Recent content by Chrissirhc

I get an error "Missing semicolon (;) at end of SQL statement" when I only put the ; on the last entry. It also highlights the 2nd entry to indicate where it is expecting the ; Have you done multiple inserts in Access using the SQL view before and know it is possible? Thanks a lot, Chris

I know I can run my queries one by one and they work...

thats a typo in my post and not in the actual query. I guess my real question is. Could you show me how to perform two insert tables in Access please?

insert into table values ('HELLO, 'V', 'HELLO', NULL,"", 0,0, 0.1,""); insert into table values ('HELLO2', 'V', 'HELLO2', NULL,"", 0,0, 0.1,"");

Should have read "Characters found after end of SQL statement" If I put a ; after every SQL statement. OR "Missing semicolon (;) at end of SQL statement" If I do not include a ;

Characters found after end of SQL statement" If I put a ; after every SQL statement. OR "Missing semicolon (;) at end of SQL statement" If I do include a ; Any ideas? Thanks, Chris

Hi, Does anyone know how to do this??? If I have more than one line in the query window it complains. Thanks, Chris

Does anyone have any ideas about this? Maybe it is an Excel setting?

This appears to be happening within the XLAs now. Any one had this experience before? Or have any ideas? A few posts up are the steps we took. Thanks, Chris.

Any ideas on this? Thanks, Chris

Yes once we've saved the file and open it back up it is fine. We have one Dll to deploy to approx 200 users. And an unknown (probably very large) amount of sheets that use this dll.

Sorry. There is not relevant code. The when opening file.xls and hitting alt F11 --> tools - references the reference to the dll comes up as missing. We don't know why this is and tried the above few things and the suggestions in this post. Thanks, Chris

The subject in this thread is bad. Sorry. It should read XLS not loading the dll. So we have tried 1) Manually reregistering the dll 2) Building the dll (written in VB) with Binary compatibility with the old dll (this keeps the same UID) 3) Building the dll in project mode None of the...

The file is local (i.e. on the c:\ drive). Is there any way to make it reference c:\ when you save it rather than the machine name? What in the environment is making that happen? Thanks, Chris

Re-registering with the full path doesn't work. Any ideas on this? Thanks a lot, Chris.