Search results

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?

This formula is working fine as far as I can tell. =FILTER(SORTBY(tblBasketList, tblBasketList[Unit], 1, tblBasketList[Basket], 1), (tblBasketList[Last] <>"") * ((tblBasketList[Crew]= "B") + (tblBasketList[Crew] = "Days")) * (tblBasketList[NL]="")) Rows without a blank name, in the B and Days...

Howdy. I am merging the frontends of a few different databases my job has had me make over the last few years. Since I've been learning as I go, each new database I make has things that work a little better/smoother. I've started merging the front ends so that it's easier for me to maintain...

Appreciate you both chiming in. Yes, it should all be static. It'll be a report run from one system that is then imported into mine. So unless that other system does a big update/change it should always be the same column names.

So I have a spreadsheet that's exported from another system. I would love to create a system that lets someone upload the spreadsheet and it pulls the data into an existing table. What I'm imagining is some code, VBA or SQL, equating the spreadsheet column name to the table name. Then just...

I used the code arnelgp posted in this thread. Did you get a warning about macros being blocked? I re-downloaded the database, and it said that and showed the button captions, Command80, Command76, and Command77. But I moved it to a folder that didn't have macros blocked, and it showed up...

Thank you very much to you and tomasm for your replies. The table only has 99 records, though the field the control is tied to is a foreign key and that table has 654 records. But just in case, I increased the number of records to read to 10000, and clicked the ODBC fields option. This didn't...

Howdy. Thank you arnelgp for the great filter code. I have three filter buttons on one of my forms. They each filter/sort a combobox control. Two of them work fine. One of them however is only partially working. It gives you the option to sort a-z and z-a, but the list of values to filter...