Search results

Yup that did it.

Select case using NOT operator I’d appreciate if somebody could comment on the below code. It doesn’t execute for a value that sets the case to true. Instead it exits to the calling procedure. GlobalUserCategory is a string and the calling procedures error handler itdentifies the error as 13 a...

fixed Never mind I fixed the problem, I was setting a combo boxes list index property before adding items to the control, so ofcourse it would error out. I changed the order & it’s working now.

Select case Zero I’m using a select case statement & am using zero as one of the values like so. Select Case glblDirCode Case 1000, 0 Now when this zero case happens, the code does not continue and execute the statements but causes an error...

Filter command bar combo box after it is created Is it possible to apply a filter to a command bar combo box control once it has been created and contains a default set of values that you want to filter further?

Cannot export report with varying textbox back color I created a report where a field’s back color is grey if it fulfills certain criteria. But as I export the report to snapshot or RTF format, the back color is not applied. How might I resolve this so the report may be sent as an email attachment?

No that doesn’t work, same problem it hangs on the NEXT statement when it tries to go to the last control.

how do you manage to format your code? how do you manage to format your code like that?

Loop help I’m running a FOR EACH NEXT loop that examines the controls in my command bar but it fails with a type mismatch because the last one examined has been disabled and I am having difficulty thinking how I can get out of this. Here is the code. For Each ctl In...

Help on command bar I’m trying to execute the below code but get a type mismatch on one of the first statements, SELECT CASE COMMANDBARS("FILTER MENU").CONTROLS, I’d appreciate any thoughts, I changed the DIM statement so that CTL was a CommandBarControl and...

Well basically my menu bar has grouping based on the logon user…coordinator, manager, director and other user. Now whenever the first three groups try to access a report, the report(s) will open as will the command bar I am having difficulty with. This command bar will allow the report to be...

Command bar combo box will not clear When I select an item from my command bar combo box I designed, I cannot then delete the value in that combo box and set it’s value to null, it will repeatedly save the last value that was in it. Could someone tell me why this could be happening?

Adding columns to command bar combo box I cannot find any way to add a column to a command bar combo box I made the way you can when you’re in form design view. I use the selection made in the combo to help build my SQL statements. But a string description in this control won’t suffice, I need...

Thanks, my On Error GoTo errorHandler wasn’t at the start of my procedure but right before the errorHandler label! Now it works!

Error handler Set qd = db.CreateQueryDef("qryDtlMgrMth" & i, "SELECT tblPromotionType.promotionType, Manager.Code, Manager.DirectorCode, tblYear.Year, tblMonth.Month, tblMonth.MonthName, Manager.ManagerName FROM Manager, tblMonth, tblPromotionType, tblYear GROUP BY...

Procedure data type John Viescas book RUNNING MICROSOFT ACCESS 2000 has a naming convention chart for data types & mentions “prc” for a procedure data type. Could someone explain what a procedure data type is & where it might be used? I gather he maybe means using “prc” as the prefex that starts...

This works... SELECT Query5.promotionType, Query5.DirectorCode, Query5.Code, Query5.Year, Query5.Month, Query5.ManagerName FROM Query5 LEFT JOIN NewQuery ON (Query5.Month = NewQuery.tempMonth) AND (Query5.promotionType=NewQuery.PromotionType) AND...

I can design a query where 5 left joins from one query to another will work but won’t let me look at the SQL because of “ambiguous outer joins”. I was trying to recreate this in code unsuccessfully so far, but is it possible? Please advise. I was typing something along these lines that tells...

I get a “Type mismatch in join expression” error when I try to run below SQL: SELECT Query5.promotionType, Query5.DirectorCode, Query5.Code, Query5.tempYear, Query5.Month, Query5.ManagerName, NewQuery.Accrual FROM NewQuery INNER JOIN Query5 ON (NewQuery.tempMonth = Query5.Month) AND...

Renaming attachment & ignored signature I’m using the DoCmd.SendObject to email a text attachment but would like to rename the attachment before it is attached to the email. This is b/c the original name is too technical sounding & only makes sense to me. If I could rename the attachment to...