Search results

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...

Thanks for your help Mercury

Hi I have this continuous form that finds the total of some values(this is working). Everytime a new value is added into the textbox i have to click the refresh button on my form.What i want to know if there is a way that i can forget about the refresh button and instead have the form update...

Hi Don't worry about it i found out the problem with a little help from some friends. What happened was that the Totals(E) button in the query was clicked and was prevented me from updating informtion into the form. Anyway thanks alot for your help Michael it was greatly appreciated. ;) Aronda

Hi again I have this form that is base on a query but unfortunately i cant change any of the information. Everytime i try to enter/change information it keeps saying "The Recordset is not updateable" but when i use the form as the control source it works but the Grand total i have isnt working...

Hi again What you did was what i wanted but unfortunately i cant change any of the information. Everytime i try to enter information it keeps saying "The Recordset is not updateable" but when i use the form as the control source it works but the totals column isnt working. Do you have any...