Search results

Hi Pat, Thanks for the quick response and quick fix - it did just the trick! :D Thanks again!!

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

Thanks -- that was what is was. I've simplified the script to its bare minimum. I can get it to send an email message to values in the form (such as the OrderDate), but I'm having some problems with the syntax of trying to recover the value: [email] in the table [customers] I thought the...

Hi Paul, I appreciate your help. I pasted in the coding: Private Sub PaidEmailButton_Click() Dim txtTO As String Dim strValue As String Dim strName As String Dim strMessage As String Dim frm As Form txtTO = [Customers]![Email] strMessage = frm![FirstName] & ", the order you submitted " _ &...

Thanks for your prompt response and assistance. I modified the code, but am having problems -- is the txtTO the name of the table with the email value? I'm not exactly sure how to use the function coding as I am trying to attach the code to a button on an order form. So far I have...

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

Thanks for the prompt response and fix! It works great now -- I certainly appreciate it! Thanks again! Jon

Thanks for the clarification -- I had it on the BeforeUpdate of the actual entry field. It now works great under the BeforeUpdate of the form with the code: The only error I get it if the field turns up a null. Is there a simple IF statement I can avoid running the code like: if [shipCity] =...

Fornation - Thanks for the prompt response. I'm using the code: Private Sub ShipCity_BeforeUpdate(Cancel As Integer) If Right$(Me.[ShipCity], 1) = "," Then Me.[ShipCity] = Left$(Me.[ShipCity], Len(Me.[ShipCity]) - 1) End If End Sub I'm getting a Run-time error '-21473567 (800200009)'...

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

Rich - Thanks for your prompt response. I am unfamiliar with being able to program queries with a statement like: Trim(Left([CustomerName],InStr(1,[CustomerName]," ")-1 Do I do this in the SQL view? Could you give me a starting point? Thanks in advance.

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

HTH - Thanks for the prompt response -- works brialliantly.

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

Rich - Thanks for the help .. I've searched extensively for 'stock' and 'paul hartman', but cannot locate any messages. I have spent most of the day reading paul's other posts. I've figured a few things out, but am still unsure how to subtract a value from the table [products] and then...

I need to post a correction: On a subform [orderDetails], I'm attempting to create a system to keep track of stock of items. My values are: [seriesTitle] is product name from the [OrderDetails] field [unitsInStock] is the number of current items in stock stored in the [products] field In a...

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

HI DBL, I've been thinking about it and looking at the database and I now understand your reasonging for having set values for dynamic totals -- I'll just have to go through and rework some of my forms and queries to reflect the dynamic addition. Thanks for help and insight! Jon

Hi DBL, Thanks for the response. I was able to create the calculation in an unbound field on the main form, but I was wanting to save it to the base table for other query calculations and totaling to keep track of how much individual customer have spent. Is there no way to save this...