Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dylan03

    Saving the calculated field to the control source table

    Actually, the form isn't tied to a query, but rather a table. This is because as the rep is entering the miscellaneous sales amounts (eg SalePrice, UsedCarAllowance, etc), the form is calculating the TaxableAmount. This is done by having the calculation =[SalePrice]-[UsedCarAllowance] as the...
  2. dylan03

    saving a calculated field to the control source table

    I thought that if I set the control source to a query, it wouldn't save the date to the table.. Am I incorrect in this thinking?
  3. dylan03

    saving a calculated field to the control source table

    I have a sales form that a salesperson completes at the time of the sale. The control is the [Sales] table. How do I calculate the fields so that they save to the (control source) table? A shortened version of my Sales table context is: TransactionID Number CustomerName Text...
  4. dylan03

    Saving the calculated field to the control source table

    I have a sales form that a salesperson completes at the time of the sale. The control is the [Sales] table. How do I calculate the fields so that they save to the (control source) table? A shortened version of my Sales table context is: TransactionID Number CustomerName Text...
  5. dylan03

    Saving form data to database

    HELLLLLLLLLLP! I used MS FrontPage's database interface to create a webpage that is supposed to save the form data to the database. I created and verified the connection between the db & webpage. I can enter information into the webpage (www.automaxxmotors.com/creditapp.asp), and I receive a...
  6. dylan03

    asp page does not save to the db

    SO can anyone help me figure out why the information entered doesn't save to the database?
  7. dylan03

    asp page does not save to the db

    That problem is now resolved. For some reason, however, it wasn't saving the chages. Microsoft does love to control and instill fear (even if it is just about a line of coding ) :) Would it be easier if I gave you the server username/password?
  8. dylan03

    asp page does not save to the db

    Unfortunately, I don't know where the problem would be... since I created this through the wizard. <% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next Session(&quot;FP_OldCodePage&quot;) = Session.CodePage Session(&quot;FP_OldLCID&quot;) =...
  9. dylan03

    asp page does not save to the db

    Hello. I am very new to this, so if you respond, please be very specific. Thanks! I have a website www.automaxxmotors.com where a customer can fill out the credit application (under the financing tab) and it is supposed to save the information to the related customer table. I created the...
  10. dylan03

    What's wrong with this OnCurrent code?

    Thanks for your help, Daniel!! One quick thing.... When I insert the Before Insert Code into my form, I receive a Microsoft Visual Basic compile error that states &quot;Expected: list seperator or )&quot;. In the VB window, it highlights this section of the code: &quot;, 4) =...
  11. dylan03

    What's wrong with this OnCurrent code?

    I have a Sales form which needs to automatically enter a TransactionID. I want the number entered to be in the format of 2002-### )the second portion being the next sequential number. In [Sales.TransactionID] I have set the input mask to >0000\-00;0 The field name on the form is [TransID] In...
  12. dylan03

    Save form data to a temporary table

    Oh, HELLO!!! Did I really not think this through????? All I have to do is create a query including the Customer, Sales & Inventory tables, right?
  13. dylan03

    Save form data to a temporary table

    Thanks for all of your help, but I'm getting stuck on something. The customer information is entered into a table from the website (a credit application). So, I need to allow the sales rep to edit any misinformation. Currently, I have a combo box fill in all the form fields (from the...
  14. dylan03

    Save form data to a temporary table

    I'll try to be short... This is for an auto sales db. My tables include: customer (name, address, etc), inventory, (make,model,year) & sales (unit price, sales tax, financing info). The concept is this... 1. Choose the customer name (which populates the related fields from the Customer...
  15. dylan03

    Save form data to a temporary table

    Hello! I'm working with Access2002. I created a form based on a table's value, but need to save it to a temporary table (to base another form's data on). Can anyone assist with the macro/coding for this task? Or is there a better way of accomplishing this task?

Part and Inventory Search

Back
Top