Search results for query: *

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

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

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

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

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

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 ppls i have posted a similar thing in DB section, but this concerns more sql so here is my problem SELECT [First Name], [Last Name], Day, [Start Time], [End Time] FROM times ORDER BY Day i run the above and i was originally (and foolishly to be honest) hoping i was going to get a list...

hey all I have a quick question for you all. I have a created a MSVB Data Report (using standard report built-in to VB), and I link some labels back to the database's field that contains days of the week (mon, tues...). I would like to do a sort on the report in the order of the days mon thru...

hello guys, me again this time i have a question that rather needs some pointing to other sources of info than the answer itself. i would like to learn more about the data reports in VB, and especially on how to code the commands in it other way than thru the properties, cuz the hard-coded...

hey guys i have a problem with JET engine in this li'l program i am trying to write. I have hardcoded the data control references to my database, but this doesnt get me far. the moment i make a change in the DB placement, it gives me an error. is there any way to quickly check if the DB is...

Hey y'all I have a stupid problem that drives me crazy for few days now. I am trying to add a record to a table in a database, and it alway replaces the first record in that table after i execute .addnew. i have a field in the database that is an AutoNumber and i have no idea if that might...