Hello all Windows 2K Access 2K I have designed a database which contains about six one to one relationships. My original thinking was this design would keep...

DawnTreader wrote: Hello All i have a table that as it is currently designed has a huge amount of fields, and as time goes on i am sure that the number...

Looking for a reality check to see if I designed this correctly. Found a couple examples and based this off of them. A project has at least 2 sites and 2...

Hi, I have a database which links to another database on the network. I have linked 5 tables from database1 into database2. Users do not have access to...

Am working in an Access tracking program at my office. I have to go through several levels to finally get to the cost information on a tabbed screen behind...

i have a form based on a crosstab query that sums on threee possible types A, B or C. on the form the field for B shows #Name?, if B does not exist. this...

I want to modify the Northwind db example. Looking at the design, I want to include another 3 or 4 tables that follow the schema of the "Order Details". If I...

Hi, I have an input mask on a text field in an access 2000 table, which is very simple LL\ 00\ LLL (Three groups of characters, 1st letters, 2nd numbers,...

New to access 2003. Have been reading my access 2003 bible and lessons on line and now am attempting to make my first relational database using proper...

hi everyone, sorry for the length of this post, but before i state the problem, i'd like to provide enought support info. here's the layout of the db - i've...

I have a form that has options to choose different reports. I want to add a comment to certain reports. What I would like to happen is when I click on a...

I have a db with 5 columns and i want my front end interface to be able to insert a 6th column. i can do it on the front end but it doesn't save to the db?

Is there a way to use the countif function to count cells in a range with 1) a red background and 2) that contain letter "A". Something like the...

Imagine 3 tables: A, B, C, with many-to-many relationships among all pairs (AB, AC, BC). Three junction tables can be used to deal with the...

I am working in an education template and want to see if there is a way to create a field that can be added to periodically to show all the courses a person...

I have read articles upon articles on relationships. Just when I think I got it I cant create more then 1 record. I know this doesn't make a lot of sence. In...

Hi, First let me apolozie for the empty question below. I hit the Post button my mistake and it posted a blank question. Sorry. Hi, I am restating my...

SO I've read a little thing that warns against using the LOOKUP feature when designing tables. Apparently its not good to assign values to a field based on...

i want to open my website for my organisation and my company

If I use a Dlookup Function to pull the dat from a zip code table that matches the zip code in the query used for a report. Table1 Fields Name, address,...