Search results

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?

I need to stop a record from being saved when the user closes the database and dots click save button on the form Seems that if you started a data entery and then stopped and just closes the database the record is saved in the able but blank?

so yes as its overtime hours available for future 10 days post today, dont want to show anything before 10 days, dont think its possible anyways

:(

So i am wondering if you can hide a field in a form if the title which is a date if its not 10 days from today field title = a date in the future with a count of available hours like 10/03/2022 14.5 11/03/2022 22.5 so i now need to hide 10/03/2022? as its 11 days from now?

thanks i had already setup a table and it all works fine :) "I have all then dates in a table called "BankHolidays""

thanks this all worked and i have tested :)

So i have this code that creates a date 12 working days from today, but i now need for it to check if the date its offering as a Bank Holiday and if so move to the next weking day. Public Function addDays(ByVal iDays As Integer, ByVal dteStart As Date) As Date Dim i As Integer Dim m As Integer...

Thanks changing this to < [Forms]![Requests].[Date] worked

So i need to have a query being back all records added before a date on a form. Tried this but didnt work <[Requests].[Date] get a prompt

So i need to add this to any numbers that are only 5 string long CorrectNumber:"2000" & [InvoiceNo] but i only want to correct if the current number is less than 6 ? how would i go about this please

did the job thanks :)

Is it possible to have on a form something that will prompt the user entering if the number of characters within a field is less than 10, is so then pop a message to say

this did the job Left([ACTION],2)

Hi, I need to trim all expect the numbers 03: SET ACTION 04: SET CALL BACK 05: CLOSE just need 03 04 05 any ideas please

what's the best way to say if two fields in query match [ID]=[SID],Yes,No ?