Recent content by stevenblanc

There are aggregate calculations. In order to determine the first and last swipes for each employee for the day I effect two queries and then join them. The first query groups date, employee, etc, and calculates the minimum (first swipe) on time and sequence ID. The other does the maximum...

Hi folks, I have a report run based off of a query. If I run the query directly, it loads in about 5 seconds; however, if I run the report it takes about 10-15 minutes to load and is only 3 pages long. The query contains first entry/last exit times for employees filtered by date. The report...

Bob, What is the danger of navigating the recordset? Also, resolved, if anyone is interested, here's the full code for the sub: Private Sub OpenCustomerReview(ListIndex As String) Dim strLinkCriteria As String strLinkCriteria = "[CustomerID]=" & "'" & Me.lstCustomers.Column(0) & "'"...

The form is open otherwise it would not make it through the first three lines of the with statement... I think my brain just clicked into gear: that particular form is unbound and as such cannot do record navigation... problem probably solved.

Hi folks, Looking for a little help here. I have a form that allows my users to select a customer from a list and inputs that customerID into whichever parent form they call it from. This works fine for 90 percent of my forms, however, I am getting the following error on one form: The body of...

Thanks for the effort Dale. Much appreciated. I'll repost tomorrow, I think I'm done for the night. Cheers, Steven

Neither refresh nor requery do anything.

I dont open the service entry form. It is a subform embedded in the same form as the listbox. It has the following properties: Link Master Field: tblMachines Link Child Field: MACH_ID ' which is the machine id It cuts down on a lot of code. When I click it updates with no code. Just doesnt...

1) CUST_SYID is not a number, it is a string. 2) Its not a bound field, and I know its a little inconsistent but I was porting code at one point from another one of my databases and it was easier to rename the textbox than find all the instances in the code. 3) That works fine without changing...

Correct. The user selects from the popup and it inserts the customer id into txtcustomerid and calls its afterupdate event. Public Sub txtCustomerID_AfterUpdate() Dim intCustomerID As Integer Dim strCustomerName As String intCustomerID = DLookup("CUST_ID", "tblCustomer", "CUST_SYID=" &...

When the customer changes and the list updates (it updates just fine). I want the subform to update and display the service information for the first machine in the list. That does not work, if I then click on the first item, it updates.

Ok. There are three tables at work here: tblCustomers - Customer Information tblMachines - Machine Information - Linked to tblCustomers by CustomerID tblService - Service History Information - Linked to tblMachines by MachineID The form in question is the Service Entry Form. The user selects...

The subform data is tied to the listbox selection, i.e. master field link = lstmachines. The purpose for the listbox is to allow the user to select the machine he wishes to view the details for on the subform. However, the machines listed in the listbox are only for the current customer...

Dale, Thanks for the reply. The issue is: when I use vba to make a selection in the listbox my subform does not update. If instead of using vba, I click to make the selection, the subform updates properly. The listbox contains a list of machines relevant to a particular customer. If I change...

Hi folks, So I have a subform whose 'Link Master Field' property is set to my listbox, 'lstMachines'. When I click on an item in the listbox the subform automatically updates to reflect the child records. However, when the items are updated in my listbox I use vba to select the first item in...