Search results

Thanks again Trevor, It Worked perfectly :)

I would like to have 3 tick boxs only one of them will ever be ticked at once for example; 1) Version 1 required 2) Version 2 required 3) Version 3 required And then to have a command button where when clicked it sends one of 3 pre scripted emails dependant on which check box has been...

I am using the following code to send an email from a form. Private Sub Label133_Click() Form_frmClose.SetFocus Form_frmClose.txtEmail.SetFocus On Error Resume Next DoCmd.SendObject acSendForm, "frmClose", "html", Forms!frmClose.txtEmail, Forms!frmClose.txtEmail & "; " &...

Thanks for your help Trevor, I have created the query and it works perfectly.

Hi guys, Is there a way to copy all data from one row in a table into another automatically? Today I have columns for example; table ID, Reference number, Name It would be really useful if i could create a Reference number_V2 and automatically fill my form with data from a specified...

I honestly can't thank you enough guys Access seems to be a really powerful tool and I am almost finished with my first database :D Thanks for your time, Jason

Thanks for your input Pbaldy, I am still struggling though, this code returns the "compile error" "expected end of statement" and highlights the second Form! Private Sub Command32_Click() Form_frmRaise_Revision1.SetFocus Form_frmRaise_Revision1.cboSupplierEmail.SetFocus On Error Resume Next...

Sorry the Error for example is when using the following code DoCmd.SendObject acSendForm, "frmRaise_Revision1", "html", Form_frmRaise_Revision1.cboSupplierEmail.Text: Form_frmRaise_Revision1.cboTEmail.Text , Form_frmRaise_Revision1.cboSupplierEmail.Text, , "Subject", "Email" & vbCr & "Email"...

Hi all, I am trying to use the code below to send an email to more than one person, the email addresses originate from combo and/or text boxes. So this code works perfectly when sending one email from cbosupplieremail To: Private Sub Command32_Click() Form_frmRaise_Revision1.SetFocus...

Thank you James, This worked perfectly!! Sorry I did mean tables :/ lol

Hi, If possible i am looking for some help regarding an access database I am trying to put together. I am completely new to access so I appologies if the questions asked are abit daft... My goal is to return a value input from a form into my database however it is not as simple as using a...