Automate Access 2003 to input a standardised record.

  • Thread starter Thread starter chrissfcs
  • Start date Start date
C

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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top