Replies

I have an idea for a work around.

How about each time a letter is clicked you first go to fields begginning with the letter A
and then procede to the one beggining with with the letter you clicked.
Since there will never be a large number of records in the database there should not be a performance hit.

How would I go about coding for this?

Thank you Hans. Yes it is a continuous form.
No wonder I was having a hard time.

Yeah, you are right, the grid does remain open.

However, when I close the form the grid also goes away.

Not as clean as the way yours works.

Thank you Hans.

It did not work at first. Then I commented out the 3rd line, RunCommand acCmdClose, and it worked fine.

Thank you, that is a good idea.

Thank you. Now all I have to do is to Format it in Short Date.

Thank you, thank you. Works great!

Thank you for your suggestion. I have implemented your suggestion.

I would now like to be able to click a button and set the field [bolSelect], a Yes/No checkbox field so that all records are set to No (False).

How does one go about doing this? I have attached the database in XP format.

Thank you for your response. If I go into the table MAINTENANCE and change the Qty field value, then the multiple labels print correctly.

However, I want to be able to change the labels quantity for each item selected on the form. Or some other way if you have another idea.

The user is going to require a different count of labels each time for each item selected.

Eureka! It works.

Entering the following – [Enter first date of month] – as the control source for the text box in the report header works.

Thank you.

Thanks for the reply. I have tried permutations of syntax but can not get the code to work.

By the way, thanks Hans for the formatting. How do you do it, insert a table?

Edited by HansV to present info in table format.

Goal: Create report giving a monthly calendar with the report header containing the seven days of the week and the month/year.

rptMonthlyCalendar3
The report works for the date 1/1/06 because January 1, 2006 begins on Sunday.
However since other months do not start on Sunday the MonthYear is missing from them.
I could use a text box with the source as [Enter Month Name and Year], but I do not want to include this extra step.

I need code to progress through each record until the field MonthYear is not null and the result is put into the header text box.

qryCreateCalendar
PARAMETERS [Enter first date of month] DateTime;
SELECT tblNos.Nos, IIf(Month([Enter first date of month]+[Nos]-Weekday([Enter first date of month]))=Month([Enter first date of month]),[Enter first date of month]+[Nos]-Weekday([Enter first date of month]),Null) AS CalendarDay, Day([CalendarDay]) AS DayOfMonth, [CalendarDay] AS MonthYear
FROM tblNos
ORDER BY tblNos.Nos;

Results of Query

Nos	CalendarDay	DayOfMonth	WeekdayName	MonthYear
1

Good idea! I am in a class this morning, Thursday, and will try this afternoon and get back to you.

Sorry for not responding quicker. My browser was not working well. I kept getting kicked out when I posted a response and the response time was very poor with timeouts occurring frequently.

Pasting into Word 97 or 2002 was done as a graphic.

I also went back to my Access 97 / Excel 97 application and it is now pasting as a graphic.
If I open the database with the shift key, run the query, and select / copy the records and then paste, the paste is done as text.

I suspect that using the command “DoCmd.RunCommand acCmdSelectAllRecords” is behaving differently since the installation of Office 2002.

If I find a solution I will post it.

Pasting, deleting, and pasting again results in a graphic being pasted.

The office clipboard contains the graphic.

Is there a way that I can paste the Windows clipboard?