Recent content by BruceG

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.