Recent content by steve1111

Thanks everyone, three separate temp tables were the way to go getting a total of 345 textboxes to loop and concatenate the string in less than a second and a half.

Ridders, very nice work. did you load with queries or a recordset? I like Doc's suggestion if I am not going to use crosstabs, but I would like to become more familiar with them so I am going to play around with Pat's Idea too. I see you have some formatting too, there are a few more lookups I...

Hi Pat, I am on a different computer now, but there is a png in the first post. Each "cell" cross-references the driver, day and 30-minute time block. It pulls in the direction, I or O, the Job name and then the second line of the cell is the job location. There are still some attributes I...

Doc, thank you for the explanation, and it does make sense. I will work that direction combined with the other suggestions head back to the direction of the query since i do not need to manipulate the recordset in this step.

Hi Pat, Thanks for the suggestion. The little I have actually used crosstabs in the past i don't think this would work with the about of data I need to show in each box. More so than just an aggregate function. I need to pull in Names, Id, direction and store code, some days and times block have...

Ok, thanks Minty, you have given me some next steps forward!

I started out with a query and used a series of dlookups and dcounts to get the day and time blocks that I needed, but that was taking 12-18 seconds to loop through all the controls. So that is what lead me to recordsets, only slightly more familiar that QueryDefs...would brushing up on the...

I am not treating them as editable. I am thinking a right-click menu to open a popup form with the ride(s) ID numbers to do all the editing there. there are more details for the ride than I can fit in the boxes.

Sorry for probably a pretty entry level question, I have looked a little but couldn't find a black or white answer and I was hoping for some quick feedback before I did the work. Currently, I have a subform that holds times slots and 5 days, there are 115 textboxes on the subform. There are...

Ah, I see where you are going. in VBA setting the recordset only runs it once for the rest of the module? Then do I just write a SQL query referencing the open recordset? I have done recordsets and SQL queries in VBA just never together.

Hi arnelgp, I do have the top of the form load when the main form loads, takes under 1 sec. The update button them loads each "grid" subform under the driver only when the update button is clicked. This step is where it is taking so long because there are three subforms (on for each driver)...

Hello all, I am looking for some basic suggestions on how to increase the speed in which my form and subforms load in my particular scenario. Attached is a screenshot of the form I am using to bring in a drivers work schedule for each day. I already query just the records from the rides...

I did see the screenshots but what I am trying to do is make individual work weeks for each driver. Your shots are nice, but I need M-F to repeat under each driver. Marks suggestion is valid, but the details of the cell and 24-time blocks I am not sure flipping solves anything for me. I would...

Thank you ridders and Mark, but I don't think rotating will work for me in this case because I would still need to simultaneously scroll each driver subform, only with rotating it would be horizontally rather than vertically. Each driver would have to show in its own subform for 5 days.

Hello all, I am creating a 5-day calendar, much like outlook, for driver jobs and times. I find the best way to do this an achievement an "endless" horizontal scroll past the 22-inch limit is to build 4 subforms and have each hold a driver rides for the day. This way certain regions that have...