Recent content by music_al

Hi pbaldy My apologies. I read your reply and I realised how it made sense. That works fine. Thank you very much Al

If the query criteria is blank I don’t want it to return all the records, I just want the query to use the other criteria. So, the combo box that would hold the variety of food types is blank so return the results of whatever is set in the other combo box, I.e. fruit suppliers.

I have a search form with 2 combo boxes, the second combo box is a nested combo box of the first. In the top combo the user selects fruit, meat, or pastry. In the second combo box the user would select types of fruit or meat etc. I have a search button that changes the record source of the...

It looks like its working now. Maybe I didn't save the Module before running the code again.

Is there any way of making the input box show a calendar when the user clicks inside the text box ?

I added this to the end of the line of code... DoCmd.OpenForm "frm_Contract_Start_Date", , , , , acDialog MsgBox Contract_Start_Date 'Added this just to test And the MsgBox is still appearing at the same time the form is appearing. Have I missed something ?

This is what I had done originally but I never liked the method.

Hi I have a procedure which creates a new contract for an employee in the Contracts table (tbl_Contracts) After some fields have been set a form appears in which the user will enter the Start Date of the new contract. This is done by the code... DoCmd.OpenForm...

Gasman, that video just shows the database using simple Text fields but I want fields that are entered from a Combo Box fed from a 2 column query - ID and Text.

DBGuy - Im using 2010 in both Outlook and Access

I tried selecting from a query too but that resulted in an error.

Hi I'm testing the gathering data via email feature. So, I've created a very simple table (tbl_Person) with just 3 fields... Person_ID Person_Name Hair_Colour_ID Ive created another table (tbl_Hair_Colour) with just 2 fields... Hair_Colour_ID Hair_Colour I've joined them in...

Thanks Minty Its a split form.

Hi I have a really simple piece of code that enables or disables 3 controls depending on the state of a checkbox. This was working fine until I applied conditional formatting to these controls. Could it be that the conditional formatting could be re-enabling the controls even when the code...

Hi I’d like to gather data via email and tried to use the built in functionality of 2010 to use Outlook. I selected the table that I’d like users to complete but it presents fields in the form as text boxes that require a number to be entered that ought to be combo boxes with meaningful lists...