Re: Adding Multiple Rows to a Table in a Word Form

Tech-Archive recommends: Speed Up your PC by fixing your registry

Greg,
I am going to try this one more time. I have submitted a reply twice.
For some reason, I am getting a notice that it is submitted, but it
never shows up.

Anyway, your suggestion does not appear to work for me. For some
reason it changes my focus to a table above my current one (the first
one in my section). I would work to correct this issue, but it still
ends up in the second cell of the row, and not the first.

I then tried to 'pause' the macro in a variety of places. I used the
first two of Microsoft's suggestions.
http://support.microsoft.com/kb/q162150/ -- "How to Implement a
Delay in Visual Basic for Applications"
This did not appear to have any discernable effect.

I did want to reply, because you requested. I believe the issue is
with my system / configuration so I will not worry about this issue any
further.
__________________________________________________________________________________________

After some thought I realized that I need to have the ability to delete
rows. I am working on having it delete all rows that do not have any
data in the first cell (text formfield). If I am able to complete
that, I will post it as well.

I am trying this approach for two reasons.
1. In case someone accidentally runs the macro (from a macro field at
the top right of my table), I don't want to accidentally delete data.
2. Even if I delete it one row at a time, it is still (remotely)
possible to delete data. If my approach can be created, it will
prevent any deletion of data.

I am taking one additional precaution by ensuring that the macro only
affects the correct table, by going to a bookmark first. I have
enclosed the start of my macro below. "It was using the 'lastrow'
command, but I will have to change that.

Thanks again for all of your help.
Keith

.

Relevant Pages

  • Re: Malcolms new book - Chapter 1 review
    ... Malcolm McLean wrote, On 08/08/07 23:01: ... that reason that it should be named 'CLAMP' rather than 'clamp'. ... a macro at all. ... Not, in my opinion, a good reason for going against long established conventions. ...
    (comp.lang.c)
  • Re: Adding Multiple Rows to a Table in a Word Form
    ... The most significant change is added row formfield naming. ... For some reason, I am getting a notice that it is submitted, but it ... ends up in the second cell of the row, ... I then tried to 'pause' the macro in a variety of places. ...
    (microsoft.public.word.vba.general)
  • Re: Adding Multiple Rows to a Table in a Word Form
    ... Sub DeleteLastRow() ... For some reason, I am getting a notice that it is submitted, but it ... ends up in the second cell of the row, ... I then tried to 'pause' the macro in a variety of places. ...
    (microsoft.public.word.vba.general)
  • RE: Declarations variables, Dim, some guidance please
    ... Good coding practice is to use global or module level variable declarations ... The big reason is that it makes the code very ... The only reasons that I ever use Globals are: ... > the macro I was testing. ...
    (microsoft.public.excel.programming)
  • Re: [patch 2/6] epoll keyed wakeups v2 - introduce new *_poll() wakeup macros
    ... It references its first arg three times. ... Is there any reason why we can't implement this in C? ... that was a macro in the first place). ... which would provide typechecking of the first arg (so people can no ...
    (Linux-Kernel)