Forms

Issue with code SendObject 2
Hi all, i appologize for my previous empty posting...below i have alos included further details related to my issue: In the “on click event of a command button in a form i shave this code Private Sub Command36_Click() On Error GoTo Error_Handler DoCmd.SendObject Dim varTo As Variant Dim varCC As Variant ... 26 Apr 2010 09:10

Legends
Hi everyone, this might seem like the most daft question ever but I'd appreciate any input... I have a pie chart that is based on a query that counts the check boxes in the table. My problem is that the pie chart gives a binary 1 or 0 for yes or no in the pie chart legend and after editing it always reverts back... 30 Apr 2010 06:12

countdown timer
I would like to create a form that has at least 5 timers on it to count down the time from when a start button is pressed, counting down from 60, 10, 5, 3, and 2 minutes. There needs to be a reset button, with the times reset for each. What would be the code for this? ... 25 Apr 2010 17:51

Enabling a control based on multiple criteria
This code will enable txtReason if cboFavColor = "Green," and disable txtReason if cboFavColor <> "Green": Me.txtColors.Enabled = IIf(Me.cboFavColor = "Green", -1, 0) If I want to expand the criteria to include "Green" OR "Blue", can I do something like: Me.txtColors.Enabled = IIf(Me.cboFavColor = "G... 27 Apr 2010 16:48

Combo Box Wizard
I use the Combo Box Wizard to create a cbo to find a record on my form based on a value I select. My values are Last Name and First Name. However, in the drop-down menu I can not see the values but they are there. So I can select something (I can not see) in the cbo and then the record appears on the form. ... 25 Apr 2010 21:13

How To Go From One Form to Another
I have a form that displays names and contact information. It is based off a master table (called CONTACTS). It uses a combo box to look up and display the contact ifo for whoever I select from the list. In order to simplify any search process, I also have simple forms that consists of a list box. Each form is sp... 23 Apr 2010 18:11

Input mask
Hi Guys I have and unbound text box, the lenght is 150, how can I create and input mask this big to allow, letter, numbers and special characters, I don't want the user to type more that 150 characters because I need to store the information in a table field 150 lenght. Thanks ... 23 Apr 2010 21:42

Form
Hello, I am using Access 2003. I have a form with a subform. In the subform I have the following fields... StatDate, Case#, Category, SubCategory, Notes and Amount. The Category field currently has a combobox with a looonnnngggg list of selections. I would like to change the category field to a text box and make ... 23 Apr 2010 18:11

DLookup
Access 2003 I posted this at the tail end of an earlier thread but since it's about a very different issue I thought it made sense to post it here. I've tossed in a DLookup into the following: If fOSUserName = DLookup("txtUserName", "tblUserNames") Then DoCmd.OpenForm stDocName, , , stLinkCriteria ... 23 Apr 2010 12:52

Getting 'Type mismatch' error after redesigning form
I am in the process of streamlining the process of generating shipping documents in our existing Access database. Our 'Orders' form currently features several buttons for the user to press to generate certain documents. Different shipments often require a different set of documents. To prevent the user from eith... 23 Apr 2010 16:11