Recent content by JimRich

If the reference is marked "Missing" and the file needed is not on the computer and reinstalling Access does not install it, what would you do? I am also using "Date" in a couple of date math functions and I get an error message there as well. DateAdd("ww", 1, Date)I have never tried using...

I have checked the references. What reference are you supposed to have to cause built in functions to work? JimRich

I have installed a program on 4 different computers. On one of the computers the date and time functions do not work. It is running Windows98. I let Office2000 repair Access. The rest of the program seems to be working fine. Any ideas as to what causes this problem. Any help will be...

$150 is showing on the open form in the subform object. I have been debugging regularly by setting breakpoints and stepping through the code. I checked and the subform name is correct. JimRich

Thanks for the tip. However it did not solve my problem. The object Me!Donations.Form!Total gave me no value whatsoever. It was supposed to be $150.00. No error messages. JimRich

I need to compare the values in an object on the main form to an object on the subform. The main form (Donors) has an object called TotalCommitment. The subform (donations) has an object called Total. The following code gives me error message 2450. MSAccess cannot find a form named...

Yes, my problem was that the "Read Only" attribute was set "on" on the folders as well as the files. When I turned "Read Only" off at the folder level the problem went away. Hope this helps. JimRich

I am not sure about any patches. I try to keep everything updated. I have permissions set, I checked them. I have put in a request for our MCSE to come check them out, but sometimes it takes two or three weeks to get him. I will try the Notepad recreation idea, but I have to wait until...

I get the message when I click on File/Open Web and select a web from the list. I tried everything you suggested with no joy; execpt that I did not delete FP from the browser. I thought maybe you ment delete "service.lck." FP did not creat a new "service.lck." It had...

Yes, that is the file, and the one I deleted. I also copied one from another source into the same folder. It is a network server, in a computer lab for high school students. The student computers are also running Windows 2000. Their data will come from the network but FP is installed on each...

When I try to open a web page I get the following message: Server error: Cannot open file "service.lck" for writing. That file name might be "service.ick", I can't tell which. I understand that this might be a server error. I have full administrative rights. My OS is MS...

Thanks Paul, I will try that. I checked on my home computer and both of those options are checked and the report prints correctly. It prints correctly with them off as well. I will not be able to go to my client until later in the week so I do not know if that will fix my problem. If you...

My 3 column report prints right on my home and my office computers but when I install it on two others it only prints one column. They all are the same version of Access 2000. All computers are set in Page Setup/Columns to the same settings for 3 columns. All other settings on the Columns page...

I would use a make table query. With both tables related on the proper fields you simply pick the fields you want in from both tables. The result will create a new table with the data that you selected. Practice several times until you get the data you want then change it to the make table...

How can I pass a variable from the open event in a report to the report itself. The query for the report already has a couple of inner joins and a union. It is really complicated for me. Now my user needs some additional information that I need another query to calculate. I then have to...