Search results

Running AC97 on WinXP. When I attempt to export the report to Excel 97, I get this error. I do not get this error when I attempt to export the same report on a PC running Win98. Nor do I get the error when I export in RTF, or Text. I'm searching the internet looking for a possible reason...

I'm running the following line: dbs.Execute ("DROP TABLE [tbl_No Certs]") the problem is that sometimes the table doesn't exist... Instead of trapping the error code, is there a way I can check to see if the table exists? If it doesn't I'll simply skip this step of my code and move on. Thanks!

Attempting to use NPV function in Access 97. I keep getting this error. Dispite the fact that I believe I'm using the function properly, as well as setting up the array correctly. pretty straight forward as far as I can tell. I keep getting a Subscript out of range on the NPV function...

I have one PC running win98,acc97 and Access is CRAWLING. I'm seeing this on ONLY this one PC, and in multiple databases. Any ideas? Possible places to look to fix this? I've tried reinstalling Office, I'd rather not have to rebuild this pc. Thanks, -Mike

I was having a discussion with a friend of mine about this... and I couldn't come up with the best explination. Hopefuly someone here can point me in the right direction. He has a table Recipies(Id, name, item1, quantity1, item2, quantity2, item3, quantity3, item4, quantity4) I don't believe...

I have a database that stores employee information. AC97 database on Win 98. One of the fields is a picture. It's a Bound Object frame. Now I'm having problem "Inserting Object" from any Windows XP running AC97. Is this because WinXP might be interpeting the .jpg different then Win98? When...

I've seen this a few times on random PCs running AC97. A calculation that works properly using multiple datediff functions giving a result of #ERROR even though it does in fact work properly on all other computers. I'm trying to nail down why this happens on only SOME records, on one or two PCs...

I'm trying to reference a field in a subform to assist a query I'm writing on the form to populate a list box. The help info is not very helpful in assisting me. taken from the Access 97 help files: To refer to a subform or subreport Refer to the subform or subreport control on the form or...

Ok, I've seen this quite a few times and I've been unsuccessful in fully restoring the database after an error like this. AC97 The database shows up that it needs to be repaired. When I attempt to repair it I get the following error: "Couldn't use Prospect 2.mdb. file already in use." Yet...

After my last thread I'm looking to split up all my databases in to a full FE and BE configuration. Someone suggested a way to automate a client upgrade, where I do a version check when the user starts the FE. Has anyone implemented something like this yet? I'm trying to think of a way that I...

Hi all, Neat forum, I'm glad I came across it. I've been working in Access databases for 5+ years now. At my current company for 3+ years. They are running on windows 98, using Access 97. They have multiple databases. Many of which have multiple users accessing them at the same time...