Suppress Autonumber record from displaying on the form 1 213 (6/23/2007 11:17:00 AM)
I have a query that feeds the form. I would like to only show the query results without the Autonumber record showing up at the very end. Is it possible to suppress it. Thanks MSA ...
Utf

Access 2007 and combo box 1 143 (6/22/2007 8:58:24 PM)
Has anyone successfully created a form with combo boxes that autocomplete in access 2007?! I'm pretty familiar with access, but cannot get combos to autocomplete in 07. When i first add the combo, it does autoc...
John

ALTER COLUMN Help 8 112 (6/19/2007 10:23:50 PM)
I previously submitted a post but was never answered. I must be because I stated it worked but wanted input how it could be simplified. However, I moved on without the simplification and I am moving forward wri...
moscat

IIf statement using a time field 3 389 (6/22/2007 6:57:00 PM)
I have a form with [Start_Time] and [Stop_Time] and a {Shift] field that has two choices, 1st and 2nd. I tried using an IIf statement in the shift field (control source) but it's not working. I want it to r...
Utf

Searching a Table on a Form Using Drop Down Text Boxes 3 101 (6/22/2007 5:03:10 PM)
I need my form to be able to pull information from fields in my table and list all of the entries entered in that field in a drop down box on my form. I got one of my boxes to display all the ID numbers, but w...
Kgwill85

Enabling buttons on forms 3 127 (6/22/2007 3:56:01 PM)
The normal way of enabling a button so the user can click on it at the form level is: expression.enabled = true eg. cmdMyButton.enabled = true This makes the button active and not greyed out. Say you want...
Utf

Combo box to increment search AND hide others 1 285 (6/22/2007 5:28:51 PM)
I know how to use combo box to search names. I want it to do further: hide those not starting the character I'm typing. For example: When I type the 1st letter S, it shows all the name starting with S and hid...
Song

General MS Access Programming 4 119 (6/22/2007 2:16:41 PM)
I have spent almost 46 years learning, using and teaching different programming languages and quite frankly, I have never found anything more confusing than trying to program functions in MS Access. I have giv...
Starwood

Stamping a field in a table from a form 7 94 (6/21/2007 5:48:13 PM)
When I send "frmOrders" to print (print preview), I want to stamp a field "LastOrderDate" in the table "refCustomers" with the field "OrderDate" in the current form ("frmOrders") Current code on the button t...
Dave

SendObject acSendNoObject Selecting Emails and Outlook 8 144 (6/22/2007 10:16:43 AM)
Hi, What i have is a list box that displays two fields from my table, it displays a name of a charity and their email address. This list box allows me to select multiple values. I have a command button wit...
b_a_redman