Search results

I am receiving a "Type Mismatch (Error 13) whenever I dimension a variable as a recordset. For example: Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb The error occurs When I try to do a statement like: Set rst = dbs.OpenRecordset("qryname or SQL", dbOpenSnapshot) Up until...

What you said about the order of inserting records in a junction table is correct - but there's one more detail that can mess it up. If I check Cascading updates and deletes for the Relationship between the Main table and the junction table, it works OK. But if I check it for the Relationship...

Pat, thanks for your reply. It got me on the right track. Foreign keys in other tables were causing most of the problem. I now have two of the four tables allowing me to append to them. Part of it also seems to involve the order in which a record is appended. If I append a record to the...

I am a bit new to using transactions. I suspect this stuff is basic to some of you. I am designing an Access application that has an application side (*.mdb file with forms, code etc.) and a data side (*.mdb file with linked tables). The data side has a main table and three other data tables...

Found the problem. Hard to believe I worked so long on this one. I was mis-naming the field in my Requery statement. Obviously, naming it correctly made it work better. Stephen S.

For the last couple of days I have been trying in vain to get the list for a combo box to refresh. The idea shown in "Tips and Tricks" on this web site was one of the first techniques I tried. It suggests using the following code on the main form: Me![Sub-form Name].Form![Control...

This is fixed. I needed to leave the combo box unbound. Before, every time I selected a record to go to, it assumed I wanted to change the record. Now, leaving the box unbound, Access is happy again. Steve S.

Chanda, Here is some code that I put together. It is not tested or debugged yet. But it is my approach to your question. It may not precisely fit what you have, but I think you will be able to use some ideas from it. Be sure you have all of the necessary references checked in VBA...

I am getting an error in Access 2000 that says, "Run-Time error '2501'. The Applyfilter action was cancelled." The "Help" button is dimmed when I get it, so there is no elaboration. Description: The form that causes the error looks similar to the "Sales Totals" form in the 'Solutions'...

Excellent!! I now have a drop down list that includes a "database" object. Thanks, Travis, for a successful fix that was also simple. StephenS

Recently upgrated to 2000 and started a new project. When trying to dimension a variable as a database object, the message, "User-defined type not defined", appeared. It occurred on this simple code: Dim dbs As Database It is referring to the word "Database". As I typed the Dim statement, I...