Search results

Thank you - that was too easy! OK spoke too soon - it worked in a database in the 2000 version, but not in the 2003 version. Is there something different?

I want the date 'August 15, 2007' to display as 'August 2007'. Suggestions?

Same problem OK - so I want to do the same thing in a new database, but the exact same code won't work here. It's been awhile, but how do I check for the references again (particularly DAO)? Thanks.

I created a shortcut icon on my computer to access an Access dB that's located on the company server. The Access db opened, but immediately froze and wasn't able to do anything (not responding). Any suggestions as to why this happened and how to fix it?

Is there an option so that turning the mouse wheel will scroll through the screen rather than scrolling through the different records in a form? Thanks! :confused:

OK - So I can see what you're doing with the Query, but I am getting an error in the ID and address controls on the follow-up form. I created a fake database to test the code, and I'm still having trouble. Are there Access settings that might prevent me from executing your query from the form...

if it's easy enough to post an example that would be great. thanks so much!

This might be a basic Access application, but I'm having trouble. I want to create a name and address table that will include all patients in my clinic, identified by unique patient ID numbers. I then want to create 3 other tables for the information collected at the 3 appointments I will have...

Thank you! Thank you! It worked. Now I can die peacefully.

Yes, it is the same. When I run the code, it stops at the .edit line and produces the error code.

I just checked - I have references to VBA, Access 9.0 object library, ActiveX object library, DAO 3.6 object library, and OLE automation. Should I have reference to anything else?

I have a button on a form that queries my table for observations that meet a certain set of conditions, and then updates a field to mark these observations. But I keep getting the error message 'Compile error: Method or data member not found.' I have used the code successfully in a previous...