Search results

Hello, I've looked through the thread and was unable to find exactly what I'm looking for ? Basically I have a table with multiple fields & records and I would like to key on the ID field which has a slew of different ID's..... these ID's can be the same & show up on the table anywhere from...

Thanks again....I'll keep you posted !!

Thanks Doc Man, Basically the file I receive is coded such as YRT159.txt, and that changes to any combination everyday, tomorrow it could be 782FGY856.txt........I've tried the * wildcard but I get the bad file name or number error. So I'm still stuck on how I can set it up to read the unique...

Hello, Was wondering if there was a way to use the FileCopy method when the file name that needs to be copied is different everytime ? The path is the same but the file that is being sent there has a different name each time and I would like to copy this but unsure how to do this since the...

Thanks Keith, I'll try it out and let you know how it goes.

Thanks Keith, I attached a scaled down copy......the ID field within the table contains multiple ID's that I want to change each to another unique ID number. Again thanks

Hello, Was wondering if there is a way without building individual update queries, to update info in one field that has multiple criteria ? Basically I need to change/update daily multiple ID numbers to new ID numbers, long story on why this needs to be done but for now I need to do it this...

Bob thank you very much this worked perfectly.

That is correct Bob

Thansk for the reponse Keith, but I'm not too familiar on creating those....would anyone happen to have an example ? Thanks

Hello, Is it possible to remove a couple of numbers in the middle of a field by using an update query ? I have for example: YF000491 and would like to make it YF0491. Any help would be greatly appreciated. Thanks

Thank you so much for your help !!

Hello, Was wondering if anyone knew if there was a way to call the actual database name through a function ? I want to use this code in a bunch of db's and did not want to have to enter the database name in each code, would just like to try & call the database name and place it in the code...

Thank you sir, I will give that a try.

Hello, I was wondering if there was a way to block users from changing the criteria set within a query ? Basically looking for a way to stop anyone from changing the information within the query. Any help would be greatly appreciated. Thanks

Thank you I'll give it a shot

Hi everyone, Looking for some assistance...again on setting up some code which would locate the last business date of the month. Also this would need to exclude weekends & holidays (this is imperative to exclude these), if anyone can assist with this it would be greatly appreciated. Thanks...

Thank you very much sir, this works beautifully !!! Thanks again

Thank you Rural Guy, I will give it a shot and get back to you with my results.

Hi everyone, Looking for some assistance on setting up some code which would locate 2 prior business dates from today's date(e.g. today's date is 8/4, want code to pull in date 8/2) Also this would need to exclude weekends & holidays (this is imperative to exclude these), if anyone can assist...