| Alex White MCDBA MCSE 2005-05-16, 7:24 am |
| Hi Julia,
The command that you issued does nothing because there is nothing to return
the data into
you need something like
dim adoTest as new adodb.recordset
dim myValue as string
With adoTest
.open "Select * from
SystemSettings",currentproject. connection,adOpenKey
set,adOpenDynamic
if .recordcount > 0 then
myValue = .fields("yourfield").value
end if
.close
end with
the above will need changing to your relevent details.
--
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Julia" <Julia@discussions.microsoft.com> wrote in message
news:D6456A58-9E97-49B8-8FDB- 7759721367D3@microso
ft.com...
> Hi,
> this is my first time using Access so I have a basic question. I need to
> get
> some informatino from the database and I tried this in a module:
>
> DoCmd.RunSql "Select * from SystemSettings"
>
> ... this doesnt work. How do I do this? Is there a web page for beginners?
> Thanks
> Julia
|