Search results

the concept is known as an intrinsic constant.

what do we mean by acTextBox in terms of concept & how does access know I’m referring to an active text box, what if don’t want an active text box what if I want an active combo box or active frame or active radio button what term do I use then? Or how do I find out in help what they are called?

Thanks Robert but that didn’t work for me as it told me that ctl didn’t support that object or property so I came up with below, problem is I have more than one tab control and more than one type of control on that tab. If IsNull(Me.DateSentToAccounting) = False Or IsNull(Me.DateSentToJon) =...

Sorry, I meant to say can I get to it thru VBA? B/c it is I who will lock a user from editing a record, not the user doing this on their own by using your method.

For each next loop I typed the following but get the error that “Object doesn’t support this property or method” for statements in my FOR loop. The below is specified in my frmDataEntry’s onCurrent event and ctl was defined as a variable of control type. Please advise. For Each ctl In...

Record Locks property My form has its recordLocks property set to no. I would however like to lock any single record if certain criteria exists. Problem is that the has too many fields to make something like me.SomeControl.Locked = true a good choice. Is there some other, better way to get at...

never mind I think I found the answer, the openQuery method will allow what I want….lemme try it out now…hehe…

Open query in design view I created a form with a combo box and a button. When the combo box chooses an option and the user clicks the button a query will run, this is fine, except for some of the queries I’d liked open in design view is this possible? So far the closest property I could find to...

How to modify a query’s WHERE clause with openQuery I would like to be able to open a query from my form & have query results reflect what it is I entered on the form controls. However, looking at the openQuery method of the doCmd object, I don’t see anyplace where I might change the query’s...

i officially close this thread. many thanks Alex!

ok, I’m really scared now b/c it seems to be working perfectly. This is what I had originally in my button’s onClick event. 'DoCmd.OpenReport "rptSearchByRefNum", acViewPreview, WHERECLAUSE and this is Alexs’: DoCmd.OpenReport "rptSearchByRefNum", acViewPreview, , WHERECLAUSE Are you...

Well I believe I got around the string problem with this: --- strMyWhereClause = "([NewQuery]![PromotionType] = '" & strControl1 & "') AND (" --- Right now for anything I do, I essentially get all records returned. Another point is that in debug mode I check out the value of WHERECLAUSE & it...

Thanks for the code Alex still not working though. I get prompted for 3 query parms when I run report, for TYPE, OA, & REGION. The second parm I don’t understand, I think it’s referring to the drop down on the main form. And when I fill these parms I’ll get events for all REGIONS regardless...

hehe…you’re a saint if I ever met one Alex….hehe… like I said I described my form above in my last response… the form also has a button that will run a report… the report is based upon a query…. 1.User clicks main form drop down and chooses type OA or BE (for the type of output records to be...

Works yes and no. Currently if I enter 1 pair of controls, I get results for all 5 regions rather than just the one I selected. My filtering is like so for the report that is output.. -By type (main form control) -By region (tab control combo box – 5 pairs) -By event (tab control text box – 5...

Well it sort of goes back to my original problem b/c my WHERE clause will need to include values that may or may not exist in 5 text boxes. My report currently has a macro run on its onOpen to do an applyFilter by record type. Now I added 5 more filters in it like so to account for values in...

I just posted the problem in FORMS forum just now title is "Numerous entries in one text box"

Numerous entries in one text box Hi I can’t find my previous post regarding this so am forced to ask again. I have a text box. I want to enter several numbers in it like so 1,2,3,4,5…. How can I do this so that when the query runs it looks at this control, figures out what the values are &...

thanks very much Alex, sometimes the forums advice sticks in my head & sometimes not, in this case it did your explanation was great, wonderful! The form is apparently running fine now with all the right results. Now only one further request if possible. Imagine this: A form with a single...

hi Alexandre, happy new year to you too hope all is well w/you. I currently am using a macro on the reports onOpen event to set to applyFilter actions, whose WHERE clause are respectively: [Reports]![rptSearchByRefNum]![PromotionType]=[Forms]![frmTest]![cboType] AND…...