Search results

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

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

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

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 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 guys Im having a problem with totaling values in a column. In the column I want to total, there is an expression that goes something like this: = A*B + C*D (i'm using a textbox), this total will appear in the totals column for each row but i want to use this same column to come up with a...

Hi all Is this possible????I was given a form that i am supposed to base this database on . Im supposed to allow the user to select a person's name and all of thier records should appear.I got this done using a subform (the subform is a in a datasheet formatt) and combobox. But the thing is i...

Hi again In my database im using continous forms and i want to know if there is a way i could increase the value in a text box by other values in other text. Is there anyway i could do this without using a button. Thanks

Hi I have this database and it is supposed to list supplies,the amount of these supplies instock, four suppliers and the amount and cost for each product supplied by the supplier. The problem im having, is the highlighting of the highest prices. What is happening is that the same column is...