I don't know if this is the right area or not but I'll give it a shot. Basically what we are wanting is to make a database that will store information that...

I'm trying to figure out the best way to go about creating something to track when vehicles are due for their next maintenance. I've created the tblVehciles,...

I have a co-worker that would like me to build a database that centralizes a huge amount of data and am wondering if Access would even be the avenue to try...

I'm trying to setup one field in my table to show percentages. I've selected format=percentage and tried everything from deciaml to double to long integer etc....

How can I format a field to hold 00:00 (minutes:seconds) ? In the end, I will need to add them up or do math operations with them. Can it be done in one...

I need to design a table for product attributes that seem to go on forever. Basically, we're trying to get all the possible responses that could ever be...

In SQL Server you can generate a script from an existing table that will create another table just like it. The script contains all the attributes,...

Hopefully this will make sense to someone... I have 5 table relationships. TableA -- TableB -- TableC -- TableD -- TableE I set up SUBSETS in the table...

I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current...

Hi, How would i design my database to work like this: We have 5 functional teams in the database. Four of those team can only have access to their...

Hi, I'm creating a form w/ several tabs. What is the coding for the tab when i click on one of the tabs it changes its font to bold and colored blue. thanks,

Hi, I have a table of file information. For image files, I wish to include a width and height field. Since most of my files are not images these fields will...

I have a table of estimates. Each estimate can have multiple locations stored as a text field. New need: I want to store the sizes of each location. Example is...

Please see the attachment. How can I create a form like this to store information. Here is what I have done. Created table BUSINESS , which has all the...

I have two table; TableA and Table B. Both have a key field named Item. When I add a record in TableA, I would like it to add to TableB automatically. How do I...

I am trying to add a drop down menu for States in my database design. How do I do that? I am very very new to access. I am using Access 2007.

I am trying to figure out a way to "randomly" generate a number, between 1 & 6; however, the caveat is that I also have percentages that each number should...

Do you recommend SQL statements, in the RecordSource property, or a saved query? Any particular reason? Thanks.

Okay, folks... I can not, for the life of me, see where my mistake is. I need another set of eyes. I am trying to loop through a Case statement, and want...

I create ms access database. In field level i get problem in date/time field when i enter any date manually it accepted, if i delete it display this message...