Search results

First, thanks to Roberts Dunstan and Saye for your replys. Two more quick questions:- 1. How do I ensure that my message box appears on the form that is being opened. Currently, it appears before the pop-up form I'm opening actally appears on the screen. Ive tried the OnLoad and OnCurrent...

Sorry - very simple question. How do I get a message box with just an OK button on it to appear when a form opens? Thanks

I would like to know if it is possible to have a command button only appear on a pop-up form when it is accessed as a pop-up. I would like the button to not be visible if it is accessed as a form in its own right. Many thanks for any help on this.

How do you add an item to a combo box using the NotInList event when the combo box in question is on a subform and is synchronised to another combo box which is on the main form. Any help greatly appreciated.

There is a pop up calendar in the Access 2000 Developer's Handbook - Vol 1. It is activated by a command button, not a combo box but does what you need I think.

I have a chain of three synchronised combo boxes - cboProductCategory links to cboSupplierName links to cboSupplierContact. The links all work fine, but I would like to use the Not In List event on the Contact name, so that users can add a new contact name if need be. Once a supplier is...

Not yet DML. I'm still trying. I'll post again if I run into trouble. Thanks for your help so far. Rob

DML Thanks for the reply. Yes, the Category and Supplier combos are on the main form and the Products are on the subform. Actually, I only need the products to be dependent on the Category. Thanks for your help.

With the help of you guys on the forum, I have managed to set up a couple of linked combo boxes on my my form - frmOrders. I can select a product category and then select a list of relevant suppliers from a second combo box. What I need to do now is select relevant products from a third combo...

I have a very annoying problem with a combo box which I cannot get to display the name of a supplier from the underlying query. It will only display (and retain) the SupplierID - its control source. If I want it to display the Supplier Name it does not hold the information - it has disappeared...

I have a form - frmOrders - which I wish to use to place orders with our suppliers. On this form I have a pair of linked combo boxes. The first gets its data from a query based on a Product Category table. This selects a particular product category. Then a supplier name is selected from a...

I like the idea of using a label to create a coloured command button. Could you post a sample code for the Mouse Down and Mouse Up lines. I don't know much VB I'm afraid

On my form I have one combo box which shows a list of product categories and another showing a list of suppliers. What I would like to achieve is that after the product category has been selected, the combo box showing the supplier names only displays those suppliers which fall into the...

I have a combo box with a NotInList event running on it which takes and sends information information to a table of product Categories. There are quite a few product categories and it would be useful for the list on the Combo Box to be sorted alphabetically. Does anyone know how to do this...

AlaskanDad Thanks for you reply. I'm sorry but my knowledge of VBA is sadly lacking. How would the line of code read and where in the procedure would it go? Thanks again, Rob

I have a form, frmContacts, which sometimes is opened in its own right and sometimes as a subform. I have a button on this form which I would like to make visible only when the form is open on its own. When it is open as a subform I would like the button to be hidden. Any help would be...

Does anyone know how to change the background colour of command buttons. Can this be done by code at all?

I had the same problem and a guy called Neal posted the code below which I have used very effectively. It should go in the On Click event DoCmd.OpenReport "yourReportname", acPreview, , "[UniqueIdFieldName]= forms!yourFormName!UniqueIdFieldName]"

I have a form - DealersMain - on which I have a subform - Contacts. Currently I have a button on the form which enables me to print an envolope containing the DealerrName, DealerAddress, etc of the record currently being viewed. What I would like to achieve is for the envelope to show, not...

I have a form - DealersMain - on which I have a subform - Contacts. Currently I have a button on the form which enables me to print an envolope containing the DealerrName, DealerAddress, etc of the record currently being viewed. What I would like to achieve is for the envelope to show, not...