Thanks all for the great help, it finally works.
The question of why remains. I have 2 computer on my desk, one with XP and access 2003 the other with Windows NT and access 2002. That code works on the old version of access and does not work on the newer version.
I also had problems with...
I get the same error. I put the Nz() in when I was researching the problem at tek-tips because it seemed to be everybody's favorite solution for dlookup problems. Unfortunatly, I got the syntax wrong.
It is weird that with or without the invalid syntax, I get the same error. I don't see how...
This code has worked for years in Access 97 and Access 2002. When I run it with Access 2003 and get "Run-time error '2001': You canceled the previous operation."
The dlookup line of code is highlighted in the debugger.
All references are in the same order the only difference being...
I need make linked table that points to a file with a non standard suffix. I am working in an enviroment where flat text files end with .csp It is a pain in the neck to rename them before my linked access tables can use them. Is there a way to link to a flat file that does not end with...
I need a dialog box that offers the user the options "continue" and "stop" instead of "yes" and "cancel"
can this be done?
My delete query doesn't work since I moved application to access2002. I get a warning message that I am about to delete rows, I click OK and then get message that rows have been deleted. When I look at the table the rows are still there. This delete query worked in access97
using Access97 to merge data with MSWord form letter
program blows with this line of code
Set wrd = CreateObject ("Word.Application")
Thanks for any suggestions, this one has me stumped.
David
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.