Search results

  1. J

    Parameter Help

    I was wondering if it is possible to put input masks on to parameters. So if I have a parameter query, where the user enters a date, can I force the format of it.
  2. J

    Query Problem

    Thanks for that. It's working perfect now.
  3. J

    Query Problem

    I have one table with 4 different columns for phone numbers. I want to run a query where the user types a number into a parameter box and the query searches all four columns for that one number. Is this possible. I kinda need to know quickly! Thanks a million for the help, Jan :confused:
  4. J

    Cancel Button

    Please Please Help I would really appreciate if someone could help me with this query cos i am totally stuck
  5. J

    Cancel Button

    :confused: I have a query where the user enters, for example, a phone number into a dialog boxes and a table is searched. However, if i press the cancel button on the dialog box i get an error. It says something in box and gives you the option to halt, which i press and then it returns. why does...
  6. J

    Query Help

    what would the timer event be on? i copied it fro the first one.
  7. J

    Query Help

    I have a query that looks up a telephone number. i have a pop up where the user enters the required number and then the table with the results opens. this works fine. however, i have made a second similar query. if i open the query it works fine but if i open the pop up form and do it from there...
  8. J

    Checkbox Query??

    i want a parameter box to appear that contains the name of eight differeent types of phones. i want the user to be able to query one or more types so i thought the most efficient way would be with check boxes. is this possible? as it is now i have the paramenter box but the user must choose a...
  9. J

    Butttons

    Hey I was wondering if anyone can help me on this one. I want bitmap pictures to act as buttons in the form, so when the mouse is put over it, the cursor changes to a hand and when clicked it follows its link. plz help thanx
  10. J

    DLookup :(

    Another question on DLOOKUP. I want its criteria to be based on two fields on the form, how is this done? Also does anyone know where i could find a working example this function. Thanx
  11. J

    Dlookup

    yes, i didnt find it very helpful. i'm not sure if its what i need. i want a form to fill out automatically when i enter certain values. i have this done by putting a subform onto a form and attaching it to a query. but now i want the values from the subform and the main form to go to the same...
  12. J

    Dlookup

    could anyone explain the dlookup function and what it can be used for pls?
  13. J

    combo boxes

    i have two combo boxes in the same form for two different fields. i am using the same code to allow users to add a value that is not on the list. however, on one of them the value is being added in alphabetical order, which is what i want and in the other one it is being added to the end of the...
  14. J

    Checkbox Query??

    Is it possible to make a query where a form pops up with checkboxes? i am amking a query for different types of phones and i want the user to be able to select more than one phone at a time? ne ideas?? thanks, jan
  15. J

    Queries Drop Down List

    Thank you both. I think my problem is now solved. It was so simple, I just couldn't see what to do. Thanks again!
  16. J

    Queries Drop Down List

    Ok, I will try to be as clear as possible but this is quite difficult to explain. I have made a query that needs to be used as a query, i.e. I have it set so that a parameter box appears asking the user to enter a department. However, I also need this query to be attatched to a report. I have...
  17. J

    Autocomplete within a form

    I have ten fields within a form which are linked to a table "A". The first five fields within this form should work as normal updating themselves to table "A". However i would like the last five to work as follows: If the first two fields of the last five contain data enteries matching data in a...
  18. J

    bypass error message box

    fizzio you have been brilliant. i have tried what you said and i am now getting a runtime error in the code. could you send me that example or shall i send you my database?
  19. J

    bypass error message box

    please help me!!
  20. J

    bypass error message box

    would it help if i emailed you my database?
Back
Top Bottom