Search results for query: *

Missingling, thanks to your email, I've discovered she's been using control keys to copy and paste Comments from one detail line to other lines/other records. So, this was a big 'Aha!' I suspect other key movements are causing the Paste action to happen, like you mention. Do any other key...

hmmm...she is used to using <Ctrl> a lot (she asked me to put in <Ctrl> + <S> for her to save more easily, which I haven't done yet). Perhaps she is inadvertently pasting... or using <'> like you suggest. I will check this out! Thanks for the suggestion...

Just checked, and my user's PC scroll button doesn't work in these forms. Scroll wheel disabled. I changed the names of the Comments fields on the 2 tables, to make them unique. Not sure if this will have any effect or not.

I have the scroll wheel disabled - but that's a great point - I can make sure it's working on her pc (it's working on mine)!! Thanks - I will check it out this morning - (but still wondering why it only happens on 1 field out of 12 fields on the subform). Lori ps - no LostFocus event.

Hi, I have new forms that a user just started using. She is having problems with data from a prior record popping onto the current form. Here are the details: It is a main form with a subform (continuous). Main Form's recordsource is a query off tblHeader, subform's recordsource is query...

Duane - Just got it to work, somehow. I sit scratching my head, wondering why it didn't work just a few minutes ago. But anyway - thanks for the tips. Me.Parent.name works (even tho' name still isn't capitalized). - Lori

Hi Duane, I am just now putting in the Me.Parent.Name into my subreport's code. I am getting an error: invalid reference to the Parent property. (and 'Name' didn't get capitalized, which was my first clue). I've tried Me.Parent.Name, Report.Parent.Name, and several variations of this in my...

Ahaaa. Two great suggestions. I already have Find&Replace, and I love it and use it all the time. I like the wordpad cheating trick for fast and easy change. Thanks!

Hi r - Argghhh!!! Don't know where my head was at yesterday. I knew it had to be my mistake...and just found it. I was using lstReport.Selected(1) instead of lstReport.Column(1), I'm embarrassed to say! Thanks to you all so much - thanks for sticking through it with me... Hopefully I am...

Hi - the MultiSelect property = None. any other suggestions? meanwhile I will play around with it later on when I get a chance. Thanks! Lori

Hi rjoubert - I tried doing what you suggested, but it seems to always give me a zero (0), regardless of which list item I select. Even if I try me.lstReport.Column(0), the results are zero. ??? am I doing something wrong? Thanks for the response, Lori

Thanks, Duane. On a similar note, in a Function I have created (it's a separate module), can I tell which report or program called it? Thanks once again - you have helped me many times! Lori

Hi, I have a listbox on a form. It has 1 column, and I am adding a 2nd column, hidden, that I can use to get info from the selected item. Its row source is a value list. I have set it up, but how do I reference the 2nd column on the item selected, so that I can get the data in there? My...

Hi- I have a MouseDown event where I change the pointer to a hand, and I just added code to underline the text as well. But - how do I undo the underline when I am not in the MouseDown event (in other words, when my pointer is not over the designated label, it's still underlined). MouseDown...

Oops, I got it - by adding some space below the subreport's control on the main report's detail section. That was easy - not sure if it's the only way, but it worked.

Hi, Lots of report q's for tek-tips today! I have a report with a subreport that prints a detail line for every record read. I would like to skip a line (print a blank line) when the room number (the main sort field) changes. How can I do this? I'm not sure if I would check in the main...

Hi - Is there a way, in a subreport's vba code, to know which report is the 'parent'? I would like to use a subreport in several different reports, and would like format the background colors differently for one of the reports. How can I check which 'parent' called this subreport? Do I need...

Hi, I have a report with a subreport displaying 1 line of data for each record read. To the eye, it looks like I have an inch of space on the right side of my subreport. However, if I try to extend the subreport any wider, the data gets cut off. The 'box' on the main report where the...

Thank you all so much for your responses. I've learned some interesting tips. Randall's example of using "nz" before passing my string worked like a charm! Just out of curiosity, why is a variant not a good variable to use? Lori

Hi Leslie, I've been using a lot of queries that reference other queries, for some complicated reports. My question basically refers to changing the referenced query, which I am doing frequently to alter test results. I've been doing this manually, as you also suggest, either in the sql, or...