I'm not much of a MS Access guy, so I may not word this correctly... Here's the rough situation:
I have a three tables (offices, users, trainings) that look something like this:
Offices...
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...
Hello Experts.
I have the following:
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "C:\Documents and Settings\pardoe2\My Documents\Blank Solution Tabs\Blank...
Hi all.
I have an Access 2003 form that has a SAVE button, I would like to do the following:
When the user clicks the SAVE button, saves the data (already got it to do that) but I also w...
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 have a mainform with two subforms...
Mainform (select case)
+---Subform1 (case's records)
+---Subform2 (datasheet for the case)
When the user selects a case in the...
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 ...
This is my third post for this topic. Think I'm almost there.
For those that have helped me get this far, thank you.
I need to add / modify the code below to check for international date ...
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...
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 standard continuous form(appears as a datasheet) with basically every property (record selectors, scroll bars, etc.) set to none/no. I have those turned off because I feel it creates...
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...
My MS Access 2003 application works fine using data tables linked on the string fields that are also displayed in Text, List, Combo boxes, etc. I "normalized" the back end data files and now ...
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 am trying to develop an interface for Access where Engineers can enter test data. They are currently using an Excel version that is very cumbersome and non-standardized. This makes it impo...
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...
Hello,
I have an Access form with three checkboxes and multiple combo boxes. I am adding a reset button to 'clear' the form. All the code works fine until I attempt to set the value of the ...
I have an Access 2003 (SP3) database (front-end) with linked tables (via ODBC datasource) to a SQL 2000 database (back-end). Whenever I edit a form in design view that utilizes one particular...
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 would like to FIND and OPEN a SPECIFIC PDF File within MS Access. My MSdatabase is over 17000 records with many fields (this is a law firm). We have PDF files related to each account contain...
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...
Is there a way to change the rowsource of a subform?
I have an In/Out board subform whose rowsource is contingent upon a combobox in the parent form.
The records in the combo box are peo...
Using MS Access 2007 as a front end to tables in SQL Server Express
In a previous question I asked how I could allow users to work on a list of records without the underlying tables being u...
I am using a text box and a listview control on a form. The user selects an item from the listview to edit, this populates the text box with the text that can be edited. As soon as the user ...
