VB & ACCESS
16 April 2002, 09:55 PM
#2
Scooby Regular
Join Date: Jun 2000
Posts: 3,783
Likes: 0
Received 0 Likes
on
0 Posts
you can build database through various levels of abstraction...
-manually with forms
-macros
-hand coded with visual basic
check out access help and look through access basic or whatever they call it. Basically its just interrupt driven vb.
sounds like you need a good book mate
-DV
-manually with forms
-macros
-hand coded with visual basic
check out access help and look through access basic or whatever they call it. Basically its just interrupt driven vb.
sounds like you need a good book mate
-DV
16 April 2002, 10:04 PM
#3
Scooby Regular
Thread Starter
Join Date: Jul 2001
Posts: 1,795
Likes: 0
Received 0 Likes
on
0 Posts
The d/b is 98% done. But my uncle is trying to imlement two functions in the d/b. He needs to know how to access the tables via VB.
He has accessed the fields in VB via the forms, but not sure how he would access the tables directly, instead of going throught the forms.
He has never used Access, but a ace in programming.
I hope the above makes sense. Things are a bit hectic, final year project, coursework and reports to hand in next week.
He has accessed the fields in VB via the forms, but not sure how he would access the tables directly, instead of going throught the forms.
He has never used Access, but a ace in programming.
I hope the above makes sense. Things are a bit hectic, final year project, coursework and reports to hand in next week.
16 April 2002, 10:17 PM
#4
Scooby Regular
Join Date: Jun 2000
Posts: 3,783
Likes: 0
Received 0 Likes
on
0 Posts
what is he trying to implement ?
its all interrupt driven eg...
on form_open (formname)
[perform task here]
or
on button_click (mybutton)
[perform task here]
or
on keypress (keycode)
[call function code here]
you can write your own custom functions and call them when certain interrupts occur like I've shown above - open one of your forms and goto the view source command on the menu in design mode.
its all interrupt driven eg...
on form_open (formname)
[perform task here]
or
on button_click (mybutton)
[perform task here]
or
on keypress (keycode)
[call function code here]
you can write your own custom functions and call them when certain interrupts occur like I've shown above - open one of your forms and goto the view source command on the menu in design mode.
16 April 2002, 11:59 PM
#5
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
Are you talking about using the vb that comes with access??
or the product "Microsoft Visual Basic" What are you trying to do with the table? Ie. If you can query the field why do you need to access the table??
David
or the product "Microsoft Visual Basic" What are you trying to do with the table? Ie. If you can query the field why do you need to access the table??
David
Trending Topics
17 April 2002, 01:09 PM
#11
Scooby Regular
Join Date: Oct 2001
Posts: 65
Likes: 0
Received 0 Likes
on
0 Posts
Use recordsets to access tables/queries from code.
e.g:
Dim db as database
dim rs as recordset
dim sSQL as string
set db=currentdb()
ssql = "SELECT table1.* FROM table1"
set rs=db.openrecordset(ssql)
DO ACTIONS ON THE DATA
rs.close
db.close
There is more on this in the help files.
Martin.
e.g:
Dim db as database
dim rs as recordset
dim sSQL as string
set db=currentdb()
ssql = "SELECT table1.* FROM table1"
set rs=db.openrecordset(ssql)
DO ACTIONS ON THE DATA
rs.close
db.close
There is more on this in the help files.
Martin.
17 April 2002, 01:32 PM
#12
Scooby Regular
Thread Starter
Join Date: Jul 2001
Posts: 1,795
Likes: 0
Received 0 Likes
on
0 Posts
Thank u for all the replies/help
David-
My uncle wants to access the tables directly via VB. For example access the members or video table. But I think Martin's comments has given us a solution to the problem.
[Edited by Vinesh - 4/17/2002 1:39:42 PM]
David-
My uncle wants to access the tables directly via VB. For example access the members or video table. But I think Martin's comments has given us a solution to the problem.
[Edited by Vinesh - 4/17/2002 1:39:42 PM]
Thread
Thread Starter
Forum
Replies
Last Post