Search results

Do a search on "Images" in the forum. You will find plenty of help on this subject.

I don't think that is was your unit price that was not working I think that it was your extended price. It (the extended price) is now working. If you don't mind me saying, with your current database you are going to have problems because you dont have a "correct" Order form, with your method...

Type "Time" into Help when you are in the vba window (Alt + F11)

Why go to all that trouble when you can have code do it for you?

>>> Here <<<

Is this what you are trying to do; Combo1 (Countries of the World) Combo2 (States of those Countries) Combo3 (Cities of those states) Select from combo1 "Australia" Combo 2 will show 8 States and Territories Select from combo2 "Victoria" Combo 3 will display all cities in the state of...

I don't know what you mean with " selection in first control", because you don't say what type of control (text box, combo, list box etc) so I have given you 2 examples 1 for text box and 1 for combo. If Me.txtFirstBox > 5 Then Me.txtSecondBox.BackColor = vbRed Else...

Look up "Conditional Formatting" in help. Please try and help your self first, however if you still have a problem then post back and I will post a sample for you.

Why not put them all in 1 table? What is it about the data that is should be in separate tables?

=DateDiff("d", StartDate, EndDate) If StartDate was 12/2/2007 and EndDate was 12/2/2007 then the days would be 0. If you leave EndDate static and change StartDate to 13/2/2007 then the result will be -1. If the StartDate was 11/2/2007 with the static EndDate then the result would be 1 If...

Bob, In the sample I posted I have a table with the Tax Rate and then placed a combo on the form, the primary key from the Tax Rate table is saved in the "Main" table. In your option is that OK or should you store the "Rate" and not the key. I was just thinking that my method would not be...

Welcome to the forum. 1) As a rule you should not store calculation in a table. 2) Most of what you want (re calculations) can and should be done in the query that is the Record Source for the form. Have a look at the sample I have attached, you should have a look at; * The query that is the...

Have a look at my sample posted here.

I am just curious why would you have a single subform linked to 7 different tables? Maybe you need to read up on normalization.

If you store images within the database you will have problems. Store the images in a folder on hard disk and then refer to their location when you want to use them. Have a look at the attached sample; When you unzip it put the database on your desktop and then put the medal.bmp into C:\Temp...

Post a copy and someone will have a look for you

If your form is based on a query then you will have to add the field to the query first, then it will be come available for the form.

Using the wizard put a command button on your first form and then select Form Operation / Open Form. NEXT Select the name of the second form NEXT Choose the first option NEXT Choice the primary key and thats it.

These should not appear in both tables. Have a look at the sample I have posted, is this what you want to do?

Sorry about that, I have attached a copy.