I have made a few changes, but still no luck...
Private Sub cmdReport_Click ()
On Error GoTo Err_cmdReport_C lick
Dim strReport As String
Dim strPW As String
Dim strGetPWReq As String
strReport = Me.listReport.C olumn(0)
strPW = Me.listReport.C olumn(6)
If Len(Me.txtdatef rom & vbNullString) = 0 Or Len(Me.txtDateT o...
pipestew
Last Activity: Feb 19 '08, 05:27 PM
Joined: Oct 22 '07
Location:
-
Password Protected ListBox Selection/Command Button
tbl_Report
- DBReportName
- MenuReportName
- FacilityID
- ReportType
- Viewable (Yes/No)
- PasswordProtect ed (Yes/No)
- Password (Encrypted)
On MenuReport form...
1. User Selects Facility ID in a combobox
2. User Selects MenuReportName in list box (row source dependant on Facility ID selection)
3. User enters date range in txtDateFrom and txtDateTo
... -
Service Industry Database
Our company provides value-added services to oil/gas pipe. The services are performed in three different facilities. I have a database that is intended to collect production data from the facilities and produce the necessary reports. I am 90% finished with the table/relationship design, but I am having trouble with one aspect of the design...
Every job is assigned a Job Number...
tbl_JobNum
-JobNum (PK)... -
Query Criteria Based on Form Value
I have a form which allows me to enter a value and then view a report based on that value.
The value is currently entered as P-##### and the query criteria is...
[forms]![frmJobCompletio n]![txtJobNum]
I want the Form to have "P-" in a text box and then the user only has to enter "#####".
How do I alter the query to still return "P-#####".
No activity results to display
Leave a comment: