Search results

Thanks alansidman, can this method apply to a query? or it must be a table? 'cause my two control are based on a query.

I Have 2 combo box on a form: Product_Type (6 values) and Product_Name (30 values and each belongs to a type), I want to narrow down the Product_Name to related Product_type whenever I select a type in the first field. Is there anyway to do this? Thanks

Actually I am trying to do something like If Order type = Urgent, then the Orderreturndate=Date()+2.

Oh I got it, my mistake! I put the calculation in the query instead of on the form. Another question is how about the date? I put this this way: Private Sub Order_Type_AfterUpdate() Select Case [Order_Type] Case "Urgent" Me.Total = Round(Me.Quantity * 20 + Quantity * Product_Price)...

Guys, there is still a problem: Actually I have 4 fields: 1. [Order_Type] with 3 types: Regular, Urgent, Very Urgent; 2. [Quantity]; 3. [Product_Price], which is locked (don't want users change this); and 4. [Total] I want whenever the Order_Type = Urgent or Very Urgent, then Total would be...

Thanks very much

This is what I put under the AfterUpdate property of a field named [Order_Type] which has three types: Regular, Urgent and Very Urgent; whereas when it comes to Urgent, then customer would have to pay a fee of $20 and the return date would be Date()+1; like wise with Very Urgent. Private Sub...

My question is this: I have several controls: [Order_Type] with 3 values: Regular, Rush and Extremely Rush, [Unit_Price], [Quantity] and [Total] By default: [Total]=[Unit_Price]*[Quantity] What I want is when [Order_Type]="Rush" then [Total] would be:[Unit_Price]*[Quantity]+20 and if...

I want to put an expression that count all Debt in a field named "Payment". What would be an expression for this: =Count([Order].[Payment], "debt")? Thanks a bunch

Problem is I want this value to be loosen, people can enter the factual values that may not be as calculated. Let me be a little bit more specific: theoretically, what pr2-eugin proposed is right. but in fact, sometimes, people want to enter different amount in the total because customers keep...

This may sound simple but I don't really know how to go about this: I have 3 fields: "Quantity," "UnitPrice" and "Total". I want to put a code that before I enter the field, the default value of "total" would equal Quantity*UnitPrice" Thanks

Problem is I already created a Lookup field that already included the city in the field. That also included the customers' zip code :(

By mistake, I have split a table into two different ones, whereas the Customers' City fell into Customers' State Table (it should be in Customers' Details Table). Please tell me is there any way to correct this mistake (I don't want to retype all the Cities)? Thanks a bunch

Thanks very much Gina!

I have created a database with relationship as showed in the attachment. Please some one have a look and tell me if it is right? Thanks a bunch

Thank you very much Cronk, you are a real saver!

I am trying to set up a mailing list database and having 5 tables: 1. Customers with: customer_id, name, company, address, city, state_id (number), zip... 2. States with: state_id (autonumber), states_name 3. Services: services_id, services_name (Fedex, DHL, UPS...) 4. Shipping: ship_id...

Actually here is the situation: I have a table inherited from someone else which was built from Excell. Every thing is a mess in that table (lol): He put all data in one piece: Clients_Name, Clients_Address, Clients_City, Clients_States, Service_Use, Tracking_Number...etc. Consequently, I try...

Please any one tell me how to this: I have two fields, one is the Client_Name, the other is the Clients_Address. I want the Clients_Address to be filled out automatically if and when the Clients_Name already are in the database. Thanks

Hi every one...to be short I am new to Access and trying hard to set up a number of databases in my office, which is a Consulate of a country in Houston, Texas the United States of A. Hope people out there could help to get through this ordeal so I can kill the time away in a positive...