Recent content by kirkm

  1. K

    Current Event handling

    What is the correct way to handle Form_Current event? I'm finding it runs many times while I am initialising various controls in my startup Form. The only way I've found to stop it is Me.OnCurrent = "" in Form load. (And later Forms!Form1.OnCurrent = "[Event Procedure]") But this prevents Form...
  2. K

    Reading Label Name Property

    Brilliant, many thanks, that did it.
  3. K

    Reading Label Name Property

    Thanks, but my problem could be how I get textboxname, which is Me!subForm1.Form.ActiveControl.Name.Controls(0).Caption returns error 424 Object required
  4. K

    Reading Label Name Property

    In text Box Properties under Other there is a entry for Label Name. What would be the command to get that name in code ? Once I have that I presume I'll be able to read it's caption ? Thanks for any help.
  5. K

    .Additem problem

    Yes, this has potential. Perhaps first an image showing the differences with the raw output from WordWrapListbox2.accdb and how I'm wanting to display it. I have a routine that formats this up to a point but yours may be better and is certainly more compact. I've identified some issues, the...
  6. K

    .Additem problem

    Hello MajP not sure if you want to do anything more with your wrappable list box ? I've been applying my data to it and finding some issues. But before going into detail I'll will wait to see if you get this or want to reply, Cheers
  7. K

    .Additem problem

    Seeing you've asked... The real big picture is this will be an interface between the data and the music and used by an interested bunch of collectors, who have gathered the songs, images (label scans etc) and lyrics. There's about 44,000 entries so far. I'd cobbled this togther in Excel...
  8. K

    .Additem problem

    Maj, I wouldn't really say I'm meaning to outsmart anyone, I defer to everyone on here. I know what you mean by no-one wants to help me do things the wrong way... which of course means my way ! They don't have the full picture of what I'm doing? You say you cannot make heads or tails of what...
  9. K

    .Additem problem

    Hey, very nice! I'm not sure how I missed the new stufff you'd added, but have caught up now. I will try incorparating your wrapping routine, it's certainly much more concise than I had. You set list colums to 2, the first may have a width of 0. Not sure why that might be yet. A part of the...
  10. K

    .Additem problem

    Opening Form1 in MajpListBoxProblem2 populates the List box with Numbers. If I run your Form_Current event it complains about Me.id. Is something missing ? The table now has contains all albums. My plan was for it to contain just the required one album, then pass each record through the...
  11. K

    .Additem problem

    I think you have what's wanted exactly Maj. What your listbox shows is it. That is all it does at this point, just copy the details into the listbox without truncating ot losing any of the data. Not sure whats meant by no Key or ID ? Some necessary step I didn't do ? The ID I used was the...
  12. K

    Listbox Click event

    Certainly with VBA I have a vague idea what I'm doing.. the other stuff drives me batty. Sometimes I'll fluke it or get advice I can implement. I persevere as Access is so good once it's nailed down. I follow what you've said Pat, but it ain't plain sailing and those tutorials that spout on...
  13. K

    .Additem problem

    This is probably reasonable to show what I'm attempting. It won't clear the listbox at the moment (I don't know why). Form1 runs it.
  14. K

    .Additem problem

    I seem to have struck a number of unresolvable problems... even after 3 hours trying to fix them. Queries that don't run all the time - or rather, fail to go to a function they should. Text boxes that just show #Deleted. A situation where Access just closes (I've remmed this out to see why...
  15. K

    .Additem problem

    Maj I am readying a demo for you in a seperate thread and this is very much a part of it. You will explain all and show how this issue's been tackled. It wasn't easy, isn't good, but 99% works. You may well have nailed it and I can replace all my stuff with yours ? It may take me ah hour or so...
Top Bottom