While the people who lurk this newsgroup are pretty generous with their time
and expertise there is a group; microsoft.public.access.gettingstarted that
is just for people getting started with Access. There are several
microsoft.public.access.YourInterest groups.
It is recommended that you post a request for the solution to a single
technical problem you're trying to solve rather than omnibus "please teach
me Access" kinds of posts.
People are more than willing to help others who are making an effort to
solve their own problems and who have run into a brick wall.
If you are unfamiliar with Access and also unfamiliar with relational
databases you'll have kind of a steep learning curve ahead of you. Once you
break through it it will all be worth while. There are lots of books that
could help you make the transition. You are fortunate that you are already
a programmer of VB. It's the core language of all the MS Office apps. Lurk
your closest Barnes & Noble or Borders bookstore and look for Access for
Dummies (no slur intended), Beginning Access [yourversion] VBA by Smith and
Sussman, Access [yourversion] Step by Step from Microsoft Press. There are
others ...
Just as the object models are more of a chore than VBA in Word and Excel,
the same is true in Access.
Yep, Access doesn't provide a "record macro" function. In fact, I recommend
that you decide early on to avoid the use of Macros in Access as much as you
can. In the other Office applications, macro just means VBA code. In
Access there is a whole different paradigm of coding called Macro.
Read some books. Understand what "normalization" is all about. Later
you'll understand why normalization is so important. Lurk the newsgroups
and learn from the questions others are posting and answering. Another
extremely valuable resource is
www.mvps.org/access It has lots of Access
lore and links to other useful sites.
See some responses inline with your post below.
HTH
--
-Larry-
--
"Volumstein" <vo********@yahoo.com> wrote in message
news:7d**************************@posting.google.c om...
Hello,
I am spoiled coming from programming in word and excel which
offer the "record macro" tool that eliminated most basic syntax
confusions that I had. unfortunately msaccess doesn't offer that
option, and my luck in the groups has yielded little results for
manipulating tables via vb code in a form. Could anyone illustrate a
few examples for me?
1.) How would I Modify a specific cell in a table called "Mytable?"
And if possible could you show me two examples. one from inside an
Access form in the current project
It isn't a "cell", it's a "Field". In the textbox in your form which
displays the content of that field, change the value. When the record is
saved the new value is stored in the table.
and one from "outside" (no current project) of Access?
No
2.) What is the syntax for refreshing an open form?
Me.Refresh
3.) And how would I delete an entire column or row from a table?
Click the record selector on the left side of your form and then hit the
Delete key. Usually you'll just be asked if you really want to delete the
record and you'll indicate you do and will succeed but this record may be
participating in relationships and that's something else. :-)
Any direct help or reference of-course recieves a thanks in advance.
Thanks,
bp