1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Database

Discussion in 'Business Applications' started by Tstright, Dec 27, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397
    I need help in creating a database that can be searched.

    3 Items are needed...

    A 2 digit year entry
    A 6 digit numerical entry (need to be able to enter less digits)
    A 4 digit numerical entry (need to be able to enter less digits)

    I need to be able to search the 6 digit number and have it tell me what 4 digit number is associated with it.

    I am hoping I am making this clear...

    for Access 07 or 03? (the previous version)

    TIA

    Tom
     
  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    What do you want to happen when they fill-in something less than 4 or 6 characters in those two fields?
     
  3. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Sorry I should have addressed the date field as well before tackling the other two. For the date field type in YY in the format field property for it.
     
  4. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397
    That field should allow up to 6, less is ok....
     
  5. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397

    Ok, But I know zip about access. where is a good place to start?
     
  6. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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.
     
  7. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397
    I'm using 07, I'll have to read up on this....
     
  8. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Ah, ok I thought you had both by specifying both in the initial post. Do your users use both or just Office 2007?
     
  9. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397
    I want to say they have 03....

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

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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
     
  11. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397

    I think we can get by with 2 fields

    A file number with the format of XX-XXXXXX (First 2 digits are a must, the 6 after the dash can be less than 6)

    A box Number with the format of XXXX (Can be less than 4 digits)

    And she needs to be able to enter the XX-XXXXXX and have it show what box XXXX it is located in.

    TIA

    I can see that using Access is an involved process.
     
  12. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    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!!!! :)
     
  13. rconverse

    rconverse

    Joined:
    Sep 7, 2007
    Messages:
    191
    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.

    Thanks,
    Roger
     

    Attached Files:

  14. Tstright

    Tstright Thread Starter

    Joined:
    May 19, 2007
    Messages:
    397
    Thanks for the help...
     
  15. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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?)
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/665415

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice