Recent content by rob_levy

Hi all, I get the following error in the circumstances which follow: The expression * you entered as the event property setting produced the following error: Syntax error Circumstances: I am in the module of a form which is in Form view (as opposed to Design view). I have got to this state by...

Hi Pam, well this is just the thing that confuses me. I've found that with the above code, the table is not always updated straight away. It can take up to a few seconds and if the code moves on before this has happened I get into trouble later on. Incidentally, I have since changed the...

Hi all, I'm doing the simplest little 'INSERT INTO' type operation here with recordsets in Access 97 (SR2). Inserting into a table whose name is stored in the Const TABLE_CANDIDS. I have a little piece of code that doesn't move on until the changes are committed to the table (usually this is...

Dear all, I believe I have discovered a new way of fixing corrupted forms in Access. After a crash, one of my forms refused to open in either design or form view saying: Form name | is misspelled or refers to a form that doesn't exist Having searched the internet for this error I found lots...

Dear forum, When running a line similar to this to add a new record to a table: DoCmd.RunSQL "INSERT INTO MyTable VALUES (1,2,3)" I'm getting: Run-time error 3167: "Record Is Deleted" When I click debug, I'll get the same error for a few seconds every time I try to run the same line then...

Hi all, Is there any difference between these two scenarios? Is one or the other better in any way? Take a form bound to a table 'Customers' 1) Open the form, set the recordsource to: SELECT * FROM Customers WHERE Name = "Rob" 2) Open the form, set the filter to: Name = "Rob" I'm assuming...

Hi all, My company has 3 access (97) databases (A,B and C) which all have linked tables into a central database (D) containing information that is common to all three. All the database files are kept in the same folder on a Windows 2003 server which is also running Microsoft Exchange and a...