Search results

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?

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

Here's my problem! I have three forms setup lets call them Main, Sub1, and Sub2. The Main form has a textbox used as a search field( using the Like command as an After Update event). Double Clicking in one of the fields will open Sub1 linking the information by the field. Double clicking a...

What I need to do is update a transaction log table when a form is closed automatically. My table has the following fields: Transaction type and Date. I would like to enter text such as "Email Send" and use the current date as the date data. I need help thanks!!

I would like to rotate a field and have the data be show from top downwards. Is this possible? Thanks in advance!

In my database I have a Salesmen Table with the following fields: Sales-ID, Name, E-mail address. I have a report which is generated from a query based on Sales-ID. Can I email this report to each salesmen by linking to email address in the table to the report? I'm looking to email mutli-users...

Hello, How can I filter the data in a subform with a combo box from the main form. Alittle info. I have a combo box which has three options OPEN,WON,LOST. When I click to OPEN I would like the subform to display only "OPEN" data. There is a field in the subform named Status with either...

I'm using a group option frame with 6 option buttons to filter on a form. What I would like to do next is filter this data further with an unbound text box. Please help!