Search results

GO IT! Thank you all.

I think what I am missing is how to call the public from the private?

What you are saying is I can make a public sub and put all the code written to private subs in there. Correct? If that is the case then how do I activate that after update of the combo box? Currently I goto the properties and assign an event proceedure to the after update and it makes it a...

First, I must apologize I am a novice and may not have all the correct terminology, but I should be able to get my question accross. I have a form with 4 combo boxes (Combo150, Combo170, Combo158 and 160) that are used to filter a sub form, which works fine as long as I filter in order. What I...

Thanks! I tried this and it worked.

I have a form with a subform that filters based on my selections. For example I can select a vendor , a status and task type and my subform shows me my records as I filter. Is there a way I can export what I just filtered to Excel?

Thanks. I was able to resolve by opening a blank DB and importing everything into it. Which after reading your resolution I think was a long way of doing what you said.

I have a DB that I use the date() function in a form as a default value and just Date in the code for comparison of today. This works fine on all my computers. When I tried running the DB on 2 other computers I get an error at start up and all the default dates show as Name? and I get VB...

More and more I have been running into an issue when I put in put a formula in a cell (especially Vlookups) in a cell it just stays as an entry as if the equal sign wasn't there? Any idea as to be what is causing this? My most recent example is below. =VLOOKUP(D2:D79,'[Invoice Hx Macro...

Can't get much simpler than that. It worked thanks!

I am stumped and need some help I have a simple select query used in a combo box to filter what is shown. As shown below. SELECT [Task Type Drop].[Task Type Id], [Task Type Drop].[Task Type], [Task Type Drop].[Task Category], [Task Type Drop].[Task Type Definition] FROM [Task Type Drop] WHERE...

Thank you that worked!

I have a form [Local Delivery History] with a subform [Local Delivery subform] on the main form I have a text an unbound text field [Text20] formated for a date. I want to be able to do an after update filter using this form. I tried Me.[Local Delivery Subform].Form.Filter = "([Ready Date]...

How can I filter a combo box to show only options available in a subform I have filtered? I hope I can make this clear. This is the start of my code: If IsNull(Me.Combo27) Then DoCmd.RunCommand acCmdRemoveFilterSort DoCmd.RunMacro "Local Hx hide Filters", , "" ElseIf Not IsNull(Me.Combo27)...

How can I filter a combo box to show only options available in a subform I have filtered? I hope I can make this clear. This is the start of my code: If IsNull(Me.Combo27) Then DoCmd.RunCommand acCmdRemoveFilterSort DoCmd.RunMacro "Local Hx hide Filters", , "" ElseIf Not IsNull(Me.Combo27)...

That worked. Thanks

I am struggling with a filter I thought would be simple. I have a field called close time and I want a filter that will show a record one hour before the close time?

It worked. I truly appreciate your help, Ken!

I tried doing : Me.[task detail subform].Form.Filter = "[Person Responsible] =" & Me!Combo107 And Me.[task detail subform].Form.Filter = "[status] =1" but I get a type mismatch error. Status is a field I have a look up to. (Example 1 = open)

I currently have code on click to filter a subform based on a combo box and it works great. (see below) Me.[task detail subform].Form.Filter = "[Person Responsible] =" & Me!Combo107 Me.[task detail subform].Form.FilterOn = True The problem is I also need to only show records that have a 1, 2...