Search results for query: *

I have a macro that can be used to import data into a simple database. When run from the macros window everything works fine. If I run the macro from a form using a button, the macro runs but then the form hangs up (becomes non-responsive). The database has to be closed and then relaunched to...

I double checked the relationship between the main table and the subform table- I unchecked the referential integrity box and still had the same problem. The funny thing is that I can still update the table- just not until I clear the error. Thanks for the note- I hadn't checked that and did...

I have a subform on a mainform that is using an autonumber as the primary key. The primary key field is WONumber, the child field is WONumber3. The subform has a one-to-one relationship with the mainform which is unusual but necessary for the security set up. The problem is that when I go to...

Solution!!!!! I think I found my problem! I had the subform Data Entry property set to Yes, so everytime the form was activated it was trying to create a new record. If a record had already been created the error message would pop up since this has a one-to-one relationship. Thanks for looking...

No problem- I wasn't sure if I had created an issue with something in those two lines. [smile] When I open the form to a record for the first time (ie there is no corresponding record in the subform) everything works great. Once I've moved out of that record and the subform now has a record...

Sorry, I forgot to include that information. The main form pulls from query qryWorkorder which is using an autonumber as the primary key in field 'WONumber'. In a later version of this database I would like to add coding that will create a workorder number that has meaning for the user but have...

I'm not really experienced with the advanced functions in Access. I'm using Access 97 to create a database that will create and track work orders through various queues- ie maintenance, accounting etc. At the end of the process the work order is 'complete' and can eventually be archived. The...