Search results

How does one report spaming on this Forum?

I use the following line and it will start an email message even when outlook is not open. DoCmd.SendObject acSendNoObject, "", "", Me.EMAIL, "", "", Me.sub, Me.Text23

I would like to add a little more to this post. This is a great way to zip contents. I use this with Ghudson browsing example to gather the folder contents. I gather the contents of the folder and record the links in a table called "holdtable". It will drop the zip contents in a folder called...

make a replica of the db.

This is what you need: http://www.access-programmers.co.uk/forums/showthread.php?t=103286 it works great

use an if then statement: if yourcontrolname = value then msgbox ("already booked") else end if

G - what about your browse example? I use the dOpenfile module from that example. Works great. Bones

right click on the control>properties, click the event tap, scroll down to the "on click", from the drop down selection, choose event procedure

try this... in your row sourse for the list box SELECT tblPeopleInsurances.PersonID, tblPeopleInsurances.InsuranceName, tblPeopleInsurances.[Policy#], tblPeopleInsurances.[Group#] FROM tblPeopleInsurances WHERE (((tblPeopleInsurances.PersonID)=[Forms]![frmPeople]![txtPersonID]));

The best way to do this is just have an edit page for them to update there info.

try this.... http://www.access-programmers.co.uk/forums/showthread.php?t=100246

Have you tried using the Form Wizard?

This requires no VBA, just a table, Query with *like criteria and a form... good luck

try here http://www.vbaexpress.com/forum/showthread.php?t=7355&highlight=export+table+excel

Have you tried Office Automation?

Try downloading MZtools. Its a freeware VBA addon. Its has an error handler that really is good.

Try Here: http://www.access-programmers.co.uk/forums/showthread.php?t=100246

try this http://support.microsoft.com/?kbid=210100

Maybe set their security warnings to LOW.....

Its possible. This is how I do it: In the folder where my database is I have a folder called "files". The user can attach an infinite number of files to each record. They can either open them with activeX control or just open them. The database doesnt store the file (this will bloat your DB)...