Introduction

  • Thread starter Thread starter Robert A Wukich, Sr
  • Start date Start date
R

Robert A Wukich, Sr

Hello Everyone

I have been lurking around numerous places and finally have decided to
come out of hiding. My name is Robert and I have been using access on
and off now for about 8 months. I am active duty military and while I am
not a programmer by trade, I have recently taken on a data tracking
project for my office where I track approximately 300 marines and a
substantial amount of data in regards to each one. I have tons of
questions and was not sure what to ask at first or where to go... After
extensive research, reading, hair pulling, I am at a good point right
now where I have provided my users with a starting point. (Its not done
by any stretch, its probabally got some mistakes but I have backups
available to restore data if necessary). Right now I have all of my
tables created (About 15 of them) some of the queries, some of the
reports and most of the forms. Now I will be working on the programming
and user interface side of this database. Keeping in mind that the end
user is computer clueless and I am trying to make it as painless as
possible for them to use on their end. Hopefully you will hear more from
me but I will start with this one question... Where can I find a good
web resource for VBA with MS Access so that I can start to integrate
some code into my product...

Thanks for you time
Robert A. Wukich, Sr
Sgt/USMC
 
in message:
Hello Everyone

I have been lurking around numerous places and finally have decided to
come out of hiding. My name is Robert and I have been using access on
and off now for about 8 months. I am active duty military and while I am
not a programmer by trade, I have recently taken on a data tracking
project for my office where I track approximately 300 marines and a
substantial amount of data in regards to each one. I have tons of
questions and was not sure what to ask at first or where to go... After
extensive research, reading, hair pulling, I am at a good point right
now where I have provided my users with a starting point. (Its not done
by any stretch, its probabally got some mistakes but I have backups
available to restore data if necessary). Right now I have all of my
tables created (About 15 of them) some of the queries, some of the
reports and most of the forms. Now I will be working on the programming
and user interface side of this database. Keeping in mind that the end
user is computer clueless and I am trying to make it as painless as
possible for them to use on their end. Hopefully you will hear more from
me but I will start with this one question... Where can I find a good
web resource for VBA with MS Access so that I can start to integrate
some code into my product...

Thanks for you time
Robert A. Wukich, Sr
Sgt/USMC
Click to expand...

Hi Robert,

Welcome to the wonderful world of Access. You have definitely come
to the right area for Access resources, help, and support. You will
be overwhelmed by the generosity of many people in these newsgroups.

Your one stop shopping area for Access information:

http://www.ltcomputerdesigns.com/JCReferences.html#Tutorial

That should get you going.

BTW, thank you for doing what you do.
 
Start with an "English" discription of what your user interface would look
like. Post that here and I will bet someone will provide anything from "air
code" to 'fully implemented code' to accomplish what you want. VBA is
actually a very easy programming language to learn. There are lots of
example code out there. Looking through how someone else accomplished a
task similar to yours will lead you to the code you need to write.


That said you can build a rich user interface without a single line of code,
just using forms and the button wizard to link them together. Take a look
at the 'tab control' it allows you to place subforms and/or more detail
fields on the page in a logical manner.

Simple example of an "English Description"

I have 300 marines. I want the user to start with a list showing only the
marine' last name and first name, and paygrade. When the user double clicks
on the record for a specific marine, I want a detail form to (open (just
open the form), or popup (stays on top), or open modal (can't go to another
form until it is closed). Once the detail form is open, if the user clicks
on a different marine in the 'marine list form' then the detail form moves
to the newly selected record.
(your vision of how the interface really works will vary)

The above is enough for the experts around here to provide some real help.

Post questions, work, learn, post questions (repeat until done)

Look forward to your posts

Ed Warren.
 
Back
Top