My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 How to get a default from the previous line?
|
|
 Jan 22 2007, 02:48 PM
Post
#1
|
|
|
New Member Posts: 2 From: Florida  |
This is my first Access job. I am posting payments to a table that is joined to a billing master table.
Most of the entries (batch, date, amount) are duplicates except for the master record ID. Sometimes an amount is different, and every 100 or so postings we start a new batch. All I can find in the help system is to enter Ctl + quote. There are >55,000 receipts to post. I want the form to offer the previous entry in the column as the default, so the operator can just hit enter, enter, to accept the defaults. I don't like the idea of having to hit Ctl+quote, tab, Ctl+quote, tab >110,000 times. Oh - and the boss wants it yesterday. |
 |
 
|
|
Jan 22 2007, 03:15 PM
Post
#2
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
Welcome to Utter Access Forums! -o!
Go here and scroll down until you find the Autofill demo. Download it and there you will find code to do what you want. There are may ways to skin this Access cat so search the Archives here or do a Google search.... hth, Jack |
|
|
|
|
Jan 23 2007, 07:41 AM
Post
#3
|
|
|
New Member Posts: 2 From: Florida |
Thanks for the pointer.
It's all about knowing the magic words (autofill). I was looking for "default from previous". Now if I can just make it work. Thanks, -Bill |
|
|
|
|
Jan 23 2007, 10:08 AM
Post
#4
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 09:40 AM |