Search results for query: *

Thanks for everyone's time and help. I had both ActiveX Data Objects and DAO checked in Tools->References section. And the problem went away after I unchecked the ActiveX Data Objects box. So now I am only using the DAO. Everyone have a great day and thanks again for all the suggestions!

I am still having trouble with this problem... : ( yes my table names are the same as it was in the code. Set rec = db.OpenRecordset("test") Anymore suggestions please?

Sorry I meant The original data is in "Test" table.

Yes "test" is the table name. And also as TempTable. The original data is in table table. I needed to format the yymmdd and get update into TempTable (with yy/mm/dd). I don't have problem with putting the slashes in yymmdd cuz I tried the same code in query and it worked. I just...

I am getting a "type mismatch" error 13 after "Set rec = db.OpenRecordset("test")" code. The rec = nothing, when i hit the debug button. Does this have to do with my table? however, both my table are all text values though. Thanks for the help!

I am trying to format a column from "test" to "TempTable" table. In test, the data is yymmdd. I need to format this data into yy/mm/dd (including slashes) and copy to the new TempTable. I have a command button which you would be able to populate when you click on it...

Hi, I hope anyone can help me with my issue. I have a column in a table that has yymmdd in it as text, however, access does not allow me to format from text to date if it does not have slashes between the yy, mm, and dd. How can I go about to code something that would populate slashes between...

HI! I have a small visual basic 6 program that parses data. Currently, my drive is hardcoded with the drive letter and path (Ex. Private Const DIRDRIVE = "J:\" and Private Const BACKUPDIR = "J:\Application Support\Process\Backup"). This however, causes a problem because the...

Hi CCLINT, Thank you for your response. However I am still a novice when comes to programming, is it possible if you can show me what you told me with the code? I tried to read the length with LOF, however I think I am getting the entire data length which is 1270 characters. Since the file...

Hi, Please help!!!! I am trying to read in the original file with a big chunk of data (& a carriage return at the end of the last line) and write to the second file with carriage return at the end of each line. However, I am getting this Error 62, Input past the end of file. My question is...

Hi, I have been looking everywhere for this solution, however, have not been finding any. Most people want to exclude weekends and holidays. Unfortunately, our system already does that, but I need to include holiday and weekends as a regular non-holiday week day. How would I be able to do...

Mr.Kaiser, Right now, the system is excluding holidays and weekends, however I want to reverse that, which counts holidays and weekends as regular week day. The code for regular holiday week day is working for me right now, but I am still trying to figure out the part that will reverse...

I finally found it...it's in this zip file! http://support.crystaldecisions.com/communityCS/FilesAndUpdates/businessdays.zip.asp

i am looking for cruflwdays.dll so i can use the wdayclass1wdnumworkdays function. anyone know where i can find this dll? i tried to search on yahoo.com as well, but no luck?! Please help! thanks a lot.

Mr. KaiserIII, I am confused now... I DON'T WANT the data to show, only if the difference between Start and End date is equal to 1. (an overnite weekday trade). if it falls on the weekend, we will include the weekend as weekdays, and still count each day as a weekday. and same for the...

What if I have to INCLUDE the holidays or weekends but exclude the weekdays?! Does anyone have sample code that I can reference to? Thank you so much....

Thank you - RobertKaiserIII (Programmer) !!! Your code worked like a charm! I guess the code that I have somehow has a mysterious bug in it. : )

I have tried everything and still not working. I am really stuck. Can anyone help me please? Thank you so much! I have a report right now that returns all data that counts weekend and holiday as a weekday. So therefore, I am adding the code (below) that maturity minus(-) settlement date...

Hallo. HELP!!!! I have an intranet application and I want to open a new window that will lead the users to an exteral website. However I keep getting File DownLoad dialog box when trying click on the link that will open the window!! AHHHH. Here is my code. Please let me know what am I...

Hi. I am really stuck with an issue. I am trying to insert date from an orginal table to another table within the same database. However, with the INSERT INTO SQL statements that I have is not giving the correct data from the orginal table. Both orignal table and the new table have text...