Search results

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

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

I'm preparing for 2004 and not sure the best way to remove 2003 invoice data from my database. I want to take all old (2003) data from the 2 tables I have and archive them. The reason why I want to take them out of the main tables is because the tables are huge. I still want to have them...

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 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 I've created 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...

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!

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

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

I cannot get replica1 to synch with the design master (or the other two replica copies, for that matter). It SAYS that the process was successful but in going into the table the updates are not there. Any ideas? I've tried adding a couple of 'fake' records and they synch but the 22 from...

I've gone through syncronizing 3 replica files successfully to the Master file, in attempting to synchronizing a second time (two weeks later) there is one Replicate file that will not synch with the master file. It SAYS that the process was successful but in going into the master file the...

Does anybody know how to unselect a date (so that nothing is selected) in a pop-up calendar? Appreciate anyones help, thanks!

I would basically like to print a daily report of activity with the report always beginning on Monday. For example: If today is Monday, Mondays report would have Mondays activity If today is Tues, Tues report would have Mon & Tues If today is Wed, Wed report would have Mon,Tue & Wed If...

Please help, I have a database. I am the only user. When I open it by clicking on the file, I have no problem. When I close out of it, it closes and the .ldb file disappears (which is what it suppose to do) but if I go to reopen it, I cannot. Clicking on the file will not execute or open it...

Please help, I have a database. I am the only user. When I open it by clicking on the file, I have no problem. When I close out of it, it closes and the .ldb file disappears (which is good) but if I go to reopen it, I cannot. Clicking on the file will not execute or open it. The .ldb file...

I have a form with a subform. When I add a record to the subform I have to scroll to the right to continue to add to the fields (because it's wide). After I click my save button the form clears so I can go to the next record to add - but my problem is that my subform clears but it is stuck at...