Search results

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

@theDBguy hope you can help me please

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

Thanks so how would i add that please just add ... MyRS.MoveFirst Do Until MyRS.EOF MyRS.MoveNext Loop

so this is what i have and it works in that it just sends an email to the first contact in the table, how do i set this to run through all.. Dim MyDB As Database Dim MyRS As Recordset Dim OutlookApp As Outlook.Application Dim OutlookMail As Outlook.MailItem Set MyDB = CurrentDb Set MyRS =...

Hoi, I need to have access send on a daily basis emails to customers which the data is stored in a table. Any suggestions for the best way, can i just set up access to send the emails? and also attached two pdf files

looking to connect directly into data bricks data tables can this be done?