A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007-Duplicate Record Field Capability



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 07:37 PM posted to microsoft.public.access.forms
Suew
external usenet poster
 
Posts: 48
Default Access 2007-Duplicate Record Field Capability

Sr. transportation appointment database. The form to schedule appointments
has a combo box that completes the client, address, city, and homephone
fields as requested by the end user. Added Find and Duplicate record buttons
so end user can find an appointment and duplicate the record to schedule the
return trip. Buttons work great except that on the return trip record end
user needs to type in the address the client is coming from and this not
possible because it is already populated from the combo box. Is there any
way around this?

Thanks for your attention.

Sue


Ads
  #2  
Old April 17th, 2010, 03:42 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access 2007-Duplicate Record Field Capability

On Fri, 16 Apr 2010 11:37:01 -0700, SueW
wrote:

Sr. transportation appointment database. The form to schedule appointments
has a combo box that completes the client, address, city, and homephone
fields as requested by the end user. Added Find and Duplicate record buttons
so end user can find an appointment and duplicate the record to schedule the
return trip. Buttons work great except that on the return trip record end
user needs to type in the address the client is coming from and this not
possible because it is already populated from the combo box. Is there any
way around this?

Thanks for your attention.

Sue



What's the structure of your table? What's the current code in the duplicate
button? What does the combo box have to do with anything (since I'd presume it
should be creating a new record in the table, rather than doing anything on
the form)?
--

John W. Vinson [MVP]
  #3  
Old April 19th, 2010, 03:58 PM posted to microsoft.public.access.forms
Suew
external usenet poster
 
Posts: 48
Default Access 2007-Duplicate Record Field Capability



"John W. Vinson" wrote:

On Fri, 16 Apr 2010 11:37:01 -0700, SueW
wrote:

Sr. transportation appointment database. The form to schedule appointments
has a combo box that completes the client, address, city, and homephone
fields as requested by the end user. Added Find and Duplicate record buttons
so end user can find an appointment and duplicate the record to schedule the
return trip. Buttons work great except that on the return trip record end
user needs to type in the address the client is coming from and this not
possible because it is already populated from the combo box. Is there any
way around this?

Thanks for your attention.

Sue



What's the structure of your table? What's the current code in the duplicate
button? What does the combo box have to do with anything (since I'd presume it
should be creating a new record in the table, rather than doing anything on
the form)?
--

John W. Vinson [MVP]
.
tblSchedule

ScheduleID-AutoNumber-PK
Driver
Day
AppointmentDate
PickupTime
SeniorIntakeID-FK (PK in Senior Intake table)
AppointmentTime
AppointmentNotes
Destination
ReturnTime
ReasonforTransportation
Cancelled
WhoCancelled
NoShow
UnabletoCancel

Current code of Duplicate button-On click-embedded macro
Combo box is completing fields from the SeniorIntake table in the form as
part of the appointment record. The end user requested when selecting a name
from the Senior Intake table the name, address, city, and home phone number
automatically populate.

Appointment by Date Query and Report:
tblSchedule
Driver
Day
AppointmentDate
PickupTime
AppointmentTime
AppointmentNotes
Destination
ReturnTime
ReasonforTransportation
Cancelled
WhoCancelled
NoShow
UnabletoCancel
tblSenior Intake
First
Last
Address
City
HomePhone

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.