Automate Access 2003 to input a standardised record.


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.
 
S

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.
 
C

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.
 
S

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.
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top