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. krzysrb

    Worksheets.Add Problem

    VBAva, You were more than right my friend, it certainly does what it is supposed to, and I have no idea why it behaved so ugly last night. Thank you for your help. I was doubting between two ways of how to battle the 'same name sheet' error, and one of the ways to solve it is yours, and a...
  2. krzysrb

    Worksheets.Add Problem

    Hey guys, I am running this code in my app to insert another worksheet into workbook: Set ExcelWS = ExcelWB.worksheets.Add ExcelWS.Name = "Created on " & Format(Now, "MMM-d") & " at " & Format(Now, "H-mm") The name part is supposed to give it somewhat...
  3. krzysrb

    From an 2-D array into file

    KaySyd, a * for you for help. I got it working, it runs well. The only thing though, you said it works with XP, but for me it works only with Excel 97. However, it works. The next question that I have is about the spreadsheet and workbook. Would I be able to create them on fly, rather than...
  4. krzysrb

    From an 2-D array into file

    johnwm, I had made a progress, learned about Put statement, and I have done this to my array: Open ExpPath For Random As #1 For i = 1 To 7 For j = 1 To 30 Put #1, , Schedule(i, j) Next j Next i Close #1 I am not sure if I used comma or pipe seperation, nor if this what I have is...
  5. krzysrb

    From an 2-D array into file

    Hello guys, Does any of you know any good tutorials or any samples where I can learn how to put a 2-dimensional array into a .txt file. Originally, I intended to put the array into .xls[Excel] file, but some friends of mine told me it is not possible. Do you know of any good references where...
  6. krzysrb

    in need of advice

    hope it went this time :o) thanks for letting me know CCLINT vlada
  7. krzysrb

    in need of advice

    Thanks a lot BlackburnKL, Your advice just crystalized what I had originally intented to do, and for that * goes to you. Thanks a lot again, and I am already making a progress to get it all done and working. vlada
  8. krzysrb

    SQL for ADO Control

    CCLINT, There is no problems with assigning the SQL statement prior to the WITH section no more, I just moved the statement two lines up, and recompiled it, and it works. Thanks again CCLINT vlada
  9. krzysrb

    SQL for ADO Control

    ...= "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & mdbPATH .RecordSource = "SELECT * FROM times WHERE [Student Number] = " & CLng(txtAddID.Text) & " ORDER BY Switch([Day]=...
  10. krzysrb

    SQL for ADO Control

    ....Refresh End With the above runs just fine. but if I want the recordsource to be some SQL statement, like: rsSQL = "SELECT * FROM times" rsSQL = rsSQL & " WHERE [Student Number] = " & CLng(txtAddID.Text) rsSQL = rsSQL & " ORDER BY Switch([Day]=...
  11. krzysrb

    another combobox problem

    johnwm, thanks again buddy. i switched over to ADO, and it runs perfect. * for you man. thanks a lot all vlada
  12. krzysrb

    another combobox problem

    johnwm, i tried changing the DataFormat property, but it wouldnt let me do it at all. the error that i get is that 'the data format property is not supported for this data source'. My combo connects to the DB table via Data control. I dont know if that has anything to do with it, but i am...
  13. krzysrb

    another combobox problem

    hey Dashley, that will format the time, but the problem i got is that the combo box adds the two zeros when i recall a record from the DB, as i said, even if it is something like 10:00, the combo box shows 10:00:00. i tried using something similar to this, but it aint working. any other...
  14. krzysrb

    another combobox problem

    hey all, in my program i have combo boxes linked to the table in the DB. When i allow a user to update the values in time field which i have stored as a date/time in "hh:mm" format (24hr clock), instead of displaying 10:00 the combo box is showing 10:00:00, which is correct to the...
  15. krzysrb

    checking the text value in combo box

    tb, you solved it right man. Thanks a lot. I have been thinking of triggering the flag in case of incorrect entry, but i couldnt never get it how to use it. thanks again man vlada
  16. krzysrb

    checking the text value in combo box

    Hey all I am wondering if any of you is aware if there is a way to check and see if the text value of a combobox is in the list of the values for that given combobox. I had this code running and it doesnt seem to work very well. Even if I have the right name of the day, it still says it is...
  17. krzysrb

    in need of advice

    hello guys i need your opinion on the problem i have. i have a db table that contains start time for a shift, end time for a shift, the day that the worker wants to work that particular shift, as well as their name. i.e Joe Monday 8:00 13:00 the work begins at 8am and ends at 11pm, and...
  18. krzysrb

    from a recordset to array (perhaps possible?)

    hey Som76, Your idea worked better than my gibberish, and i got the code to store it all into the variant-type variable. but how do i make a leap from the variant into array of strings is what bugs me now. i know that the values are in there, but how to get them out now is my problem. here...
  19. krzysrb

    from a recordset to array (perhaps possible?)

    hello all i have just a simple question about the little thing i have been playing around with lately. I wanna try to make a schedule for this place i am working at, and i have all the preferred times of the workers in a DB table, and i have the following code and please if ya can, please...
  20. krzysrb

    sorting the days

    hey guys thanks for your help, but i followed to another suggestion from another helpfull guy here, and he suggested SWITCH statement in the ORDER BY line, and it runs smoothly. the credit goes to CCLINT, but thank you for your efforts. vlada

Part and Inventory Search

Back
Top