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