[Gllug] Visual Basic Help

[Jackson, Harry]

> -----Original Message-----
> From: Wulf Forrester-Barker [mailto:wulf.f-b at uhl.nhs.uk]
> Sent: 05 July 2001 15:27
> To: gllug at linux.co.uk
> Subject: Re: [Gllug] Visual Basic Help
> 
> 
> Ah... that looks like Visual Basic for Applications (sticking 
> programming behind an Access form)... I'm afraid I can't give 
> specific help, but it looks like you need to throw in some 
> kind of 'while not at end of recordset, advance to next 
> record and repeat' loop. I used to find the Access VBA help 
> files quite useful... I'd sit and stare at them for long 
> periods and by a slow process of osmosis understanding would 
> gradually form in my head (well, slow osmosis and lots of 
> trial and error.... you're not working on live data are you?).
> 
> Wulf

Yes its for the back of a Form in Access. I have tried various things to get
the loop to go through each record. The loop works but it does not append
the data to the the table. I drop the data into a .csv and then auto load it
into access adding the other columns necessary using a macro. So I can play
with the stuff as much as I like as the data in Access is only important to
me. The help files are quite good but I cannot find any decent examples for
what I want to do.

Harry.


**********************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


**********************************************************************

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug