Search results for query: *

I am just x-ing it to try and close it down. I don't get a error message. It doesn't do anything. Then when I switch to design view, I can close it down. I do not know how to close using code.

It's only me. I copied our working copy to my computer to try and see what's going wrong.

My data base is acting crazy. I am trying to import as much as I can save to a new database trying to isolate the offending item. One of the issues that has developed is that my forms will open but I cannot get them to close. I either have to control alt delete and shut down Access or...

A while back, I made a copy of the database and created some new forms and reports which I proceeded to copy into the working database. I have done this many times with no bad results. However, something about this time created numerous problems. I think the problem is in the forms/reports...

I have been struggling with some type of corruption in our database. I have tried all of the easy fixes and I just can't get this thing to correct. Does anyone know of a reliable company that can review the database and help me correct the problems that it has? Thanks for any direction...

I tried importing as you suggested. Tables and queries went well. When I tried to import forms, I received a name conflicts message and then could not start, too many transactions already nested. I got similar messages when I imported reports. However, it appeared that a couple forms and...

Recently, our dtatbase has been acting very strangely. I copied a form into the database and started recieving the network connection lost message. I copied all the recods into a new database and it was working for a while but now new problems are arising. I tried a compact and repair and was...

I am not extactly sure what you mean when you say delete the class module.

The following steps are required to try and fix my problem. When I tried to save the code as a text file, it would only save as a .cls file. I change the hasmodule to false and then save but the object reverts to the original true value. I am just stuck. Can anyone help out? 1. Open...

I tried to export the code file and it saved as a .cls file in my documents. I am assuming that this was what I needed to do. How do I restore the code back into a new database? Thanks again,

I have a problem with an Access 2000 database. I am getting a "Error accessing file. Network connection may have been lost error" message. One fix involves saving the code for the forms and reports as a text file and rebuilding the database. I am not sure exactly how to save the code as a...

I change the isnull expression from the report to the query and it works. I don't know why it won't work in the report but I am getting the results I want. Thanks to all. If anyone knows why it would not work in the report, I would like to know. Thanks again,

I really appreciate all of these suggestions but none of them has change the #error output. I am stumped.

I am not exactly sure how to check for zero length strings. I tried the NZ code and got the same error response.

#error. If I change the arguements to two "text" responses, I always get the false response whether the [customer po] is null or not. Maybe this is a clue. Thanks,

I think this is a simple problem that I just cannot resolve. I am using the expression =IIf(IsNull([Customer PO]),"NEED PO",[Customer PO]) in a report. The result is an error. Customer PO is a text data type, required-no, allow zero length-no,index-no and unicode compression-yes.

It seems to be a problem with the MonthName function. The program is just not recognizing it.

My fault. It is MonthName. Is this an add on because it is not working on my lap top. I get an undefined fucntion error.

Is this a function that needs to be added to work? It works on my desktop but does not on my laptop. I want to use a function that will read the numeric month and convert it to the name ie September, etc. This works but only on my desktop. Thanks, Mitchy

Traingamer, It was working great. Now when I go to print the report, it is asking me for MonthName, I hit enter leaving the space blank and then I get a error on the report. I did not change a thing. Is MonthName a function that coverts the numeric month into the month name? I cannot find...