1. Welcome to PlowSite. Notice a fresh look and new features? It’s now easier to share photos and videos, find popular topics fast, and enjoy expanded user profiles. If you have any questions, click HELP at the top or bottom of any page, or send an email to help@plowsite.com. We welcome your feedback.

    Dismiss Notice

Using MS Acess

Discussion in 'Business Fundamentals' started by NNJSnow, Apr 15, 2003.

  1. NNJSnow

    NNJSnow Senior Member
    Messages: 228

    Lately I have been playing around with a common program on most of your computers called MS Acess. I find it very useful for holding account names, running billing, and many numerous applications. Just wondering if anyone else uses this and what they think of it. If you are interested in learning about MS Acess just ask.

    Last edited by a moderator: Apr 16, 2003
  2. plowman777

    plowman777 Senior Member
    Messages: 227

    i didnt know it was on most computers, i thought of it as expensive software but with limitations...we are presently using it at work to compile records of surveys we did of a large building complex, we have 20,000 entries and it searches fast, the only thing i dont like is there is no undo!...it seems very customizable. however i use quickbooks for my side business and love it.
  3. Rooster

    Rooster Member
    from Kansas
    Messages: 650


    MS Access can be purchased alone or as bundled software in a package such as Microsoft Office or Microsoft Office Professional.

    As Jeff stated, the program is very powerful. Configerations can be made to do quite a few functions.

  4. wxmn6

    wxmn6 PlowSite.com Addict
    Messages: 1,037

    I use MS Access for billing my customer. I built my own program for it. But the only problem I have is that I cannot find a way where I can type in my customer account number that can automatically enter the customer mailing address. Right now, I have to type in the customer address for each billing, which is very time consuming. My program have four boxes for customer address. First box is for customer name, second box is for address #1, third box is for address #2, and the fourth box is for the town, state, zip code. My program don't have a box for entering customer number yet. I know how to put the box in, but I can't find a way to make the program automatically enter the customer address once I enter the customer account number. Anyone know how to do it?
  5. Rob

    Rob PlowSite.com Veteran
    Messages: 306

    I presume that your program is storing the customer transactions are in one of the tables, correct ? Hopefully, this table is "linked" to a customer table where the address, name etc. information is stored, so that each of your invouice records does not have an address on it, but it is looked up on the customer address table. In any case, it would probably be easiest to add a "lookup" button to your form and put some VB code behind it to do the lookup and populate all the fields you are looking for.

    If you would like some assistance, feel free to drop me an PM and I'd be happy to help you out.
  6. NNJSnow

    NNJSnow Senior Member
    Messages: 228

    I think all you have to do is create a "primary key" which gives everyone on your data base a "customer number"

    If you need anyhelp feel free to contact me.