Search results

  1. 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...
  2. 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]![...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. P

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

    Hi, hope someone can help. I have a main form with a tab control. In the tab control I have a subform. I wish to update the data in the subform with values entered into unbound text boxes in the tab control on the main form. Main Form Name: VehicleDetailsFormUPDATE - Primary Key: VehicleID...
  8. P

    Calculating Length of Service where one field has a Null Value

    Hi hoping someone can help. I am creating a personnel database and need to show the length of service as years months days from StartDate to EndDate. Where EndDate contains a null value then the Today () or Now() needs to be used. There is alot of info on the subject but none that I can find...
  9. P

    End If without Block If Error Message

    Hi all hope you can help - I have the following vba code but I keep getting the End If without Block If error message - cannot figure out what I have done wrong - can anyone help please Private Sub txtPassword_AfterUpdate() 'Check that User is selected If IsNull(Me.cboUser) Then MsgBox...
  10. P

    Filter a Form based on a field in another form

    Hi, hope someone can help - I have a form (Suppliers) with a button that opens another form (Product List). At the moment the form (Product List) is set as a pop-up form and when opened lists all products. I want to filter the pop-up form to only display products for the current supplier...
  11. P

    Autonumbers Reset in Split Database

    Hi all, I have split the database I have created via the splitter-wizard and found that all tables with auto-numbers have re-set back to 1. How do I get around this problem - I have tried running an append query but it flags up an error message. For certain functions to work in the database...
  12. P

    Disable or Hide Minimise, Restore and Close Window buttons on a form

    Hi all, I know this is a common question to ask but I can't seem to find a solution. I need to disable or hide the restore, minimise and close window buttons found in the top right hand corner of a form. I navigation buttons that controls open, close etc already set up. Can anyone give...
  13. P

    Form Access Restrictions MulitUser Database

    Hi, hope someone can help - I am trying to restrict access to users to prevent Level 1 users from gaining access to all the workings eg tables, queries and forms. I have a security table and a login form which brings each user to a specified switchboard showing command buttons to specific...
  14. P

    IIf Statement Utilising Yes/No Field

    Hi, I am working on a hired plant database and want to limit the combo box on the hired form to only list items not on hire. I thought I could do this using the IssueDate and ReturnDate fields within a query with an IIf statement forcing the Yes/No field to choose Yes when there is a date in...
  15. P

    Filtering a Combo Box on a Subform from a Combo Box on a Main Form

    Hi, hope someone can help. I have a Suppliers database which contains a form that will allow me to place orders with Suppliers. The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following: Row source: SELECT...
  16. P

    How to link Combobox between Form and Subform to only show selected filtered data

    Hi, hope you can help. I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products. I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly...
  17. P

    Hello

    Hi, I am based in the UK and have dabbled in Access for a number of years but have done little with actual programing so am hoping some kine person out there can help me with a query.:)
Top Bottom