Search results

What do I check for as far as the referential integrity of my relationships? I read a little about it but came away more confused..........help! Thanks!

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 don't think this is what I want to do ....................

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

Kabir, where's the attachment?

Here you go .................

Yes, it is set to auto-center and it is a pop-up form.

I couldn't locate a TabIndex. When I open it up there is no cursor, it just shows the form with the Tabs (after I scroll up to the top).

My first control (Tab) at the top is a Search Control - when I pull up the Tab properties under Format for that control, the PageIndex is at 0. Should I be looking somewhere else?

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

Thanks for your help, Keith. Cassie

The replicas are not partial. The Design Master was deleted (not moved) by right clicking and deleting so does that mean your option is unavailable to me? If no, at the end of your instructions, I'll need to create a new replica to replace the one that I promoted to the design master - right...

If I didn't have write permissions, wouldn't I not been able to sync the network replica copy with the laptop replica? Or is that different from synching the network design master with a network replica? I'm not too educated in networks... as you can tell! Thanks.

Keith, Thank you for your feedback. Just one (more) question... I tried creating a replica from a replica but it just hung there and the task manager said 'not responding'. I tried this many times and the same thing would happen. It seems to only happen when I do this process on the...

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

Wayne, how can I figure out what to fix when I don't know what is wrong. I'm at my wits end with this whole project. Thanks.