Tables: tbLImport(PK AutoNumber,FK GID), tblDataEntry(PK GID)
Relationships: All Records from tbLImport on GID and only records from tblDataEntry where GID is equal
Queries: select_tbLI...
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...
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 complex database with heaps of forms and extensive use of subforms.
I sometimes have to use continuousforms in a subform and generally this is fine for simple lists of records.
Howe...
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'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 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...
When I try to add the Microsoft ActiveX control - Common Dialog (Comdlg32.ocx) the message appears:
"You don't have the license required to use this ActiveX control"
I have registered the ...
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...
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 ...
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...
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...
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 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 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 ...
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?
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...
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...
I have a continuous form where there is a combobox in the header that contains only SS#'s. The continuous form has the data record for all SS#'s.
Whe I select a SS# in the combobox, I want...
I can't believe I haven't seen this bug reported yet for Access 2007 - am I missing something?
Each tab in the tab control has a property "Picture". Click the builder icon (...) and select...
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...
How can I determine which control currently has focus on a form?
Hello experts
I'm sure this is the simplest question ever, but I'm short on time so here it goes:
I have a table of information on teachers (Name, school, and notes). I want to have a f...
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 am using a calendar (ocxCalendar) to enter dates into a form and the date is currently being displayed as 08/04/2008.
I need to be able to change this so that the date includes the day. S...
