Hi,
We recently moved our Access 97 to Access 2003, and how we keep getting the error message "could not update; currently locked". We have to exit, compact, re-enter and then we can work for a while and then it all starts back up again... One of us can be in a query and the others may just...
Hi,
We have an Access 97 program that we are sharing between 3 users. I had an error and it would not let me out... when I did get out, it seems to have corrupted my data and now the DB has a .lbl file that will not close, even if I shut down all the computers. I can not get into the db, and...
Using: Access 97
We have been having a terrible time with our Access DB and it keeps needing to be compacted and or repaired. Recently we have lost all of our relationships but basically the database is still working!?
Our newest problem is that we have a "compiled" list query that no longer...
I recently added a tab to a Access DB forum and yesterday it was working fine. All records were attached to the appropriate data.
Today we had some problems and I had to compact the DB and now it seems to have added the new tab records to all my record. I originally made the subform from a...
Hi Fly,
Woo Woo! It worked. I imported all the tables, forms,queries, resorts... It did not want to bring in the forms or reports so I took them from an old copy.
Thanks Again,
Kiiwii
From the main computer the message is "this program has preformed an illegal operation and will shut down.
From the other computers on the network..
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
If youj were in the middle of something...
Hi,
We recently had some problem with our Access Database while trying to attempt to print a large merge file. Since then the file grew close to 20,000 kb. We repaired/compacted and it reduced size, but it will not let us in. I think the problem is that it created a Micrsoft Access...
We recently were trying to verify that our computer system and Goldmine 4.0 (5 users network)would run on Windows XP. We did our test on our Access DB by bring the DB unto a laptop with XP on it. But when we went to test Goldmine. We put another copy of the program on the lap top and then...
Hi,
We are having a problem with our Access 97 program. It seems that perhaps the computer was left on and we had a power failure. Anyways, the message we are getting is:
<Index name> isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid...
I can't seem to be able to open links that are showing in my emails. We are currently using Outlook Express 6.0. I can click on it, but it does not give me an error message but it does not go to the link.
Thanks,
Cheryl
Thanks Duane,
I got it. It was 2 problems. # 1 I went back to look at the USX db I created and noticed I had it as a text not a number and the 2nd thing is that there are a bunch of databases & quieres put together for this report, so I had to add the db to one of the queries.
Hi,
this the the calculation:
=IIf([txtBilltoCountry]="USA",([Price]*[USX]![USX]),[Price])
The textbox is just "text93"
I hope I am making sense.
Thanks,
Cheryl
Hi Duane,
Thanks for the quick response. That is what I thought I had to do and I tried that but I got a #error instead of the new calculation?
Thanks,
Cheryl
Hi,
Originally the programmer who created our database did an invoice report in which each line the US exchange rate was calculated. So that now everytime the rate changes and we invoice,(which is only once every 2 months), we have to go in and change the calculation. IE: ([price] *.075)...
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.