Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by skinicod

  1. skinicod

    On/off button

    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...
  2. skinicod

    using sas to open up ms access but with a twist...

    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...
  3. skinicod

    Refreshing a Form during a procedure

    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...
  4. skinicod

    row source length

    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
  5. skinicod

    Refreshing a Form during a procedure

    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...
  6. skinicod

    Refreshing a Form during a procedure

    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??
  7. skinicod

    Refreshing a Form during a procedure

    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...
  8. skinicod

    row source length

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

    arrays and recordsets

    Cheers thats fantastic
  10. skinicod

    using an array as a froms record source

    it will be a continuous form
  11. skinicod

    arrays and recordsets

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

    using an array as a froms record source

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

    Skip an iteration in For...Next loop

    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...
  14. skinicod

    Switching CurrentDB.Properties like &quot;AllowFullMenus&quot; back to true

    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...
  15. skinicod

    creating relationships between tables in vba

    Thanks
See more

Part and Inventory Search

Back
Top