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 importing but i still get the "you do not have the necessary permission to open..." error message. I have read the security guide and still am unable to figure it out. If anyone knows a lot about access security and is able to fix my database i will paypal you $10 because I am...

no i do not have a non-secured copy. i only have the original, which i cannot access. and the .mdw which does not have any of my forms ect in it.

I have figured out that my admin account does not have permission to open/run the database. I cannot assign this permission because it says i do not own the database; however, neither do any of my other users. None of them can open/run it either.

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

Thank you for all your help guys. I have got the updating comboboxes working as I wanted them to. I am still having two minor problems with my form that I was hoping you guys could help me fix so I could get everything working. Sorry for the inconvenience and I thank you for your patients with...

I have taken your advice; however, I am still unable to get the comboboxes to limit off each other. I put the following code in the keypress event of the first combobox: Me.cboCustomerID.RowSource = "SELECT Customers.CustomerID FROM Customers WHERE " & _ "Customers.CompanyName LIKE ' " * "...

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 managed to fix most of my problems; however, I have two remaining questions/problems 1) I cannot get the my calculated sum values to work and I have no clue why they are not working. I used =Sum([Quantity]*[UnitPrice]) for the control source but I get the #Name error. (I have another...

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