Design view is a good place. Double click on "Create a table in Design View." When you create your date field you will set the data type to "Date/Time." At the bottom of the screen are the field properties which I was talking about previously. For the other two numbers fields you can set the field length as well within the field properties.
This is for my wife. She places files in a box. She wants to be able to enter a file number and a box number. Then be able to type in the file number she is looking for and have it show her what box it's in.
If it's easier the file number can have the year (07) precede it as xx-
If she is using 2003 then you will want to save it in a 2003 format. I would even recommend that you make it in 2003 since some of the new items in 2007 are incompatible with 2003. Please list all the fields that will be in her database and I will look into making something for her
If she is using 2003 then you will want to save it in a 2003 format. I would even recommend that you make it in 2003 since some of the new items in 2007 are incompatible with 2003. Please list all the fields that will be in her database and I will look into making something for her
No, using Access is a lot of fun, and easy to boot. Now, building a complex database, well, to major geeks (Hi Jim!), that is fun too!
Happy New Year, gang!!!!
This is pretty crude, but you could use it as a starting point/sounding board for your own ideas and preferences. You may also want to think about how data is entered into the table. For example, create a check to verify that each file number entry contains "xx-" at the minimum.
I can have the year automatically be pulled into a year field and then truncated to two digits based upon when she makes the record. This will not be that hard to setup. I just need to know what she is wanting to track. It seems like this is her field list so far.
Year (2 digit format)
4 digit field (number I am guessing, but what is this for)
6 digit field (file location, but what format does this need to be in? will it hold letters and numbers?)
Of course you're looking at two forms-data entry & query. Only the data entry form should automatically pull the year. (OK, I guess the query could pull the current year as a default, but the user should be able to change it for the query whereas she shouldn't for the data entry.)
For mine, it is only a default value and as such can be easily updated.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!