I have a button on my form that selects all clients in a list box. It works in the sense that when I click it, it does select all clients. The problem I'm...

Hi. Is it possible to define a variable = value of the field on focus? E.g.: in a field called «Var» I enter the value «1», and if I have the mouse cursor...

-- Hansford D. Cornett

I want to set the date in an unbound textbox to 01/01/1970 Properties format : mm/dd/yyyy Properties data - default value: 01/01/1970 turns to 1/1/1970 or if...

How can i execute code when the access database application closes. is there a way to hook into a 'database_close' event, or the like? thanks!

I have a Letter Date of 01/01/2006 that is input on the FLY for each letter when I print it. I want to put a paragraph in with a ResponseDate file that...

if you want to use controls on an object, click on the appropriate control, then click on the "detail" section of the object (queries, forms, reports,...

I am having trouble linking subforms together. I use the technique with the invisible text box. So i have it so that the textbox reads the value from the...

do you ever get so far out in left field that it's hard to find your wasy back to the dugout where everyone else is sane and speak's english

Hi, I have a access 2000 form which is linked to a table. This form has calculated text fields. So far, when a user hits the save button on the form it...

Hi all, I have tried several other things that were not directly an answer to this from other posts, but have not had success. I have code that finds the...

I have a form with a bound combo box that has duplicate numbers in it. I need the duplicates removed. How do I eliminate the duplicates from the drop down?

I have designed a form which allows me to edit records in my database. The data is a list of issues and each record has a status ID (1=Review, 2=In Progress,...

I have two forms. The first form is frmCustomer_Lookup and the other is frm_Customers. In frmCustomer_Lookup I have a combo box where the user selects a...

I need to update a display in a listbox because of other user activity in form. How do I look through a controls list to find the proper row to display? My...

My criteria in query is: where outlet in . Outlet type is text and . type is number is there any way by which i can match the values. Thanks.

Hi, How do to block my scroll of mouse not to alter the record current of form? Thanks, Michel Ank

We have a service request database that we want to use a single form to enter new requests. We have it set to close out of the database when the close / submit...

Hi: Can any one please help me how to i join both tables so that i get value from FieldC. Table A of val(left(FieldA,5))=Table B of FieldA Table A FieldA,...

I have a combo box in a subform. When the user selects and account and then goes to enter the contract for the account, they need to select the associated...