Recent content by jevans

On my main form I have a combo box that I use to select from a list of 35 different reports. Once the report and criteria is selected a simple click of a command button generates the report. The following is a sample of the code attached to the click event on the command button. If...

Hello Everybody, I want to use a static product listing form to select multiple items and then have these items copied(append) to my current order form. I 'm using a checkbox to select the items and when the form closes I reset the check boxes to false status. Any ideas?

Hello Everyone, I have an Order(main)form and Orderdetail(sub)form, which I use to generate invoices. The underlying tables have a one to many relationship. The OrderDetail form contains the individual line items of the order. I also have a Product Select form with checkboxes attached to each...

Hello everybody, I've been trying to email a report using the html format on an HTML template, so far no luck. I've tried to get the sample templates included with access to work, but can't seem to get the images to display. My end goal is to send user HTML Email. I figured out that if I...

Hello Everybody, Ok, here's my problem! I have a form (frm_Customer) that I am using to display and update customer information. I have two types of customer, personal (P) and business (B). The field Type holds either a P or B to identify customer type. I want the code in the before update...

Hello Everybody, I would like to use a modem and the caller id information from the Telephone Company to automatically open a customer contact form to that customer information. Has anybody accomplished this?

Hello Everybody, I'm using the 10 digit input mask for my telephone number field(!\(999") "000\-0000;;_). I would like to change the system generated error message with my own. In the same form I have a postal code input mask(>L0L\ 0L0). I tried the following code, but I want seperate message...

Hello Everyone, I have a form that prevents updating unless certain fields are completed. Here's my problem; I have a Cancel button which actives the msgbox in my BeforeUpdate event before the form closes. Can I suppress this msgbox form opening?

Hey Pat, I'm going to use a bound form and the BeforeUpdate Event on the addition form. What is the code to prevent records with null values in the customer and business fields (text fields) from being entered. Also, if they are null return the user to the incorrect field for correction without...

I forgot all about the beforeupdate event. I agree this approach is too time consuming and I'll try your method. Thanks Pat

Hello everybody, I think this is a problem that has been asked anytimes, so what's one more time. I have an unbound form named tbl_AddCustomer with fields like Customer,Telephone#, and Address. What I'm trying to do is prevent entries into the customer table if either the customer or telephone...

Hello, My Customer Form lists all customer in the database. The fields are CUST-ID & CUSTOMER NAME. The CUST-ID has a DDL_Click event which opens Invoice Header Form and shows all outstanding invoices. My problem is show of the customers do not have invoices and the debugging window pops up. I...

I have 2 tables Customers and Contracts. Each table has its own form. In the Customer Form I have the Customer # field code to open the Contracts Form when this field is double clicked on. When there's no contract data the Debugging window pops up. How can I get a MSG box to appear and say "No...

I have a "Searchfield" Textbox in my form, which is used to filter data on the form. The filter executes after Update and I would like to have access return to the "Searchfield" Textbox highlight what was previously enter and ready to enter in difference search criteria without using to delete...

I have a form with to fields "Begindate" and "Enddate". I would like to have these fields on form open generate the first and last days of the current month automatically. Thank you, in advance! Jerry