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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. Eupher

    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 =...
  3. Eupher

    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...
  4. Eupher

    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...
  5. Eupher

    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.
  6. Eupher

    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...
  7. Eupher

    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 =...
  8. Eupher

    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.
  9. Eupher

    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...
  10. Eupher

    Set &quot;dialogue&quot; 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...
  11. Eupher

    Set &quot;dialogue&quot; 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.
  12. Eupher

    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...
  13. Eupher

    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.
  14. Eupher

    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...
  15. Eupher

    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.
  16. Eupher

    User-friendly popup selection form doesn't fire main dirty event

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

    Need to create new records on a table based on form

    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.
  18. Eupher

    Need to create new records on a table based on form

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

    VB creates AutoNumber

    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...
  20. Eupher

    Code Window Opens With No Error???

    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.

Part and Inventory Search

Back
Top