Search results

Becuase the data changes week on week and we never want to over right any data, also the records are very large so separate tables will be best

So i have a database that creates a new local table which is created using a week number like LocalTable_Week1 I need to get access to have a query/vbs to then move the database from the local table to the oready created blank table for the same week number like Master_Records_Week1 what's...

Thanks for your pointers, i have now created a new table and have a vbs to rename it adding the current week number, and have also changed my code so when i export the table to excel it names the file with the current week number too so all sorted. will share code in a bit

is it possible to rename a table ending with the current week number it was created and or export the table via a query ending in the week number it was generated ?

I need to add to a query an extra column that would say [SN] [SN_REQ] 123 RR554554 If the two above have data in a new field say called "Match" write Yes *** Its ok i have just used an update query ***

Thanks so i need both or two options?

I need to convert this date layout... 2017-10-27 00:00:00.0000000 to 27/10/2017 is this possible?

I need to add a formula to a query to report as if data is found in one column write in a new column something like Machine_SN New Column 23GGGED11121212 BlueShark Brand So machine_SN if its populated - say BlueShark Brand ?

I am looking for a way to consolidate multiple rows into one line for the following results Customer_ID Start Date Last order PkID Last Contact Name 1444 01/01/2022 1444 28/06/2022 1444 323232 1444 Bob Smirth Output required... Customer_ID Start Date Last...

That worked, thanks

So i have a filed that is set as text and i need to convert as follows.. 22/07/2022 12:00-16:00 from the above i need to take the date and time window and split them. 22/07/2022 12:00-16:00 is this possible?

Can i add a button to a data entry form and on clicking it would get the customer details from a customer table, was thinking of as they type the account number it gets the details and auto fills the customer contact, address ect

So i need to have a query to show any customers details that have changed in a master table v a local table Cus_ID Phone_1 Phone_2 Email I have the same fields in both tables i need to have the query look at Master Table (Customer_Master) and Bring Back any records that do not match the Local...

Did the job thanks

Is it possible to have an update query to add a missing 0 to a telephone number

Worked 100% :)

Hello, I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to > [Delete_SetDate].[AppDate] The date in the table is set as 31/03/2022 - i am getting this error if i use this criteria it works >#31/03/2022# But i need to have...

Yeah thats why i have to use the bat file to do that, any other way to call a bat file to run other than SHELL?

it copies the same database and replaces the current one, so has to be done via cmd. seems anything that is called using "SHELL" is now being blocked by windows security

' runs the batch file shell Test.cmd This is now causing the operation to fail and windows security is blocking it from running. is there another way to run a bat file from VBS/modules