Search results

Finally managed to crack it. Create a new unbound form. Put an unbound combo box in the form and set the ROW SOURCE to link to the table that holds all the option for you original combo box. Put an unbound Textbox in the new form and set the CONTROL SOURCE property to equal the new combo box and...

I have tried several possibilities too but no luck. I have tried creating a separate unbound form to use instead of the parameter box but that won't work either!

Hi, I have tried the suggestions but I still can't get it to work. The parameter box comes up with what I typed in the criteria as the prompt in the box. What am I doing wrong??

Thanks very much for your replies.

Hi, Is there a way of changing the input box when you enter a query parameter to a drop down list linked to a table? Say for instance you need to enter a name of a town to run your query and you want to give the user a list of available town names in you table.

Thanks, I did think of doing this but I just wanted to make sure that I couldn't set the input box using code. Thanks once again.

Hi, I have have certain fields in a form set to disabled. To enable them the user has to enter a password via an input box. Is there a way of masking what the user types in the input box? I know it can be done with a text box via the mask property setting.

Thanks for the suggestions.

Hi, I need to be able to print a report on both sides of sheet of paper.Is it possible to, when the first page is printed, pause the print and prompt the user to re-insert the paper for reverse side printing and then to continue printing once the user has clicked an OK button?

Hi, I have numurous buttons which activate VB code procedures and up until now everything worked fine.Now when I click one of the buttons I get the message 'module not found'. This then takes me into the VB environment where all my VB procedures are for the form. I then get a message which says...

Thanks for the reply, I will give it a try.

Hi, When emailing from Access is it possible to use the .Body command to send text and a field entry. At the moment I can send one or the other?

Thanks for your reply Helana. I have sorted the problem now and I have included your suggestion of the drop down box.

Hi, I have created a databse in which a user enters their name along with other data.Once the data is entered the database manager can access any record and add a required action to the entered data.The manager then needs to send an email to inform the person who entered the data to of the...

I have created a database which currently holds 300 records. Each record has a 6 fields to show allowable defects (size, colour etc).All 300 records will only have choice of 3 possible defect descriptions. Is there a way of having each set of descriptions on 3 separate forms and with a click of...

I am relatively new to the world of Access so forgive me if this is a stupid question. I want to be able to add some sort of security to a 'YES/NO' field where the user is prompted for a password before being able to update the field.If an incorrect password is entered then the field will not...