Seth Schrock,
Thank you for your prompt reply. But may i know how to add into the code you gave?
Million thanks...!
henry1988
Last Activity: Feb 5 '15, 02:06 AM
Joined: Jul 12 '13
Location:
-
Hi Seth Scrock,
Awesome, that is the code what I need! Thank you very much!
However, I notice that if I click the button twice, the data will insert twice. Is there any way can prevent this?
Again, thank you very very much.!Leave a comment:
-
Hi Seth Schrock,
Thank you for your advised. I am agreed with you but i have no right to restructure it due to my company policies..=(
Back to the insert query, is it possible to execute it by pressing a button in the mainform. if the answer is yes, then how to do it?Leave a comment:
-
Hi Seth Schrock,
The details are as below:
MAINFORM (TblStock)
Primary Key: STOCKID
STOCK DETAILS
STOCK INFO
* STOCKID from TblStock LINK TO STOCKID from TblDeliverDate & TblBackupDate (One to many relationship)
SUBFORM 1 (TblDeliverDate ) :
Primary Key: Delivery DateID
STOCKID
Date For STOCK A
Date For STOCK B
Date For STOCK C
SUBFORM 2(TblBackupDate ):...Leave a comment:
-
Thank you for your reply;)
Yes, it is a separate form. May I know how to use the Insert Query? Also, Is it possible to copy the data by pressing a button in mainform?Leave a comment:
-
henry1988 started a topic How to copy records from continuous subform to another continuous subform?in AccessHow to copy records from continuous subform to another continuous subform?
To person who may help,
I have a form with 2 continuous subform.
-Mainform is used to record the product details.
-first subform is use to record the product delivery dates.
-second subform is use to keep the previous delivery dates from first subform if we revised the new dates in first subform.
However, how to copy & paste the delivery dates from the first subform to... -
Hi Adezi,
Very thank you for ur help. I am ok with the calendar which showing 3 newspaper at the same time. i am a newbie for ms access. So i think the second option is not suiting me.......
HenryLeave a comment:
-
Hi ADezii,
Thank you for your replied!:') (touch)
Yes, the relationship was linked as to your perception.
HenryLeave a comment:
-
Hi Frinavale,
Thank you for your reply!
I am using Ms Access 2010.
Is it possible to do it?Leave a comment:
-
Create a calendar-view
To Any People who kind in help,
Currently I am trying to create a Booking Database for my department (advertising). Is it possible to show the record in Calendar View?
My Table are as below:
AdvertisorTable ( Field:Advertise rID, Company Name, Person In charge)
Order Table (Field:PressOrd er ID,AdvertiserID , Ad Size, Rate,)
InsertionDateTa ble:(Field: Press Order ID, Ins Date For Newspaper A, Ins Date...
No activity results to display
Leave a comment: