Recent content by miked1978

  1. M

    Form button to populate fields

    Got it. Same name but one had a space and the other has a "_" in the name Thanks I really appreciate it!!!
  2. M

    Form button to populate fields

    where is the subcontrol name at?
  3. M

    Form button to populate fields

    I have a button on my main form that when clicked I want to populate 3 fields on the subform. The weird thing is I have another form that this works perfectly in, I literally copied the code and replaced the form names and the field names. Anyway I get an error "Access cant find the field...
  4. M

    Creating a Order # on form

    You're right. I might be thinking about this all wrong by trying to force everything into one table when maybe I need to be using multiple tables.
  5. M

    Creating a Order # on form

    I'll search for Dmax. I was searching for auto generating a # and didn't get anything that I thought would work
  6. M

    Creating a Order # on form

    I need to generate an Order # on a form. I currently have a continuous form and the bottom is in Datasheet view. Each record has a check box and the user can check whichever record(s) they want and a SAVE button is provided that saves their selection to a SQL table when the button is pressed...
  7. M

    Need advice on listbox or another way

    thanks. How would I implement it to my field? I copied the module to my DB but I don't see where he is calling the module in his form.
  8. M

    Need advice on listbox or another way

    I have a simple data entry form and one of the fields the user needs to input into is a Ticket# field which is set as a long text but in reality its between 10-15 characters (SQL server has it as nvarchar(255). The ticket number already exists and the user just needs to pick/input the correct...
  9. M

    Multicriteria search form - adding checkboxes

    Thanks but I would need the option for both checkboxes to be checked.
  10. M

    Multicriteria search form - adding checkboxes

    Yeah I kept getting syntax errors so I stripped the AND off from yours and I stopped getting the errors. I think I may just abandon this. I'm too new at VBA to make this work Thanks for the help though.
  11. M

    Multicriteria search form - adding checkboxes

    not sure if its working or not but now getting error "syntax error in union query and Me.[Tasks subform].Form.RecordSource = StrWhere line is highlighted. Private Sub cbo_Search_Click() Dim StrWhere Dim lngLen As Long If Not IsNull(Me.cbo_Employee) Then StrWhere = StrWhere &...
  12. M

    Multicriteria search form - adding checkboxes

    I added the code below but I'm not sure what to put for my checkboxes in the strWhere line. Both are looking at the status field and the status field in the table will be populated with: Closed, In Work, On Hold, & Not Started as its values. Open = In Work, On Hold, Not Started Closed =...
  13. M

    Multicriteria search form - adding checkboxes

    I have a search form and a subform underneath in datasheet view. On the search form i currently have a combobox where the user can select a name and press the search button (code below) and it gives the results for the name they selected. That part works fine. However I want to add 2...
  14. M

    Help with adding checkboxes to search form

    I'm not sure how to add the checkboxes to the VBA code
  15. M

    Help with adding checkboxes to search form

    I have a combobox on my main form that the user selects the employee and the the subform displays the results in a datasheet view. The code is below. I'd like to add 2 check boxes as additional criteria the user can search with. First checkbox will be "Open Tasks" and the 2nd checkbox would...
Top Bottom