Recent content by Crawforda
-
C
Show week beginning on a report
You are a genius. That code works an absolute treat. Thank you ever so much for all your help. Anthony -
C
Show week beginning on a report
That's what I've had to resort to, but I'd really like it if it would display 4/3/2002 as that is the Monday of that week. Perhaps I should modify the question to: How can I display the date of the Monday on my report when it is grouped into weeks? Or how can I convert =Format([date],"ww")... -
C
Report footer at bottom of page
I am in no way fluent with access, but I have had a similar problem and got around it by doing the following. Right-click the Report Header and Force New Page - After Section then Right-click the next footer just above the report footer (StaffName footer in my case) and Force New Page - After... -
C
Show week beginning on a report
Hi I am creating a monthly report of product outputs grouped by members of staff but with a week by week breakdown. My problem is that if a member of staff doesn't have any outputs on Monday, then the date on the report is set to the first instance (whenever in that week he does have some... -
C
Self populating a table from another table with a form
Hi Doug, Thanks for that tip, it put me on the right track. In all the times I was checking the help files, not one of them suggested a combo box. Now it seems really obvious. Anyway, many thanks again Anthony- Crawforda
- Post #3
- Forum: Modules & VBA
-
C
Self populating a table from another table with a form
I have 2 unlinked tables and a form. The first table contains basic information (unique number, part # & Qty), this table is updated daily from another database (not compatible, and off limits to me). The second table contains details of details related to the unique number, part # & Qty. The...- Crawforda
- Thread
- Replies: 2
- Forum: Modules & VBA
-
C
Selecting last months data
In the end I plumped for Harry's solution which works a treat. So thanks again for your help. Anthony -
C
Selecting last months data
Excellent. Cheers for both those pointers, I'll try them out as soon as I can (Unfortunantely I can only devote an hour or so a day to Access). Again, thanks for all your help. Anthony -
C
Selecting last months data
I am trying to create a report totalling up data for 'last month's' data input. I would like to be able to run this report at any time in the month without affecting the data collected (initially I tried using DataAdd, but found that it only collected data a month prior to the current date). I...