Search results

Thanks so much !!

Hi , If i have an input date, is it possible to derive the first day of teh year from it ? e.g INPUT START_DATE 1/3/2002 1/1/2002 2/6/1999 1/1/1999 4/16/2001 1/1/2001 I tried date value , but it gives me only for the current year...

Done! Hi , I used a script on my harddisk with FTP commands. it's simple and works reliably. ************************************************* Function FTPUpload() On Error GoTo Err Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("c:\FTPXfer.txt", True)...

Hi John, I cannot provide the ftp server details. Those are dummy values i typed in. sorry about that. I created an import spec as u suggested and tried importing the file instead of exporting. I get the same error. I can export and import my file on local disk with or without the specs and...

FTP export error I've spent all day trying to do export a query from my MS access database to an FTP server using a macro with TransferText. I get this error saying "Microsoft Jet Database could not find the object 'ftp://UserName:assword@abc.com/../dir1/dir2/dir3/Data/' .Make sure the...

Hi , I have a MS access db with linked ORACLE tables. I used the ORACLE passwd when i linked the tables. Instead of relinking all tables , can i link automatically with ORACLE via code/ autoexec macro , when i open the database ? Would appreciate any help. Thanks, Gina.

Hi, I have a table with fields ID, Summary. The summary field is an Embedded Excel spreadsheet. Is there a way to access specific ranges in the Excel sheet, and read /write to it ? eg. I want to change the cell A1 in the embedded spreadsheet from "Value" to "Last Reviewed" Appreciate any...

I'm sorry , I couldn't get this myself .

u need to change the SMTP server address to your SMTP server IP . and also change the email id. apart from that , there are no changes. don't forget to put in the refrences mentioned. Gina

Well i didn't modify any code , 'cept for the email id . Besides i just need a simple send mail code, dunno if that's what you are lookign for. Just copied and pasted the code by Russell Grice, Page 1 of this post with subject "Finally got it working"...

Hi Bragg, Thanks a lot for you help and patience. Dunno what I'd do without people like you and this forum :) I did find another solution to my problem and it is very good, got rid of everything that was bothering me ! Though I'm not quite sure how it works ...

Hi , Assuming i understood your question correctly , the following may work :) select traitid, trait1 as Trait from Individual union select traitid, trait2 from Individual union select traitid, trait3 from Individual Good Luck. Gina.

I OWE U !!! I've been hunting for 1 whole week.. tried everything i cld possibly think of!! Even contemplated win Socket programming !!! and here it was , all the while , the simplest of all solutions !!! Thanks a lot!! Dunno what i'd do without this forum!!! Gina!

Thanks Bragg .. I have tried everything. It works perfectly fine on my machine, the moment i run the very same application through Citrix, I get prompted for user/pass 'Am kind of at a dead end. would really be grateful for any help from anyone right now ! I was thinking of some way to write...

Hi , Thanks so much for your patience ... I've tried the following steps with other users , and get the same results: 1. Login to Outlook on local Machine with user name password and domain 2. Login to Citrix with NT user and password 3. Application uses EmailSend code (instead of...

Hi Bragg , Sorry to bother you again, But it seems that you have a setup very similar to mine and I'm kinda stuck .. I tried sending email using EmailSend on Citrix, but I still get prompted to create a profile, it does not use my outlook pfrofile which is already open on my machine .. Also...

Hi Bragg, I made the change from SendObject to EmailSend in the copy of the database on my machine and ran it from there. That's when i get this error . I'll try it through Citrix . Thanks for your help ! Gina.

Hi , I get an message alerting me that "A program is trying to access my address book " I've attached the screen print in this post. I don't get this message if i use SendObject. I'm still runnign this on my local machine and not through citrix. Please have a look if you can ? Thanks a lot...

Hi C Bragg!! I have exactly the same setup , i think. MS Access 2000 Database & MS Access 2000 front End on the Citrix Server. The email piece in the Access application currently uses SendObject . When users login through citrix and try to send email through the application , it asks...

Hi , Thanks so much . It worked with the references added ! Actually I'd hoped that using this method instead of sendobject would eliminate the need for user name and password entry. But it doesn't. Is there anyway to communicate directly with the SMTP to send an email ? So that when users...