Recent content by Draknor39

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

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

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

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!

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

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

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

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

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

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

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!

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!

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.

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.

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