Recent content by Stang70Fastback

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