Help with a Macro!

[Bob V]

I am trying to write a Macro that will enter these thing into my text boxes
on a form, How do I go about writing it?
Thanks for any help.............Bob
tbStartDate1 = DateSerial(Year(Date), Month(Date), 1)
tbEndDate1 = DateSerial(Year(Date), Month(Date) + 1, 0)
cbDailyCharge1= tblServiceInfo,ServiceID(AutoNumber)2

on the subform:
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)2
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)5
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)7

 

[pietlinden]

I am trying to write a Macro that will enter these thing into my text boxes
on a form, How do I go about writing it?
Thanks for any help.............Bob
tbStartDate1 = DateSerial(Year(Date), Month(Date), 1)
tbEndDate1 = DateSerial(Year(Date), Month(Date) + 1, 0)
cbDailyCharge1= tblServiceInfo,ServiceID(AutoNumber)2

on the subform:
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)2
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)5
subAdditionChargeChild,AddintionCharge =
tblAdditionalCharges,ChargeNumber(AutoNumber)7

Personally, I'd use VBA.
Here's an article on Access Web that might help. Can't tell you how
to do it with macros. Never use them.

http://www.mvps.org/access/forms/frm0031.htm

 

[Bob V]

Thanks Steve for your response, Each month I do an Invoice to a Client for
his horse , say 80% of the time the first "say" 4 things I do is the same,
so I was thinking if I had a macro that I could click on my form it would do
these 4 things for me, but the sub form has a continuous form that adds up
the expenses with details and date, It just seems so easy in excel when you
can record a macro but not in access, thanks for the help... Bob but I think
I will give it a miss its not as simple as I thought it would be!

 

[Steve Schapel]

Bob,

I understand what you are saying.

Macros in Excel and macros in Access are quite different creatures.
And, of course, Excel and Access themselves are quite different creatures.

I think you will find that what you want to do is not really all that
difficult in Access. But yes, it will mean learning about database
concepts, and learning new skills.