Search results for query: *

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

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

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

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

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

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

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

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

CCLINT, as always you were right on with help. and that DAO ADO deal was a typo, sorry about that. Anyhow, I got the SP7 for Xp and then changed few things around and now its running just fine. here is the code if you care to see how it looks now, With adoEditTimes .CommandType =...

hello guys, I am running into problems with this ADO control I am using: With adoEditTimes .ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & mdbPATH .RecordSource = "times" .Refresh End With the...

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

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

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

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

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

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

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

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

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

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