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.

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:

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

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

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

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

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

i have a code that bypasses a microsoft error but now it shows a message box with the error number in it. is there any way to hide this box? my code is# MsgBox DataErr 'Use this to detect which error number to block. If DataErr = 2237 Then 'If gives some stupid error message number 2237...

xweyer hi! sorry to bother you but i see you're online at the moment and i was wondering if you could help me with my combo box question. please!!

i wrote a question there about ten minutes ago asking bout adding entries to combo boxes and i was wondering if anyone can help me. i really need it.

a few weeks ago i asked if anyone knew how to add an item that wasn't on the list of a combo box to be added to the list. simon c wrote back and gave me a basic code that worked. however, if i enter an item that is not on the list it asks me do i want to add it, which is exactly what i do want...

i have a report that is linked to a query which runs by using two parameter boxes. one of the boxes asks for a room number and the other for a port number. however, unless i type in both the room number and the port number i get back a blank report. it will sometimes be the case that we will...

i have a report that is made up of two sub reports. it is working perfectly. my problem is that the title of the sub reports are appearing in the background of them and i really want to get rid of them. is this possible? thank you!

I don't mean to be annoying but I really need to know if that is possible. I am referring to the topic I posted about thirty minutes ago called "2 parameters for one query". Please Help Me, I'm Desperate!!!

i have a database set up for a telephone system. one of the fields in it is "extension number". the other fields include things like name, room number etc. it is sometimes the case that i will want to bring up two records, by typing in their extension numbers, and "swap" them. i was wondering if...

i have a drop down list containing several entries. the field is not limited to list. if a user enters a value not on the list is it possible for it to be added to the list?