Search results for query: *

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

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

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

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

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

I am processing a large (400+ page) MS-Word document with my VB(A) program. I have various tags for client name, client address, etc. I have code that works, but it runs sloooooooow (when I was working with smaller documents, I did not notice a speed issue). I am looking for suggestions on how...

In the XL sheet I'm working with, there is a column that contains data with carraige returns (multi-line text). What I need to do is replace all of these line breaks with some other character (like a pipe). Is there a way to do this in Excel (I know you can do it in Word, but Excel does not seem...

Suppose I have 2 bookmarks in an MS-Word document ("Book1" and "Book2"). Between these 2 bookmarks could be anything (from a single character to a 25-page document). What would be the code to delete everything between the 2 bookmarks? TIA for your help.

Has anyone had success with this? If so, what is the syntax? Also, what type of file does Word want to print to, and can this "print file" be read back as a "doc"? I am particularly interested in the "append" argument of Printout. I have been searching for months...

I'm working on a VB app to generate one big master Word document that is a compilation of many other individual Word docs. I'm doing this by repeatedly executing the "InsertFile" method. I want the characteristics of the individual docs retained in the new master doc. (i.e., one...

I've got a puzzler here. I have two MAS tables connected to Access 2000 thru the ODBC driver. In the SQL query window, I have the following: SELECT CustomerNumber, COUNT(*) FROM AR4_OpenInvoice GROUP BY CustomerNumber HAVING COUNT(*) > 10 The problem? The query runs but produces no records...