G
Guest
Hope this is ok to post these here:
I'm working on what amounts to a case database. My primary tables are 1 for
cases and another for parties (case parties like defendant, plaintiff, etc).
I'm pretty new to all this stuff but mostly I just need some concept of how
to proceed that I can use to guide my focus.
1. I have basic forms for inputing the info in the primary tables. What I
ultimately want to be able to do is this: open some type of form/query,
input a party (last) name, which will allow me to choose from anyone who has
that last name (or maybe in combo box just autocomplete the first of those
names and allow me to use the arrow to get to other potential names). Once I
have the right name, I'd like the form to "fill in" the key personal info.
Basically, I want to supply some info and have the form fill in the rest
(say I provide the name and the form fills in address, phone #, organization,
etc...various info from the tblParty I have) Then in another section
(subform?) list every case that this particular person is involved with.
Finally, I'd like to be able to click on any of the cases in that (subform?)
list and open up another window with the key case info (like parties,
status, case type, etc.....stuff found in the case table).
I think it's a form with a subform (the combination of the two making what
amounts to the first screen of the process), but I don't know the basics of
what I'm putting together. Is there some calculate function I need to add so
the form knows it's time to pull up the other info after I pick/input a name
in the main form area? Is the area of my form where the cases will appear
be called a "subform"? Is there some trick to linking case names to a popup
window so I can click on a case and get the details about it?
2. The second question relates to a problem I'm having with my current
project. I've set up some basic tables, forms, reports and a switchboard
that I made thru the switchboard manager. I have two main input forms and
two reports included in the choices I have on the switchboard (so far). The
problem is, one of the forms works fine when I click on the button on the
swtichboard that makes it pop-up. When I hit the buttons on the switchboard
for the other form and/or the two reports, they each pop open, but appear
behind the switchboard window and I always get this error:
DOC - Case Database can't find the macro 'DoCmd'
The macro (or it's macro group) doesn't exist, or the macro is new but
hasn't been saved.
Can someone tell me how to get rid of that message? There must be something
different in that one form versus everything else (other form and two
reports), but I just can't find it. Can someone point me in the right
direction? It's annoying to say the least.
As part of the learning process I've opened the vb editor thing and might
actually made it do something useful once, but if the solution is in there
I'm a complete novice and would need the click-by-click guide to get me to
the right spot...
Sorry for the long questions. Thanks a ton for any feedback.
CW
I'm working on what amounts to a case database. My primary tables are 1 for
cases and another for parties (case parties like defendant, plaintiff, etc).
I'm pretty new to all this stuff but mostly I just need some concept of how
to proceed that I can use to guide my focus.
1. I have basic forms for inputing the info in the primary tables. What I
ultimately want to be able to do is this: open some type of form/query,
input a party (last) name, which will allow me to choose from anyone who has
that last name (or maybe in combo box just autocomplete the first of those
names and allow me to use the arrow to get to other potential names). Once I
have the right name, I'd like the form to "fill in" the key personal info.
Basically, I want to supply some info and have the form fill in the rest
(say I provide the name and the form fills in address, phone #, organization,
etc...various info from the tblParty I have) Then in another section
(subform?) list every case that this particular person is involved with.
Finally, I'd like to be able to click on any of the cases in that (subform?)
list and open up another window with the key case info (like parties,
status, case type, etc.....stuff found in the case table).
I think it's a form with a subform (the combination of the two making what
amounts to the first screen of the process), but I don't know the basics of
what I'm putting together. Is there some calculate function I need to add so
the form knows it's time to pull up the other info after I pick/input a name
in the main form area? Is the area of my form where the cases will appear
be called a "subform"? Is there some trick to linking case names to a popup
window so I can click on a case and get the details about it?
2. The second question relates to a problem I'm having with my current
project. I've set up some basic tables, forms, reports and a switchboard
that I made thru the switchboard manager. I have two main input forms and
two reports included in the choices I have on the switchboard (so far). The
problem is, one of the forms works fine when I click on the button on the
swtichboard that makes it pop-up. When I hit the buttons on the switchboard
for the other form and/or the two reports, they each pop open, but appear
behind the switchboard window and I always get this error:
DOC - Case Database can't find the macro 'DoCmd'
The macro (or it's macro group) doesn't exist, or the macro is new but
hasn't been saved.
Can someone tell me how to get rid of that message? There must be something
different in that one form versus everything else (other form and two
reports), but I just can't find it. Can someone point me in the right
direction? It's annoying to say the least.
As part of the learning process I've opened the vb editor thing and might
actually made it do something useful once, but if the solution is in there
I'm a complete novice and would need the click-by-click guide to get me to
the right spot...
Sorry for the long questions. Thanks a ton for any feedback.
CW