I helped a co-worker set up a One to Many design. The parent table had a field called TransID and we linked it to a child table which also had a field called...

GIVEN: A spreadsheet containing a dozen "blocks" of constants data. Each block consists of 16 columns and 12 rows of constants, and each block relates to a...

Is there any way to point the linked tables that I have to another source. I have the same tables in a test database as I do in live, whilst developing the...

How do I display event information in the calendar on calendar control. I want to be able to click on a date and see the appointment information for that...

I am using Access as a front-end to an SQL database. I need to be able to prevent having duplicate keys without using a composite primary key. I have a...

I am creating a database with weekly staff hours in a format of 40:00:00, I figured out how to get access to accept these numbers but now I need to transfer...

I know that I may have more luck posting this question in an Outlook group, but these Access groups are the ones that I most frequent, and I like all of the...

Is this valid? Three tables (call them A, B & C), each with a junction table between (call them a, b & c). Six tables total, in a related in a circle? Is...

I created a database in access with the following table. but when ever i try to enter data it gives an error message. "You cannot add or change a record...

Dear All, This will be a bit difficult ot explain, hope it clear. As a product manager I'm responsable for a few brands. This means, I need to keep SAP...

I need to order and track printer toners. We have many many different printers, therefore many toners. When a user requests toner, I need to enter their...

I'm getting a strange error in one particular record. Somehow, a duplicate record was created, and I cannot delete the record. I get the message "The search...

I am creating a database for a friend that will keep track of issues and questions. I think it should be set-up similar to a family tree because there...

Hi does anyone have a databse for the above or one that could be adapted thanks marion

I've been using a tool called SQL Compare for a while now to update MS SQL schemas. I found something called dbweigher that does something similar for MS...

I created a DB a year ago in which one of the tables holds input from a form. Several of those table fields hold record numbers from other tables or...

I have a third party event software that I want to use a linked table from my database for its data, so I don't have to re-enter contact information. The...

I have three tables: BusinessContacts, IndividualContacts, and Donations. BusinessContacts has a one to many relationship with Donations (Donations being the...

Hello everyone, I have a junction table that unites events and invitees. Plus other fields like invited, present.. bla bla... Now to save space I could only...