Re: Access 2007 Mehrwertige Felder updaten

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hallo Peter

quoting Peter Doering:

Die versteckte Subtabelle, in der die Werte angeblich tatsächlich
gespeichert werden, finde ich leider nicht :-(

Die ist auch nicht zugaenglich, zur Zeit zumindest.

DAs stimmt so nicht ganz. Diese ist schon zugänglich, muss aber zuerst über eine Query sichtbar gemacht werden. Die Tabelle selber ist an der Oberfläche Tabellen-Container nicht sichtbar, aber per VBA kann diese sehr wohl über die TableDefs Collection ermittelt werden. Und dann können auch die Detaildatensätze ausgelesen werden, zumindest eben in einer Query.

Gruss
Henry


--
Keine E-Mails auf Postings in NGs senden!
KB: http://support.microsoft.com/default.aspx
FAQ: http://www.donkarl.com (neu mit Suchfunktion!)
OH: Online Hilfe von Microsoft Access (Taste F1)
Downloads: http://www.dbdev.org

.

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)
  • Re: Form Advice Relating to Queries
    ... books, Mastering Access 2002 Premium Edition, Access InsideOut 2002 by Helen ... For more complex queries, use vba programming..... ... I haven't quite worked out how to use the Query Builder via ... ... The form's RecordSource property is a string. ...
    (microsoft.public.access.forms)
  • RE: Macro
    ... The macro can be found by type Alt F11 to get to VBA and clicking on Module1 ... Then post the query results. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • Re: Form in macro to not open if query result is empty recordset
    ... basically a redisign of a previous tool that was written solely in vba. ... macro means that one will not run until the previous query has completed. ... If not all the vendors will be in your vendor list and you have RI ...
    (microsoft.public.access.forms)