Search results

The only salient difference that I see if the methods of displaying the text. Why Print one out to the Immediate Window and then the other a Message Box (which has an inherent limitation of its width and number of rows it can display). What are the two sets of results actually showing...

Hi. Late to the party here, so not sure where we're at. Are we removing any text that is non alphanumeric and also anything delimited by brackets? RE.Pattern = "\([^)]+\)|[^\w\s]" I might have missed something - or it's already been sorted... Cheers.

Stephen Lebans' PDF code samples includes a method for combining pre-existing PDFs into a new one. www.lebans.com/reporttopdf.htm You'll need to download the two DLLs that the same uses too. (They don't need to be registered - merely positioned.) Cheers.

In this instanc, frm is an object variable of an AccessObject type. It contains no reference to the object itself per se. And the form isn't necessrily open. (A requirement to examine its child controlls collection.) You could open each form first. Dim frmObj as Access.Form ...

Generally text substitution (which is fairly common conceptually) is facilitated by escaping your text fields. This identifies the fields in text as being for substitution (as opposed to just being text which happens to match your field name for example. Hello! This is a reminder that you...

Just to mention.... >> rsData.ActiveConnection = CurrentProject.Connection So this is an ADP you're using? You could bind more simply Me.SubFormA_SearchForm.Form.RecordSource = "EXEC dbo.ICT_Reports_LoadData_Searchform '" & Me.ApplicationCombo.Column(0) & "', '" &...

Welcome. You're OK with the how and why too? (A bit brief of late, through necessity :-)

Hi This can really be just string manipulation, rather than having much bearing on your Outlook code. For example: stCC = Nz(Me.strCCEmailAddress, "") & ("; " + Me.strCC2EmailAddress) To ensure you have a zero length string (as you're using a string variable not a variant) and don't need the...

The Jet OLEDB provider is more sensitive to reserved words than Access or DAO. You need to escape all of yours. I presume you're providing a cut down version of your code? You pass five values to your form - and only insert 3? Assuming you actually have: INSERT INTO members(username, password...

Hi Just passing through but I wanted to observe a thing or two. First of all, you're opening a recordset, essentially pulling over every active Employee record. Fair enough - you want the user to select from any of those. You're doing so in an ADO recordset - again fair enough (and actually...

As mentioned above - an autonumber is completely independent of all other columns in the table. The code suggested doesn't require that it's related or varies depending on the other columns. You want it to be independent. You're keeping your Code1 and Code 2 columns. It's simply a way of...

Well, I wasn't assuming anything about the desired order particularly. Just that they be made unique. Yes if the higher values were wanted then they absolutely need to be DESCending.

Hope your wife is doing OK! Yes, that had crossed my mind. Although Jet defaults to what would be "WITH TIES" in another SQL dialect - and it intrinsically locked to that - it's not difficult to push further. When there is a tie, the decision inevitably rests with the developer (informed by...

Hi, welcome to AWF. What's the actual, specific, problem that you're having? You've tried to implement the UPDATE or APPEND philosophy, but rather than one of us pouring over the code to see what could be wrong (time consuming much?) if you narrow it down then you'll get more responses I'll...

>> Joining Code1 & Code2 together (e.g. Code1_Code2) would be a unique identifier. It might well be - but if you created a new field holding that, them your data is not atomic. You're repeating the same information in fact. Adding a primary key index over those two fields wouldn't help you...

For example, assuming a single identifying column, PKID, then something like just: SELECT T.Code1, Avg(T.Reserve) AS AvgRes FROM tblTableName AS T WHERE T.PKID In ( SELECT TOP 150 T2.PKID FROM tblTableName T2 WHERE T2.Code1 = T.Code1 ORDER BY Code2 DESC ) GROUP BY T.Code1 On...

I have to ask... Does your table not have a single primary key field? You mention Code1, Code2, Reserve. Is the primary key a combination of Code1 and Code2? Or do you have another, for example autonumber, column? (It so often makes such solutions simpler.)

I know this might never get a response (it looks like we're two days and counting - but what the gang has suggested is worth reading carefully...) but I just wanted to ask a thing or two. This is in the SQL Server forum. Is the query being executed in an Access application linked to server...

I'd have to agree. You're using the CurrentProject.Connection returned object, and so this is a locally accessible table or query that you're opening. So you can assign a RecordSource property directly. I should point out that there are occasions where you might still want to assign a...

You're into a performance minefield there. It's the problem once data which lends itself to atomic (individual) inspecetion is stored concatenated like this. Yes, it may represent something like a manufacturer's serial or model number, but if you need to consider it as individual values then...