Search results

@mdluek: the link you provided is related to autofilter in PowerPivot not sure if it applies the same way in Access. Chris: It might be related to the fact that SQL Server syntax for filtering could be a bit different than Access. Not sure - would have to see the data you are filtering...

Please post your code. You need to pass the full SQL syntax of the pass through query to the ChangePTStatement procedure, including the WHERE statement.

Did you try stepping through your code? Perhaps the event is not firing. If not, you should remove that procedure from the module, exit the database and go back into the form and put the procedure back in.

You can try fully qualifying your parent form in your subform reference. Instead of this: Me!frmNextEvent_sub.Form.RecordSource Use this: Forms!ParentFormName!frmNextEvent_sub.Form.Recordsource =

Is it just not working or do you get an error?

Oops..sorry. the query above is not correct. Here is a revised one: SELECT Date.ClassName, CALENDAR.cdate FROM DATE, CALENDAR WHERE (((ClassName)="NEWHIRE") AND ((Calendar.cdate) Between [DATE].[StartDate] And [DATE].[ENDDate])); NOTE: I would not name your table DATE. This is a...

You need to create another table called Calendar or Years and load every date for each year into it. So you would have a Calendar table with this data in it: cdate 1/1/2013 1/2/2013 1/3/2013 1/4/2013... etc.. for 365 days of the year. Then you just need to create a query: select...

No you still need the pass through query. You need to replace "YourQueryName" with the name of your passthrough query.

Leave p_Queryname as is. This is just the name of the variable/parameter you are passing to the procedure.

You need to modify the pass through query dynamically. Use something like this function in your code: Public Sub ChangePTStatement(p_QueryName As String, p_sql As String) 'for changing pass-through's in this db Dim qdef As dao.QueryDef Set qdef = CurrentDb.QueryDefs(p_QueryName)...

Oops..sorry I read your post a bit more and see it's coming from command button...so do you have any code executing behind the command button?

How are you running this query (executing it)? Are you calling it from a button on your form and executing it through VBA code? Also, what is Print Template? Is this a temporary table or do you have unique records in it - the reason I ask is because I don't see a WHERE statement in your...

Well, what format are you importing from? Excel, csv, etc?

Are your Win 7 machines 64 bit?

I just thought of something else if you don't mind changing the design of your form. Have the user choose the day of the week from a drop down list and store it in your Weekday column. You would lose the pretty format of having the weekdays display across the screen - you would also have to...

Yes. I see. You could accomplish what you want to do in many ways. One way is to have an unbound form with a save button. When the user saves the data you could then check the values of each undbound control for M-F and then programmatically save it back to the table. The problem is when a...

Well, can you post your table structure? The table you are storing the user entries for their goals for each day will have to have a field store the day of the week as well. I'm not sure how your form is set up - you say when a user enters a goal all the other fields are duplicated on the...

It depends on how you are using this form. Is it only for adding new records? or can the user open this form and see existing records also. If this is only a dataentry form then use this code: if me.recordset.recordcount = 0 then if msgbox("You have not entered any records. Are you sure...

no problem. glad that helped! I am a madam. :)

try this - your last outcome field is a text - so you need to enclose your WHERE argument in single quotes: Forms]![Frm_Contact_1]![Complete].Value = DLookup("Complete", "Lookup_Outcomes", "Outcome='" & Last_Outcome & "'")