Search results

All you need to do is follow the Combo Box wizard. Make sure that you select all the information you want to show in the unbound Text Boxes, that will be related to your selection. Then when it comes to to point where the wizard shows you all the columns that will be shown in your Combo, set all...

When you create your combo box you have to make sure that you select all the fields that you latter want to show in the Text boxes. You don't actually have to show them in your combo though. Just remember that the columns in your combo box are numbered from Zero up.

You could use a Combobox that contains all your suppliers and then from there use that selection to populate a number of text boxes with the supplier details. Check the Sample DB

This site should help you out, with the correct syntax for referencing your various controls.

Have you tried conditional formatting of the cell?

Firstly you will need to create a query that collects all the data, you need in your report, based on the information you have put on your form. Once you have created that query, it should be a simple matter to create a report based on the query.

Whoops sorry misread/understood your response my bad :(

Sorry but my code will only send the report to the nominated emails adress/es, that you place in the following line of code (from the above) Which I have coloured and bolded below for clarity. stAddText = "Name@hotmail.com" 'insert your own recipient email address/es between quotes

Yes you should be able to, in the on change event of the field you wish to monitor place the following code; Dim stDocName As String Dim stMsgText As String Dim stSubText As String Dim stAddText As String stMsgText = "Data has been Change, Please refer to attached...

1) Me.RecordSet.RecordCount = 0 Tells you there are no records. You could test for this in the OnLoad event of the form and put up a MsgBox. 2) in the On current event check the current record number against the record count and if they are the same you could then lock the Next record button.

That seems to be a fairly mean spirited attitude you have there.

Do a test on the edited date and if it is less than today's Date() then pop up a message box to notify the user that they have entered an invalid date.

In your query criteria try IIf([Forms]![Form_Name]![Option_Group]=-1,-1,IIf([Forms]![Form_Name]![Option_Group]=0,0,-1)) or IIf([Forms]![Form_Name]![Option_Group]=-1,-1,IIf([Forms]![Form_Name]![Option_Group]=0,0,0)) ie. in the first criteria line put line one of the code and in the second line...

Just what I was looking for, thanks :) I used (Left(Replace([clientname]," ",""),3))

I have an update query that creates a reference. part of the update is the following code (Left([clientname],Len([clientname])-(Len([clientname])-3))) Which works fine. What I'm wondering is if there is a way to ignore any spaces that might be in the first three characters. So in other words...

Check out this link I think it will have what you are after.

Access does not use cell references, so whilst Mikes formula is valid, it is some what meaningless. You might want to do some reading on the differences between Excel and Access, and also read up on normalisation.

You might find this linkhelpful in formulating the correct reference.

Point taken, thank you :)

A check box has a value of 0 when unchecked and a value of -1 when checked. So couldn't you just put something like; =([check1]+[check2]+......[checkX])*-1 in the control source of the textbox?