Search results

I stepped away from this and just came back to it. I was running an update query generated from a userform which populated the current data from a table upon loading and allowed a user to modify values then update the table. I'm glad I worked on something else for a while because I just went...

I'm having trouble articulating this because I've been staring at this for the past couple hours and it's giving me a headache. I'll try to break this down it its simplest form. I have a combobox on a form that is set during the form's load event using a public variable which stores a value from...

I could have worded it better, see my previous response. Prior to opening the second form the current row's data in the listbox (its query) is stored in public variables which are then passed to the second form. The controls in the second form are set during the form's load event. I've double-...

I stated that it's coming from the table with the field set to long integer that the listbox is pulling from and that the variable being used to store that data is also set to long integer. When I msgbox the variable to see what it's returning it's what I expect it to be. Sorry if it's worded...

I have a form with several comboboxes that pull their values from another form. Everything works as expected except for one particular combobox. Its bound column is set to reference a listbox (whose data is populated by a field in a table with a long integer datatype.) The variable used to store...

Okay, that was enough to get me pointed in the right direction and now it's working. Thanks!

Okay, that makes more sense - I misread the prior reference to the code builder as Expression Builder. When I click the button it returns the value in the combobox.

Using the Expression Builder, correct? When I try the above I am still prompted to enter parameters, and when using [MsgBox Forms] I also get a syntax error. Speaking of which, I'm not familiar with that particular tag; what's the significance of adding MsgBox?

Are you sure? I can get three (counting the NavigationForm's sub). See attachment. Maybe I'm not following you, but that doesn't work when calling the sub from the Navigation form. It only works when the form containing the sub is loaded on its own. *Edit: For simplicity's sake, I recreated...

I've searched for a few hours and have not been able to find a solution. I am using the NavigationForm with a subform (frmSetup) as one of the tabs. Within frmSetup, I have a combobox that loads another form within frmSetup's subform (fsubSetup). Within one of the possible forms that can be...

Yes, you're correct - I originally had it like that, but when I had the function in the criteria field of [employee name] in the query design, it started giving me an error for a reference to more than one [employee name] (which I'm not sure why, there's only one in the query). I added the table...

It does not expect a parameter. Each employee only exists once in the table. The other table has performance data linked to the employee (by a unique number). The report always produced unique employees, the trouble I was having was hitting the limit on open table references when trying to...

I really do appreciate your help; however, I'm still having problems. I understand what you're saying, and I know what I want it to do, but I'm having trouble executing it. This is what I have now: Option Compare Database Option Explicit Private Sub btnpdf_Click() Dim db As...

Thanks for the reply. I've re-done this so many times and have been staring at it for so long it's starting to melt together. Are you saying I need to set the recordset inside the loop? Can you extrapolate a little more, please?

I know. Please re-read my question. I'm not opening the report in any of that code. Also, I want ALL of the employees to print individually with one event procedure. There are thousands of employees; it's not practical to select them individually with a listbox (unless there is some other...

Okay, I'll preface this by saying this project caused my first attempt at this. I originally got it to work fine by grouping on the report (opened report, docmd.output to PDF, close report - then closed rst and set =nothing); however, I quickly ran into the dreaded 3014 error (can't open any...