Re: Macro
What database are you used to? Something like Oracle? Helps a little
to have a frame of reference, that's all.
What are you trying to do in the form? Do something like an invoice
where you can add line items? If you don't have a copy of
Northwind.mdb, you can download it from MS's website. it has a
functional database that does this kind of thing, complete with forms,
reports, macros and the whole nine yards. Some people here hate it and
think it's hideous, but it does work (at least to some degree).
Sounds like you want a main form (Invoice) with a subform (LineItems)
in it.
.
Relevant Pages
- Re: Using two columns as a primary key
... I have a database of my own records which are invoices I work on. ... These invoices are from four companies with their own invoice ... reference each record. ... include the company code as part of the number (either as text or as ...
(comp.databases.ms-access) - Re: Using two columns as a primary key
... I have a database of my own records which are invoices I work ... I cannot key by invoice number because ... using a created index to reference each record. ... number and include the company code as part of the number ...
(comp.databases.ms-access) - Get value from another table
... I have 2 database tbl_inv and tbl_coursePayment ... Invoice No which obtain the value from tbl_inv.no + 1 as a New Course Payment ... would somebody give me some example code for my reference. ...
(microsoft.public.access.formscoding) - cdt glossary 0.1.4
... This glossary seeks to limit lengthy misunderstandings ... basic database research and mathematics. ... When context matters, it is provided. ... It is /not/ the same as a reference. ...
(comp.databases.theory) - RE: MSOWCF Dll File
... Tom, Thanks again. ... > options and any required references that were checked in the source database. ... > Data to create new linked tables, instead of importing existing linked tables. ... > fine without the reference. ...
(microsoft.public.access.setupconfig) |
|
