Search results for query: *

Hey anyone out there have a solution to easily opening another users folder? Ideally i'd like a button or something similar i can click to get to it. I'm happy to do it just about any way i can (new form, vba etc etc) so suggestions are welcome!

I should know this but can't seem to get the thing to work. Check out this code: Select * from x inner join y on x.ACCTNUM = y.EXTPRDID So ACCTNUM is Decimcal(12,0) and EXTPRDID is Char(20)... this might be Varchar(20) as there seems to be some difference between out data dictionaries...

I have the joy (!?!?!?) of working in a statistical environment. Unfortunately this means that whenever something comes along claiming to be random colleagues question what random actually means. So that's what i'm now asking you!!!: When submitting a query with a SAMPLE clause, what criteria...

Here's a quickie for you. I'm using Attachmate 6.4 to connect to an ISPF system. Currently i've got my display working at 43*80 to give me extra height however a colleague has just shown off about being able to do something like a 132*80 display using PComm. I don't like PComm (change is scary!)...

Thanks for your help folks. I've got it working fine now! Cheers

Hi all, I'm quite new to the Windows API functions and and am trying to figure out how to open a HTML Help file in a VB application. It seems that API is the way to do this but the help doesn't seem to give much in the way of examples of how exactly to do it. Could anyone give me some help on...

Oh yes. That's the one! I knew access wouldn't let me down. Thanks for all your help. Unifex

I see what you're trying to do here with the correlated subquery, unfortunately it appears just as slow as the original subquery. The derived table worked in a fraction of the time. I actually wrote the query in Queryman (an NCR Teradata piece of software) just cuz it's easier. The '%' is...

Hi all, Does MS Jet SQL support Derived tables? I'll tell you what i'm doing and see what you come up with. I have an audit log of account changes. Fields are Id, ChangeDate, ChangeType, AccountNumber There is one record per change on each account. What i need is the last change of a specific...

Oh yeah, sorry. Forgot the SendKeys method was part of the Session object, not the system!

Hi all, I'm still relatively new to VB6 and have been experimenting recently with Data Environments. I've found a weird problem which i can't explain. I have created a data environment with a connection to one of the access sample databases (biblio.mdb or nwind.mdb). I've used the connection...

Hmmm, is this the method you're using to actually open Attachmate? I personally think it's the shell command which is causing you the issues. You need to really create a reference to the attachment object as below: Dim ExtraSystem as Object ExtraSystem = CreateObject("EXTRA.System")...

Yeah but I don't have anything to go on. How can i tell you what's wrong if i can't see your code.

Could you post an example of the code you're using. To see if i/we can spot anything. I use the sendkeys method regularly in various macros and have had no problems so i have no idea what's wrong!

I don't know if you got this sorted yet but the last bit of code certainly won't work unfortunately. The main problem with it is that SAS will not output any observations until it reaches the end of the step (the run statement) unless you specify an 'output' statement in the code. It also won't...

All, I've been playing with the SAS Integrated Object Manager from VB6 and have created a simple form which submits a proc upload from our mvs system onto out local pc. It works fine on 3 of the 5 machines i've put it on but on 2 the SAS log reports an "ERROR: Insufficient authorization...

Well now you're asking! I'm not certain exactly how to do this but I have a thought you might try. If you use a Rank of some sort to number the records and then just select until >5. Then you'd need to delete them from the table so that next time you'd get the next 5. Not a pretty way of...

I'm not certain what you mean by the 'next set of records'. The SAMPLE statement is random so you may well get common records between the two. You may also find that it doesn't always give exactly the number you request either, i'm guessing that this is due to it using a percentage of the total...

The first of them is a decimal(10.0) and the last is a char(3). I have successfully read in both these fields in other tables as they are both key values. Forgive me for not listing the rest of the fields as there are plenty but basically they are either decimal (5.0) or some length of...

Well i should probably be embarrassed about asking this because i'm sure it's really simple - just haven't found anything covering it already. Is it possible to limit the number or records returned by an SQL query? All i want to do is run a test job and check the output but don't want to have...