Recent content by Starnheavn

Waiting for a reply, anyone? Thank you.

It is typed correctly and I"m working with Access 2007. I have attached it here. Maybe I am missing something but not sure. Your help is greatly appreciated.

I have a database that has several forms (for entering and looking up customer and quotes) and one form is a utilities form. In it I have a VB code and one of them is DoCmd.ShowToolbar "mnuForm_FileEditWinHelp", acToolbarNo When I go to click on my Products button I am receiving this error...

Ok, so you're saying to create a field for my Quote Number? I've done that already. And I've created a field for the Invoice Number, but how do I get the form to change from Quote to Invoice? Someone mentioned a flag or code, and if that is it what is the code or how do I create a flag? and...

Well mine is very similar except no order number is given BUT the Customer P.O. number is placed on the quote (this number is just entered as text and is not autonumbered) although the quote is given a quote number (i.e. 3077). The quote can be changed but once it becomes an invoice it cannot...

Everything in the qoute will be in the invoice. So if Mr. X accepts the quote with the 5products on the quote then it will need to become an invoice. Nothing changes except that it will no longer have a quote number it will need an invoice number. If the quote doesn't get accepted, it needs to...

I created a database that includes my tables for Customer, Quote, Quote Detail, Product, Rep, and States and forms for looks up of customer, products, etc. Ive included a Form for Quote and its Quote detail (which is the subform). Where I am getting stuck at is: say the client decides to...

Thanks so much!

Thanks for the info. What common methods are there for generating my Quote Numbers?

The Quote Number is autonumbered in order to give each entry it's own number (not to be duplicated) and is a unique identifier. My database is being set up in order to enter a quote for the customer with pricing information as well as product description. I have attached the DB here so you can...

Hi Beetle. I am lost. I have my tables set up One for RFQ Items and the other is just called RFQ. I have autonumbered the Quote Number Column in the RFQ Table and is primary. I have in RFQ Items the same Columnbut named Quote Number Link. I've created the relationship. Where I am lost at...

Thanks for the info. I'm with company of just 2 right now and who will be using this I believe no more than 10 over a few months to a year. So I think we are safe on the user part. ;-)

I'm just terrible at trying to explain what I need in words LOL. So far I have been able to understand you the best. It's not that I have the same questions I just refer to the same things while asking for instructions on others. Again, sorry. I am working on structuring the database...

Sorry for that. the Vendor information is for internal use and will not be used in an invoice but rather just to input information for the vendor that sent us a quote for the items just as a reference. The Quote # is the RFQColumn As for the Invoice/Quote they both will have the exact same...

I have created 3 tables. 1 with Customer Information, 1 with my RFQ Items (Qty, description, Price and notes), and 1 with RFQ info such as Quote #, Date Quoted , Date Received. I need to link the Quote # to the RFQ Items table. How do I do this?