I am trying to setup a database, forms, etc for a Bed and Breakfast reservations. Has anyone done this?

I'm creating a database to track/log quotes for products. I have created a master table for the all the information (quote log# {PK}, RepID, Rep Name,...

I have a Db that I am working on and I have several small tables related to one main table. the smaller tables are each to capture one step of a several step...

I have been developing a database with Access. I have a number of calculated fields; DCount, totals, Comparisons between DCounts, etc. My problem is that the...

We would llike to place our registrations in a data base with the option of printing invoices for club membership fees etc

Hi, I am trying to set up a database to be used by students to look up food composition information. The students need to search for information but don't...

I have added new records to a database via form, but when I go to search for the new record again using "FIND" it cannot find the record. Old records can...

Hi. Part one - my problem may be my design. I have a db with tables: tblSystem (*SytemID, CustomerID, lots of detail fields) tblCustomer (*CustomerID, name...

Is it best to set default values at table level or on the form? Is it best to base a main form/subform on a single table each, or a query that pulls all data...

Hi everyone, I am developing an Access database and I need some help to figure out how to link the table in the proper way. I have the tables which look...

If you right-click on a table or query, one of the options is to create a shortcut to that object. The result of this is a .MAT file. I have a user trying to...

I am designing a database to trace bid request info. I have created a (table)"project list" containing project name & project location, and I have created a...

Hi, I have been trying to learn database design for quite a while now. I never seem to have a block of time to devote to it though. I am back at it after a...

-- Catherine W

Hi, I have built a database and in the form I have a text box called Re-use Date and I have a text box called Term Date. I need the Re-use box to let people...

I have an autonum field in table1 that is the relational field to table2. It is an indexed field in table1 that will not allow duplicates, but is not the...

I need to write a validation rule on a table/field where the field must begin with a number, but then can be any length and any mixture of numbers and...

Hi! I need a little (a lot?) help. I'm working in a database that someone else built but I've been maintaining for a while. Now I want to add a field to a...

how do I erase what I originally typed that is showing in my document after I have made changes in tracking.

I would like the cells (fields) in my database to accommodate a greater amount of text when necessary - even to be able to tab to a second line in the...