Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tincan56

    Please help with my code - adding slashes in yymmdd

    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!
  2. tincan56

    Please help with my code - adding slashes in yymmdd

    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?
  3. tincan56

    Please help with my code - adding slashes in yymmdd

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

    Please help with my code - adding slashes in yymmdd

    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...
  5. tincan56

    Please help with my code - adding slashes in yymmdd

    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!
  6. tincan56

    Please help with my code - adding slashes in yymmdd

    ...this issue? I tried and tried but couldn't re-solve it, so I need some help... Both tables have all "text" fields. Thanks so much! ************************************************ Public Sub Command0_Click() Dim db As Database Dim rec As Recordset Dim...
  7. tincan56

    format from yymmdd to yy/mm/dd in a table

    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...
  8. tincan56

    How to dynamically replaced the hardcoded drive letter/path?

    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...
  9. tincan56

    Error 62, Input past the end of file

    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...
  10. tincan56

    Error 62, Input past the end of 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...
  11. tincan56

    Reverse NOT counting weekends and holidays for a date range

    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...
  12. tincan56

    My code for calculate exclusion of weekend & holiday is not working?!

    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...
  13. tincan56

    where i can find cruflwdays.dll? i tried at seagate.com, no luck.

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

    where i can find cruflwdays.dll? i tried at seagate.com, no luck.

    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.
  15. tincan56

    My code for calculate exclusion of weekend & holiday is not working?!

    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...
  16. tincan56

    My code for calculate exclusion of weekend & holiday is not working?!

    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....
  17. tincan56

    My code for calculate exclusion of weekend & holiday is not working?!

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

    My code for calculate exclusion of weekend & holiday is not working?!

    ...date is 7/5/02. And since 7/4/02 is a holiday I dont' want to see all records with 1 day of working day (maturity - settle) in the report. **************************************************** DateVar Array PubHols:=[Date(2002,07,04)]; NumberVar StartDay:= DayOfWeek({transrpt.settle_dt})...
  19. tincan56

    HELP with window.open, I keep getting Filedown load dialog box!

    ...on the link that will open the window!! AHHHH. Here is my code. Please let me know what am I doing wrong? I really appreciated for your help! ******************************************** function myVoid() { } function openWin(){ windowHandle =...
  20. tincan56

    INSERT INTO statement (data not showing correctly)

    ...data from the orginal table. Both orignal table and the new table have text field. I would really appreciate for any suggestions and help! **************Here is the VBA/SQL code. Dim db As Database Dim rec As Recordset Dim strSQL As String Dim dtBillingStart, dtBillingEnd As Date Dim i...

Part and Inventory Search

Back
Top