Search results

  1. John Big Booty

    Use textbox to adjust criteria in query

    It is certainly possible to do what you are after. What you would need to do, is set a delimiter (like a comma) to separate your search terms. You would then need to construct your query as a SQL statement using VBA, and replace your delimiter with an OR argument. If I get a chance I try and...
  2. John Big Booty

    Use textbox to adjust criteria in query

    You could also do that using the Nz() function :)
  3. John Big Booty

    Use textbox to adjust criteria in query

    Welcome to the forum. You can use the following schema to pick up information from a text box on a form as criteria for your query [Forms]![YourFormName]![YourTextBoxName] Change the two bolded areas to reflect the reality of your DB.
  4. John Big Booty

    Age groups from date of birth

    Try; Public Function AgeGroup(dtmBirthDate As Date) As String Dim intAge As Integer 'Age Calculation intAge = Int(DateDiff("d", [dtmBirthDate], DateSerial(DatePart("yyyy,Date()), 1, 1))/365.25) Select Case intAge 'For each Age range, write out Age Group (used in qry) ... End Function
  5. John Big Booty

    Add Days from one Field to Date Field

    The DateAdd() function would be the way to go. You would need to do something along the lines of; DateAdd("d",[GrowDays], [StartDate])
  6. John Big Booty

    Combo Box filter continuous form- Suburb & Post Code

    Perhaps you can adapt the principal demonstrated in this sample.
  7. John Big Booty

    Combo Box filter continuous form- Suburb & Post Code

    The sample here may not be what you are looking for but it may be of interest anyway.
  8. John Big Booty

    Combo Box with 6 scanned signatures

    The sample here may give you some pointers as to how to approach your signature requirement. Also did I understand you correctly in that you have a form for each of your 2773 pieces of equipment (ie 2773 forms) :eek:
  9. John Big Booty

    Please use Code Tags when posting VBA Code

    Thanks to pr2-eugin, for the following advise regarding indenting in your code;
  10. John Big Booty

    Search Multiple Fields

    The query is returning all records when you leave one of the field blank, as you are using the OR criteria, try using the AND criteria.
  11. John Big Booty

    A 2013 scrolling marquee

    Why not ask the author of the code :confused: Also are you sure you have all the code there?
  12. John Big Booty

    field type - date/time

    What you need to do is put your form in design view. Ensure you are dealing with the form properties. You will see a small black square in the box at the junction of the vertical and horizontal rulers when you are. Now select the Event tab on the property sheet, and go to the Before Update...
  13. John Big Booty

    field type - date/time

    In the form's Before Update event simply use; Me.YourFieldName = Now() This will update that field with the current time and date whenever you update the current record.
  14. John Big Booty

    table combo box

    This article on Table level lookups may also be of interest to you.
  15. John Big Booty

    concatenating values into one record

    Perhaps the article here will help you achieve your goal.
  16. John Big Booty

    Question Updating Table with Forms

    Given that you are working with a form/subform set you will need to check this link to get the correct syntax for referring to subform from the main form or visa versa.
  17. John Big Booty

    select field button

    Build a query that collects the data you wish to export to Excel and then use the code here to export that data to Excel.
  18. John Big Booty

    Filtering Based on Query

    Welcome to the forum. You might find the search function here of interest.
  19. John Big Booty

    Want to count Age from DOB to Admission Date

    Perhaps the code here is what you are looking for. Or perhaps this article.
  20. John Big Booty

    combing rows into 1 field

    Welcome to the forum. Perhaps the article here will help you.
Back
Top Bottom