Search results for query: *

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

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?

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

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

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

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

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?

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;) =...

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

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

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

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?

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

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

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?