Search results

I put it into the after update event. But when, I researched it further everyone said to put it into the On load event. In any event it's now working thanks again!:)

Should this be in the on load or after update event?

Here is all the code. Now, the combo box is not being populated. Private Sub SoftGiftType_AfterUpdate() Dim strPerson As String Dim strOrg As String strPerson = "Soft;Joint;IHO;IMO;Faculty & Friends" strOrg = "Soft;IHO;IMO;Faculty & Friends" If Nz(DLookup("PersonorOrgan"...

New problem follow-up. This string is being assigned to a combo box row source. When entered using the GUI this string works fine: "Soft";"Joint";"IHO";"IMO";"Faculty & Friends" That is with the double quotes but when I change to single quotes: "'Soft';'Joint';'IHO';'IMO';'Faculty &...

Thanks! theDBguy it's been a long day.

I have code to dynamically assign a string to a Combo Box's Row Source. If, I type it into the Row Source property Sheet it works fine: "Soft";"Joint";"IHO";"IMO";"Faculty & Friends" But here is the vba: Dim strPerson As String Dim strOrg As String strPerson =...

This is what I came up with after asking for help. Please see attachments. As I said the table has two columns. The values for person_or_Org is pre-populated into the table so when you select the combo box the AssociatedString is bought in based on P or O. What is going wrong is that instead of...

Sorry that, I'm dense today. I created a table with two columns first one is Person_or_Org {p, o}, second column AssociatedString {"Soft";"Joint";"IHO";"IMO";"Faculty & Friends", "Soft";"IHO";"IMO";"Faculty & Friends" } Now, how do, I code it so when a row represent a person 'p' that string is...

I want to dynamically select two different 'Value List' based on the value of a column in a table. The values are P for person and O for organization. If the value is P then the Value List should be : ["Soft";"Joint";"IHO";"IMO";"Faculty & Friends"] but if the value is O then the Value List...

Hi Form Masters, I want to convert an existing tabbed form with about six tabs with about 120 data fields into variables that I can save using vba code in a button or simple clear and start over again. The back end is sql server 2008 R2. I want the vba code to be the only way data entry into...

Hi VBA Masters, I have a button with the code DoCmd.OpenReport. This command is in a case statement that print/opens the appropriate report based on some conditions. In any event what, I need help with is code that will run after exiting the report preview. This is the code: DoCmd.GotoRecord...

There is a screen shot and complete description of it in the tread.

Yes, the table only has 0 and 1, I created it for this combo box.

0 = off or Incomplete, 1 = on or Complete, I think this is standard. It is not bound, I have a simple table two columns Description and Complete See attached picture. This is the record source for the combo box. The default value for the back end SQL DB is 0 (zero) Incomplete. So, every row...

There are a total of 114 rows 5 = 1 (Complete) and 109 = 0 Incomplete. Any thoughts on why the default setting does not work? It is set to '0' Incomplete.

Any comments on the second issue?:o

That is correct hence my posting the question. I will try DCount but how is it better than RecordSet Count?:(

Hi Form Masters, I have a label that is not refreshing properly. Here is the code: Me.lblRecCnt.Caption = _ "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount When, I use navigation buttons to move forward or backwards it updates correctly. Here is where the combo box comes in...

Nothing it was just recycled code so, I did not change it.

I found a solution as follows: I created a function: Public Function DecUser() Dim UserC As Boolean UserC = False If GetCurrUser = "RS" Or _ GetCurrUser = "EP" Or _ GetCurrUser = "AR" Or _ GetCurrUser = "TA" Or _ GetCurrUser = "EG" Or _ GetCurrUser = "ML" Or _ GetCurrUser =...