Search results

no Steve, I’m not resetting the tags at all, they were meant to simply help identify a group of controls is all.

well I think I figured it out, the disabling procedure is this: For Each ctl In Me.pagePromoPreApproval.Controls If ctl.tag = "tagDealer" Or ctl.tag = "tagVu" Then ctl.Enabled = False End If Next ctl I’m assuming the Controls collection represents the controls as a whole, and not as they...

Frame causing trouble I have an option group frame on my form that disables certain controls based on the frame value. When I hit a certain record though, the locks are applied, but then as you scroll thru the records either way, the same lock applies to all the records, locks that were not...

Well, this works.... Like "[!A-Z]*" thanks though Steve

Need help using LIKE predicate My database has story titles, but some titles are special b/c they don't start with letters, some of them include: 'Blue Eyes' ...And My Fear Is Great I've been trying to specify criteria using the LIKE operator in my query to capture these types, but have...

it works

how to place in a string argument? The last argument in Dlookup ( ) is criteria, a string. How then might I accomplish this? “left(code,2)=" & left(Code,2))

pressing Ctrl C would take you to a control whose label has &C, but when i tried the same thing with a label attached to a button, the code did not "push" the button.

how can you assign shortcut to a button w/a pic on it? If a button has a picture on it rather than text, how could you assign a shortcut key to it?

well, yeah sorry I didn’t mention before, but that’s how my combo’s were setup, the bound column hidden in both controls.

autoExec macro headache I picked up the following code from this site: 'This Code disables the shift key '********************************** Public Sub SetAllowByPassKeyProperty() Dim db As Database Dim prp As Property Set db = CurrentDb Set prp = db.CreateProperty("AllowByPassKey", dbBoolean...

combo list problem I used VBA to hardcode the rowsource of two combo fields, they’re both value lists. When one of my users requested additional codes to their region I inserted the applicable data in both controls. Basically a user selects a code in one combo & the other combo fills...

parameter report upgrade running a parameter report is fine & great but is there someway I can enter several values for one parameter at one time? Or is there someway to restart the report through code with a single action? Right now I’m having to close my parameter report and restart it and...

never mind I fixed it, a choose function in my code was missing october as one of the choices, doh!

curent month not showing up as group my new report works fine in every way but one. The current month, the word October does not print on my report, it is skipped & the following month is printed there. I though it might have to do w/the system date so I flipped my computer date to other months...

formatting dates my report groups by month, but when I place “mmmm” as the format for the month fields it starts out right, January for 1, but the other months appear as December.

never mind, I commented this out next to the button running the report & peace & order was restored to the universe. 'MsgBox err.Description

how to avoid open report action cancelled message box what is a graceful way of avoiding the “the open report action cancelled” window when you cancel a reports open event?

hi Alex, tblMonth has 3 fields & 1 index (auto num) the 3 fields are Month, MonthName, and Type Month is numeric and has 1 to 12 in it, monthName is self explanatory & Type is one of 2 types, OA or BE. This table has 24 records. click this link for a screenshot view...

hi Alex, here’s my query curently. SELECT newQuery.PromotionType, tblMonth.Month, newQuery.RegionalDirectorCode, Sum(newQuery.Results) AS SumOfResults, Sum(newQuery.ActivationForecast) AS SumOfActivationForecast, Sum(newQuery.TotalCommits) AS SumOfTotalCommits, Sum(newQuery.TotalPaid) AS...