Recent content by RWilliams500

Have not tried the quotes. Will do so. It's a mix of Win 10 and Win 11, and I tried it on a Win 10 VM right before posting, and not a problem at all occurred. It is, at the moment, literally one system where multiple others just like it are fine.

I have a batch file that downloads the current front end from a file server to the user's computer, then runs the front end with ' Start "" "%userprofile%\Documents\Databases\Exam\WarriorExam_USER_FILE.accdr" /cmd batlaunched '. This tells the program it was run from the batch file, rather...

Thank you very much for the tip. I can definitely picture myself running around in circles in a scenario like this trying to figure out why my new knowledge isn't working in a situation like this.

So how do I set the parameters so that when I have (as an example) DoCmd.OpenQuery "QueryName", acViewNormal it does not prompt for the parameters? That is the question I'm trying to get answered. If that is not possible, fine, I'll figure out alternatives. I'm not just trying to solve this...

So you cannot open it to view with the parameters already filled out? You have to do it as a recordsource or like as a recordset of a form? Because getting rid of the 'Set rs =' line doesn't make it work.

Adding the defined parameters did not. It still asks for the parameters again. As far as getting rid of the function call... How do I figure out the value of the function without calling it?

This is the full query. SELECT tblEquipment.EquipmentID FROM tblEquipment WHERE ((([parExamFreq])="Weekly") AND (((DatePart("yyyy",[tblEquipment].[StartOfServiceDate])*1000)+DatePart("ww",[tblEquipment].[StartOfServiceDate]))<=fExamPeriod([parExamPeriod],"Weekly"))) OR...

The query, originally, had more options. But with it having trouble, I paired it down to try to eliminate variables on what the issue could be. If I can get this to work, I'll just add the other options back in.

I'm not sure what you mean about the double quotes. But here is the qdf.sql FROM tblEquipment WHERE ((([parExamFreq])="Weekly")) GROUP BY tblEquipment.EquipmentID, (DatePart("yyyy",[tblEquipment].[StartOfServiceDate])*1000)+DatePart("ww",[tblEquipment].[StartOfServiceDate]) HAVING...

Howdy. I'm messing around with parameters in a query and setting them via VBA and I've hit a problem. I think I'm setting them right, but when I open or execute the query, it still asks for the parameters. If I enter them in the prompt, it works fine. Also, the For Each debug.print section...

Based off @MajP suggestion this is the query I went with. It SEEMS to work properly, based off my bit of poking around so far. This appears to be getting me people who used to be actively assigned (in tblAssignedExaminers with an assignment type of 3, and not in the table at all having never...

Not in! Holy cow, I didn't even know that was a thing. I REALLY need to do a real read of some SQL book or something. I was trying to get it with the Access not matching query. Thank you for the point in the right direction. If I still can't get it, I'll post more information as GPGeorge...

Howdy. I'm trying to get a query (and ultimately a form or control) to display any active user that is not currently assigned to the piece of equipment being viewed in a form. I'll give (what I THINK is) the relevant table information. There are other fields in the table, but I didn't want to...

Yes, I'm aware of that. Was there supposed to be more to the post?

But it works in the top formula. Why would it not work in the second formula?