Search results

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

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

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 & "'"...

Need Help with Summing Query (SOLVED!) Hello again! Another question, since you were so helpful with the last one: I have four columns: Employee, Discipline, AvailableHours, TotalHours. I want to summarize these by Discipline, so that for a list of employees, I wind up with a list of the...

Hello everyone. I'll try to explain this intelligently. I need to generate a report that uses a Left Join query. The tables being joined are a "Projects" table and an "Assignments" table. The Projects table, as one might expect, has one entry for each project being worked on. The Assignments...

Question guys: When is it appropriate to use the '.Value' property in your code? I'm OCD about keeping code as neat as possible, and I started wondering if I was doing things properly. For example, when referring not to a control, but a field in a linked table, which is the "correct" form to...

Hello all. I'll cut to the chase. I have an Access front end and SQL Server back end. I use DSN-less connections to link up all the tables. If the user doesn't have the rights, then I get this error: and then it displays a small login window with the server info, etc... I want to avoid all...

Hey guys. I recently converted my back end to SQL, and since then I've been trying to track down things that broke, and fix them. I posted this in the SQL subforum, but I think it's actually a VBA issue, so I'm putting it here too (this subforum is also much more active.) I'm having trouble...

Hey guys. I'm new to SQL, and I can't seem to resolve this problem (and neither could my SQL friend.) I recently converted my back end to SQL, and since then I've been trying to track down things that broke, and fix them. I'm having trouble getting timestamps to communicate properly between...

Hi guys. Did what everyone here suggested I do and converted my back end to SQL Server. I'm still learning SQL, so I'm tracking down all the things that broke during the migration and am trying to fix them one at a time. Here is a bit of code that worked fine when the back end was in Access, but...

Hello All, I've done a little bit of Googling and some searching here, but still feel as though I don't have a firm grasp on this subject. This is my first "real" database that I have built. It is going to be deployed to many users, at many satellite locations across the city. Prior experience...

Hello all, I have code that loops through a lot of objects, and adds them to a table. Right now I have suppressed the warnings via the DoCmd.Setwarnings = False command, in order to avoid the user seeing the message confirming that they want to make changes to the table. However, I WOULD like...

Hey guys, I've got a simple question. I have two forms - both of which are subforms on another form. Each of them is linked to a different table. The master field/child fields are linked to the main form, and those fields do not have controls on the subform as that is unnecessary for me. On...

Hey guys, this is the query I am attempting to run: The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. Can someone explain to me what I am missing? I need these sorted by the NumberofReRoutes field, but this...

Hello all. So I have a main form and a subform. Long story short, I do not want to allow the main form record to be submitted unless there is at least one subform entry. Initially I thought it would be as simple as a "Before Update" event which would test the record count of the subform. This...

So I know you guys on here like to harp on everyone about proper database design and structure, so I'm sure there is someone who would love to answer this question. I have a table which holds records for an employee's work day. As it stands right now, along with all of the other information...

Can someone tell me how to solve my data type mismatch? It is supposed to be filtering records to only show those where the user-entered date falls between the start and end date. I can't seem to figure out the proper way to relate the date in the text box. I've also tried without the hashtags...