Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kiiwii2

    Could not update; currently locked

    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...
  2. kiiwii2

    Access 97 .lbl locked

    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...
  3. kiiwii2

    Run-time error 3078

    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...
  4. kiiwii2

    Access - Added Tab to form -

    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...
  5. kiiwii2

    Access 97 won't let me in and created Record-locking

    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
  6. kiiwii2

    Access 97 won't let me in and created Record-locking

    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...
  7. kiiwii2

    Access 97 won't let me in and created Record-locking

    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...
  8. kiiwii2

    Lookup Tables

    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...
  9. kiiwii2

    <Index name> isn't an index in this table. Look in the Indexes collect

    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...
  10. kiiwii2

    Can't open a link in Email

    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
  11. kiiwii2

    Adding an exchange rate calculation to a database/reort

    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.
  12. kiiwii2

    Adding an exchange rate calculation to a database/reort

    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
  13. kiiwii2

    Adding an exchange rate calculation to a database/reort

    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
  14. kiiwii2

    Adding an exchange rate calculation to a database/reort

    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)...

Part and Inventory Search

Back
Top