Re: Tricky Delete Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I can't think of a way to do this with a query. It would require some VBA
code to permanently delete the column.

I'm not being critical, but this seems like something that wouldn't be done
in a database. Can you describe why you feel the need to do this? Also,
what version of Access are you using?


"Ida" <idta@xxxxxxxxxxx> wrote in message
news:1132199843.655598.91780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks for the help. Yes I only want to delete column 5. And in the
> example you just created, lets say there were 10 more columns after
> column #5. And all 10 columns had NO data. Then I would want to delete
> column #5,#6,7,8,9 and 10 too.
>


.

Relevant Pages

  • Re: Merging content from access
    ... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • Re: Merging content from access
    ... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
    (microsoft.public.word.docmanagement)
  • Getting Started with VBA and Access
    ... stored in the database. ... >unable to get any traction with the VBA code necessary to ... >NumField3. ... >(Obviously, this is trivial to do using simply a Query, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Merging content from access
    ... I agree with you that Word VBA is a more elegent solution. ... The word merge was getting complex because I had a simple access query to ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • Re: Merging content from access
    ... The word merge was getting complex because I had a simple access query to give me tblRequirements and tblNotes linked by an requirement ID field. ... I've changed this by creating an access query and vba function that gives me the data exactly as I need it in word. ... I have one problem I'm struggling with - I have a merge field that is longer than 255 characters (the first record of the query). ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
    (microsoft.public.word.docmanagement)