Search results

arnelgp, Thank you for the response, The field [COST_CENTER] is formatted as a number

On the surface this seems easy enough, but here is my problem, I have a report, that when opened from the "Home Form" (A form that is sort of like a switchboard) receives a value and the formulas on the report are updated So in other words, you run the report, a variable is passed from the...

Markk, Thank you again. I much prefer to look at my criteria on multiple lines. I have used this method in the past for SQL, not sure why I didn't apply that here

Markk, You were correct, I did not have the appropriate quotation marks, therefore it was reading the whole line as a string as opposed to the two values I was trying to pull, The final string looked like this: sWhere = "[COST_CENTER] = " & iCost_Center & " And [CATEGORY] = " & "'" &...

I believe I am missing something so obvious. I am trying to open a form with multiple criteria in VBA, here is what I have: Private Sub Text2_Click() Dim iCost_Center As Integer Dim sCategory As String Dim sWhere As String Dim sFormName As String iCost_Center = Me.txtCOST_CENTER sCategory =...

Im sure Im missing something so obvious, but cant seem to troubleshoot it. I am getting a type mismatch on the following code: Private Sub Text2_Click() Dim iCost_Center As Integer Dim sCategory As String Dim sWhere As String Dim sFormName As String iCost_Center = Me.txtCOST_CENTER...

Thank you very much for your post, it is very similar to what I ended up working out, which is: Private Sub cmdEXCEL_Click() Dim whereClause As String Dim myPath As String Dim sFileName As String myPath = "C:\Users\X\Desktop\Budget process information\"...

You are correct, someone did give me this code, I suspect he only meant it to be an example of what needed to be done, and expected me to fill in the blanks. Which is what I am trying to do. Good point about "Set Qdf" at that point neither do have any variables. I moved it to after strSQL...

I'm fairly sure, as all other commands function as expected, and this is the first time I have come across this error. Thank you for lesson is using variables in SQL strings. The debug.print shows a more accurate result of: SELECT * FROM COPY_TBL_LEDGER_DETAIL WHERE ([ACCOUNT_NUMBER] =...

Ok, I have updated the sql string to: strSQL = "SELECT * FROM COPY_TBL_LEDGER_DETAIL WHERE & me.txtFilter" But I still get the same runtime error of 3027?

Here is the problem, I have a form "frm: Report Creator" with a subform that is linked to a query. Basically the parent form acts like is a report creator. Where a user can input data into any field to pull results to the subform. On the parent form, I also have a field (txtFilter) that...

I have a continuous for, with a txt search box that contains a sql statement. the sql statement is as follows: strLedger = "Select * from qryLedger_Detail where DESCRIPTION like ""*" _ & strText & "*"" or VOUCHER like ""*" _ & strText & "*"" or POLICY like ""*" _...

So now I am being promoted for the parameter "fnCostCenters" Please excuse the previous message

So now I am being promted for the parameter "

Sorry, in addition, this is what the full macro looks like,

I did actually, please see the attached screen shot

When I update the where clause in my macro to " fnCostCenter([COST_CENTER])" and paste the code in a new module, I get the error message "Undefined function 'fnCostCenter' in expression?

Very interesting! I sort of inherited this db. Following your statement, why shouldn't report open forms? If I was creating this from scratch, I obviously would have built these "reports" as forms, and generated reports off of the data, Having said that, I believe I have to build a an sql...

Good morning all, I have a report with some calculated fields on it. And these fields are hyperlinked to open a form with the detail that makes up the calculation. On that form, there is a button to export the details to excel (via ExportWithFormatting), and everything works fine if there...

My current formula is: =DSum("DEBIT","qryExpense_Report","ACCOUNT_NUMBER = '" & 5040823 & "' And Month = Format$(DateAdd(" & Chr(34) & "m" & Chr(34) & ",-1,Now())," & Chr(34) & "mmmm" & Chr(34)) And I cant run it against the table, as I am trying to pull a variable from a calculated field,