Search results

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

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

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

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

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

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!

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

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

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.

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

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

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

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