Search results for query: *

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

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

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!

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

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

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

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

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

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

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

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

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

Would I cause any problems by making a copy of a replica file from our network to my desktop? My intention is to just look at the copied file and delete it afterwards. Will it screw up the replication status of the replica I copied it from? Thanks!

I'd like to put a password protection on 2 certain fields in order for those fields to be modified. Nothing more than that. Is it possible? Thank You in Advance!

Here is my dilemma............. Last week I replicated my database in error. What I did was create a replica set (Design Master, Rep1, Rep2, & Rep3) on our network, connected the laptops (via network cable) and dragged & dropped the Rep1,2,3 files to the corresponding laptops (1,2,3). I've...

Here is my dilemma............. Last week I replicated my database in error. What I did was create a replica set (Design Master, Rep1, Rep2, & Rep3) on our network, connected the laptops (via network cable) and dragged & dropped the Rep1,2,3 files to the corresponding laptops (1,2,3). I've...

Here is my dilemma............. Last week I replicated my database in error. What I did was create a replica set (Design Master, Rep1, Rep2, & Rep3) on our network, connected the laptops (via network cable) and dragged & dropped the Rep1,2,3 files to the corresponding laptops (1,2,3). I've...

Hi All, In my form view, is there a way to highlight (upon opening the form) only the records in my linked subform whos field option is only "YES"? (The one field asks 'further work needed?' - select 'yes or no' - I want the 'yesses' to be highlighted in the subform upon opening.)...

Hi, In my table have serial numbers from 1 through 99999 (example 34, 989, 12938 .....etc) but when I put them in ascending order it will put them in 12938, 34, 989 ... order. I think it sees the numbers as 12938, 34000, 98900 .... . I would like to place 000's in front of the 2/3/4 digit...

Can you make updates/add records or only design changes to a Replicated Design Master? Thanks.