Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Eupher
-
Clicking a button to e-mail
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...- Eupher
- Post #4
- Forum: Microsoft: Access Forms
-
Limit Unbound Text Box Length
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 =...- Eupher
- Post #3
- Forum: Microsoft: Access Forms
-
Access questions?
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...- Eupher
- Post #2
- Forum: Microsoft: Access Forms
-
Access and Groupwise Part Duex: The need for speed!
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...- Eupher
- Post #17
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access and Groupwise Part Duex: The need for speed!
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.- Eupher
- Post #16
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access and Groupwise Part Duex: The need for speed!
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...- Eupher
- Post #15
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access and Groupwise Part Duex: The need for speed!
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 =...- Eupher
- Post #12
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access and Groupwise Part Duex: The need for speed!
Hi, Tarnish, Never worked with it, but you might take a look at the .Find() method of the AddressBookEntries collection. Ken S.- Eupher
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Create table dynamically from recordset
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...- Eupher
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Set "dialogue" mode after form opens with some code
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...- Eupher
- Post #5
- Forum: Microsoft: Access Forms
-
Set "dialogue" mode after form opens with some code
What changes are you making to your form in code that cannot be done when the form is opened in dialog mode? Ken S.- Eupher
- Post #2
- Forum: Microsoft: Access Forms
-
Record displaying dimensions
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...- Eupher
- Post #5
- Forum: Microsoft: Access Forms
-
User-friendly popup selection form doesn't fire main dirty event
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.- Eupher
- Post #10
- Forum: Microsoft: Access Forms
-
User-friendly popup selection form doesn't fire main dirty event
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...- Eupher
- Post #8
- Forum: Microsoft: Access Forms
-
User-friendly popup selection form doesn't fire main dirty event
Hiya, T, Really? Me.Dirty = True wouldn't trigger the OnDirty code? Hmmm... Likewise, good to see you too! Ken S.- Eupher
- Post #6
- Forum: Microsoft: Access Forms
