Search results for query: *

Yes this sounds a good idea, let me try and get back to you.. Thanks a lot

Hi CodingNovice, Thanks for the reply but say I am looking for date, time of tokyo. The timeoffset is 9 hours. if I add directly to the hour field it gives figure which is greater than 24 and naturally this dose not change the date field. I am looking for something where we add the offset and...

Hi, is there any way to calculate other date&time like london, tokyo from gmtime? Thanks in advance

Thanks all!

It says Syntax error near print. Also Could you please explain why we have to open sendmail?

HI all, I have written following code.. /usr/lib/sendmail -oi -t <<EOF To: abc@xyz.com Subject: test test EOF But I get this error.. Bareword found where operator expected at aaa.pl line 127, near "/usr/lib" (Missing operator before lib?) syntax error at aaa.pl line 127, near...

Could you please tell me what is it? I cant figure out the problem.. Thanks

I have following code /usr/lib/sendmail -oi -t <<EOF To:=abc@xyz.com; Subject: abc test EOF But I get this weird error Bareword found where operator expected at abc.pl line 124, near "/usr/lib" (Missing operator before lib?) syntax error at abc.pl line 124, near "/usr/lib" In string...

I am little confused about RDC. What is RDC? I go in the application. Click on Add Crystal Report 9. Then select already created .rpt file and thats it..Am I dealing with RDC here?

My application uses existing crystal reports .rpt files. Refreshes data every morning and exports it in pdf format. I want to put this application on another machine where Crystal reports is not installed. It gives error "Run time error '50003'. Load report failed." Is there any work around like...

Hi dave, Thanks for the input but after some further investigation I found out that linking in one of the queries was going wrong. And the report was going blank. Do you have any idea why crystal generates the report so slow..Access runs the same query pretty fast.. Also is there any way to...

I have created a report which heavily uses MS Access queries. The tables on which these queries run are also quite huge. My problem is if I add one more formula that accesses a query result field, it blanks out the whole report whereas I can use the same formula in another report fine. Also...

Hi all, How to put a job on ice in autosys? Thanks

MS Access help Topic "View, refresh, or change the file name and path for linked tables" says "The Linked Table Manager can't refresh links to Microsoft Access tables whose names were changed after they were linked. You must delete the current link, and then link such tables again. " So I...

Hi All, I am newbee to MS Access. I have a table linked to a txt file already. Someone who has created this table has given different column names to it. I want to create a new table with same structure as the previous one linking to a copy of the same txt file. For example Table A is linked...

Hi All, I am using crystal report designer within VB. I have a table in MS-Access which is linked to txt file. I use this table from Crystal report designer and generate a report. However while doing this it gives me error "The text file specification 'T210 Import Specifiation2' dose not exist...

Great, it worked. Thanks

Hi All, I have two string variables StartOfRange and EndOfRange which has valid values (eg "A120" "B233") I want to select range from StartOfRange to EndOfRange How do I do this? Thanks

Thanks PHP, I commented out the On Error Resume code and found out that there was error in connecting to database. I had DAO 3.51 instead of 3.6. When I made necessary changes it worked fine. Thanks a lot

Hi All, I am a new to Excel, VB and using Access for excel through VBA. I am trying to run a query in a VB macro and return the result to the excel sheet. I dont get any compiler error but I dont get any result too.. please help.. Here is the code Public Const DEFAULT_PATH As String =...