Search results

In my access database I have a "products" table which contains three concerning columns (pID, price, listprice) This table contains products from hundreds of different suppliers. Periodically, each supplier will send an updated price list containing the three pieces of information listed above...

I tried to set user security levels without really knowing what i was doing. I know bad idea; but the worse idea was i did not currently have a backup copy of the database. I used the security wizard and it created a [filename].mdw If i open that file, none of my tables, forms, ect. are there...

I have a form where the user can create a new order. The user input a PO and then a unique orderID is created. there is a subform on the form which is linked through the OrderID which contain details about the order (contains different products, quantities, ect.) Is there any way that this same...

I have a table (Customers) with a column (taxable) which contains a Yes/No value. I have a report (rptInvoice) with a field (txtTaxable). I want this field to auto-fill based on another field (txtSubtotal) if the Taxable value in the table for the specific customer is Yes. If the table has a...

I have two question about dependent combo boxes. First is it possible to make a combobox that functions as follows: Two comboboxes (CompanyName and CustomerID) on load both comboboxes come up with all possible options. If you start Typing "Amer" in the CompanyName combobox, it will limit the...

I have a subform in which the user enters information about an order that a customer is making. My main form is working correctly; however, I am unable to get my subform to work correctly. Here is what I need the subform to be able to do: The user enters the productID, then the unit measures...

Ok I am totally lost here. My boss gave me a paper copy of their current order form. It has fields to fill in the customer company name, billing address, shipping address, product information (catalog #, description, price, cost, ect.) order information (order number,quantity of each product...