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 Mike Lewis 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. mistereli

    Synchronization Problem (error)

    I seem to run into a synchronization problem (error) when I use the Tablet PC for anything other than the Access Forms application it is mainly used for. For example, when I add an Excel, Word or another Access file the main Access forms application will not synch with the main file. Could...
  2. mistereli

    Delete Query???

    That doesn't solve my problem of the delete query processing and deleting all 500 records. Half of them are deleted and the other half are under a lock violation. Thanks, Kim
  3. mistereli

    Delete Query???

    Can anyone help me with this problem? This is what I've done: 1. I have a list of serial numbers in a seperate table. 2. I created a delete query using this table to delete the serial numbers in 2 seperate tables. 3. I tested it on a test copy of my database (on my laptop) and I run the...
  4. mistereli

    Does Anybody Know ......

    Does anybody know if there is a website that lists all of the error messages given in MS Access? (and what they mean and how to resolve them...) Thanks!
  5. mistereli

    Error Message - MS JET DB Engine cannot open file .....

    The .ldb file disappears on its own when the application is exited.
  6. mistereli

    Error Message - MS JET DB Engine cannot open file .....

    Not sure if this is where I should be asking this question... Currently a MS ACCESS2000 database project is replicated and kept on the network (Windows2000). The department just got new computers with WindowsXP and when trying to access the database project they get an error 'MS JET DB...
  7. mistereli

    Disappearing Forms, Tables, & Reports

    It has worked in the multiuser environment for about 3 months and the disappearing act has happened 4 times. So it happens some of the time in no specific pattern. I've got another application that is huge that is on the network used by many and there has been no problem there. It is located...
  8. mistereli

    Disappearing Forms, Tables, & Reports

    It's always worked for me. I've never experience this problem first hand. It's being used in a multiuser environment on a network and I've set the default record locking is set at all records (if that even matters). Any ideas?
  9. mistereli

    Disappearing Forms, Tables, & Reports

    I'm stumped and need some expert help. I have a Access (2000) application that utilizes a Switchboard form and allows for data entering using a form (it also has queries and reports). When the users use this application and exits properly out of the application, upon going back in the...
  10. mistereli

    Creating a Delete Query

    In Access2000 I would like to create a delete query using as criteria a table of selected records to delete from two other tables. Table #1 lists only the specific serial numbers that I would like use as the criteria. And the other two tables are Inventory and History. All have the serial...
  11. mistereli

    Archiving 2003 Data

    Access2000 - sorry for that!
  12. mistereli

    Archiving 2003 Data

    Would anyone out there have any good suggestions on the best way to remove 2003 invoice data from my database. I'm doing this to prepare for 2004. I want to take all old (2003) data from the 2 tables I have and archive them. I want to take them out of the main tables (because the tables are...
  13. mistereli

    Moving records to seperate tables

    I was wondering if anyone knows how I can do this. What I would like to do is .... after selecting a record in my form (sign inventory) and subform (sign history), I would like to take the sign and its history I've selected and click a button/control and move the records to another table(s)...
  14. mistereli

    Moving records to seperate tables

    I was wondering if anyone knows how I can do this. What I would like to do is .... after selecting a record in my form (sign inventory) and subform (sign history), I would like to take the sign and its history I've selected and click a button/control and move the records to another table(s) in...
  15. mistereli

    Form Display

    I am trying to make it so that when I click on my file.mdb it opens up to my main form centered showing the tabs at the top. When I click on it now it opens to the main form but I have to scroll up to see the tabs at the top. How can I make it so that the form opens and automatically goes to...
  16. mistereli

    Replication Question

    I had a design master and 4 replicas. I was able to synchronize the 4 replicas with no problems but when I went to synch with the design master it failed. So I deleted it thinking I could take one of the existing replicas and promote it to the design master. After I do that would I create...
  17. mistereli

    Curious Question Re: db1.mdb

    Yes, I am compacting it. Shouldn't it disappear after the compacting is done and the database is closed? Today I came across a file that was named the same as the database but it had a '_backup' attached to the end of it. Why was that created? Thanks Ian.
  18. mistereli

    Curious Question Re: db1.mdb

    I've got a curious question...periodically I'll look at the workspace that houses the Access application that I created that users use... at times there will be an additional file 'db1.mdb' in there (and it is always called db1.mdb). Why is it created? And would it be wrong to just delete it...
  19. mistereli

    copying a replica file

    Yes, it helps a great deal! I thank you!

Part and Inventory Search

Back
Top