Search results

At first glance I can say that this APPEARS to be similar behavior to a special character problem. I would recomemend trying to populate the MS Word document with some simple, short strings to eliminate special character considerations. At second glance I would consider the possibility of a...

Ken, thanks for the post. I'm using Office 9, not 10. I found a copy of vbagrp9.chm. I'm looking through it now. ________ Easy vape

Cullihall, This is more of a business requirements question, but have you clarified whether by "average" you need a mathematical "mean", "median", or "mode"? Different kinds of averages will give you different values and have different responses to outlier events. As Scooterbug...

HISTORY: I've been working on creating MS Excel charts from MS Access as the closing piece of more than 3K lines of code used to generate a single complex report. Unfortunately, I have not been able to figure out how to define the data range in my code. I can dynamically define data series and...

I'm not sure exactly what you intend to do in looping through the records, but typical syntax would look something like this: Please be advised that this is a quick rendition of code to address your question, but has not actually been pre-tested for you in MS Access. I suspect that you will also...

Some Java colleages of mine have advised that if you are going to reuse the values stored within a recordset several times, you could realize a performance increase by extracting values from the recordset and populating them into an array (or structure) before setting the recordset equal to...

I don't have any messages handy, but you might want to take a look at the HTML source for the next Amazon.com type e-mail you receive to review the HTML tag syntax used to link to picture files stored on a remote server. ________ FORD P PLATFORM

Hmmmmm the last time I had SQL code that would not run AND would not generate an error I discovered a pecurliarity within MS Access VBA. When using WILDCARDs within a query composed in "query view", you use an ASTERISK, whereas if the SQL statement is composed as a string and then executed...

Though this will not actually help the end user a whole lot, it may help you. I often capture errors as part of the error handling. Most every subroutine or function I write incorporates error handling language similar to the below: Err_lboTasks_Click: MsgBox Err.Number & ": " &...

Are the values in 'Set_A' and 'Set_B' static, or are they expected to be updated over time? If tyey are expected to be updated over time, then I would store the values in tables and create two recordsets (one for 'Set_A' and another for 'Set_B') and use PBaldy's method. Here is a raw code...

BobLarson, Thanks for thinking of this. I know that Gemma-the-Husky, you, ajetrumpet, LPurvis, and CraigDolphin have been very helpful to me over the years. It's great that you have found a way to give a little back to these people, and the rest of generous souls who make this site what it is.

Error 1004: Method "ChartWizard' of object '_Chart' failed I get this error when I try to run a code snippet for creating a graph in MS Excel. Not surprisingly, Using the MS Access VBA Object Browser, I find that the method Chart Wizard is present within the Excel library Chart Class. I...

I've written VBA code to export MS Access data to MS Excel. I'm now working on making MS Excel Charts based upon this data, but am having a heck of a time defining the data range for the chart because the number of rows of data will constantly change. Is there a good way to have MS Excel...

build your SQL statement in a VBA module and things should work fine for you. this should work because you are using VBA to write the variable inside of an string thta just happens to be an SQL statement once the SQL statement is complete, you can pass this statement along to MS Jet. MS...

I think I figured this out... should read as ________ Vaporizers

Thanks for the suggestion. Normally MS Access will pop an error explicitly stating that there are too many continuations... I eliminated all continuations and made one very long line of code. Unfortunately the "Compile Error Expected end of statement" persists... ________ Oregon Dispensaries

In answer to yoru post, I see an error near the end of your SQL statement should read or ================================ General thoughts regarding SQL in VBA ================================ Always be on the look out for double quote characters within an SQL statement as VBA uses them...

I have a code block that fails to compile when a multi-dimentional array is defined. This sample code compiles without error but the code below fails at the comma within every "), " Where am I going wrong? ________ Ford Thames 300E History

Steve R., Thanks for the suggestions. While waqiting for a response it occurred to me that the problem was entirely related to nulls. by eliminating nulls I was able to make the problem go away. Things are working now. Here's the working code, though I do have to admit that it is a bit...

CAVEAT: I have some very poor quality data to work with. GOAL: Run a series of data quality checks and edits against every field before a "cleaned" record can be INSERTed into a "cleaned" data table. METHOD: (1) Assign a variable for every data field in "cleaned" data table (2) Build a...