Search results

If I use a query, can I still edit the data in the form, though? I thought that at that point the data would become read-only?

It gets a little bit complicated, but there are several tables involved here for various reasons. Here are the relevant fields: Table 1: Timesheets - Employee Badge Table 2: Employees - Employee Badge - Employee's MANAGER'S Badge Table 3: USERS - Manager's Badge - Manager's Windows CORP...

Like, the resulting SQL statement will look different for every record it looks at. Maybe that's where my problem lies... now that I think about it, I don't think that makes any sense. For example, for each record in the Timesheets table, I would expect to see: SELECT * FROM Timesheets WHERE...

Holy $%&# how have I made it this far in life without that glorious snippet of code?!?! EDIT: Do you know if it's possible to have it iterate the output for each record it looks at in the Timesheets table?

Hello all. Here is another issue I'm having. I have the following in query form: SELECT * FROM Timesheets WHERE Nz(DLookup("Username", "USER", "Badge = " & Nz(DLookup("Manager", "Engineers", "Badge = " & [Badge]), 0)), "NoResult") = fOSUserName(); I realize it's a bit "messy" in how it does...

I love you long time!!! <3

Ohh, that's a good idea. Let me try that instead. Will report back in a few. I appreciate the help. Is that a better method to use in general? Is there a reason to use one method over the other?

So I added several "MsgBox" markers throughout my Form_Load code to see if it is working as intended, and it turns out that NONE of them appeared. So the Form_Load event doesn't seem to be even firing. So it looks like I'm getting white space where that form is supposed to be because the form...

This whole chunk of code is in the Form Load event. I'm not doing anything outside of this event with regards to the VBA code.

I just tried that and it didn't help, unfortunately. I still get a giant blank white space where the form is supposed to be, and if I edit the form, I still see the previous filters in the form's properties. :banghead:

Hello folks. I'm sure this is another simple one, but I can't seem to find the solution anywhere. I'm using VBA code to set a form's filter and sort order based on certain criteria (mostly, which user is logging into the database). For example: If DCount("[Username]", "USER", "[Username] =...

By default, as you type into a listbox, it searches in a "starts with" fashion. Is it possible to configure a listbox to search in a "contains" manner? For example, if the listbox contains 4 entries: This is a test Testing 123 Also another test Macaroni and Cheese And I start typing "test"...

Okay, so I'm probably doing something dumb, but I'm TEARING MY HAIR OUT over this. I've got a continuous form, and one of the ways I allow users to clear out records in this form is by clearing out the first combo box. SO, I have this chunk of code, which works just fine for the job (basically...

Hello all! Here is my latest conundrum: I have a table of data that exists as such: DISCIPLINE | MONTH1 | MONTH2 | MONTH3 | MONTH 4 | ... | MONTH 12 Architecture | 384 | 382 | 234 | 429 | ... | 434 Civil | 324 | 598 | 843 | 472 | ... | 425 Structural | 432 | 892 | 842 | 133 | ... | 743 etc...

Okay, so I figured it out and I feel dumb. It WAS just the two fields with the slashes. Someone edited the tables and made exactly TWO changes: They changed the "Mechanical/Plumber" field to just "Mechanical" and the QA/QC field to "QA / QC" for some dumb reason. I hate people. Time to add...

Well screw you then, lolol. Hmmm... let me do one last round of idiot-checking and if I still can't find it I'll snip things apart and post something :)

I'll try to separate stuff out so I can post something. I have like 10 fields, and only the two with the slashes cause the problem. I've encountered this issue before, I think, but I can't remember how I solved it. If you explicitly name the string, it's fine, but if it's a reference to a...

Neither of those options seem to work. In either case I still wind up with a blank report with the #Type error :(

Hello all! Simple question. I have the following code: If DCount("Employee", "ManpowerDataEmployee3", "Discipline = '" & Me.DisciplineCOM & "'") <> 0 Then DoCmd.OpenReport "ManpowerSummaryDiscipline", acViewPreview, , "Discipline = '" & Me.DisciplineCOM & "'"...

I actually did do exactly that in another query where things happened a bit differently because the numbers were grouped by employee. In this case, that isn't possible because some of the employees are part-time employees, so the number fluctuates. I actually resolved this issue, but forgot to...