Search results

arnelgp Just wondering what could cause this error please when clicking the cmd button? On Debug it displays the following in Code window Thanks Jonny

arnelgp, your code was plug and play, thanks very much :) I know you helped me earlier with this post and I'm really grateful for your support and expertise Kindest Regards Jonny

Hi Hoping someone can assist me please? I've been trying to filter a continuous form using checkboxes and cmd button and am nearly there apart from the filters not filtering data properly. On my form i have 9 x checkboxes as shown, these should filter the query field [FILTERYEAR] according to...

Thanks for the continued support from arnelgp & Gasman This is the error i get when using the Year and Activity Filters

Thanks Gasman & arnelgp I tried both ideas thanks, unfortunately the attachment from arnelgp didnt work. I have managed to filter the subform from the mainform by "CboYEAR" but then i cant get the second combobox "cboCELL" to filter the data on the subform by Cell within the selected year (if...

Happy New Year to All :) I've been searching for a solution to enable me to filter a continuous form using 2 comboboxes but without success! On the form are the following:- Combobox 1 = "CboYEAR" - rowsource has value list of Years from 2022 onwards Combobox 2 = "CboCELL - rowsource has value...

Good Afternoon :) I have a form in my Access DB called "frmSales" and it has the following fields:- Initials Company Name Job No Jan through to December (12 fields) Date Year At the top of the form are 2 x comboboxes cboYEAR which contains rowsource from table containing Years 2022 onwards...

Thanks Gasman The line is: olNewEmail.To = .Fields(2)

Hi all I have the following code behind the On Click Event of a command button on a form, the code basically generates an email and looks up email addresses in a query called "qryGATE2_Email", currently there is only one email address in the query but if there is more than 1 email i get an...

Hi hoping someone can point out the errors in my VBA code please I'm trying to export a report to PDF with a filename and filepath on a CMD button on click event My current code is as follows but i keep getting a VBA Runtime error 2501 OutputTo action cancelled Private Sub Cmd133_Click() Dim...

Hi I have been scratching my head on this one and still no solution so hoping someone with more access intelligence than me can help? I have a table called tblEnquiry which has an autonumber PK field called EnquiryID What i would like is when a record is generated the PK field "EnquiryID"...

Hello I have a form in my Access database which has a cmd button with the following code, what i would like to do is include the values from txtEnquiryID and txtCustomer on the form in the message body of the email. How would i amend the code below, it works now to send the email but just...

Hi I'm hoping someone can assist me please? I have a table called tblRouteCards which contains the following fields:- Job_Number Order_Number I use a form called frmRoutings to populate the table and have a cmd button to open a form called frmBILLOFMATERIALS which uses the following VBA to...

Hi I have one final hurdle left in the development of my MS Access Project Management Database, essentially i have a table displayed in a form (frmUser_DS) which contains the database users, the fields in this table are as follows:- UserID UserName UserLogin EmpPassword PCName UserSecurity...

Hi I have a form called frmMasterData which contains the following code in the On Timer Event:- Private Sub Form_Timer() Me.Text33.Requery If Me.Skill_Renewal_Date.Value >= Text33.Value Then Me.Training_Status.Value = "In-Date" Else Me.Training_Status.Value = "Expired" End If End Sub The...

Wondering if anyone has the wisdom to solve this for me please? I have a form called "frmTransactMovement" which has a textbox called "status", on the form is a subform which contains a Combobox called "id_State" with a dropdown selection of "Approved" What i would like to happen is when the...

Hi I have a form called "frmTransactMovements" which has a checkbox called "Approved" on it. On the above form is a Subform called "frmDocMovements" and it has a combobox called "state_Id" Is there a way that when a certain value in "state_id" combobox is selected, after update it ticks the...

Hi I have a ListBox on a Form which contains a list of entries in my database, one of the fields in the list is the location of an attached document Is there any way on the double click event for each particular row in the listbox to view / display the file stored in the location, eg a PDF...

Thanks Isaac, i tried the code but it still returns the same error as previously identified for the .To command. Regards Jonny

Hi All Thanks for your help, can anyone tell me why i am getting this message (see attached) when i run the function sendemailGate1 below? Public Function SendEMailGate1() Dim oLook As Object Dim oMail As Object Dim MyDB As DAO.Database Dim rst As DAO.Recordset Dim strMsg As String Set MyDB =...