Search results

OnOpen filter question I specified the below in my reports onOpen event & yet I get the error I “entered an expression that has no value” the WHERE condition of the applyFilter property is sending something to the left side of the = sign though. DoCmd.ApplyFilter ...

Control referencing in vba I’d like to be able to do something like this in code, where I write Me.cboRegion(I) where I=0 and thus me.cboRegion(I) will be me.cboRegion0 I currently wrote something like this but it is failing with a “method/data member error not found error” If...

I designed a report & its recordsource is a query, criteria for the query is set to controls on a form which runs the report. I can’t enter all the criteria I’d like to b/c of the error message I previously mentioned in my first post.

Is an SQL statement limited to 256 char or something b/c when I try to add another control as a query’s criteria source I get a message that “The string returned by the builder is too long. The result will be truncated.”

my date is stored in mm/dd/yy format but when I format your code to this: DoCmd.ApplyFilter, DatePart("yy",[MediaStartDate]) = “02” I get an error message about an invalid procedure call or argument.

Your code will allow originally filtered records to remain onscreen rather than going to a new record like mine did. Basically not worrking. A note that my records are initially filtered in vba code before I start trying to replace it with my new filter.

Filter question Here’s my code: Private Sub cmd2002_Click() 'remove filter.. DoCmd.ShowAllRecords 'add filter.. DoCmd.ApplyFilter , Right(Me![MediaStartDate], 1) = 2 End Sub It appears in my form & is meant to remove the form’s filter & then apply a filter that will return...

well I realized one thing. My relationships aren’t set up for the subform table…!

Subform records missing an index I dropped a subform onto my form and can successfully add records to it however the foreign key linking the subform & mainform is not saving when the subform record is entered. Thus I can enter subform records but cannot go back & see them entered against the...

thanks! it worked

Subform refuses to come up as datasheet view I have a button that activates a subform but whenever the subform pops up it’s never in datasheet view although in its property sheet I specified the default view & views allowed property to be datasheet, why?

OR expression help I setup a query to receive multiple criteria against at least one of 3 fields. My criteria are the name of controls on a form, 3 controls total. I specified different combinations of my criteria (controls) in the query grid, 7 rows total. In 3 rows, I specified a...

Parameter optional? If I set up a query with some of its fields criteria set equal to a form, how can I tell the query that the form is optional (or in other words, that the parameter is optional)

Instr function question I picked up the below to help me run a query that would allow me to enter more than one value for a parameter. InStr([Event number separated by commas],[EventNumber]) the query also has a criteria that it should be greater than zero. When I run this query though, the...

Enter last field info I’m doing some data entry & am finding from time to time that on the current record I’d like to enter into a field the last value I typed in the prior record. How can I accomplish this?

How to capture value in module I have a value sitting in a standard code module I’d like my macro to access, what’s the best way to do that?

Module scope I’m finding that I am writing some standard code modules and then forgetting to discard them if they don’t work out. How can I find the references to those modules by the other database objects so that I don’t accidentally delete something that is actually used by some other object.

oh a2k I see well no good for me then.

Travis I don’t find any help in access97 for Split, where do I look to find it?

count problem I have a processedActivation table with text field that has a letter of the alphabet in it. I’d like to create 2 fields in my query, one that will tell me how many records contain “A” and another field that will tell me how many fields don’t contain “A”. What functions ought I be...