Search results

Kryst51 and ChrisO; I deleted the previous control and code from my project to start fresh with the latest example given by Kryst51. I imported into my project the form from Kryst51 example. I then opened the form in my project and cut/paste in the four parts that make up the control. I then...

Kryst51; have you had a chance to look into this? chris

Thank you for that. I'll be watching this thread closely. chris

Well I may be on to something here. I commented out the code that the debugger was complaining about and now the control runs on the form without error messages, (except that the two list boxes stay expanded. It doesn't auto collapse when the form is opened, or after a selection is made. It...

if you have A2010 maybe you could look at the DB in post #37 and see if it works for you? I can open it and the control will run, but if you follow the posts after #37 you'll see where the issue is. chris

Please expound on what you mean in your first paragraph about control "txtSelection" needing to be requeried? chris

Well so far I've exported just the form and the two tables, the productionNumbers and productionHours tables, needed to drive the control to a blank 2003 DB and from there, tried to run that new 2003 DB in Access 2010. Same anomalies as posted in #38. Guess I'll see what else I can try. Don't...

No it does not work correctly in v2010. :eek: I created a XP Pro VM and installed Access 2003 SP3 to it. I ran your DB in 2003 and it works. Not sure why I'm seeing the errors and broken functionality in v2010. Since I have both versions of Access, is there anything I can do to get this to...

I've plugged in all the pieces into my project and it compiles. When I change from design to form view, I get an RT error "Invalid use of null" When I debug the line in yellow is Private Sub Form_Current() SetShiftColours Me!TimeID.

Chris; I tested the form. Opened it up in Access 2010. The form opens without error, however, it opens to a random time being displayed in the text box. I cannot select another time from the list boxes. The color in the box will change from yellow to black depending on either AM or PM time...

thanks guys; I'm thinking the only way to do this, given the errors, is a step by step process. Here is what I did: 1.) I copied/pasted in the four different parts of the control, the text box to show time selected, the down arrow button, the box for AM times and the box for PM times. 2.) I...

it "works" in 2010 but has the weirdness you talked about. Having to click/select a time by clicking several times on it. Also doesn't present the different color in the box after selection. John Big Booty's upload works the best. Just not sure why plugging the code in a piece at a time gives...

Still cannot get it to work. Neither one. Even tried to mix and match. I've left off using the first solution, as it seems to have less issues. Plugging the code it piece by piece compiles, but when I open the form with the control on it, I get a Runtime error 2950, Reserved error. several...

Do you think the corruption issue is because I created the DB in Access 2010 and then down saved to 2003? I will take a look at this tomorrow morning. The confusion I ran into last time was that the control was saved onto a form, of course, but from there I didn't know how to get the control...

Chris; Please forgive my knuckleheadery. I kept telling myself to convert to 2003 but when the time came to do that the other part of me kept that info to itself. I've posted it above.

Chris; here it is. I put a label on the form called frmProductionNumbers where I was going to put the time control. The bound field is TimeID on tblProductionNumbers chris

Chris; Is the version you posted above the one you want me to use? I've spent the morning getting my DB back to the error free way it was before I tried to create this control. Do you want me to upload it? chris

Chris; here is a bigger copy of the DB in 2003 format. Only raw data was removed. I apologize for the incoinveinance I'm causing you. chris

Chris; can you just delete any part of the DB that is not directly related to your solution? Will that fix any error you're receiving? You might be getting the error due to my housecleaning the DB to reduce it's size. If not, I'll repost the DB but this time only remove raw data. chris

Here it is Chris chris