Search results

I have an Access form with a Subform when the User clicks Save on the Main form I need to check and make sure a required field has been populated on the subform. Below is the code I am using it runs but doesn't work (ignores test). Basically if a User selects "Pending" in the cmb_ActionCode I...

Yes, once the user selects the recordset row on the subform I want a query to be triggered and opened. The parameters for that query will be some field(s) from the selected recordset from the subform.

I want to pass a couple field values from the selected recordset thru to the query. Because the subform contains multiple records in datasheet view I only want to pass the field values for the selected recordset (active) from the subform.

I am trying to reference the fields on the active record in a subform. What I would like to do is have the user select a row on a subform (Datasheet View) and have a drill thru query generated. How can I pass fields from the active record in a subform to a query using VBA? Any help is appreciated...

Is it possible to have a Cover Letter print at the begining of each Group? For example I have a Report with the following Grouping: Report Header Page Header Client Header Client Detail Page Footer Report Footer I would like a Cover Letter to print at the Begining of each New Client is this...

I have a form that allows a user to select a time from a combo box for scheduling a report. I keep getting a runtime error 13 type mismatch on the line in red below. What am I doing wrong? Any help is greatly appreciated. Dim strHour As Integer Dim strAmPm As String Dim strSQL As String Set...

How would I do that? I have never worked with this object.

All, I have an Access Form that I have embedded an Active X object(Microsoft Office Spreadsheet 11.0) in. I would like to populate it with a query from within the same Access Database how can I do this? I have tried the below but I get the error "2455 You entered an expression that has an...

Hi all, I want to add 2 columns of data to a combo box on an excel worksheet. The combo box is on a worksheet not a form. How can I do this? When you drag the combo box onto an excel spreadsheet it doesn't prompt you to name it.

bhamilton42, I was finally able to get it to work by changing i to integer datatype and passing strArrayPayor(i) to the SQL like you suggested. Thanks for your help I appreciate it.... Also thanks for the tip on writing SQL in vba. Dim strArrayPayor As Variant Dim i As Integer Dim db...

I am trying to pass an Array value to a SQL query in vba. I keep getting the error "Expected Array" Basically I want to pass the string value of strArrayPayor to the SQL code as a string. See my code below.... Arrays are new to me but I am trying to learn.... Private Sub...

Thanks mdlueck and pbaldy your suggestions were very helpful...

I added an If statement inside the Case statement to test for value and it worked like a charm see below Case "Unresponded" If IsNull(cmbFscRptCat2Grouping) = False Then SQL = "SELECT *" SQL = SQL + " FROM Group_" & cmbGroups & "_ATB_Daily_Grouped" SQL = SQL + "...

I am passing a SQL string to a Pass Thru query (SQL Server Backend). When the User selects a report from [cmbReports] they will also have the Option to select a payor from [cmbFscRptCat2Grouping]. Basically I would like for the user to be able to run the report with or without a selection from...

All, I have an Access 2003 Data Project with SQL Server 2008 Back End. When the user selects a drop down list I am trying to assign the recordsource of a subform and I keep getting the following error: Error 2467 "The Expression You Entered Refers to an object that is closed or Doesn't Exist"...

When I try to execute the code below I get error 3075 Missing Operator.. The code looks ok to me am I missing something??? "INSERT INTO Tbl_AP_Temp" & _ " SELECT * FROM dbo_Tbl_AP WHERE" & _ " dbo_Tbl_AP.[MEDICAL RECORD]= " &...

Thanks Beetle, I appreciate the response.....

All, I am considering using Access 2010 Front End linked to SQL Server Backend to Build a User Interface for Data Entry. I have a couple questions. 1. Can you publish an Access Database that is linked to a SQL Server backend to Sharepoint? 2. When a User pulls up the Published Access form on...

I have and Access form and I want to Pass some text box values as the criteria for a Pass Thru Query, can this be done? I tried writing the SQL statement out and passing that to the Pass Thru Query Definition but that didn't work..... Dim db As Database Set db = CurrentDb Dim...

Thank you very much! I appreciate you pointing me in the right direction.