Search results

Has anyone experienced this problem ? When I add a command button to a form, picture builder brings up a list of available pictures in the system that can be applied to the button. Well the list displayed doesn't have a picture for every action that is available ( yes I have the show all...

OK Rick I see where I went wrong. I placed your code in all the other reports and it all appears to be working fine.Thank you very very much.

OK Rick I see it. I'll give it a try and let you know. Thanks

Rick, was there an answer in your reply or did I miss something ?

Can someone help me with a sub procedure that doesn’t always calculate properly. I have a table named tblRecap that has daily profit and loss figures. A query named qryMonthlySums that totals these daily figures for each month. A form named frmGetReports where the user enters a year for a report...

Thanks to both of you. I got it ........decided to use a form and a SQL string. Thanks again.

How can I have a user enter the WHERE criteria in the Set Rs statement below. Set Rs = CurrentDb.OpenRecordset("SELECT [Net] FROM [tblRecap] WHERE [Yr] = 2000 and [Event] = 'lancaster'") I would like a message box to ask the user to define the [Yr] = and [Event] = fields since they would...

I want to place a control in a report footer that will return the highest number of consecutive weeks that a profit was earned. The database has fields named WeekNo and Net. The Net field contains positive values (profit) and negative values (losses). The WeekNo field is an integer from 1 to 52...

I have a Visual Basic problem that generates the following error in a sub-procedure: Run-time error '-2147221164 (80040154)' Class not registered Until recently the sub-procedure use to work on my Windows XP computer running Access 2000. I have a vague hunch that the problem may be related to...

I'm unable to set up a simple filter for a pivot table. Here's what I've done. Created a query that asks the user for the begin date and end date of the search. The pivot table form uses this query as the record source. When I open the pivot table all the records are retrieved. I understand how...

form to filter data Thanks Fizzio for the help. I realize I made a typo when I posted the expression. The parenthesis at the end of the expression should be ommited. I have it without the trailing parenthesis in my query and it doesn't work. The proper expression follows: Between...

I'm using a form to filter data for a report. The form has 5 unbound text boxes for the user to enter the criteria. The unbound text box names are Type, StDt, EndDt, Event, and Loc.Sometimes the user doesn't need to fill in all of the 5 unbound boxes that's on the form and leaves some of them...

Thanks Patrick, That was it. The code is as follows: DoCmd.OpenReport _ ReportName:=ReportName, _ view:=Me.OutputMode, _ wherecondition:=DateFieldName & " Between #" & _ Me.StartDate & "# AND #" & _ Me.EndDate & "#" & " AND " & CatCriteria We...

I'm using the DoCmd.OpenReport method. A portion of my code looks like this: Dim ReportName, DateFieldName, CatCriteria DateFieldName = "DelivDate" ReportName = "rptInvoices" CatCriteria = "meat > 0" DoCmd.OpenReport _ ReportName:=ReportName, _ view:=Me.OutputMode, _...