is anybody aware of how to use a list box column as a criteria in a query?
basically i have a list box based on a query, and the 2nd coloumn (column(1)) i want to use as a criteria....this ...
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...
I have an Access 2007 database and have a form with patient information. There is another table in the db that has the insured's information in it. What I want to do is if the information is t...
Would somebody be able to point me in the right direction?
I am in need of gabbing a vbcode to do the following:
I need to filter a listbox that will be contained in a form, over a ton o...
I am creating a simple database and form in Access 2007. Can anyone offer me assistance in figuring out how to display a radio button or checkbox horizontally on the form.
Right now if I ha...
Hi,
I have a table, "Websites", that has two text fields: "DisplayName" and "URL". I want to use this table as the source for a combo box (i.e. Select DisplayName, URL from Websites) that w...
I have a form with a various items on (comboboxes, textboxes etc).
I have set the tab order up so that the tab order goes from top to bottom of the form. On the form I have a combobox for ...
I am working in MS Access and have a form where a person chooses a name from a Combo Box.
The row source for the combo box is SELECT tblClientList.Full_Name FROM tblClientList;
What I wa...
Hi
How do you refer to a form if you have a string variable containing its name
Dim fld As Field
Dim strForm as string
strForm = "Customer"
For Each fld In Forms.strForm 'This...
I have a form with 10 little subforms. The form has an unbound combo box call cboStaffID Each of the forms contains a field called StaffID.
1) When I select a member of staff in the main...
I have a form with a subform.
On the main form (frmcases) there are two buttons. One filters the records in the subform (frmCare_Options) to show only those in the "Past Requirements" sect...
I've got a form with a combobox...
Row Source Type: Field List
Row Source: Table
Can the list be populated with...
- the Captions assigned to the fields and not the field names thems...
I have a series of controls (text boxes) that require the user to type a single number. Currently the user needs to press enter or tab to move to the next control.
How can I save users the...
Hey All,
I am going to be running a simple DB in runtime mode so the user won't have access to the toolbar, therefore I need to create a button so they can sort by certain fields...
I wa...
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'm trying to create a function that hides and unhides subform columns through the use of a list box. It is working incorrectly as it is hiding and unhiding the wrong columns. This is a chal...
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 ...
If I bind the results of a query to a form. (Data Sheet View). How do I then allow the user to change field contents?
Hi guys
Problem: Access 2007 does not appear to allow me to size forms in Form Design, so when I open a form modally it is those exact dimensions.
I have recently discovered Access 200...
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...
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...
Hi:
I have a form that I've converted over to HTML, but now some of the commands don't work bcs its obviously in a differnt language (originally done in VBA through Access).
The code that ...
I need to get the value of a specific row from a combo box to be inserted in the following query. The value is for Expr6. I've tried this
"Forms!Booking_EventDetails![LastofBooking ID]!Row(...
I'm having problems requerying data in a combo box on a form in Access 2007. The form (its a "continuous" form) is based on a table that stores two particular fields among several--a "SchoolID...
My question is similar to question 21687496 but not exactly the same. What I'm trying to do is actually simpler but I'm still having trouble.
All I want to do is execute a stored procedure...
