Search results for query: *

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

Thanks that is very useful. The reason I need to open the database is not update tables - although I also do this, it is so I can run some vba code to archive and rename the table that SAS is about to update and to establish various links with other tables already in the database. Thanks...

Hello, I am trying to change various attributes a database using vba. The first of these is the relationships between tables. I think my code should look something like the following: Dim rel As Relation Set rel = currentdb.CreateRelation(???????) My query therfore is - if I have two...

Note quite, but I've been able to use this to get to what I want anyway, Cheers

Hi, I am currently using the x command to open up a MS Access database from SAS. The only problem is I need to open up the database in administrator mode. If I was doing this manually I would hold down the shift key whilst double clicking on my access database. Does anyone know a way of...

Hello all, I wondered if anyone new if there was a DOS way of opening up an access database, which is equivelent to double clicking on it in windows explorer whilst holding down the shift key. ie a way that dos can open a ms access database in administrator mode, Any ideas would be gratefully...