Automate Access 2003 to input a standardised record.

[chrissfcs]

I have set up an enquiry database that holds enquiry data for a
Library/Learning Centre. There are two or three standard type enquiries that
I want to make quicker and easier for the user to input. I have tried using
SetValue but this only works if you input some data in a field first and
specify the data for the other fields. Is there a way that I can fully
automate a record input from a button press.

 

[Steve Schapel]

Chris,

Make an Update Query to add the data you want to a new record. You can use
the OpenQuery action in a macro to run the update.

 

[chrissfcs]

Thanks for this, I've been trying with Append Queries and managed to get a
duplicate last record button from that, but I never thought of trying an
update query. I'll try it. Thanks again.

 

[Steve Schapel]

Chris,

An Append Query will be applicable if you are creating the new record, with
the data that you want automatically inserted. An Update Query will be
applicable if you already have a new record created, and you want to write
the automated data into it. I am not sure from your description which way
this will go.

 

[chrissfcs]

Thanks Steve, it is the Append Query I needed. I have created what I need,
but I do have another problem now. I'll explain:-

The data is added to a new record, being a record of enquiries received.
If you remember I successfully created a Duplicate Record button which I got
from the wizard when I put the button on my form. That was working fine.

The way I got the standard records to be added was by making another table
with the standard records in, then making an Append Query for each record.
Then I made a macro for each append query that added the record to the main
enquiries table and gave a confirmation message before returning to the main
form for another record entry.

I tested my new buttons and they worked okay. BUT!.... My Duplicate Last
Record button does not work now! I get an error messaga that reads,
"Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following.
Reference is missing or Expession misspelled."

I'm nearly there - can you help me please?

Chris.