Search results

In a form [orders3] which is primarily controlled from the table [orders]. I have a list box of the table [MailType]: for instance in the table [MailType] I have the values: MAILINGMETHOD MAILTYPEPRICE MAILAUTOID Priority Mail $4.00 1 First Class $2.00 2 I need to update the value...

Hello, I was interested in programming a button in an order form sends an automated email to the customer through Outlook. The customer's email address are already stored in a linked table. Are there any pre-programmed basic scripts that could send a message like: " Hello [firstName]...

Hello, In a form, I cut and paste a lot of address information. On one field [ShipCity], the pasted data often ends with a comma -- Is there a simple script I can put into the After Update event that will check to see if the last text is ", " or just "," and delete the comma? Thanks in...

Hello, I am redoing some of my main data and seperating the Customer information into first and last name and then street address in seperate fields. Right now, I have the field [CustomerName], I'm trying to build a button that, when clicked, will automatically put the first and last name into...

Hello, I am attempting to create a button that when clicked in the form that will put the current date in the [OrderDate] field. Is there a simple command to to do this? Thanks in advance for your assistance!

Hello, On a order form, I currently have an 'edit customer' button which edits the current customer's profile in a 'customers' form I was wanting to include a 'new customer' button that could automatically open up the 'customers' form, add a new record and then upon closing the form would...

Hello, On a subform [orderDetails], I'm attempting to create a system to keep track of stock of items. After I enter the value for [seriesTitle] for the product entry, I would like the value [numInStock] to subtract one(NumInStock=NumInStock - 1) and display this value in the same subform...

Hello, I have a report that has a informal greeting in the header and in the 'detail' section of the report is the repeating list of items ordered. I was wanting these items to print out alphabetically sorted from the value [seriesTitle]. What is the best way to do this? Is there any easy...

Hello, I'm trying to create a form that contains a subform to create the subtotal, shipping, and total cost in the main form. Could anybody direct me on how to do this - I keep getting #error! My values should be: Subtotal should be =Sum([price]) from the subform OrderDetails Total should...

Hello, I have an order form with a subform with order details. The orderform allows you to select the customer's name and then input all the order details in the subform. I would like to create fields that once I select the Customer's Name, it plugs all customer's query information into...

Hello, I was wanting to write a personalized report letter using customer data. I was wanting to do a header like: "Dear Joe," I have the entire customer name in one field and a seperate nickname field. So I would need a command that goes something like: write "dear" & IF [nickName] is...

Hello, I have been using the M$'s Northwind DB as an example and I would like to have a button on my order form to print out an invoice/shipping report of only the order you on working on? The Northwind DB has a Print Invoice button which I can't figure out how it works! My northwind...