Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Unanswered: Pulling information from prior records for new data entry

    Totally new to Access, just started last week. My company needed a program to keep track of venders and print checks. We have custom made checks so the fields are in different places than most stock checks, and I just couldnt' find a program that would track the stuff we wanted and print on our checks. So, I made one.

    http://www.frogheadedmonkey.com/checks5.mdb

    On to my questions...

    Everything is working great on it, but I can't figure out how to do a few things:
    1. On the check entry section I want the check numbers to automatically increment from whatever the last check number was. But it also needs to be able to be changed if necessary (in case someone hand writes a check) Can't seem to get this to work right.

    2. On the check entry section I want it to also pull whatever the last check entry information was from that last vender (we have a lot of reoccurring checks).

    3. I don't suppose there is a fairly simple way to convert the numeric vaules into words so I don't have to type both? (e.g. $10.05 to TEN DOLLARS AND FIVE CENTS)

    I'm a pretty quick learner, but these have got me stumped.
    Last edited by blarneystone; 09-22-08 at 11:12.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    1) http://www.mvps.org/access/forms/frm0012.htm (modified to add one) You could also use a DMax to get the largest existing value and add one to that.
    2) Open a recordset using the vendor control, using SQL that gets the last check entry for that vendor, and fill in the form using values from the recordset.
    3) http://www.mvps.org/access/modules/mdl0001.htm
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •