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

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

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

My data base is a record of bank deposits by date. I update the table using a form and I would like to automatically enter the next date by adding one day to...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

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

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

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

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

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

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

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

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

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

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

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

This is not a drop dead issue, yet is there a way to remove empty input mask entries or old ones that have been created? I've seemed to have collected a few...