Search results

array data types when defining an array meant to store a series of control names what would be the best way to store the names? I’m assuming as a string since an array can’t be defined as a control I’m finding.

well, I’ve modified my code some but am getting an invalid use of property on the assignment of my array index to a control, what am I missing since I’ve defined the array as a control to begin with? I would have liked to have assigned the controls as it appears in my commented out code but am...

Travis, your point 2 is what has been driving me up the wall. point 3, those public vars defined at the start are the ones used in the modules procedures/functions, so i don't have to create the same values for each sub/func in the module.

lockTaxes2 is saying an invalid use of property I’m assigning a string value to an array defined as a controls but I don’t know how else to initialize the index with the NAME of the applicable control.

you're telling me, don't worry i caught it i'll post shortly, lockTaxes2 is acting up since the indexes contain strings and but the array is returned as a control.

array problem I’m trying to use/learn arrays & am using one in a standard code module so that a particular array index can stand in for the name of a string, that is meant to lock out a control on a form. Below code shows declarations and assignment of the of array index in the standard code...

I fixed above so far with this: ***Standard code module:*** Option Compare Database Option Explicit 'assign an array to hold taxes to be locked... Public aryTax(3) As String 'lock taxes on promoPreAapproval/Cpr tab... Public Function lockTaxes(GlobalRegionCode As Variant) 'determine taxes...

array not being recognized I’m calling a function in a standard code module from a forms openEvent, to lock out certain tax fields that are on it, the standard code module has a function that assigns a value to an array. ***Here’s my standard code module:*** Option Compare Database Option...

child/master problem I’m trying to dynamically create the master/child relationship between my forms unbound controls and its subform. I’m trying to issue 2 master fields and 2 child fields in vba code on the afterUpdate event of one of my main forms unbound control. Currently I’m prompted for a...

listbox connection to subform I’m trying to specify a link box as the linkMasterField to my subform. Could someone tell me if below is on the right track b/c it is giving me some problems, essentially listbox value is meant to filter (further) the subform. Below code applies to the list box as...

that's ok, my vba was getting in the way.

I created a list box on my form, but choosing a value in it does not “stick” Once you click an item it does not remain highlighted, it just highlights for a second and then leaves the box looking like it did originally, as though nothing was selected. My list box values are bound to a table &...

subform field shuffle design view of my subform shows a different order of fields versus the datasheet view, how do I have my columns appear in the order I want in datasheet view?

Critique I’m still working on subforms & trying to get them to work, I’ve yet to create a successful one that does exactly what I want. But I thought I’d throw this out & see if it’s possible. I’d like to use an unbound main form with a subform in it to retrieve a specific set of records. I was...

i have no idea what that means

Unmatched query problem I’m using the unmatched query wizard to help find different values between a table and a query. Nothing shows up in my results even though I can easily point to at least 3 records where there’s a non match. The value being matched up against in the query is essentially an...

oh I get it, I didn’t comment out option explicit in the module.

I get a “variable not defined” error when my standard module tries to access a variable defined as public in some other standard module in the same database.

Need to use public value across standard modules I declared a public variable in a standard code module & need to reference this value in another standard module, how can I do that? Possible?

cross tab query in subform possible? A cross tab query has a nice X & Y axis look to it & I’d like to use apply such a “look” to my subform, is this possible? Crosstabs calculate values, whereas I’m looking to have a user enter a record’s info.