Recent content by Sanguineus

  1. S

    Update part of delimited string in field.

    Thank you this is pretty much what i've just finished doing, as you say was leading myself down an overly cmplicated solution when there was a perfectly good simple one staring me in the face. Taking the opportunity to talk it through helped (as it often does for me). Just one tinyissue to...
  2. S

    Update part of delimited string in field.

    I don't have the seperated data pere that function would give me the seperated data, from the exsisting data. I am wondering if I have over complicated things. I would essentially know where in the string the substring I want to replace is so I could include the delimiter in the searchand...
  3. S

    Update part of delimited string in field.

    This code, takes a string from one field i.e. One-Two-Three and splits in into 3 fields One, Two and Three (using "-" as the delimeter) EDIT:: So in my problem I might want to change 'Three' to '3' so Ihave records showing as One-Two-3 instead of One-Two-Three
  4. S

    Update part of delimited string in field.

    Hi All, Really stuck on something that after a couple of daysis doing nothing more than giving me a headache. I have been asked to look after/maintain as DB from a colleague who is moving on. I am going through updating code, forms and so on, but have come cross a problem I just can't crack...
  5. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    OMG! why didn't I think of that.. thank you so much...
  6. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    I used a listbox because it looked nicer on my form (/shame) i'll take a look at a subform.. and then read about recordsetclones. I'm just at the startof my Access/vba journey it seems. thank you for the tip!
  7. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    At the moment its going to be a shared table on a backend just so that I can keep track of whats going on for who, but if there's a performance impact i'll make it a local table. I wasn't aware that we could limit a table to a fixed number of entries (never had a need to before now) but if...
  8. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    Table is a physical table within the DB, with the fields listed above (plus the name of the user). The timer value is a value from a timer class i'm using, and the value will be updated by the forms ontimer event, (once I figure out how to keep track of which slots are in use). There are 5...
  9. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    wouldn't listbox.listcount only tell me a count of items within the listbox not the position. so for example if slots 2, 3, 4 & 5 were in use, the return from the count would be 4, not the required 1 in this case.
  10. S

    Solved Keeping track of "slots" within a space limited list as items added/removed/amended

    I have a listbox (that is bound to a table) that I will constrain to being able to hold at most 5 items. The listbox is split into three columns TimerNumber (integer 1 to 5), TimerName (string) and TimerValue (double). I have controls set up that will allow the use to add and remove items from...
  11. S

    Solved Saving Control properties

    If it helps this form is a Time in motion tracking form so has a tme and a few drops down boxes to help classify the activity. There are 4 comboboxes and two text boxes (one of which is a timer) I literally only need to hold the values for asecond or two. Between the form closing and then...
  12. S

    Solved Saving Control properties

    Thank you -- I had thought of that but thought that would be a fairly huge table again with lots of fields for each property, but me being a collossal moron has just realised it wouldn't matter as simple loop would take care of the heavy lifting. Think i've had my head in the VBA Window for far...
  13. S

    Solved Saving Control properties

    I have a form that I have opened with a standalone app feel. I also have some code that detects if the application background has been maximised and hides that part again. However to do so Ihave to close and re-open the active form. What I am struggling to do is save the properties of each...
Top Bottom