Recent content by XB9R

Hi Skip, Thanks a lot - I got it working. This is how I did it: Data > Get External Data > From other sources > From Microsoft Query > Databases tab ... UNTICK the wizard ... Select Excel Files* and drill down to a workbook ... In the Add Tables window, click the OPTIONS button and make...

Hi Skip, Thanks for your reply. Not sure whether I understand you correctly. a) When I use: Data > Get External Data > From other sources > From Microsoft Query > Databases tab ... Select Excel Files* and drill down to a workbook - I get an error that the file doesn't contain a table. I'm...

Hi All, I have exactly the same issue is described in thread707-1650324. Unfortunatly there is no solution given ... My specific case: I want to use data from an excelfile, let's say "Data.xls" and import it in "Master.xls". The data file is refreshed once a day somewhere between 2 and 6 pm...

Thanks for your responses. Some more background: As I told 2 db's, db2 being a copy of db1. db2 transferred to different PC. db2 worked fine until a day ago. Copied db2 back to my PC. the "No current record" stays. So same OS (XP pro), same Access 2003,... I traced the error down to SQL in a...

Hi all, I have a db with a simple query: main table & detail table linked through 1 IDkey - display all records from main table and only the related records from detail table. Output is grouped: IDkey from main table and a Yes/No checkbox from the detail table. The detail table is empty (no...

OK, I need to give more info: ° When the attachment is created 'manualy' it sends fine & opens without any error/remark. ° When sending the same excel-file through VBA I get the above error. I would like to think that a missing/incorrect registry entry would also affect the manual approach...

Sorry, i've been away for a while. Now I'm back. The file is still tagged as .xls. On opening LN displays a message : This file is not in a recognizable format. You can however select to open the file. The file is then displayed reading something like : –6h3Â. Ä4á@!GÀ
üÿ€Ñx...

No ideas ? Nobody ? Dave

Hi all, I have some VBA code to send a Lotus Notes email from MS Access. The code has the ability to attach a file. Code works fine : it creates & sends the email. There's only one issue: when attaching anything else than an .TXT file the file is unreadable for the mail-recepients. I'm using...

Thx for pointing me to 2 valuable forums - can't remember what made me post in this forum... Well actually the code is in Access (VBA) We're trying to send a Lotus Notes mail with an excel file attached to it. The code works fine when we attach a text file. Attaching any file with a different...

Hi all, I'm using some code to send an Email with an attachement. We are using Lotus Notes 7 and Excel 2003. the code: Call Body.EMBEDOBJECT(1454, "", "C:\MyFile.xls", "") It sends fine, only the file can't be opened by the receiver. Only TXT-files can be opened. Any other extension...

It worked for me with Access ...I got the error After installing the 'Microsoft Office 12.0 Object Library' is available as a reference in Access. ... still it might not work for you ... Dave

I had the same problem with a 2007 access database developed by a co-worker that used some new 2007 reference. I'm still on the 2003 version. I got around the issue by downloading & installing the Microsoft Office 2007 Viewer...

Thank you all for replying. I 'accidently' found the solution: Since there raised a problem with Excel2003 not recognizing a rather basic function as WEEKNUM(), I installed all of the possible addins (goto tools->addins). Solved the problem of the unknown function and also solved this problem...

Thx PHV that works great Dave