Search results for query: *

Hiya, PaulMThomas, Sounds like you need to use column notation. Dim strEmail As String strEmail = Me!MyComboBox.Column(X) ...where the text in blue is the name of YOUR combobox control, and the red X is the appropriate column from said combobox. Column notation is zero-based, so the first...

Far be it from me to suggest an alternative to PHV's perspicacious suggestion, but here goes. If you want to just truncate automatically, perhaps this in the AfterUpdate event: If Len(Me!MyField & "") > 80 Then MsgBox "Too much text! Truncating to 80 characters..." Me!MyField =...

gbrataas, Your company is not willing to purchase help desk case tracking software, but they are willing to pay *you* to learn Access from the ground up and design, code, test, and debug your own custom solution? Might be good for you, 'cause ultimately maybe you could add MCDBA certification...

Hiya, Chuck, still there? Any luck with the find() method? For reference, in my little bit of code, the find method searched our entire global address book ( ~ 9,000-10,000 addresses) and returned results within 2-3 seconds. In one of my personal address books ( ~ 70 entries) results were...

p.s. Should have qualified... the keywords above are the valid keywords for the AddressBookEntries object. As with the operands, many others are available for the message object. Ken S.

Heh, well, I think calling me an expert is overstating things a bit, but thanks for the compliment. ;-) Seems the keys to the search string argument are the keywords (i.e. field names) and operands. According to the API, only Name, <First Name>, <Last Name>, <E-Mail Address>, and Department...

Hiya, Chuck, Here's some code which may help you: Public Sub GW_Lookup() Dim oApp As Application2 Dim oAccount As Account3 Dim oBook As AddressBook2 Dim oContact As Address Dim oContacts As Addresses Dim sSyntax As String Dim i As Integer Set oApp = New Application2 Set oAccount =...

Hi, Tarnish, Never worked with it, but you might take a look at the .Find() method of the AddressBookEntries collection. Ken S.

girky, If for some reason jadams0173's suggestion will not work for you, I suggest you will need to: 1) add a new tabledef to your database 2) loop through the fields collection of your recordset object(s) to determine the fields and data types for your temp table 3) append the fields to...

xhonzi, I have used the design view (hidden) method proposed by MajP successfully in the past. As a general rule, though, I try to stay away from that unless absolutely necessary, mainly because design view is not available in an MDE file - so if I want to package my app as an MDE (highly...

What changes are you making to your form in code that cannot be done when the form is opened in dialog mode? Ken S.

drimades, You should have some idea of the upper limit. What is the field size for the field in the form's table? Textboxes on forms are usually designed to handle the maximum desired text; if the field is larger than can practically/aesthetically be handled, then usually the control is...

T, Why not put it in the close event of the datepicker? Or write the old value to a variable in the procedure that opens the datepicker, then refer to it when the datepicker closes. Yes, the Dirty sub requires the Cancel argument, that's why you kept getting the prompt. Ken S.

Hmm... in my little informal test, changing the value of a control in code (via an InputBox) causes the form to become dirty, but doesn't fire the OnDirty event. How's that for a puzzler? And Me.Dirty = True didn't fire the OnDirty event either. However, calling the OnDirty sub DOES trigger...

Hiya, T, Really? Me.Dirty = True wouldn't trigger the OnDirty code? Hmmm... Likewise, good to see you too! Ken S.

Another possibility might be to set the form's Dirty property to true in the same procedure that writes the new values. Ken S.

Assuming Text18, Text16, etc. are all string values, and are all on the current form: SQL = "INSERT INTO answers ( CliniqID, Date, VarID, AnswerOther) " _ & "VALUES ('" & Me.Text18 & "','" & Me.Text16 & "','" & Me.VarID & "','" _ & Me.Combo8 & "','" & Me.Text14 & "');" HTH, Ken S.

mdgarred, Why add all the double quotes to the concatenation? Ken S.

Hi, William, I don't think you got all of my post: Doesn't seem to matter whether it's a saved query or a SQL string - it will raise an error. My suggestion again: By this I mean creating a simple table with only one record. The data in it is irrelevant, as its only purpose is to be open...

alr0, This sometimes happens to me if I save the DB with a breakpoint set. Then, even after removing the breakpoint, it will break until I re-compile and re-save. Ken S.