Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Field auto-update in form
Name: yamaha dt Date: July 8, 2008 at 01:45:17 Pacific OS: xp CPU/Ram: NA Product: NA
Comment:
Well, im now trying to make a database. Dont really know alot about access, but thought i would give it a shot. Im doing quite well so far, but im really stuck. I have one form, with 197 records on. I need to be able to make my comment field autoupdate every 2 seconds; so on each record, the information gets refreshed contantly. I also need an extra field where i can type in anything, and when i click a button, what i just typed in goes into the comment table/field. Can anyone tell me how to do this? Thanks for everyones time!
Name: Jennifer SUMN Date: July 9, 2008 at 18:14:27 Pacific
Reply:
The information in a record will be updated if it's changed.
As for the additional field on the form, add another field to your table and add that field to your form. If you type information into that field, it will update the table as soon as you move from that field.
Summary: I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in analyzer and it worked fine there but is not working i...
Summary: Can anyone suggest the easiest way please to achieve the following; I may have totally overlooked the obvious! Three of the fields I have in a table have related information, e.g. a person, their job ...
Summary: I am creating a form to track information for numerous construction jobs. The form has about 20 fields. One of the fields I have created is a "Last Update" field. I want this field to update to the...
0 
