Novice/Access 2003 How can I connect one table to two or more fields in the same table in a one-to-many relationship? Example tblWriters to fields: Writer1,...

I have a custom help file and it works when my users press F1 when the forms are on screen. I would like to add Help to my Help menu on my custom menu bar. I...

Dear All, I was trying to get my database propeties using VBA Code as follow : Dim fs, f, s Set fs =...

I have a field in a table that will contain values from 0.000 to 1.000 and will ulitmately be used in a calculation. The source values are being imported...

I have a existing database with a table in it called parts, and in this table there is a column called word one and one called word two, i need the...

Anyone got any ideas about the following. I have a table of keywords. The keywords can be 3 levels deep so the table has 3 columns Tier1, Tier2, Tier3. Tier1...

I have 3 tables then another table (loc_adjustment) that has joins all 3 tables. id value x3 id t1.id t2.id

I am trying to enter decimal numbers in the Purchase Orders subform and it is rounding the numbers. I have opened the Inventory Transaction table in design...

From Access '97 through to 2002, it was possible to enter a multi line entry into a table field. This I could do with a Control - Enter (NewLine Char). With...

I am creating an Access 2002 DB for Test Cases. My tables a TestCases, CaseScripts, ScriptType, and Application. What I would like to do is assign...

I’m helping a user design their database and I’m having trouble with one area. The purpose of the DB is to track tissue donations. There are 5 recovery...

I could use some help with a table design problem. I have an electronic flashcard program. Actually, several of them. They each rely on a utility program to...

I am trying to find a template to track workorder for city government? I have tried adapting the service call template, but it won't work.

Setting validation for a code such as AB1234C where there are always 2 letter, 4 numbers and 1 letter. I thought ? represented a letter and # a number but if...

Hi, I have a form with a phone number field. Instead of using formats or input masks in the table I just formatted the field on the form with a format of...

I need to add a new field to a table. I receive the warning prompt that I can't change the table design because the table's pre-existing relationships. The...

We are looking for a volunteer to design database for an international ngo. Incoming goods .... projects .... inventory ... outgoing goods. Network for...

Woody, I have no idea how to open a form with a hyperlink so I can't advise as to its nuances. The straightforward way to open a form is the OpenForm...

thanks...... "Wayne-I-M" wrote: Hi Press the Shift key as you open the database. The go to tools - startup and change the options to what you...

I have a Supplier table that contains 'supplier name' and 'supplier number' fields. Both are unique. I have chosen 'supplier number' to be primary. In a...