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

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

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

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

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

I am trying to create a report that needs information from many calculating queries. The reason why I do not create one query to do all my calculations is some calculations create another level of calculations based on the previous query do to grouping, summing etc. I was wondering if I could...

I am having a problem with a form. I have created a form, (in order to make changes to a Table) with the control source being a select query and not an actual Table. I created a combo box to search for the record along with the rest of the fields in that record. I search for the record to be...

I am trying to develop a unique key from a make-table query that selects records from user-specified date range. I am trying to extract the last record from the selected date range of meter readings. Some meters may have only 1 record while others may have many readings for the selected date...

What is the best way to place a parameter value specified in a query to be placed on a report based on that query? Thanks..Diane

I am importing a file through ODBC. One of the fields is a numeric field (which is a date). When I bring it into access is comes in as a numeric field, but I need to have it as a Date/Time field for query purposes. When I try to copy/append to a new table which I have the numeric field copy...