Search results for query: *

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.

Hi, Is there anyway you can make ctrl D calculate a workbook without having application.onkey in a macro somewhere??? I've searched through all the xla addins and the workbook modules for onkey and cannot find one. Any ideas? Thanks, Chris

If I pick a sheet up from someone elses share on the c:\ references to ranges on that sheet are also prefixed with \\machinename\filename!range Why is this? Hasn't happened to me at other places... Thanks, Chris

Registering the dll manually doesn't resolve the issue. Although typically I go to the directory and try registering it... I'll try registering it with the full path, my gut feel is that it won't work. Thanks, Chris

Ok in the main workbook I can recreate the issue. When I say find the dll I mean I go to tools --> references in the IDE and then I see that the dll comes up as missing. I have to uncheck it. Close it. Go to tools --> references and then browse for it and then it works.

Can't seem to recreate the issue. But I can with an XLS. And it keeps on happening. I have to untick it and then press ok and then I have to find the dll and tick it again. Is there anyway to make it find the dll in the directory rather than it worrying about the version? Thanks, Chris