Information not showing

[Guest]

Ok, I have having a huge problem - The information that I am inputting into a
form is not showing up in the table. Let me explain to you what I have. I
am working in Access 2000 - I currently have a form that is linked to what I
call a history table. The user inputs the information into the table and
they press a button. This button is associated with a macro that says to
take that information that was put into the table and to append it to another
table. I have checked all my queries and I have checked the macro and
everything seems to be working fine. I have also tried deleting the queries
and setting them up again hoping that this would fix the problem and it
didn't. So I am at a loss. All of my forms are set up this way and it is
like nothing is working. Does anyone have any ideas. I hope I gave enough
information.

 

[Allen Browne]

There are a few cracks here for the data to fall through.

Firstly, it seems to rely on the user to click a button. So, if the user
moved to another record without clicking the button, the first record would
be silently saved, with the changes NOT written to your history table? To
avoid this, use the AfterUpdate event of the form, instead of the Click
event of the button.

Secondly, how does the macro add the record? Does it use RunSQL? And do you
turn SetWarnings off to suppress the messages? If so, you will get no
warning if the query does not work. For an alternative approach, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

 

[Guest]

I don't have an option for them to move to another record. The only way that
they can get rid of the record that they have is to push the button -

basically the macro is set up as
SetWarnings
SendKeys
Close (Closes the form)
OpenQuery (this opens the append query)
OpenQuery (this opens the delete query)
OpenForm

All the other files that I have set up the same way work fine. It's just
this particular one that is not working. I'm finding it very weird. I will
check out your document. Thank you.

 

[Allen Browne]

Okay, it is most likely the queries are failing silently.
To help debug that, turn SetWarings back on, and read the messages (or
follow through the article.)

But you have not convinced me that you have covered all the other bases that
could cause a record to be saved, such as:
- Shift + Enter
- Ctrl+F4
- Alt+F4
- F9
- Close the form
- Close Access
- Close Windows
- right-click and apply a filter
- right-click and apply a sort
- use the toolbar to change the sorting
- use the toolbar to apply a filter
- use the Records menu to save the record
- use the Records menu to apply a filter
- use the Records menu to change the sorting
- use the Records menu to Refresh
- tab past the last box on the form
- etc, etc, etc.