Can someone please HELP!


M

mattsmom

This is the 5th time I've posted and gotten no response... Am I doing
something wrong?

I have one database to track the progression of inspection reports, there
are 7 end users. The forms pop-up and the db is hidden. I created a form to
input records into 2 tables. The query (BatchQuery) pulls from the 2 tables.
The users will review hard copy inspection reports and then open another
form which displays data pertaining to these records and contains six text
boxes for date input. They will then input the date they complete their
review. I need help getting the date they input to populate all the records
in the query immediately, as they will then print a report.
I have been able to update/populate all the records using an update query,
however that is another step I will have to complete and the user will have
to wait for me to perform this action.
Oh, this database was created with 2003 and we have recently converted to
2007. I have been working to get this to work the ’07 version for about a
month. I have even started to create a new db in 2007. Someone – please
help me!
 
Ad

Advertisements

G

George Nicholson

This is the 5th time I've posted and gotten no response... Am I doing
something wrong?
Yes. Its very hard to tell exactly what the problem is. Note that the first
2 statements appear to contradict each other and the 3rd doesn't make a lot
of sense (why can't the update query be run by code or by the user?):
1) I need help getting the date they input to populate all the records
in the query immediately, as they will then print a report.
2) I have been able to update/populate all the records using an update
query,
3)however that is another step I will have to complete and the user will
have
to wait for me to perform this action.
Taking a WILD guess as to what you are asking:

strSQL = "UPDATE tblOne SET dtmModified = #" & Now() & "#" WHERE
SomeIDFieldIn_tblOne = " & someValueFromForm
CurrentDB.Execute strSQL, dbFailOnError

If you need to update fields in BOTH of the tables that your query is based
on, then you will have to create and execute a 2nd statement
 
Ad

Advertisements

J

John Spencer

If all you want is the date of record creation then just add a datetime
field to the table(s) and set the default to Date() (or Now() if you want
the date and time). There is the problem with NOW() being slightly
different if you are creating mutliple records.

Of course, it could be that I don't understand what you want and therefore
the above advice is useless.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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