Search results

I've frequently used the code here to change the source on all of my BE tables. It may be a good place to start if you don't get any other replies

Sorry, my bad. I assume you've resolved the problem with boblarson's solution

Is there a field called Location in the query qryLocation?

If you want a grant total for all records in your query, uncheck the 'Show' box underneath all fields EXCEPT the field you wish to 'Sum'

Something like; SELECT First(Left([VendorNo],8)) AS [CityCode], Count(VendorNo) AS NumberOfDuplicates FROM tbl_Vendors GROUP BY Left([VendorNo],8) HAVING (((Count(VendorNo))>1));

You could use DMIN; score_grade: IIf(IsNumeric([score_result]),DMIN("Grade","tbl_scoregrade","[Score]<=" & [score_result]),0) Or DLAST if you create the query 'qry_scoregrade' as; SELECT * FROM tbl_scoregrade ORDER BY tbl_scoregrade.Score; The formula would then be; score_grade...

Try changing the code in the event that produces the report from; DoCmd.OpenReport stDocName, acPreview to DoCmd.OpenReport stDocName, acPreview, , Me.Filter

As your table name contains a hypen, it should be enclosed with square brackets ie CREATE UNIQUE INDEX PrimaryKey ON [Pre-Deletes] (Geo) However, this will only create an index called "PrimaryKey" To create a Primary Key on the field Geo, you will have to append "with Primary" to the end of...

Done! PR

See the following link for a good explaination http://www.mvps.org/access/forms/frm0028.htm

You should; 1. Include the field UserId (as the first field) in the query Query1 2. Change the code behind the listbox OnClick event to 'find' UserID rather than Provider

Hi Sue Are you not able to leave all of the pages with the same smaller width? PR

But applying a filter will re-render the report meaning the amended form text field will be picked up. Taking your '.filter = on' a bit further you could use something like .Filter = "[Page]>=1" .FilterOn = True .FilterOn = False

I don't know the answer to your question ("Can page margins be different on different pages") but in a similar situation I include the letterhead graphics/text in the 'Report Header' which only appears on the first page of a report Also, are you able to print single report to different paper...