Use the _AfterUpdate property of the Client Type box to load the appropriate file source of the picture into the picture object control. Then, update the picture object control.
Sub <client_type_control>_AfterUpdate
Dim strPictureFile as String
if me.<client_type_control>.Value = 1 then...
The easiest answer I see is to add an Immediate IF (IIF) to test for Null, substituting zero if True. However, this may put a lot of overhead in your code.
I have an Access DB that needs to log into MSN Chat (4.0), navigate to a room, and parse text from the chat screen. (All text is ASCII - this room does not allow hex characters.)
In response to the text, I will look up info from the database and send back information in the form of chat...
The easiest way to do this is to remove ALL formatting in the text and let Access do it for you:
First, copy and paste the following code into a module and execute it on a COPY of your table.
Then, on the copy, change the format and input mask information to the internal telephone formatting...
The same thing happens to me. I have all fields in a continuous form set up for identical conditional formatting. However, sometimes one of the items will fail to format. If I requery, it works fine. It is not related to which field I click on to "set" the condition (I use a...
Has anyone tried automating Instant Messenger 4.5 from Access VBA? I have the MSMSGS help file, but I have been unable to properly declare and create the object for manipulation. I need to:
(1) Open and signin to IM if it is closed
(2) Get the list of online contacts
(3) Populate a table with...
Has anyone tried automating Instant Messenger 4.5 from Access VBA? I have the MSMSGS help file, but I have been unable to properly declare and create the object for manipulation. I need to:
(1) Open and signin to IM if it is closed
(2) Get the list of online contacts
(3) Populate a table with...
This seems a simple question: I want to conditionally change the fontweight to "Bold"(700) on a control ([txtNick]) when another boolean control ([NickError]) is true, in the detail section of my report. [txtNick] is a calculated string. Numerous variations of the reference to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.