Recent content by skinicod

Hi All, I have a series of buttons that I want to be on/off style buttons - i.e. click once to turn on and once to turn off. In order to show that any given button is on, the button text will turn white, and when off it will turn brown. I have all this working, except that if a user does not...

Thankyou dmksas - I am already aware of the use of client side components and intergration technologies, and I make use these methods extensively in my work. There are times, however, when it is nice to control applications from SAS, as opposed to writing VB/VBA code to open up a workspace and...

Good Idea Flyover, I am away for the next week but will let you know how I got on. My current solution has been to create text boxes that look like the list boxes and populate these as well as the listboxes during the procedure. At the begining of the procedure I make the text boxes visible...

Thanks Roy-Vidar, The reason for this post was I was that I was trying to avoid using the callback function as I wanted to keep the code simple for future handover, however due to the size of the list I need to use it. Useful to know about the 2048 characters though, Cheers, Skinicod

Okay now Im really freaked... I decided to do an experiment and change the background colour depending on which stage in the loop I was at - the list box now changes colour during the loop, but the information still remains allusive until the sub has finished...

This doesn't work either - incidently this seems only to effect listboxes - I just tried a similar thing with a text box which works fine. Any other ideas??

Hi, I have a procedure that loops round and fills 3 list boxes. during the procedure I want to be able to see the values that are being entered into the list boxes in real time. I have tried refreshing and repainting the form at the end of each loop, but nothing seems to work - ie I can only...

does anyone know how long your value list can be when using "rowsource" to populate a list box in Access 2000?

Cheers thats fantastic

it will be a continuous form

Hi, Does anyone know how you can create a new recordset using data held in a public array??

Does anyone know if you can use a public array as a form's record source, and if so how??

I would create a boolean variable called something like "Skip" set it to true when you want to skip the next iteration and then use an if statement within your loop: if Skip = False then 'YOUR CODE if <your argument for skiping the next iteration> then Skip = True else 'reset the Skip...

I had to do this in code recently - try this: Sub SetStartupProperties() Const DB_Text As Long = 10 Const DB_Boolean As Long = 1 ChangeProperty "StartupForm", DB_Text, "(none)" ChangeProperty "AllowFullMenus", DB_Boolean, True End Sub Function ChangeProperty(strPropName As String...

Thanks