Search results

I have a form that shows all records in a query, one field is called ProductType, In the header I have an unbound combo box that gets records from the product type table and filters the detail section of the form (all records) to the selection in the combo box. All is working fine but once i...

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...

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?

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...

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

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!

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...

I am trying to use the =Sum(txtHours) on a form footer. All I get is error, what am I doing wrong?

I have copied the following code from another thread, post #4, the thread is located here: https://www.access-programmers.co.uk/forums/threads/roundup-or-down-to-the-nearest-half-is-it-possible.237264/ It is not working , please help Public Function RoundTime(varTime As Variant, Optional ByVal...

I have a table that collects clock-in and clock-out "punches" for my employees to do Job tracking, the employee clock's in on a work order, then clocks out on that work order, then Clock's in on a new work order all through the day. so each entry in the timeclock table has two entries - an "in"...

I have a form that is unbound, I scan an employee badge and the after update event opens a Job tracking form that has a work order subform on it. when the job tracking form opens after some if/then statements, the form sets focus to a work order field and is waiting for input, when I scan the...

I have a time keeping form that should set properties based on the conditions of the last record such as if there are no time stamps then the time-in field should be enabled and the time-out field should not, but it is not working. Only the second set of conditions works correctly. Here is the...

I am working on a form for my shop personnel to keep time on orders out in the shop. The plan is to have 3 or four computers connected to our network with scanners and access (distributable) on each one. Here is how I envision it: The whole process is collecting the employee id, the work order...

I have a table with a field named WONumber. It is input by a barcode scanner and is a Text field of the order number (long) and item number (txt) and is represented like this @@@@@-@@@@. After the dash in the field the remaining string is of variable lengths, so I am doing this to get a Dlookup...

I am not sure what has caused the issue but I am pretty sure it is either a MS windows 10 update or a MS Access 2016 update, but my application has stopped allowing multiple users to connect to my backend. has anyone come across this and if so found a solution. I need help quickly as this is...

I have a report that I need to print out for each record on a quote, the problem is that I need the report to print duplicates for each line item based on quantity. So if Line 1 has a qty of 1 print one copy, line two has a qty of 10 print 10 copies for that item, ect. Having trouble getting...

I have a quote form that looks up a product we build to get all the pertinent info from such as price and description. The combo box then takes the ID for the product and saves it to the quote table, the drop down list is based on the products table and only shows active products so someone...

I have a main form with a sub form on it. and a subform on that one as well. The subform's subform has accessories and has these fields: qty, price, exprice. With exprice being a calculated field of price x qty. I have a total on the header of this form with this =Sum([ExPrice]) in it's...

Does anyone know how to write code for a dynamic search box for data in a form who’s recordset is read only? The one I’ve been using works great when the query is editable but when I add a calculated field I get the dreaded “can’t reference a property unless the control has the focus” Thanks