Recent content by Jim Specht

So I suppose that the quickest way around this situation would be to just continue using the existing import spec but use the Transfertext function instead of the built in wizard. I'm sure this will resolve the issue.....I'll just need to incorporate the common dialog control to allow the...

Thx for the advise cpod.....I loaded the Jet 4.0 Service Pack 6, as I have a Windows 2K machine, and found that the problem still exists. If you have a moment, link a table up from another access db and then run through the import wizard as if you were going to import a *.txt or *.csv file to...

I have a DB which I recently converted to Access 2k from 97. Everything works except for one thing. When I attempt to import a *.CSV file, *.txt, etc. .....on the 3rd screen of the import wizard in the "in an existing table" combo box, it only shows me unlinked tables.....no linked tables...

Well...never mind on my issue...I just wasn't creating my string correctly. Both of you might find this send method as easy and more effective then the sendobject. You have to make sure that you have the MAPI activeX control (MSMAPI32.ocx) registered and added into your VB references...but...

I'm all of the sudden having a somewhat simular problem but I'm using a different method to create the email. The error I keep getting is "Object Required". Don't understand why this is happening. Worked fine up until a few weeks ago. Makes me think that I don't have the MAPI activeX control...

Yes it does...Thank you for your time....I understand it now. js

Thank you. It worked perfectly. I'm confused now though...my logic says that the required argument <<Result>> is missing... ie. "If IsNull(x) then <<Result>>" Why does your suggestion work if there is no specific <<Result>> specified??? I had tried something simular to this...

I am trying to create a custom function (which have need for often) in a Module. The function takes a date,(x), and returns the Fiscal year value. It works fine in a query where all values of the recordset are not null....but if just one record value is null, it returns an "Invalid use of Null...