Hello, I have created a form using a query. The query has a field that selects criteria to open the first form such as a Birthdate. I also added a...

I have a form that I want to use for inputting new records only. Right now the form shows all records from the table it is linked to, but I would like it just...

I have done something and I am clueless. Please be aware I am self-taught. I get the above message on my form when I try to select a record via combo box. My...

1. I am using a continous form called that looks like a table. At the top of the column I want a button that will sort the form by that column field. When I...

Hi, I have a continuous form that is using a table as a control source. Each record has a checkbox, I put an unbound check box in the form header- when I check...

Hello. I want to put a control on a form that displays the real time - or to be more precise - a clock, resembling that in the system tray. Is there any idea....

Hi Doogle, I hope you are still there. Chett Doogle wrote: Hi Chett, Sorry, you've just lost me!

I have created a table which contains info about facilities; sample lines a Course ID Golf Course Chapter Facility 1 ABC X3 ...

I have a combobox in one of my access form. I am using a query to populate the combobox. When i am setting the BoundColumn property to a nonzero value, i am...

When I use my form to add a new record, I get the following error: "You tried to assign the Null value to a variable that isn't a Variant data type. (Error...

I am looking for an alternative to Dlookup to autofill a form. Because this process is very slow and we are working across a WAN, I do not want to bog the...

I have a subform with fields Price, Quantity & Total (among others). The "Total" field is autopopulated by using =* as an expression in the Control Source. Is...

Hi Stephen, Recently, I used on my form a your example, http://www.lebans.com/autosize_textbox.htm, to resize automatically the width of text box to fit its...

My form contains a box control and some label controls on top of the box. The labels' mouse move events contain code to emphasize the labels caption...

Hi, I don't know what I've done, but my combo boxes just stop functioning! (i.e. when I click on the arrow, the list drops down, but when I try to select...

In Access 97, have a form with a subform on it. Upon opening the main form, I'd like the focus to be immediately set to a textbox on the subform. The name of...

I'm trying to make a query system and want to speed up the way it is used. Basically I might be wanting a query on a street name. The street name is: Cherry...

Hi there, I have a bug that I cannot trace. I use a short date format of d/m/yyyy. This is used throughout my database. However when I use dlookup through...

I have 2 tables I want to show in 1 form. The "Locations" Tables lists unique locations and their information. Then I have a "Documents" Table that has many...

Hi all, I want to create a form using vba. Iv'e got Dim frm as new form. but some of the design time tools such as create object do not work. It appeqrs...