Search results for query: *

I've got a DVD movie that I'd like to run from within a powerpoint slideshow presentation. Creating code that would start the movie from a button click would be fine - all assistance is greatly appreciated!

Perfect - thank you!

I have a 3-page report (one large Detail section with manual page breaks) grouped by "LastName" with a LastName section header that I want to print on the first page of each 3-page group. My problem is that the LastName section data prints on its own page - not at the top of the first page of...

Perfect - just didn't know where to look. Thanks much!

Okay - I got the sub-report inserted & spacing works fine. For some reason, there's a border around the sub-report in Print Preview. I've looked at every setting & can't seem to find where to delete this. Any suggestions?

I've got a report where I need the Detail section to be longer than the currently allowed 22". The report is basically a text report with specific field data disbursed throughout - so not compatible with sub-reports, etc. I'm working in Access 2003. Can this be done?

Thanks much - I chose the Combo box & though the format is a bit different, it does solve the problem of endless scrolling!

I have a list box created on a form to search for and select a specific name from my database. When the name is selected (either by double-clicking or selecting & hitting the "Open" button on the list box form) it then opens the data entry record for that individual name selected. When first...

Perfect - much simpler than I thought. Many thanks!

I have a report where I'm using the following code in an unbound text box to try to arrive at a subtotal of Pledges Received for each golfer registered: GolferPledgesReceived=DSum("[PledgeAmount]","qryPledgeStatus","[Received] = True" And "[GolferLastName] = '" & [GolferLastName] & "'")...

Thanks for the point in the right direction - because the Total Received value is calcuated in a query I used the IIf(IsNull) function in the Total Outstanding text box & it worked great.

Clicked in the wrong box & started typing too quickly - many apologies :-)

I've got a form with three calculated fields - Total Pledges Raised, Total Pledges Received and Total Pledges Outstanding for each GolferID record. Pledges Raised and Pledges Received are calculated through queries and displayed on the form using the DLookup function. Total Pledges...

Of Course! It was right in front of me - too close to see, obviously. Thanks much!

Thanks - when I tried that, I got an error stating "Automation Object not supported" in reference to the query name qryPledgeTotal. My expression read: =DSum([PledgeTotal],[qryPledgeTotal],["GolferID = & "GolferID])

I've got two forms (Golfers and Sponsors) based on two tables (also Golfers and Sponsors). Tables are linked via GolferID field. There is an unbound text box on the Golfers form that I'd like to use to show the total amount pledged for each golfer. I've created a Sum Query that's working...

I have a form "Golfers" based on a table "Golfers" containing golfer information and a form "Sponsors" based on a table "Sponsors" containing sponsor information (forms are linked many Sponsors to one Golfer via GolferID). I have an unbound text box on the Golfers form where I'd like to show...

I use the following code that takes care of this (& works better for me as I cannot always use AutoFilters in my spreadsheets): Function SumVisibleCells(CellsToSum As Object) 'sums only visible cells, ignoring cells in hidden rows or columns Dim cell As Variant Dim total As Single 'I use...

I've got several regional reports that the user runs from a "Print Reports" form where the report type & region are chosen via Option Groups then the report runs when a Command button is clicked (either in Preview or Print mode). I'd also like to give the user the choice of how to sort the...

Thanks again for your assistance. I came to the same conclusion on using an optiong group as well & have put it in place.