Search results

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

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

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

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

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

Hello. My name is Rocky. I'm an office worker in the US who's trying to teach himself database, VBA, SQL and other fun things while doing projects for my job.