Search results

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

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

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

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

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

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

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