Search results

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

Wonderful :)

Is this even possible? I have a date entry textbox on my form. I also have a "insert time" textbox aswell. Can I either lock, or make the "insert time" box invisible if the date entered in the first box is after todays date?

Everything is on the ONE form. A combobox acts as criteria for a query. To show the user what is happeneing i have used this query and put it in a sub report. But if the combobox/criteria is altered then the subform/query does not update automatically. Instead i have to manually go to the...

thanks for the reply but i cant get it to work still. my query is named "qryevpb". But the subform that has this as its source is named "child 128". Am i right in thinking that the code should be Me.Child94.Form.Requery And I am putting this code in the after update property if the...

hi this is the reply i have recieved What code have you tried for the requery on the after update of the other? If it is on the main form that the criteria is selected, you would need to use something like Me.YourSubformContainerName.Form.Requery But it doesnt seem to work for me