Search results

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.

Thanks for that. It's working perfect now.

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:

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

: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...

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

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

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

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

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

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

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

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

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

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

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

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

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?

please help me!!

would it help if i emailed you my database?