Structured Parts Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H
I'm looking for some tips and/or a tutorial that will show me how to design a database that stores structured parts lists.
e.g. An assembly is made up from parts and other assemblies (in the same way as a PC directory contains files and subdirectories). I want to store the parts and assemblies in the database so that I can produce reports showing parts and assemblies within an assembly to a chosen level
Thanks for any pointer
AlecJ
 
Try The Access Web article :

http://www.mvps.org/access/modules/mdl0027.htm

--
HTH
Van T. Dinh
MVP (Access)



AlecJ said:
Hi
I'm looking for some tips and/or a tutorial that will show me how to
Click to expand...
design a database that stores structured parts lists.
e.g. An assembly is made up from parts and other assemblies (in the same
Click to expand...
way as a PC directory contains files and subdirectories). I want to store
the parts and assemblies in the database so that I can produce reports
showing parts and assemblies within an assembly to a chosen level.
 
Contact me if you would like my help!


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AlecJ said:
Hi
I'm looking for some tips and/or a tutorial that will show me how to design a
Click to expand...
database that stores structured parts lists.
e.g. An assembly is made up from parts and other assemblies (in the same way
Click to expand...
as a PC directory contains files and subdirectories). I want to store the parts
and assemblies in the database so that I can produce reports showing parts and
assemblies within an assembly to a chosen level.
 
Thanks for this link, this shows me exactly where to
start. However I do have a VB problem when trying to
follow it. I'm using Access 2000. I have built up a
project with several tables and forms. I can enter and
view my data - no problems.

I then created a module and pasted the VB from the article
below into it. I made a form with a combo box that has an
event (on click) that calls my module and passes the combo
box selection as a parameter. (As in the article below)

When my module is called I get a compile error in my
module "User defined type is not defined". I removed all
the code from my module and replaced it with

sub Mytestfn()
dim db1 as Database
end sub

The line "dim db1 as database" also causes "User defined
type is not defined". When I enter "dim db1 as" the
intellisense type list does not include "Database".
I created a new database with just the form and the module
and it works fine?

I tried "Compact and repair database" in case wy project
was in some way corrupt but this made no difference.
I don't understand what in my project causes "Database" to
be an undefined type.
Any suggestions gratefully received
Thanks Alec




-----Original Message-----
Try The Access Web article :

http://www.mvps.org/access/modules/mdl0027.htm

--
HTH
Van T. Dinh
MVP (Access)



show me how to
design a database that stores structured parts lists. assemblies (in the same
way as a PC directory contains files and
Click to expand...
subdirectories). I want to store
 
The code was written using Objects from DAO Library so you need to add the
Microsoft DAO 3.6 Library into the References Collection of your database.

The References Dialog can be accessed from the VBA window through the Menu
Tools / References...

While you in this dialog, remove the Microsoft ADO 2.x Library from the
References if you are not using ADO. If you leave ADO 2.x Library in the
References and you use the Recordset Object, make you disambiguate the
Recordset declaration like :

Dim rst As DAO.Recordset

or

Dim rst As ADODB.Recordset

since both Libraries have the Recordset object but DAO Recordset and ADO
Recordset are NOT compatible.
 
Back
Top