I've been watching this group for a couple of months now and have noticed that most design questions are posed in narrative form. I propose we come up with a...

Hello, Thank you for your time. I have a split database used by 20-30 users. I have installed the FE on each user's computer, the BE resides on the network....

Hi All I'm trying to design a computer inventory program with VB6 using Access as a backend. I have the follwing tables so...

Can someone please tell me how to have the priced field automatically show the preset price of a product. When I enter an order into my form. I don't want...

What is the best way to link a chart to a field for many records? Or, are there any templates that are already made up to do this? Thanks -- FL

I noticed that nobody answered. In case this brief 30,000' view after a quick read is helpful. What you described doesn't sound like the way to do it...

This message is for John, but, of course, I'd like anyone to respond. John, I'm having trouble understanding the lookup tables concept that you described in...

I am looking for a way to update data in a table from the back end to front end without linking the table in to avoid the users in front end from locking and...

You asked this in General Questions also. I'm posting my answer to that post here also. Assuming that there is a valid reason for storing the calculated...

I'm very new (and, therefore, stupid) to Access. I'm attempting to create a database of information for about 300 kids in a program at my center. I also...

Hi, I hope someone can suggest the best way to design my database. I've tried it a couple of way but am not having much luck. I am looking to keep personnel...

It sounds like you're on the right track. Issues Table with fields: IssueID (pk) IssueDescription ClintID .... ActionLog Table: ActionLogID (pk)

How do you make all entries in a database field automatically capitalize the entry? -- Thank you.

I have a drop down list on one of my forms that contains description selections for end users to pick from. The problem is that the field can not be edited...

Hello, Is there anyway to store both a date and the string "N/A" in a table?? I want to use a date field because of the added benifits of this but there...

Hi, I have a table called Tbl_Person where I have (PK) Person_ID and a field Supervisor_ID. I am able to establish a supervisor from a combo box on a form...

Can I copy or import some tables (3 or 4) and one query from one database into another so I can use them to create a form in the other db? Both are 2003 with...

Last week I posted a request for help in tracking down a data base for a multi species fishing competition that my company here in Mozambque wishes to...

I have a medical assessment form that I must mimic and it contains 309 fields. I know that sounds really extreme, however each question is unique and...

This may be a silly question, but I am having the hardest time figuring out how I can have my Database window pop up separately from Access. When I click on...