Recent content by mercury

hello, Thanks alot for your help.

Hi everyone I am using dlookup to get the price from a table called Table1 so that it would appear on a form called Prescription. What i was trying to allow a user to make a selection from three combo boxes. These three selections would then be combined to make 1 selection. This 1 selection...

hi again i tried the Dlookup and it worked thanks alot mercury

Thanks alot ill give that a try

Hi guys I need some help.I would like to know if anyone has a solution to my problem im using Microsoft 2000 and i would greatly appreciate it if someone have any ideas on what i could do.This is how it goes........... When a item is selected from three combo boxes the 3 selections would...

Hi It worked but the thing is i keep getting this run time error which says "The OpenReport action was cancelled" could you or someone tell me what is wrong i figured it is something with the code i have in my search form anyway if you would like to see what im talking about just view the...

hello there, I would like to know how to do a validation check, so that if a person chooses a particular option from a drop down menue and no information was written about that particular company, a message would appear stating that no information was entered regarding that company therefore the...

Hi Thanks alot that worked but what exactly is does "[CompanyName] = " & Chr$(34) & txtSearch & Chr$(34) mean? Mercury

Hi everyone Im not sure whether i should post my question here in the form forum or in the report,anyway im using a form to act as a search page, where a user would be able to type a Company Name in a text box then they would have to click a button which would open a report showing only the...

Hi Im having a problem.In my database i would like the user to select a choice from each of my five combo boxes, Each selection is attached a cost. In a textbox(txt1) this seletion would be concatenated and a total price is supposed to be in another textbox(txtTotalCost). Im having a problem...

hi again, I just wanted to know, what does column(1) do.

Thanks alot that worked. Mercury

Hi I tried what you suggested but the thing is i keep getting a number and not the selections i made in the text box. I have posted it just in case anyone has anymore ideas.Thanks Alot though What is supposed to happen when a person selects a choice from the two textboxes, those choices should...

There are five combo boxes cbo1,chbo2,cbo3,cbo4,cbo5. The user is suppose to select a choice from each combo box and when a button is clicked a textbox is suppose to produce a cost and your selection. e.g. P L E A S E S F A txt1= PLEASEFA cost=$13.00 Im...

Hi everyone In my database i wanted my form to remain maximized instead of the minimized way it kept appearing when it loads. So on the On Load property i placed DoCmd.Maximize and in the On Close event DoCmd.Restore. I also have the Navigation Properties to Yes but i still cannot see my...