Search results for query: *

Oh well not that clear on what you are trying to do... Ok goto the properties of the report goto recordsource on the data tab, Click the query builder button. when the query window pops up on the table you are trying to select click the (*) to select all records. then select an empty field...

Most likely the best approach is the following: Build a simple select query where you are only pulling one or more day's worth of records. I then would use the qry to build a report that shows the detail of the records. In the group footing for the day instead of using just the simple Sum...

pretty simple. On the report section click sorting and grouping icon. Select the date field you want to group, then where it shows: group header group footer group on group interval keep together select group on select month and away you go.... since its a date field access understands the...

Try Something like this: Private Sub Combo1_Change() SearchString = "Select * FROM tbl_YourTable " SearchString = SearchString & "Where [YourField] = '" & me.Combo1 &"'" SearchString = "Select * FROM tbl_YourTable " & SearchString...

Access by default will open the recordset in Read Only mode. You need to ensure that the you open it in Edit mode. Something like this: With rst_YourRecordSet Set .ActiveConnection = CurrentProject.Connection .CursorType = adOpenKeyset .Open "tbl_YourTable&quot...

Actually what you will find is that all the built in templates for P&L/BS/SofCF are nowhere near useable. If you can get your DOS files migrated easily into Access, You will find that writing the P&L and BS custom reports are pretty straight forward. Just lots and lots of grouping based on...

Make sure that the control on the form is UnBound.

do something like this Dim rstDailyDQ As ADODB.Recordset Set rstDailyDQ = New ADODB.Recordset With rstDailyDQ Set .ActiveConnection = CurrentProject.Connection .CursorType = adOpenStatic .Open "tbl_name", options:=adCmdTable end with Do Until rstDailyDQ.EOF MsgBox "yadda...

Thanks for the idea but, the problem with just scaling the fonts is that I have 14 columns of data and all of the font size's are currently set to 8, otherwise the data won't fit on the page. I do fully understand about the sizing issue and the print quality concerns. The documents are just...

I have a loan amortization report that depending on the number of months of the loan will print that many detail lines. 12 month loan == 12 detail lines 24 month loan == 24 detail lines 60 month loan == 60 detail lines I would like to be able to scale the report from 50% to 100% depending on...