Search results

I've tried solution 1. it opens report but doesn't pass the filter on, so chart doesn't filter and the report data isn't filtered as well :/ also tried the second option with query and doesn't even open the report run-time error 3075; syntax error (missing operator) in query...

changed button to Private Sub cboAPeffort_Click() Dim strWhere As String Call cmdAPfilter_Click If Me.Dirty Then Me.Dirty = False 'save any edits If Me.FilterOn Then strWhere = Me.Filter Debug.Print strWhere DoCmd.OpenReport "R_APdailyplan2", acViewDesign, , strWhere, acHidden, strWhere...

What exactly do you mean by "place all the code"? I already have SQL in OnLoad event on my report. Could post DB, but will take me few hours to make it internet friendly, so just hope for directions instead :/

Hello again, I probably didn’t specify my problem clear enough? I have a form with a filter, user can apply filter - this works ok. There is a button on the form that opens report and this report print correctly filtered data using strWhere: Private Sub cboAPeffort_Click() Call...

your message is off topic, only need to use # if you use specific date like #24/11/2015# here, date() is a function so don't need to use # I can create a calculated field in report footer, but I can't based chart on it....?

Hello, I have been trying to find a best way to open a report based on form filtered data, with additional chart on it. The form and report works perfectly fine. Then I created second query and added a chart based on this query to the existing report. It does work well but unfortunately I don't...

SUPERB!!!!! Thank you :)

Hello all, I followed this: http://www.fmsinc.com/microsoftaccess/Forms/openargs/index.htm which works perfectly, but When I want to add 3rd value or in the future potentially 4th, I'm struggling with code. Can anyone advice please. This is button command in form: Private Sub...

hmm.... still dont really get it. I noticed when I click on drop down for USER it shows 3 column, of USER AREA and something else.... so no it doesnt work. I started again with my query and made direct relationship between table in that very query. This sorted my problem and all data shows as...

llkhoutx, No this dont work, arnelgp, I made a typing error, so first one works but second one didnt, so I modified it. This works for me. ..... ElseIf cboAPduedate = "Monday" Then DoCmd.OpenReport "R_APdailyplan", acViewPreview, , "tTaskDueDate=date() + 7 - Weekday(Date())+2 " ElseIf...

llkhoutx, php? that wouldnt work...? arnelgp, both give "syntax error, missing operator in query expression"

Yes that's right.

Yes Monday-Sunday. How to do it please, too advanced for me :/

Hello, I have been searching for past 6 hours but can't find my answer. Have an after update event, where depending on selection a report will open and show all records with due date for next Monday, or with due date within next week. here's my vba: Private Sub cboAPduedate_AfterUpdate() If...

Hi Sorry for the delay. Thank you for this, looks like it works. But I dont understand few things: You removed few tables from query Q_task, so how is it possible for it to work in the form F_Tasktracker? Also, in the F_Tasktracker, field Department name and area name have weird source, what...

yep, that worked lovely. Thank You

it didnt work, but when Left joiun first one and right join second one it works. Is that correct?

Hello, I have a table DEFECTS and table USERS in the table Defects is a field called dUserFK which is linked to table Users. I need to make some changes to layout of the database. Until now, we had PERSON REPORTING which is dUserFK, but need to add another field in the same table PERSON...

Any other suggestion please?

Hi, Any luck on this, please?