Search results for query: *

Hi all. Just a brief warning. If you bring a large chunk of SQL into Microsoft Word to do mass edits on it, be careful to turn smart quotes off. Word will replace the straight quotes that Microsoft Access requires into smart quotes that make Access choke. I spent 2 hours trying to figure out...

Hi all, I'm trying to prevent a user from entering the pound sign (#) into a text box. The text box is used to rename a file using fs.CopyFile. That file is then linked via html, and when the user attempts to follow the link to the file, if a pound sign is in the path, Access thinks it's...

Does anyone know how to determine the class of an OLE field? I'm trying to control the class of an OLE object automatically using code such as: [OLEField].Class = [txtOLEClass] At runtime, I am told that the .Class method or data member is not found. So I need a library reference? Please...

Hi all, I'm banging my head against the wall on this one. I'm using code provided by Microsoft Knowledge Base to import OLE objects from a folder. I'm trying to import photos from a CF card into Access so that they can be renamed, grouped etc... I've tried directly setting an OLE field equal...

Does anyone know how to prevent a form from jumping to the first record of a dataset after requerying the underlying query? I've tried requerying specific control boxes and entire forms, only for it to either not work or get the usual "object is not open" message. This is a general...