Recent content by hrov

John that seems way too complicated for me, although it looks similar to what i am looking for: all i want is the code to say If today is a monday then run "macro 1" surely this doesnt need to be too complicated. ( i have changed from the 1st of every month, to every monday as the database...

can someone write me a code to: Print off certain reports on the 1st of every month? E.g. 5 different reports that we can call "report1" "report2" etc for simplicity.

I have a report that may or maynot hold any information based on what date it is. Is there a way to automatically make this report appear if it is holding any data? (For any code lets call the report "report 1".)

Can anyone help? The report is sorted correctly, now i just want to give a nmber 1 to the first 5 rows, a number 2 to the rows 5-10 etc.

I have a report that shows customer name, age, money owed. Now i want to add a check box that is named "payed". When this checkbox is ticked I want the name, age, money owed etc to disappear. Is this possible to do with a report? (note that the money owed data is summed up in the report...

Thank You pbaldy

ok thanks thats sorted. Now what i need for another query's criteria is : To show dates that are one month or less away from todays date.

DateAdd("m",[expires_(months)],[date_achieved]) doesnt work either, i get a box asking for expiresdate (the new field) where the expression is going. I was thinking that it could have something to do with the format being short date?

In my query i have a field that is titled "date_achieved", and another that is titled expires_(months). for example the date_achieved field may hold 01/01/2020. The expires_(months) may hold 24 months. I have made a new field (an expression) that is supposed to give the date of the...

Can anyone help?

Either i dont understand what you mean or i explained myself wrong: I know that i can sort my query (ascending etc) but how do i group it? here is what i want my report to do (if i wanted to group every 5 customers)>> customer A 1 Customer B 1 Customer C 1 Customer D 1 Customer E 1...

I have a fairly simple list in a report of about 80 rows. How can i group these rows? As in the first 10 are in "group 1". The second group are in "group 2" etc.

In my form evrything is working ok. But i have a filter. The toolbar at the bottom of the page is what i am trying to work with. I want the user to use this, but only the search function. Is there a way that i can alter this? I do want search I dont want record navigation or the filter...

thanks for your help again But when the user is faced with a blank form is it possible to hide the "time" text? This would mean that the time text box would only become visble after the date textbox had been filled in and is less than todays date. Private Sub Form_Current() If...

I would but i would have to alter some sensitive data first so would only be prepare to do it if i was very desperate but i have sorted it a different way. Thanks a lot for helping