Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / March 2007

Tip: Looking for answers? Try searching our database.

Repeat Button Possible?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stockwell43 - 28 Mar 2007 01:10 GMT
Hello,

I was wondering if this is possible:

If a user has three loans by the same company(but different loan numbers,
amounts etc..) and fills in all the information in record one, because most
of the information will be the same for the next two records(next two loans)
is there a way to repeat the information from the first record to
automatically fill in record two and three by clicking a button or something?
My reason for asking is because one of the users said it take a lot of time
to entered repeated information and asked if there was a way to carry it to
the next record.

Thanks!!!!
Allen Browne - 28 Mar 2007 10:48 GMT
See:
   Assign default values from the last record
at:
   http://allenbrowne.com/ser-24.html

The code is very easy to implement. (It's a bit lengthy because it has to
figure out which controls to copy, and which ones not to, but you just
copy'n'paste it.)

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello,
>
[quoted text clipped - 15 lines]
>
> Thanks!!!!
Stockwell43 - 28 Mar 2007 12:52 GMT
Excellent, thanks Allen you're always a big help!!!

> See:
>     Assign default values from the last record
[quoted text clipped - 24 lines]
> >
> > Thanks!!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.