ElizabethLOng
Last Activity: Oct 11 '12, 09:07 AM
Joined: Aug 15 '12
Location:
-
Sorry it took me sometime to reply, still trying to work out my code. I am using MS Access 2007. My code can filter records in the subform based on the date range entered in the main form. The problem with my code after filtering the subform it only refreshed the first record, is there a way to refresh all the filtered records? I need to constantly change the quantity at a certain date range in the subform based on the revised quantity in the mainform.... -
I filter the records based on date range using the above code.Leave a comment:
-
Want to replace just the records selected in the subformm based on the revised quantity in the main form. Tank you and regards EOLLeave a comment:
-
My code can only filter within the date range I need, which is perfect but I don't know how to continue to write the code that will auto replace the quantity on subform based on the revised quantity entered on the main form. Thank you for your help. Regards EOL
...Code:Private Sub Image87_Click() With Me.subformname.Form .Filter = "[DDate] BETWEEN " & Format(Me.LastOfRevSDate, "\#mm\/dd\/yyyy\#") &Last edited by zmbd; Sep 30 '12, 02:21 PM. Reason: When posting programing code, SQL, HTML, etc... please format it using the <CODE/> button.Leave a comment:
-
Thanks for your immediate response. The subform is embedded in the main form. Main form fields: CodeID (unique for each product), Product Name, Production Daily Quantity, StartDate and EndDate.
The embedded subform is linked to the main form by CodeID, I have a command in the main form that initially populate the subform with production daily quantity and running date (from startdate to enddate). During production the Daily Quantity and...Leave a comment:
-
Auto populate additional new records
One more problem I am currently facing with Access, I have a command that auto populate new records based on startdate and end date. How to add additional new records when the end date changed. Example: initial start date is August 1 and initial end date is Aug 31, when I click the command it will auto populate 31 records, my problem is when the end date is revised to let say Sept 30, can anyone please advise me the code to add on my command that... -
Sorry for my late response, I was trying to work it out. I think I am not clear with my question.
The main form and subform are linked by a CodeName. The main form has a forecast quantity (Fcast) and startdate & enddate)for each CodeName. The quantity for each CodeName in the main form keeps changing at certain date range.
The subform has a quantity field and running dates
Using a command how to auto refresh the quantity...Leave a comment:
-
Requery Subform
How to requery the subform based on date range after update in Main form. Example: The forecast quantity in main form was revised based on the new startdate and enddate. How do I requery the subform in order to revise the forecast quantity?
Thanks for any help.
Elizabeth -
Thank you ALL for your help. TwinnyFo, the code above is perfecrt, it works. I just change the field names as per my needs. Once again thank you all.
Can I ask you guys for more help. Can you please advise on how to filter and modify the data in subform. I need to filter records in subform by date range to change the ProdQTY. Example I want to filter records from Aug 25 to Sept 24 to edit ProdQTY from 100 to 200. Can you please...Leave a comment:
-
Thank you Zmbd & TwinnyFo for your responses. Apologies for responding only now as I was on leave. I tried the code send by TwinnyFo, but i KEEP GETTING THE FOLLOWING ERROR MESSAGE "424 Object Required". I am not quite good with Access codes, any help will be appreciated. Thanks again for your help. Maybe I was not very clear with my query. My Tbl-1 contains the ItemCode (unique for each item), item descirption, TQty (total production...Leave a comment:
-
Thank you for your immediate reply, what I actually needs is the code that will automatically generate the rows with date series in the subform based on the main form startdate and enddate for each ItemCodes, so I can enter in one go ALL daily ActualQTY without missing a day. Each ItemCodes will have different startdate and enddate. One item could be for a period of 3 months, others could be 6 to 12 month.
I tried searching the internet...Leave a comment:
-
ElizabethLOng started a topic Create rows in a subform based on a date range entered by user in the Mainin AccessCreate rows in a subform based on a date range entered by user in the Main
I have a list of items to be fabricated, each item is unique, each one has a stardate and enddate and quantity. I created 2 tables: Tbl-1 fields are ItemCode, StartDate, EndDate and PlanQuantity. Tbl-2 fields are ItemCode, PerDay (date), ActualQTY. I created a form with Tbl-1 fields as main form, and Tbl-2 as subform. ItemCode links the parent and child. I need a code that will automatically create rows in subform with daily dates based on the main...
No activity results to display
Leave a comment: