Structured Parts Lists

[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

 

[Van T. Dinh]

Try The Access Web article :

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

--
HTH
Van T. Dinh
MVP (Access)

Hi
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.

 

[PC Datasheet]

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

Hi
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.

 

[Alec James]

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

subdirectories). I want to store

 

[Van T. Dinh]

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.