Recent content by Pauline123

Hey sorry only just getting back to you guys - your info was great but I realised that all I needed to do was just reference the text box on the sub form and it worked a dream - hate mental blocks lol but thanks for your input very much appreciated - Pauline

Hi all - just wondering if someone could give me a hand. Have a code set up that I am trying include an append query to allow me to populate another table. Private Sub Command40_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

Help! I am slowly losing the will to live :( I have a control on a subform that uses the DLookUp function to get a numerical value from a query. When I use the following in the subform it works fine: =DLookUp("[TotNoDays]","qryHolEntitCalculation","[HPIDNo]=" & [Forms]![HolidayTakenForm]![...

Hi CJ - Many thanks - I thought that would be the case but just wanted to check as I am no expert - will let my IT guy know - Pauline

Hi all, got a bit of a tricky one here. We have recently upgraded to Office 2016 but still running Access 2007. Have the following code set to email a report in PDF format via a button as follows: Private Sub Command86_Click() Dim myOb As Object Dim AutoSend As Boolean Dim stDocName As...

Ah so I had referenced to the label and not the field lol :banghead:

Hey Jdraw I will take your comments on board and make the adjustments - thank you for your insight :)

Hi I get this piece of code highlighted rs!TheoryRenew = Me.txtTheoryRenew This is a Tick box - which I removed then deleted this field from the Theory Table and it seems to be working fine - thanks for the help - I can't believe it was that simple :-)

Hi have now attached the database in question.

Hey hope someone can help. I have an unbound form that I have a multi-select list and unbound fields to enter data into the Theory Training Table. I thought I had got the bugs out but now keep getting the "Object Doesn't Support..." error message. The details are: Forms Name: TheoryTraining...

Hi Paul thank you so much for your help - that kinda did the trick - just created another problem so I think I need to go back to basics to see what I have done wrong. Thanks again :-)

Hi Paul have attached the database

Sorry my subform is called "SupContInsertForm" The main form where the combo box is located is called "SupplierContactSub"

Hi Paul - I have tried this and keep getting "Compile Error: Method or Data Member Not Found" This is he code entered in the after update of the combo box: Me.SupplierContactSub.Form.RecordSource = "SELECT SupplierName FROM qrySupplierContactList WHERE SupplierName Like '" & Me.ComboAlphabet &...

Hi, am trying to figure out how to set a filter via a combobox selection. My subform contains a list of suppliers. I would like to select from a combobox a letter from the alphabet and filter the subform based on the first letter of the suppliers company name. Does anyone have any ideas.