Search results

Select case statement >>>I tried writing this:<<< If Right(globalregioncode, 2) = "00" Then Select Case globalregioncode Case "1100" Or "1200" Or "1300" Or "1400" Or "1500" DoCmd.ApplyFilter , "[directorcode]=" & globalregioncode End Select End If >>Instead of this:<<< If...

you're telling me!

ok, so now I got it working now. I dunno, it got fixed after I destroyed the control & recreated it again with a wizard. I dunno, but the storm has passed.

Well mine is updating a query, but the funny thing is the values are storing ok, but the control is just not "showing" anything, even if i use a wizard. the closest i have got is getting the "receiver" value to appear in the control but not "system". I'll be honest, this is frustrating

Same error.

Thanks for the reminder but the control now tells me I’m entering an incorrect value in control. Here’s my value list: System;Yes;Receiver;No The field saved to is a yes/no data type with yes/no format but the combo box doesn’t show text in the control for current records, it shows a 0 or a...

Combo box I’m running myself ragged trying to figure out why the value in my combo box is not showing a value in the control. However, selecting a value from the combo box will save to the resultant field, it’s just that the value does not “appear” in the form control. I have two columns in the...

AddNew method Am I correct in understanding that if a user clicks the add new record button on my form, the best way to provide a message box on this single event is through the addNew method? But which event would I place such code, maybe in onCurrent? Recordsets and modifying them is a new...

i came up with this, thanks for your help! Private Sub cmdEmail_Click() Dim intResult As Integer ' yesNoCancel... intResult = MsgBox("You are about to submit this subscription information. Are you sure? (Be sure you're connected to the internet and that Outlook is on.)"...

Msgbox constants A vbYesNoCancel messagebox has a value of 3. But what does this value represent, just that the button was pressed? Because that’s what I’m finding out. I would however like to get my hands on the value that indicates WHICH button was pressed, YES, NO or CANCEL. I thought...

Option group If you have an option group with two option buttons bound to a field with Yes/No data type, with a Yes/No format, would this cause a problem? Because I did this and my form is not allowing me to click a choice in the option group. Please advise.

thank you! it worked!

Force first three characters I have an IRD field 11 char long whose first 3 characters are always R00 followed by 8 digits. But how do I use an input mask to force the 2nd & 3rd characters (the zeros) There’s nothing in help for that. Please advise.

Parameters If you specify a parameter in a query, can an expression in the query refer to the value that was entered? Please advise.

well yes, a cartesian product is what I was going for, let me explain in my limited way. The query I want to make is something that will list all our dealer & tell me $values they’ve spent in 2001 based on a certain payment type, by month. Now, my query that contains the detail records doesn’t...

well, here it is, hope there’s something tweakable in it. SELECT qryProj7.promotionType, qryProj7.Month, qryProj7.RetailerNumber, Sum(NwQry.Results) AS SumOfResults FROM NwQry, qryProj7 WHERE (((qryProj7.promotionType)=[NwQry]![PromotionType]) AND ((qryProj7.Month)=[NwQry]![tempMonth]) AND...

how to speed up query I created a query that takes a LONG time to load 10-15mins & I was looking for some helpful tips on how to possibly make it load faster? Please advise.

haha, I figured it out, one of the fields in my criteria was not being saved in order for the criteria to work.

Dmax I’m using dmax to assign values to a text box each time I add a new record in my form. However, when I goto the next record and add the next info & save it, I notice that the text box is the same as the last record, it is not increasing by one as I specified in my vba. Here’s what the...

Thanks, but I got to it using this way: 'lock record if submitted... If IsNull(Me.DateSentToAccounting) = False Or IsNull(Me.DateSentToJon) = False Then For Each ctl In Me.Controls If ctl.ControlType <> acTabCtl Then If ctl.ControlType <> acPage Then If...