Search results for query: *

I want to build a form that allows keyword searches using a textbox but don't know where to insert the "like" clause. If Not IsNull(Me.txt_search) Then Whereclause = "[Details] = '" & Me.txt_search & "'" End If Thanks

I have a form called frm_Mainform that is used to enter general information regarding the service of an instrument. frm_MainForm MainFormID <PK> PersonPerformingService <Text> Department <text> ServiceDate <Date> I now have a subform that contains: sfrm_Instrument InstrumentID <PK> MainFormID...

I have a form, frm_Main, with three subforms. One of the subforms, sfrm_Service, contains a multi select list box. This list box shows all the possible repairs that can be done on a particluar instrument. I want the user to be able to click all that is done. I also placed a command button...

I am using the following code to filter a form, frm_ExternalAudit_View, with a subform, fr_AuditDetails. The field that I want to filter is [Status] and this is found in the subform. Dim stDocName As String, Whereclause As String, frm As Form, sfrm As Form Set frm =...

I am using the following code to open a form (frm_Audit) that contains a subform (frm_AuditDetails) from another form, frm_Search. This is the code in the On CLick event of a combo box in frm_Search. Dim stDocName As String Dim Whereclause As String stDocName = "frm_Audit"...

I have two tables: tbl_Audit AuditID <PK> Auditor Name etc tbl_AuditDetails DetailsID <PK> AuditID <FK> I have a form, frm_Audit, that is used to enter general info into tbl_Audit. This form also contains a subform, frm_AuditDetails, and this is used to enter the specifics of an audit. The...

I have a form, frm_Metrix, for viewing the number of audit items performed during an audit. The record source of this form is tbl_Audit which has: tbl_Audit AuditID <key> Item No <Number> I have another form, frm_Audit, that is used to enter all the audit items into tbl_Audit. In...

I have an unusual problem with one of my forms. I designed a form for entering maintenance records of instruments. One of the fields is for attachments and its property is set to OLE Object. I named this field txt_attachment and placed it at the bottom of the form, after several other text...

I have a form, frm_Metrix, that I use to tract the number of Reports generated per month. The RecordSource of the form is the query qry_Metrix. Here is the sequel for that. SELECT Count(*) AS NoOfReport, Year([Date Initiated]) AS [Year Initiated], Month([Date Initiated]) AS [Month Initiated]...

I have a table for client complaints, tbl_CARGeneral. The fields are: tbl_CARGeneral CARID <autonumber> Initiated By <Text> Date Initiated <Date> Status <Text> I have a form, frm_CARNew, where users can log the complaints into tbl_CARGeneral. I then copied this form (frm_CARReview) then set...

I have a form with two text fields, txt_FollowUpDate and txt_ApproveDate. In the After Update event of txt_ApproveDate, I placed the code below to check if the date enetred in it is before the follow up date. If DateDiff("d", Date, [txt_FollowUpDate]) <= 0 Then Me.txt_ApproveDate = Date Else...

I have a form for recording client complaints. The first control is a combo box, cbo_PM, where people can select their names from a drop down list. The rest of the text boxes and combo boxes in the form is for documenting other aspects of the complaint. The problem I have is that people...

I have a table for storing client complaints. The structure of the table is: tbl_Complaints ComplaintID <autonumber> InitiatedBy <text> DateInitiated <date> Complaint <Memo> Every month, I need to make a report on the number of complaints received per month. How do I qeury that from the table?

I have a form, frm_Log, that people use to document phone calls from clients. If the phone call is a client complaint, the check box, chk_Complaint, will be checked. Clicking this check box sends an outlook task to the department manager to respond to the client within a specified amount of...

I have this code for assigning tasks. When I run the code, I get the "Invalid use of null" error message. I looked at all the fields on the form and subform and nothing is null. Why am I getting this error message. Please help. Dim OutlookApp As New Outlook.Application Dim OutlookTask As...

I have a form with 2 tab pages. Each tab page has a subform in form view. In tab page 1, I have a command button, cmd_Next. When this button is clicked, I want another command button in tab page 2, cmd_Send, to become disabled. How is this done?

I have a form, frm_CARReview, that I want the data filtered using a selection in combo box, cbo_Choices in another form frm_Choices. The choices are All, Open and Close. The first filter is to give me the last record in tbl_CARGeneral. SELECT Last(tbl_CARGeneral.CARID) AS LastOfCARID...

Hello. I am running the following sql query as the record source for my form: SELECT tbl_CARGeneral.CARID, tbl_Employee.Employee, tbl_CARGeneral.[Date Initiated], tbl_CARGeneral.Status FROM tbl_CARGeneral INNER JOIN tbl_Employee ON tbl_CARGeneral.[Initiated By] = tbl_Employee.EmployeeID; I...

I have a form that has 5 tab pages. There is also a command button on the form, cmd_Submit. Is it possible to enable/disable the command button, cmd_Submit, based on which tab page is selected? I tried placing the code in the On Click event of a tab (say Tab 2) but it didn'd do anything to...

My subform contains several combo boxes and text boxes. Users will enter data into all these fields. I want to place a command button on the subform so that when it's clicked, all the fields on the subform are locked. Can this be done?