Search results

Hi Thanks for the reply, i have to have it on Private Sub Btn_Update_Click() tested the above but doesnt seem to work? please advise thank you

Hi I would like a query to run, depending on a date If the date in [Txt_Date_Account_Opened] is between todays date, and within the last 30 days do CurrentDb.Execute ("Qry_Append_Units") else a msg box stating "account is not yet open" thanks in advance

thank you very much kind sir

Hi thanks for the reply, below is my code where i have Number: , in the msg body i want the number to equal the value entered in Fld_Number, label is Txt_Number - not sure which you need thanks alot Dim MyOutlook As Object Dim MyMail As Object Set MyOutlook = New Outlook.Application...

Hi i have code to open up an email from a form, what i would like is certain field values of the form to appear in the email anyone help? thanks alot

if the above doesnt make any sense basically my sub form has 5 seperate filters, one of them, if the end result is false (as in nothing to return, not null) then for that one to be ignored

Hi i have a form that user completes there are certain txt boxes that once filled out, will filter a subform of a table of 1000's of records to give them a number to use on the form around 200 of the records have a depot in the "depot" field on the table, when they input a depot, it filters...

works perfect thank you the ascetics of the form need it this way, thank u very much

Hi All please could someone help with the below i have a table holding a list of post codes, and their servicing depot EG - ID Postcode Depot 1 AB10 Edinburgh 2 AB11 Edinburgh then a form, which has a field for depot ( Fld_Depot ) what i would like is, when the user clicks...