Search results

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

LOVING THIS HOW DO I GET IT TO RUN IN X64 BIT ACCESS

Thanks we now have many users connected through VPN, so we are experiencing slowness caused by home working and VPS.

Hi, I am trying to gain the understanding on how changing these settings can improve the speed..

dont understand as then if i open the file in excel and change the format its all correct?

I am trying to export a table to a csv file but the numbers are showing up like this Guess i need to have some formatting added to a query?

sorted this added code to close outlook and load a different profile

Is it possible to have the code changed to send the emails from a different outlook email address. this is my code.. I get this to work by creating a second profile in outlook and select that and it send correct but looking for a way now to have the code do this so the user doent need to do...

Resolved it back changing the method - Thanks Dim MyDB As Database Dim MyRS As Recordset Dim MyForm As Form Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment Dim...

Moved loop to after End With and now getting's this error.. on debug this is the line highlighted in yellow .BodyFormat = olFormatHTML end With MyRS.MoveNext Loop End Sub

changed as above still same issue on the loop

yeh code is behind button and in my test i have 3 emails to send

Dim MyDB As Database Dim MyRS As Recordset Dim OutlookApp As Outlook.Application Dim OutlookMail As Outlook.MailItem Set MyDB = CurrentDb Set MyRS = MyDB.OpenRecordset("test") MyRS.MoveFirst Do Until MyRS.EOF Set OutlookApp = New Outlook.Application Set OutlookMail =...