Create a new record using a macro?
On the employee table Clock # is the primary key and cannot be duplicated. What I want to do is create a new expense report for each new employee (a dummy record to populate a zero value for each category of expense type).
So when I enter the employee and save the record it would automatically create a record with all the specified values, only changing the clock # (as input on the employee form).
I don't want to build the default values because each employee may have multiple expense reports with different expense types.
My thought would be to copy the entries in say "record 4" (autonumber field), only changing the clock # as input on the employee form.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have created a database for recording Quality issues from various customers. I have also created a FORM for ease of entry of data. What I want to do is create a BUTTON for this FORM that when clicked will create a PDF of the current record only and attach it to an email. I have tried to use the SendObject action and have set up the email side of things but the problem I have is that the PDF that has been created has ALL of the records listed in it and not a singular record.
I suppose a macro similar to PRINT RECORD would be required.
Would this be able to be done as a macro or would VB be required?
I hope to hear from someone soon
When I try to run my macro, nothing happens, regardless of the value in txtSerialNumber (so regardless if the Serial Number exists or not). When I remove these lines, my macro runs fine.
What I'm looking to do is take the value of cell that has just been updated and use that for the search criteria to look at the history table and search for that value in a specific column. If the value exsists, do nothing, if it doesn't exsist create a new record and populate the value using the search criteria.
The only start I have is I believe i've found the code to create a new record which I think is : "DoCmd.GoToRecord , , acNewRec
To accomplish this I am thinking I need to run a macro that that updates the appropriate field but I am not sure of the best event to trigger the macro. Perhaps there is a better way
I want to create a button in "Employees" form and press it, so that "Employee Badge" form opens displaying only the record that was on the "Employees" form at the time I pressed the button.
I have created a macro to do this. The "Action" of this macro is "OpenForm".
Can someone please tell me what I need to put in the "Where Condition" of the macro?
Or is that "something" entered in "Filter Name" of the macro?
In my macro I have:
When the [employee_ID] is null the message dispalys and the macro stops, however the open form button will nolonger work even if I select a record. How do I get my macro to work after it has stopped