Thanks again hymn, but I followed your advise, clicked on the Microsoft DAO Object Library 3.6 reference and I even added Dim MyRst as DAO.Recordset to my databse and still the same error.
Hymn, you were correct, there was a missing reference, but I corrected! Now when I run it, I get a runtime error 3001. It is telling me I have an invalid argument. Impossible, I have run this code every other week for the last three years.
CODE (where it is hanging up)
qd.sql = sql
qd.execute
I just installed XP and now when I try and run my old VB code is MS Access 2000, I get this error ---->
Can't find Project or Library.
Anyone? How can I fix it?
In most cases you can't with MS Access! But here is the sweet part. You can still access querys, tables, some system objects and procedures as well as functions with another ODBC SQL tool. I ues Query Tool ODBC. The file names is QTODBC.EXE and can be downloaded from any ftp site or...
Is it possible to access table objects in a corrupt database. I have a dbase that access will not open. When I try to access the objects by importing or linking, I get an error messages telling me the dbase can not be opened.
Yes dvannoy, I used the Jetcomp.exe and it actually was able to go in and compact the db externally. However, I still couldn't open it and I have no back up. :-(
Thanks dvannoy, but the dbase is compactable externally, it just will not open. Access can not open the dbase. I can't even access to import files to or from it. I just can't figure this out.
Hey Cruford, Didn't work! That was a neat trick though. I will be using it from now on. It did compact the db and make a new one, but I still can't open then new one that it made.
My data base won't open. I keep getting an error message. I have tried to import the objects into a new dbase and all, nothing works. The error message is "THE DATABASE IS IN AN UNEXPECTED DTATE, MS ACCES CAN'T OPEN IT" Then goes on about this whole conversion spill but this dbase has...
Is it possible to print my access reports to a (or multiple) PDF files rather than printing them one at a time? I would LOVE to have code that does that!
Please help. I have some vb code in MS excel that opens all the files in a directory, formats them and closes and saves them. Unfortunately, the SAVE AS dialog box keeps popping up because the file format, although the extensaion is .xls, appears to be Symbolic Link. Is there any way I can...
I want to set a the VISIBLE property of one of my sub-detail footer lines to NO based on the value of a field. For instance, I am sub-totaling on a group, lets say the groups are A and B. When the [GrpTyp] field="B", I don't want to show the sub-total footer. How do I do that?
Thanks!
I saw a post which provided the code that would alternate shaded lines in an MS Access Report. I can no longer find it. Anyone? This has been a very useful formating tool when preparing 100 page financial reports!
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.