Search results

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

True I wouldn't use Like in that exact case either, but from the OP's original msg he's going want to end up looking for words mid line, so you would need Like "*word*" or similar.

use an import/export spec, do it manually but don't press finish at the end, press advanced...you can then save the spec and put the name of it as the 2nd option of the transfertext sub. The other method is to write a manual text import routine, the one I use, uses the destination table as the...

Change the if in the middle to: If Trim(.Lines(lngCounterB, 1)) Like "Replace" Then '(.Lines(lngCounterB, 1)) contains 'Replace' some where in it End If You could then use the Replace() function to replace the words. If A97 then you will need to find a VBA equivalent of the replace function.

well I didn't post any because a) its random (but the line does use excel objects (normally range) b) it continues anyway...so I thought the error code might mean something to someone c) the code is large...I could post a section though if you think that will help Dim oExcel As Excel.Application...

I've got some code that generates an excel spreadsheet from scratch. When I run it, it sometimes falls over with the following error message: but, and this is what I don't understand, pressing F5 continues, it then might fall over slightly later but again F5 continues. It doesn't always fall...

urm for starters fld, id and col aren't used at all in that function! If you give a code that equals on of those constants then it returns on of those cases. The last one being the one that gives you a year that = now-4+row tbh the whole lot looks like gibberish.

Ok, that makes sense! But is using a querydef the same as creating it in the grid, and then same as using docmd.openquery?

oh I didn't know that the querydef method would make such a difference, I'll try it. tbh I've never really understood what querydef's gives you...except if your building a changing query for a report.

I've got the following query: INSERT INTO selFeesSum ( FEE_TYPE, FEE_HOW_PAID, FEE_AMOUNT ) SELECT srcFees.FEE_TYPE, srcFees.FEE_HOW_PAID, srcFees.FEE_AMOUNT FROM selAccounts INNER JOIN srcFees ON (selAccounts.ACCOUNT_NO = srcFees.ACCOUNT_NO) AND (selAccounts.SUBACC_NO = srcFees.SUBACC_NO); If...

Is the following code snippet alright? 'add up int terms iTerms = 0 RateRS.Seek "=", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO Do Until RateRS.NoMatch iTerms = iTerms + RateRS!TERM_BAND_LENGTH RateRS.Seek ">", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO Loop It's the seek usage...

too slow:) I just ran it on my home pc and it's far quick, but then thats going from 256mb to 1gb of ram so thats probly it. At the moment its taking 1-2mins to do one main record on the work pc's. The child tables aren't complicated, at most 9 rows, and I tend to use 2/3 of them, the date...

I've got a model that needs to do a lot of date lookup's on largeish (200k rows) tables, at the moment I load up readonly recordsets and use findfirst, but this is proving very slow. What alternatives are there? Would loading into arrays be an option (worried about memory there). or any other...

yep its helped me...dunno what happens to closed threads on this board though, the code/thread might be useful to others.

Ended up with this: Public Function InSet(sString As String, sSet As String) As Boolean 'see's if sstring is in a set of strings 'set is ; delimited like patterns Dim sSetItems As Variant Dim I As Integer sSetItems = Split97(sSet, ";") For I = 0 To UBound(sSetItems) If sString Like...

trouble is I can't make that code user defined or expandable.

Is there a quick way to match a string to a group of strings? ie if "xyz" in ("xyz","zzx", "yyx") then true does that make sense? it would be even better if I could do like matching ie? if "xyz" in ("xy*", "xz*") then true anyone? or do I need to write it?

ok these are bit rough n ready but they might be useful to someone: I might add more if I find I need them Public Function rI2C(OrgVal As Integer) As String 'converts a number into an excel style column reference '28=AB, C=3 etc Dim FirstNum As Integer, SecondNum As Integer FirstNum =...