access query that uses visio to draw data link analysis flowchart

MS Office Access

    Sponsored Links


  • 1. automatically naming the new tables I'm creating automatically...
    Hi, I've found a script on-line (it appears in several places) that automates importing all excel files in a given folder into access. The problem is, I want each table to be imported AS A SEPARATE TABLE in access, and have each table be named after the excel file it was imported from. Here's the script: Sub sImportExcel() Dim strPathFile As String, strFile As String, strPath As String Dim strTable As String Dim blnHasFieldNames As Boolean blnHasFieldNames = True strPath = "C:\WS\Scratch\MAPSS_temp\CUR\" ' Replace tablename with the real name of the table into which ' the data are to be imported strTable = strFile strFile = Dir(strPath & "*.xls") Do While Len(strFile) > 0 strPathFile = strPath & strFile DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ strTable, strPathFile, blnHasFieldNames strFile = Dir() Loop End Sub As you can see, I've attempted to cause the program to name the new tables after their excel counterparts by using the strTable = strFile statement... but that causes a Run-time error (code = 2495, "The action or method requires a Table Name argument)... so I'm at a loss... I did try just doing strTable = "test" and it seems like every excel table in my folder was copied into just one acess table called "test". I have to do this on many, many files, so can someone help me??? Thanks!
  • 2. >> sql trigger
    Hi using Access 2003 and SQL 2005. In sql a record update will run a trigger. However in an Access UI when a user updates a field (of an existing record) with the trigger active and the record saves, the value is cleared from the field. When the trigger is disabled in sql, the value is retained/saved. The question is therefore, should sql triggers work for an Access UI? If 'yes', any ideas/suggestions for me to investigate would be appreciated :-) Many thanks, Jonathan
  • 3. Button to open sub-form and follow main
    On Form1, need a button that will open Form2, link Form2's formID field to Form1's formID field, and follow Form1 as the records are scrolled. Form2 being much like a sub-form, only not embedded into Form1 - just pops up and "follows" when necessary. A simple code routine would be sincerely appreciated. Thank you, - Mike
  • 4. Access Template for People Helping People
    Hi, I've been tasked in setting up an intake Access database and would like to know you have a template for this use. Please reply to XXXX@XXXXX.COM . Thanks so much.

Re: access query that uses visio to draw data link analysis flowchart

Postby TC » Thu, 05 Jan 2006 18:26:35 GMT

You want to pull data from a table as an Access report to automatically
create a flowchart?

I have hundreds of tables in dozens of databases, but I have no idea
what it would mean to "create a flowchart" from any of them!

You'll have to be clearer in what you require. Remember - we have /no
clue/ what you are talking about, except for what you write in your
post. There is no auomatic or common sense relationship between tables
and flowcharts, which would let us guess what you want.


Re: access query that uses visio to draw data link analysis flowchart

Postby RD » Fri, 06 Jan 2006 08:39:03 GMT

I seem to recall that in some past iteration, Access and Visio could talk to
each other.  I could design a database in Visio and import the flowchart like a
schema into Access.  In the other direction, I could export the relationships of
an existing db into Visio which was nice for documenting the project.

I wish MS hadn't eliminated that functionality.  I kinda miss it.

Re: access query that uses visio to draw data link analysis flowchart

Postby Tim Ferguson » Sat, 07 Jan 2006 02:38:46 GMT

RD < XXXX@XXXXX.COM > wrote in

That was Visio Enterprise edition: for all I know it still does it. 

There are any number of ER modelling programs on the market, some 
expensive and some cheap, and most of which will read and write to a jet 
mdb. Have you tried googling? These come to mind:



but there are lots more. 

Hope that helps

Tim F

Re: access query that uses visio to draw data link analysis flowchart

Postby RD » Sun, 08 Jan 2006 01:19:57 GMT

On Thu, 05 Jan 2006 09:38:46 -0800, Tim Ferguson < XXXX@XXXXX.COM >

Ah!  That would explain why I haven't seen it in a while.  I haven't had
Enterprise Edition in a long time.

Thanks for those links, Tim.  Both products look very interesting.


Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 71 guest