Recent content by dmeid

Is there a way to email a report into the body of the email. I have set up a macro to send the object.... but it can only be sent as a file attachment. We have users that view the report through their blackberry's. A blackberry can not open an attachment in an email. So I need to find a way to...

Thanks so Much FoFa. My train of thinking wasn't going in that direction. That will work out great.

Really what I need is the full path of the .tif ...... but if I can not seem to retrieve that, all I need is only the name of the file not the image itself.

I have MANY scanned image (.tif) files in multiple folders based on certain criteria. I need to find a way to import only the names of these (.tif) files into a table or even into an excel spreadsheet. Since they are scanned images you can not do a simple copy / paste. I would appreciate if...

I am looking for a VBScript function calling an RPG Program on the iSeries. Any examples or links to a helpful website would be appreciated.

I am having a problem with a combo box that is the second field within a subform. Every time I enter a new detail record(which is the subform) the combo box auto fills with the first record of my underlying query selection before I even get to the combo box field for entry. I have created many...

I figured it out, you are right. The reason why I can't edit is because of the referential integrity at the database level, because of my key fields, I have a "1" to many relationship. Thanks for your help all.

Actually I Made an error on the order by on my copy and paste. This is the actual one. modest..... I did remove the Order by .....but it still did not do anything. All I can think of is that I have too many tables that I am joining. When I only have 2 left joined tables, I can still have the...

Here is my SQL.... as you can see I am doing to 2 Left Joins. Possibly that makes the recordset not updateable? SELECT tblDetail.*, tblMaster.OnLineDte, tblChecklist.[Permit#] FROM (tblDetail LEFT JOIN tblMaster ON tblDetail.WellID = tblMaster.WellID) LEFT JOIN tblChecklist ON...

I have created a query where it does a left join of a table and a select query. The resulting query returns the correct records, but I am unable to have the option of adding any new records. Many other queries I have created allows the recordset to be updated! Can anyone give a logical...

KSWINTH, I have the same situation that you had...... could you possibly enlighten me on how you solved your problem. Any help would be greatly appreciated. dmeid

Thank you so much........I got it to work !!!

Does anyone know how to create a custom toolbar item ..... that if they select the toolbar button it will display a list of options they can select (such as a list of tables). I know how to display. for example 1 option, but not a drop-down list where the user can select from. Thanks for any...

Thank you soo, much it worked wonderfully!

I am trying to apply security to a FE and a BE Datase, by using a short cut that looks somewhat like this. "C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "X:\YourWorkgroupFile.mdw" "X:\YourFrontendDB.mdb" "C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp...