Search results

  1. P

    DLookUp Referencing in Control on Subform #Name Error

    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
  2. P

    Run an Append Query in VBA Code in Access 2007

    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...
  3. P

    DLookUp Referencing in Control on Subform #Name Error

    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]![...
  4. P

    Run Time Error 2282 - Exporting Report to email in PDF Format

    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
  5. P

    Run Time Error 2282 - Exporting Report to email in PDF Format

    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...
  6. P

    Object Doesn't Support this Property or Method Error Message

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

    Object Doesn't Support this Property or Method Error Message

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

    Object Doesn't Support this Property or Method Error Message

    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 :-)
  9. P

    Object Doesn't Support this Property or Method Error Message

    Hi have now attached the database in question.
  10. P

    Object Doesn't Support this Property or Method Error Message

    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...
  11. P

    Combo Box to Filter Contacts based on Letter of the Alphabet

    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 :-)
  12. P

    Combo Box to Filter Contacts based on Letter of the Alphabet

    Hi Paul have attached the database
  13. P

    Combo Box to Filter Contacts based on Letter of the Alphabet

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

    Combo Box to Filter Contacts based on Letter of the Alphabet

    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 &...
  15. P

    Combo Box to Filter Contacts based on Letter of the Alphabet

    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.
  16. P

    Updating a table with data from an unbound form via VBA In Access 2003 / 2007

    Hi thanks again for your help - found an easier way around the problem but I continue to learn thanks to you guys :-)
  17. P

    Update Data in Subform from an unbound text box in a tab control on the main form

    Hi Arnelgp sorry for the late reply but I managed to find a way around the problem, just had to keep it simple. Many thanks for all your help Pauline
  18. P

    Updating a table with data from an unbound form via VBA In Access 2003 / 2007

    HI arnelgp, thanks but as I an flitting between two computers would rather set the insert to current database than use a path - is there anyway that can be done ? Plus would I only just use your coding or would I insert it into one of the codes I have added. Many thanks
  19. P

    Updating a table with data from an unbound form via VBA In Access 2003 / 2007

    Hi Peter, sorry no I am trying to update a record in the current database but the coding refers to an external database and I am not experienced enough to amend the code. The idea is to enter the details from Vehicle Checklists to the underlying table and then for the results to appear in a...
  20. P

    Updating a table with data from an unbound form via VBA In Access 2003 / 2007

    HI, I am stuck - I would like to update a table with data from a form. I initially used a bound form and placed a subform in a tab control on the main form but this failed to work. Have now considering using a pop-up unbound form with a command button when clicked with update the table...
Top Bottom