I have a dropdown combo box. A user can either select a date from the list or type on in. The problem is when I start to type in a date, the box auto fills with the bound column which is not...
I am currently trying to alter my database to represent data better...
What I have currently got is a technical database with various tabs with client information. One of these is a broadb...
When I attempt to edit a specific form in the DB the application crashes with this error:
*****************
Faulting application msaccess.exe, version 11.0.8166.0, stamp 46437912, faulting m...
Hi Experts,
I have a calendar control I want to become visible when the date combo box is clicked. Below is what I have, nothing happens when I click the combo box. Thanks for your help. T...
I have a subform that is based on a query which looks to the value in the combo box.
Combo Box OnChange event contains subform.requery method
The combo box on the subform from a column...
I created an Access 2007 database for a Client that has a form to add or edit records. The source of the form is a table. The first day there were no problems, but the second day, the client...
I have crated a database from new, I have picked Date Picker in the table and on the form, I have placed a date format in the table to 01/01/2008 format. How every my Date Picker does not come...
I have a form with a subform in data view (Access 2002). The user can apply filters on the subform to get a subset of the data. Now I would like to allow the user to export this subset to Exce...
I have a form where the values are entered into a table called TblTrainingInfo. The form has a Combo box which has a SQL statement which provides the training types to pick from a table calle...
Simple question: On a form in Access, I update the value of field 2 from an AfterUpdate event on field 1. How do I get the contents of field 2 to automatically display on the screen. At the mo...
I am trying to format a MS ACCESS form label or text box in the vertical position, with the text begining on the bottom and reading upward. The build-in property VERTICAL , sets up the label v...
What I want is to require the user to enter 1 address(in a sub form) before leaving the main form. All but line 2 of the following code works if the cursor is on the 1st record. However if ...
I have 2 issues both relating to an unbound form. The project is in Access 2003.
I have a product table that requires multiple serial numbers as well as a note field. The note field in th...
I want to create a command button on my access form that when clicked opens a folder on my directory that relates to the record currently being viewd. The name of the folder is the same as one...
I have been pulling [what's left of] my hair out trying to reference a fourth-level-down Sub-Form in a Form using VBA and keep getting road-blocked. Can anyone give me the correct syntax? I ...
Right now I am using a temporary table, but I suspect there is a way to do it with a recordset. I'm using Access 2007 DAO FE with SQL Server 2005 BE. I have datasheet subform based on a temp t...
I have a problem with a pair of combo boxes that I am trying to use to query a table based upon the selections made in said combo boxes.
route_combo selects the distinct route from table In...
I need to make a field on my form a required field. How would I do this. The user must fill in a required amount of digits or see an error message.
Thanks much!
I have a list box with four columns. The first three are ID, Address and City. The fourth is a sales number that I would like to be right justified for ease of reading. Is this possible? T...
Dear expert!
I am stumped on this one - I have a continuous form, and users happily use the right-click on a given field to sort Asc/Desc on that field.
However, there is a combo box on ...
Hi
I have an Access database which I am trying to migrate to SQL Server 2000 for the back end, but keep the front end in Access 2003 for now. We have a query which runs and selects the las...
For my department I built a simple MS Access database.
It contains a form with the ActiveX Control Microsoft Date and Time Picker Control 6.0
A coworker of mine can access the form but t...
I have an Access database with a single table containing 13 fields. I need to design a form which will update its contents when the user changes on of the input fields.
The form will have s...
So I have a table called Requirements and in the table there is a field called Description which is type Memo. As listboxes can't display more than 255 char, I want the Description field to s...
I have a form which has five different "areas" on it where the user enters information. The first 'area' is a combo box (created via the wizard) where the user selects a customer name and th...
