Search results for query: *

[Account_#] is a text field.

I am attempting to format a text box which is based on the field Account_# from a query. In the control source I have: =MaskAccount([Account_#]) MaskAccount is the following function: Public Function MaskAccount(strAccount As String) As String MaskAccount = "xxxxxxxxxxxx" &...

I found the answer in another forum...thanks to raskew... Sub RunReport(strReportName As String) On Error Resume Next DoCmd.OpenReport strReportName, acPreview If Err = 2501 Then Err.Clear End Sub

I used Jerry's advice for the On No Data event. However, when I call the report using this procedure... Sub RunReport(strReportName As String) DoCmd.OpenReport strReportName, acPreview End Sub I get a run-time error..."The OpenReport action was canceled." What am I missing...

It pays to search through old postings. This was exactly what I needed!

I've tried using the global variables as suggested. However, it's telling me that I can only set the record source property to a table or query. Any thoughts?

I need to generate a quarterly report (user input date parameters) that contains about 60 different calculations. I have been writing a procedure with a series of nested Case statements to produce the calculations. I thought they were too difficult to do in a query. How do I tie these...

I also found this in another posting. I haven't tried it yet but it looks simpler... ********************** This is 'My' holidays table(tblHolidays), refered to in the function below: HoliDate HoliName 1/1/00 New Year's Day 1/17/00 Martin Luther King Day 2/2/00...

I just asked a co-worker this same question. She found some functions here http://www.mvps.org/access/datetime/date0012.htm that were very helpful. So far, I've been able to make this work on a form and in a query. However, when I try to add the parameter for an array of holidays, I get a...