Search results for query: *

Hey addy, I appreciate you taking the time to respond. My colleague who is responsible for setting up the user's PCs does not think that this is the issue, but we will be checking into it. If we can definitively determine the cause for this issue, I will post back here. In any event, your help...

Hello, I have an app that is having an intermittent problem with reports coming up "blank" when run - meaning that the basic structure of the report shows up (headings and graphic lines and so forth) but no data is filled in. This seems to happen only on certain reports and only on certain PCs...

Thanks for responding, Zion7, I will take it under advisement.

Hello there, I am a veteran of straight VB programming, but less of a veteran in Access VBA application development. I am currently working on a large Access application, and I want to search for a particular string across any module (form, report, VB module) that has code in it. (For those of...

Thank you for taking the time to respond. I figured as much, but was looking for confirmation.

Hello, I have inhereted an 8-year-old Access database that I am currently "gutting" and in some of the DELETE queries I am seeing DELETE DISTINCTROW ... and DELETE ROW ... These are single-table DELETEs, so I am wondering if these keywords are unnecessary. I am used to coding DELETE statements...

Hello there - As a VB6 programmer who will now being more stand-alone Access development, I am in the process of getting used to the Access way of app design. My question today is how do I maintain consistency in the size of the form (detail section) so that the size of the form during...

I have a feeling the answer is "no" to both, but I thought I'd ask anyway. Is there a way change the font of the MS-Access SQL window (the default of MS Sans Serif 8 pt) can be hard to read (especially when you get past the age of *ahem* 29) ... Also, is there a way to have Access...

Thanks for your responses. Edric: I am not sure that the auto-complete command would come into play when manipulating a document thru code; I doubt that it would, but I'll check it out. ETID: A virus may be a likely culprit; that did cross my mind. Do you have any idea which virus would...

OK, I know this is a weird one. I have clients using an app I wrote in Visual Basic which makes text substitutions in legal documents (kind of a glorified mail-merge app). They claim that occasionally, in this one particular document, the name "Robert A. Smith" appears unexpectedly...

Loomah, that was it, thank you very much. Thanks also, Voga, for your response.

On a colleague's machine, we were trying to do a LEFT function in a cell (i.e. in B2, "=LEFT(A2, 6)"). In B2, the formula was displayed, not the result. The same thing happened when we tried MID. I did the same thing on my machine and it worked fine. Apparently my colleague's Excel...

It looks like the Change event is firing for each character that is entered thru the scanner. If the number of characters to be entered in Text1 is consistent, you could set the Maxlength property of the textbox to that number (let's say 10). Then modify your code in the Change event to this: If...

As meldrape implies, this kind of thing is pretty much a manual effort. Many "core" BASIC elements (such as string functions, math statements, file manipulation statements, etc.) will work the same, but other than that, you'll need to create new code in VB to simulate the functionality...

Thanks, Nikki, I'll give your suggestions a try.

The last thing I mentioned did not work well, because when you do text replacement on a selected portion of text like that i.e. Selection.Text = Replace(Selection.Text, &quot;<<NAME>>&quot;, &quot;John Doe&quot;) the formatting is not retained. This is what strongm was referring to a couple of...

strongm, That was an honest question. I wasn't sure how to use Regular Expressions in the context of my problem. However, that go me thinking, I could probably select all the text in the doc and use either reg exps or VB's native Replace function, both of which should be much faster than Word's...

How would Regular Expressions help?

I would say several hundred. The client name is all over the place, and there are also addresses, dates, and other info, spread across all of these pages. One thing I tried was to go &quot;outside the box&quot; and read the file as &quot;binary&quot; in straight VB, do the replacements in VB...

Thank you. I had put that in before and was able to shave some time off, but not enough to make a difference. The entire process was taking about 20 minutes (I was doing other things besides search and replace) and was able to get down to about 16 minutes by using the ScreenUpdating = False...