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 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 Draknor39

  1. Draknor39

    Listbox items - column delimitator

    You need to add a hyphen to each of your items. Like so. Item = "'" + CStr(rs("id")) + "';'" + CStr(rs("fecha_vencimiento")) + "';'" + rs("descripcion") + "';'" + CStr(FormatPercent(rs("iva"), 2)) + "';'" + CStr(FormatCurrency(rs("importe"), 2)) + "'" Or. list_Test.AddItem...
  2. Draknor39

    How to allow users to use mouse wheel to scroll down long forms???

    I believe I have a very simple solution to your problem. In the form in question place the following code. *NOTE* you must set the "Allow Additions" property of the form to no for this code to work. 'Private form declarations. Can also make this public in a module Private Const WM_VSCROLL =...
  3. Draknor39

    Getting the hwnd of a textbox located in a Tab Control

    I should have been more specific. hwnd is a pointer to the handle of the form. I've been using the above code for sometime in my API Classes that require the value. Whenever I use the code on a control that is embedded in a tab control it returns 0 instead of the expected long value. To...
  4. Draknor39

    Unable to Use Switchboard Manager in a Project (adp)

    I forgot that I added that field to the Switchboard Items Table. Thanks for catching my error Marty and I'm glad it's working for you!
  5. Draknor39

    Getting the hwnd of a textbox located in a Tab Control

    I've used the following line sucessfully to retrieve the hwnd of a form where my control is located. hwnd = ctl.Parent.hwnd However, this line is not working if the control is located within a Tab Control. Does anyone have any ideas on how I can retrieve the hwnd value for instances where the...
  6. Draknor39

    How do send email using addresses in access table

    I'm assuming you know how to query your table for the names. Once you do that all you need to do is loop through each name in the table and execute your Sendmail procedure. Here's the Sendmail procedure I use. It doesn't rely on the clients E-Mail client and just send via SMTP. The only...
  7. Draknor39

    How to Remove Old SMS 2.0 clients

    This is exactly what I wanted to know. Thanks Chris!
  8. Draknor39

    How to Remove Old SMS 2.0 clients

    I recently took the position of Network Admin at my company. My predecessor had previously installed SMS 2.0 and then removed it for some unknown reason. When I took over the job I found most clients to still have the 2.0 clients installed even though the Site Server no longer exists. I went...
  9. Draknor39

    Create MDE: ACCESS2002 stops responding

    I should have been more specific. RoyVidar is correct, /decompile does a few extra things that the standard comact and repair does not. As a general rule if you can not create a MDE or ADE after running Compact and Repair then you should decompile and then Compact and Repair. I've actually...
  10. Draknor39

    List Boxes

    Aye, that is the one I meant. Sorry for the confussion. And thank PHV for pointing out the correct article. Cheers.
  11. Draknor39

    Create MDE: ACCESS2002 stops responding

    You most likely just need to Decompile your database to clean up leftover pieces of code. Then to recompile it. Doing this will also result in a smaller database size. Here's a site that has detailed instructions on how to do this. http://www.granite.ab.ca/access/decompile.htm Hope this helps!
  12. Draknor39

    How to select the first row in a list box with vba and get the value?

    To fix this don't select the item using lst.Selected(0) = True. Instead select it using the ItemData method like this. lst.Value = lst.ItemData(0) Hope this helps!
  13. Draknor39

    Form Becoming Blank

    I've had this occur several times. Every time it occured for me was because the form was bound to a Stored Procedure or a Query and no Records were returned.
  14. Draknor39

    How attach a file...

    Easy place to post files is at www.ripway.com then just place a link to your download site in this forum. Hope this helps.
  15. Draknor39

    VBA Form Question?

    Assuming Form 1 = Master and Form 2 = NewInspectionForm and the key was called MasterKey you could add the following code to Form 1 Private Sub btn_OpenInspectionForm_Click() DoCmd.OpenForm "NewInspectionForm", , , , , , MasterKey.Value End Sub And then add this code to the Form_Open...
See more

Part and Inventory Search

Back
Top