Search results

I have this code in the on current event of a main form I want a checkbox on the subform to change the value to false if QtyAvail = 0 But it is not updating. Private Sub Form_Current() If Me!frmOrderDetailsListToMarkForCompletionWthQty.Form!QtyAvail = 0 Then...

Thanks

What event occurs when user moves to new record on main form and subform updates the list of it's records? In other words: If move move to another parent record on a form, is there an event that is triggered in either the subform or main form?

Cool, that was easy!

Thanks How would i code this?

I have a popup form that lists records and has these fields: CompID Qty Date OrderDetID I want to restrict the user from editing the existing records while still allowing them to add the new record. Not sure how to go about this Thanks

I have a DB that has an OrderDetails table with Qty, Description, Yes/No Complete and Price fields along with some other fields. Currently I have a form showing an order list and when clicking on one of the orders, the subform will populate with all of the order details records. I can check each...

Thanks all, I will create separate reports, one with the filtered qry and one without. Thanks

Thanks, I forgot to mention that I have a report that prints all records of the subreport is there a way to modify the current subreport based on the combo boxes or do i have to create two seperate reports and subreports? And why do i have to remove the Master/Child Links? Thanks again

I have a form with cascading comboboxes, I select the record from the main table and then select the record of it child table. I want to open a report to the specific record from the parent table and to the specific record of the subreport. Any help is appreciated as always. Thanks

Yes My IT guy just clued me in. Very Frustrating

I have a project database that is written in version 2016 and File locking is not working correctly It is set up to be shared no exclusive locks or users, I keep getting "file already in use" This is a major problem! I need to know how to fix this once and for all. Please help!

Thanks guys, I think I got it working.

So do I set the recordsource for the subform to a sql statement instead of the query def (currently set to qryPayrollPunchEdit)? Here is my current recordsource in SQL View: SELECT tblTimeClock.TimeIn, tblTimeClock.TimeOut, tblTimeClock.Comment, tblTimeClock.AdjTimeIn...

Ok, so I have the unbound txt box on my main form with a date in it. how do i limit the txtTimeIn field on my subform to between that date ad 6 days prior? Thankds

Ok, so maybe I am not understanding: On the subform I have these fields, EmID, TimeIn, and TimeOut. I want to limit the records on the subform to where the TimeIn field is between period ending date and period ending date - 6 I don't have a period ending field anywhere on the forms as it is...

Thanks for the reply but I do not want to have to requery the subform's data everytime i change main form records - in other words, I do not want to have to select week ending date every time the user moves to another employee on the main form

I am not even sure where this post goes but here it is: I have a Employee form With EmpID and various other fields. Linked by Master/Child Fields is a sub form with time clock data, I want to be able to open the forms and limit the subform data to a Period ending date picked on a modal (or...

How do I put this code in a query OR How can I Private Sub Form_Current() If IsNull(txtAdjTimeIn) And Not IsNull(txtTimeIn) Then Dim t1 As Date Dim t2 As Date t2 = DateValue([txtTimeIn]) + TimeSerial(Hour([txtTimeIn]), Minute([txtTimeIn]), 0)...

Yes sir, Thank you! I had the brackets (not shown in my post) but it is indeed a calculated field - went to the source and viola, it works!