Search results

OnFormat event works as expected thanks again to everyone for your help

I do not see the onFormat event anywhere

using a macro

If WorkGroup = "control" Then controlpm.Visible = True End If

Hello, I have a report that is emailed out. For the report itself i have a onload event which will display information depending on the workgroup the report is for. This works fine when viewing the report but when i send the email it does not assuming it's because the onload event is not...

it all works now thanks so much for your help

oh my it was a spelling error #$#!@

yes query shows all numerical values in the days remaining field

when i look at the report the days remaining are right aligned I think that is what you are asking. So yes, it is numerical value as it matches all the other numerical fields are right aligned text fields in the report are left aligned

when i go to pick a control source in the report it is left aligned as well

The record source is a querie that has two tables one that holds the days remaining data type just shows as calculated. on the report property sheet is shows the days remaining as format general number. Sorry not really sure if im looking at the right place you are speaking about but from...

the calculated days remaining is from a SharePoint list. when i run the command without the sort i pull 4 items. all with the days remaining fields populated

made the changes plog suggessted still doesnt sort, i get a pop up window asking for days remaining value

days remaining is a calculated field based on 2 dates

Hello, I have a report i call to open but i would like to to only show items that are <= a numerical value that is entered before the form loads. Im trying to sort the days remaining field on the report by the value of the dtotext field. Ive tried various things, but nothing seems to work I...

Yes Sir thanks so much theDBguy had another look realized you removed 2 quotations it works now. Many thanks

Thanks for having me in the form i have done some VBA programming in the past but has been a long time since i touched it have some past experience with Access as well. Overall I'm probably a newb. Been getting buy with you tube videos and this forum so far

When i remove the " before location i now get a syntax error

Hello I'm trying to open a report with 3 where conditions i can get the 1st to work but cannot seem to figure out how to get the second going. I assume once i get the second working the 3rd should be the same This is the line that works with 1 condition DoCmd.OpenReport "melreport"...