Search results

Pat, I guess I tend to remain as naive as possible until confronted by a shut door and no way around. I really appreciate your comments and link as I hope to eventually (like soon) create a deployable application on a CD. So I best pay attention! Guldo my friend, With your example dB as a...

Guldo, You have done me a world of good! I made excellent progress last night! I should have something to show you in a couple of days.

Strange Stuff Going On! Guldo, I have been working with the logic you so kindly provided but have thus far been held back by a continuing series of Access errors dealing with my SQL statements. I mean almost beyond the point of frustration. Today I napped on the dilemma and came to the...

Guldo, I am sorry for taking so long, I knew your reply was there but have been sidetracked on other aspects of this program. I have downloaded your sample files and believe I can leverage them for my report. It will take me some time but I will return to this thread with any progress made...

guldo76 , I wish you had an example of what the results look like. I am searching for the method to create a report like the attached zipped Excel file. I believe I can create the report lines for the room and tasks. From another thread in this forum, it looks like I could possibly color code...

guldo76 , I wish you had an example of what the results look like. I am searching for the method to create a report like the attached zipped Excel file. I believe I can create the report lines for the room and tasks. From another thread in this forum, it looks like I could possibly color code...

Great question, I have also been unhappy with the defaults of 75 and 100% preview zooms. Any information that would enable more flexibility would be a great boon!

I am Interest in the Final Product ! Cosmos75, If you are were successful and willing to share, I'd sure like a look at your public function to Shade Alternate Lines of a Report with Different Shades. :D

Final Touches on the Loop Code I had lines not needed and although the code was looping, it was looping through properties until it came to a listbox with no data. In other words, it did not work right. The loop code below correctly finds all of the 7 "Day_Table_" tables, and then exits the...

Shay, Actually I did much worse than that. I am beginning to understand more and more what the word 'object' means in object programming! The actual Microsoft code had 2 FOR loops and two WITH statements. Although I had SET the database in the code (but did not inform of such in this...

I have a form with about 10 recordsets. Of them 7 are named rstTemp_1, rstTemp_2 on to rstTemp_7. They are temporary RowSources for listboxes in the form. In using the form, one, two up to all of the listboxes may have data placed in them. I am looking for a method to loop through all the...

Wayne, Although I have not gone through the logic again, I did check out the tilde. I made the path "C:\HMS_temp.mdb and followed the variable through to the kill statement. The string was OK, nothing wrong with the path or filename but still the same 75 error. It has to be something with...

Wayne, I agree about the tilde, I didn't like it either but note that it is in the demo mdb and works fine there. When I first ran across the error, I had the space before the temp but thought that was what was killing me so I took it out. It is actually just the way he concatenated the...

Hi Wayne, No, There are no spaces. Here is what it looks like in debug: C:\ACCESS97\HOME_MGT\DEVELO~1\HMS97_Rev11temp.mdb The very good man I got the code from has a demo database that I attached. His temp table in debug looks like this: C:\ACCESS97\TECHTO~1\TempTables temp.mdb an yet the...

Gentlefolk, I have created a temporary database to do some work in for a form. When the form closes I receiving a Runtime Error 75: File/Path Access Error. The form opens and works fine but when I close it, I cannot Kill the datbase! I've been over the code many times and cannot figure out...

DES & jjturner, Thanks for taking a look. After DES's response, I loaded a P166 Windows2000 machine with Office97 and ran the demo against it. I did get the scrollbar to drop to the bottom of the listbox the first time after the form opened but no hourglass either and no 'hanging' of the...

Greetings, This has been a perplexing problem. The form in the attached Access97 demo database graphically shows the problem. When the form is opened, then the scrollbar in the listbox is dragged down for a bit (say 3/5th of an inch or more) and released; an hourglass appears that will not go...

jjturner , Actually, no I am not trying to move records. Once the user has designated which room he/she wants for a specific day and clicks on a command button, I will be modifying a single table by default program rules. The information in all the listboxes is solely for the final...

In a form in my program, I may need from 1 to 7 listboxes based on the days of the week depending on how many the user has selected in an earlier form. For each listbox, I need to create a temporary table to hold text data that is to be drag-n-dropped from one table to another. I would like to...

Make that subform! Boy, would I like to change the title of this thread!! It is a subform that is treating me cruelly, not a listbox. My apologies. Still would appreciate help of course!