Search results for query: *

Do you need this to be a macro? Or are you able to use a vlookup in column I on Sheet 1? =IF(COUNTBLANK(A1)>0,"",VLOOKUP(A1,Sheet2!$A$1:$I$5,9,FALSE)) gives you the following: Column A Column I Row1 Bill Cleared Row2 Row4 Row4 Row5 Tom Pending

Is this what you're looking for? Dim strDlg As String strDlg = "Select the excel file" varFileName = adhGetExcelDataPath(strDlg) varFileName = the path to the excel file chosen by the user. Hope this helps! Stephanie

Would something like this work for you? SELECT table1 FROM ACCT_HIST a ,ACCT_LIST b WHERE SUBSTR(TRIM(table1), 2, LENGTH(TRIM(table1))-1) = SUBSTR(TRIM(table2), 2, LENGTH(TRIM(table2))-1) Results: table1 09871 09876 02345 09867

Not sure of your specific needs, but this might be what you're looking for: SELECT * FROM table1 WHERE first_name(casespecific) = 'John'; The other option is to set up the column to be casespecific when you initially create the table: CREATE TABLE table1, ( first_name VARCHAR(20)...

I had the same problem. After installing numerous texture/brush styles etc, the load time for Photoshop was huge! I ended up deleting most of the styles -- You can always install them later when you need them. This did the trick and Photoshop now loads normally.

gj0519, Here's one module I use to open a workbook template and then export the results from 3 tables/queries to 3 separate worksheets in the same workbook. I am using Office 97 so some of the actual VBA syntax may be slightly different for you, but hopefully this will give you a start as far...

Hi gj0519, What version of Access are you using? Will you be using an already-saved template or creating a new Excel workbook each time? I use Access 97 and have several modules that I use on a regular basis - all of which will export information to separate worksheets in the same workbook...

Thanks for your help Jo. I'll look into this. Steph

I have the same problem, but we don't use Outlook. Does Anyone know if it's possible to do this using Access 97 and Netscape rather than Outlook? Thanks!

I had this same problem. This is what worked for me: You need to find the setup file "Off97pro.stf" in your Office directory and rename it (This file should still be in your Office directory even if you uninstalled Office). Then try re-installing Office from your CD. Choose the...

Thanks Steve! I will play around with this and give it a try! Stephanie

Does anyone know if it's possible to attach multiple tables/query results etc to an e-mail using SendObject? I have 3 reports I need to send to each recipient and would like to be able to send them all in one shot (one e-mail) through Access rather than having to export the files and then...

Does anyone know if it's possible to attach multiple tables/query results etc. to an e-mail using the SendObject command? I have 3 reports I need to send to each recipient and I would like to be able to send them all in one shot (one e-mail) through Access rather than having to export the file...

Thanks for the good ideas! I have a similar problem, but I need to do this on a Form rather than a report. I tried using the "Can Grow" Property on a text box, but couldn't get it to work. Does anyone know if this will work on a Form?