Search results

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

I have a macro which runs many different queries to group and sum data. After this process is done, it should produce 12 different tables with only 1 record in each table. But there are times where there is no data to add records to a particular table. Each of these 12 tables need to be...

Thanks Pat, for the extensive listing of books. Now which book do I begin with? In your opinion, do you need to know the VBA Code to master Access? Or is is best to now the SQL language to get out of the box, in order to do more. I would probably consider myself as intermediate. I know how...

I am looking to expand out of the Access Capsule(Template). Does anyone have any advice on good reference books for SQL Code and VBA Code for the Beginner to the Intermediate. Or possibly any good sites for On-Line training?

I have figured out the problem......why I get 0 records. On 1 of my tables is has 0 records ...... so obviously it doesn't load the new table with any fields. Possibly I need to put a criteria in each cell "If not Null" ??????

I have created 4 different tables from multiple calculating queries and forms in order to produce a final field to be placed on a report. I know reports can only have 1 record source table. ( DLookUp doesn't work efficient enough for what I need). I am trying to consolidate these 4 tables...