export table to excel using template Results


Page 1 of 3.
Results 1...20 of 43

Sponsored Links:



Hello - I would like to export a table or query (using Access VBA) to excel 2007, using an excel template (for headings, formatting, totals, etc).

Is this possible?




Hi ,

I have a linked ORACLE table in Access 2000 with a date "mydate" of type "Date/time"

I have built a simple query which selects mydate.
the query output shows as mydate as e.g. "6/23/1997"

1. If I export this query to Excel using "output to" in a macro
the same date is displayed as "23-jun-97"

Although if i try to change it it reverts to the format "6/23/1997"
and then goes back to displaying "23-jun-97"


2. I tried using Format([mydate], "mm/dd/yyyy")
Then if i export it to Excel, i cannot sort or change the date format as it is now a text string instead of a date

3. I also tried CDate(Format([mydate], "mm/dd/yyyy"))
but it yields the same results as option 1.

4. I created a excel template ( which i really don't want to do 'cept as a last option) myfile.xlt and used it in the options for outputTo .
It does not seem to have any effect on the data.

Really need some help right now !
Thanks,
Gina.


bit




First of all thanks to all posters on this forum. Though this is my first post I've already used quite a bit of answers/ example code here to solve issues in the database I'm working on.

But on this one I could not find the answer. As such my question here:

Background:
I'm hired within a project which has the goal of migrating 45000 computers to a new platform: Windows 7 with Office 2007.
For this project I manage the informationdatabase containing details on all in scope components (Computers, Useraccounts, Applications, Authorizations, etc)

The migration will be planned by clusters. A clusters is a subset of the scope based on either location, department or mixture of both. Such a cluster is assigned to a clustermanager who will be responsible for a succesfull migration.

Each clustermanager now has an information need on it's cluster. As such Users are now assigned to a clusterID.
Using query's a total of 7 views can been created. (Each query has a variable parsed containing the ClusterID).

The Clustermanagers like to have these views in a Excelsheet. with every view on a different sheet. For this a template has been created.

Of course I want this sheet to be created with a single click .

My challange
As I need to control how the data is exported I want to use automation to export the data.

However this method requeries the use of a recordset. Of which a parameter needs to be either the name of a Query or Table:

Code: Set rst = dbs.OpenRecordset("QueryOrTableName", dbOpenDynaset, dbReadOnly) In a simple query where no variable is used There is no issue for this.
However I want to have the ClusterID (Which is a variable in all Queries) to be passed into the query.

As such I tried to contentate the query using VBA to a string called strSQL. I then want this string to be captured by a Querydef called qdf. So I would have a query I can call by name right.

I thought I could then parse this Querdef into the Recordset as a Query.

Is this in anyway possible? And if so how would the syntax be for the Recordset. My Querydef is:

Code: Set qdf = dbs.CreateQueryDef("Query", strSQL) My syntax for setting the record is:

Code: Set rst = dbs.OpenRecordset("QueryOrTableName", dbOpenDynaset, dbReadOnly) If it is not possible to use a QueryDef in the recordset I would like to know alternatives to accoplisch what i want which is:

Exporting data to excel with control on where what is passed in the Excel sheet using Queries to fill the sheets where the querie has a variable in it.

Thanks a lot in advance for your reply.




Please help!

I have two databases.

The first database contains all the ODBC links, queries, and creates local tables to be used in the first database.

The second Database uses a form imports the tables from the backend, queries those tables to a specific customer, creates new tables and exports those tables to excel for field use.

The reason for the import into the second table is that sometimes the users are in the field and our VPN security is so tight that it would be too slow to query off the system.

I am dealing with several customers, and now I am getting occasional calls about the database erroring or timing out. I am needing help to correct this action.

Steps I have taken so far:
I have run the analyzer and made the changes except for relationships.
I have set the frontend to compact and repair on close. (Very slow also)
I have convert make table queries to Delete + Append.

The database is about 813,500 KB in size. It is very frustrating.

Also, occasionally, the tables in excel will not be replaced. It will be data from the old customer. I am exporting to a template xlsm file.

It is frustrating trying to field these questions constantly. Any help on either topic would be greatly appreciated.




Dear frens,

I have successfuly exported a Namelist inside a query Table into an existing excel file but it creates a new worksheet and the data is dumped there.

what if I want to export the data to a named worksheet (already in the existing excel file) and the appropriate cells too eg. A3: A23

Here's the code i have so far ... Feel free to take a look or use...

Thanks in advance for any help ...

Private Sub TransferNameListToExcel_Click()
Dim fileName As String
Dim result As Integer
Dim MyXL As Object
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Select Excel File to export Name List to"
.Filters.Clear
.Filters.Add "All Files", "*.*"
.Filters.Add "Excel", "*.xls"
.Filters.Add "Excel Template", "*.xlt"
.FilterIndex = 3
.AllowMultiSelect = False
.InitialFileName = CurrentProject.Path
result = .Show
If (result 0) Then
fileName = Trim(.SelectedItems.Item(1))
DoCmd.TransferSpreadsheet acExport, , "Evaluasi Query", fileName
Set MyXL = GetObject(fileName)
MyXL.Application.Visible = True
MyXL.Parent.Windows(1).Visible = True
End If
End With
End Sub




Hi,

I run a make-table query which saves the data I require to a table called "tempcsv".

I can manually export this to a csv file - however I have tried two different methods to do this automatically, however both have errors - if anyone could help me to solve either one then I would be very thankful.

The first method I tried was a Macro using the Outputto method, here is what the macro looks like:

(Outputto)
Object Type: Table
Object Name: tempcsv
Output Format: MS-DOS Text (*.txt)
Output File: C:Documents and SettingsDean RoweDesktoptempcsv
Autostart: No
Template File:

However if I open the file using notepad it comes out like this:

---------------------------------------------------------------------------------
| Total Selling inc | Customer Name | Customer Address | Customer Postcode |
---------------------------------------------------------------------------------
| 366.60 | Test Name2 | la la land | NN4 6AF |
---------------------------------------------------------------------------------

and if I open it using excel it has a similar appearance.

I've tried changing the output format to: Microsoft Excel (*.xls)
If I open it in notepad then it appears like this:

         +   )   ,   *     !P    "x AI    "x @,I,    +| @,I,

and if I open it in excel it has the field headings above the data, which I dont want to appear.

So I tried a different Macro, using the TransferText option:

(TransferText)
Transfer Type: Export Delimited
Specification Name: temp csv export {I created this when I successfully exported the table manually}
Table Name: tempcsv
File Name: C:Documents and SettingsDean RoweDesktoptempcsv
Has Field Names: No
HTML Table Name:
Code Page:

However when I run the macro, the following error occurs:
"Cannot Update. Database or Object is read-only"

If anyone could help me or provide any advice then I'd appreciate it very much, I can't think how to get around this problem.

In case there is any confusion, I'm trying to output a table which contains 1 row of four fields so the outputted file looks like this:

[Field One],[Field Two],[Field Three],[Field Four]


Thanks again

Dean Rowe




Is there any way to export a pivot table from access to Excel? I have a couple Excel templates that I paste the pivot table results from access into and it populates the data in a format I need for some slides. I've tried a crosstab query but it's not a option. Is there any way to use vba to export a pivot table view of a table or query to Excel? Thanks




I am currently running a VBA script that imports my Access 2007 table into Excel. I have set it up to import to a sheet in my workbook called 'Data'. In the main sheet, where the calculations are done, I use a sumproduct formula to find and calculate values from the 'Data' tab. In this way I can preserve the standard formatting that is used in the report I am generating.

I would like to find a way in VBA to export the Access data directly into my Excel template without having to store the data in a separate sheet. When I diseminate the report I do not want the data visible to the viewers. I also do not just want to 'hide' the sheet.

Is there a way to do this in VBA? Also, I am looking for something relatively simple. I have heard rumors that there is a simple few lines of code I can add to achieve this.

Thanks,
Alex




I am using

	Code:
	 
Dim xlApp As Excel.Application
    Dim xlWB As Excel.Workbook
    Dim xlWS As Excel.Worksheet
    Dim acRng As Variant
    Dim xlRow As Integer
 
    Dim qry As QueryDef
    Dim rst As Recordset
    Set xlApp = New Excel.Application
    Set xlWB = xlApp.Workbooks.Open(Me![txtExportFile])
    Set xlWS = xlWB.Worksheets("WORKLOAD")
 
    xlRow = (xlWS.Columns("A").End(xlDown).Row)
 
    Set qry = CurrentDb.QueryDefs("queryERCIC")
    Set rst = qry.OpenRecordset
 
    Dim c As Integer
    c = 12
    xlRow = xlRow + 1
 
    Do Until rst.EOF
        For Each acRng In rst.Fields
            xlWS.Cells(xlRow, c).Formula = acRng
            c = c + 1
        Next acRng
        xlRow = xlRow + 1
        c = 1
        rst.MoveNext
        If xlRow > 1000 Then GoTo rq_Exit
    Loop
 
rq_Exit:
    rst.Close
    Set rst = Nothing
    Set xlWS = Nothing
    xlWB.SaveAs "J:InspectionTQAPublicDatabasesWIPWorkloadProcessor" & Me![txtQuarter] & "-ERCIC.xls"
    xlWB.Close acSaveNo
    Set xlWB = Nothing
    xlApp.Quit
    Set xlApp = Nothing


to export a query into an excel template. In my table that the query pulls the data from the field is defined as a number, but when I export to excel, the numbers are not stored as numbers, but as text... Is there a way to fix this?





EDIT:
I fixed it by using

	Code:
	Private Sub Workbook_Open()
    Range("N12:P1012").Select 'specify the range which suits your purpose
    With Selection
        Selection.NumberFormat = "General"
        .Value = .Value
    End With

End Sub

In the template....




I'm running Access 2010. I have a macro which exports my table "tbl_orders" as an excel file called "orders.xls" (I'm exporting for graphing purposes).

The details are:
ExportWithFormatting
Object Type: Table
Object Name: tbl_orders
Output Format: Excel 1997-2003 .xls
Output File: ???
Auto Start: Yes
Template File:
Encoding:
Output Quality: Screen

In the "output file" field, if I just write "orders.xls" as the location of the file, it gets save to my docs. if I type "oders.xls", it gets saved to C:

Is there any way I can get this exported spreadsheet to be stored in the same folder as my access database, no matter where the database is? The reason for this is that I use it on my laptop and on my work PC and lots of other people will be using it if it proves useful, so keeping everything "relative" would make it easier for us to use and transfer without having to change paths etc.

Thanks a lot.




I haven't used 2007 hardly at all, so my wish list is based on what I see in 2003.
VOTE HERE:
http://spreadsheets.google.com/ccc?k...Nb6tVOWA&hl=en


All suggestions so far, with number of people who voted for each one:
FORMS/CONTROLS/INTERFACE:
-Bound treeview and listview controls, or at least wizards to assist with the loading
-Ability to show different image for each record in a continuous form (1)
-Ability to change color and/or shape of command buttons
-Provide more configuration options to tweak the behavior, even if it has to be done with a CLI, *ESPECIALLY* for ODBC/OLE DB behavior and bound form behavior (e.g. saving early or late, etc) (1)
-Allow for form and control templates
-Better tab control (e.g. transparent ones *and* using Windows Theme for example)
-Corollary: Make sure that Access controls inherits from Windows' controls (I understand that Access controls are just lookalikes... confirmation?)
-Restore the new look and feel in 2007 back to 2003 (1)
-Better integration with BLOB types (sound, picture, and video) with Active X controls
-Provide a means to open a .doc/.xls file directly and define fields for records graphically to simplify the automation and using Word/Excel's native functionalities with convenience of Access's bound controls. (1)
-easy interface to integrate ribbon use instead of the XML fiasco (1)
-Continuous form on a continuous form (1)
-Web integration
-Word properties in Access
-Built in or at least intuitive drag/drop functionality


QUERIES:
-Editable crosstabs (1)
-Retain formatting in SQL view of query, allow commenting
-Union queries in the QBE
-Drill down into sub-queries in the QBE (3)
-Provide a mean to use read-only query as a recordsource for a bound form/report, and a separate but updateable recordsource for inserts/updates. (1)
-Give *real* paramaterized queries/prepared statement a la Oracle/MySQL/MS SQL

MACROS/VBA:
-Completely eliminate macros as they currently exist. Adopt the Excel/Word macro paradigm (using VBA) and institute a macro recorder. Integrate Application level commands into the "macro" recorder (i.e. split a database, etc.). (2)
-Invoke the QBE within VBA and format SQL from QBE into VB ready string. And/or do a direct dump of SQL from QBE to a VB formatted string.
-Provide Application Events (e.g. OnOpen and OnExit for Access environment) (1)
-VBA commands for *everything* that you can do in the frontend, like splitting database, etc., and/or better documentation of such commands if they already exist
- update the vba code when using the command button wizard

SECURITY:
-Better security, restore ULS, provide a hook into logging so we can specify custom logging form or do some extra processing with security (e.g. authenticating for backend at same time) (1)

OTHER:
-Ability to turn mde into exe (2)
-Use different registry keys for different versions of Access so that running multiple versions doesn't cause problems (1)
-Make Access completely separate from the rest of MS Office, instead make it an Add-On to Visual Studio
-Make it fully object-oriented (1)
-Reinforce good programming habits (e.g. have a sane naming convention for starters), controls on form should have a different default name than the field names when created ... maybe using some kind of prefix such as cbo, txt (2)
-Remove the 355 byte limitation (per field) on exporting data to Excel.
-remove/hide certain features which are considered "bad practices" such as lookups at table level
-make Access much more robust with regards to networking and provide error handling for networking issues (5)
-better native database backend
-Triggers




Hi

Is there any way to export the results of two Crosstab queries into a single Excel Worksheet, specifying destinations for each fields result using VBA?

I am looking at placing the code in a buttons On_Click event so that the user doesn't have to manually copy the results into the Spreadsheet, therefore eliminating the risk of human error when sending out figures to management.

I have attached a copy of the Database and the Template Spreadsheet. The queries in the Database to be exported are "7e Completion by Manager Append_Crosstab" & "8f Progress Against Test Plan Append_Crosstab" and a quick look at the Spreadsheet should show where I want the results to go.

Thanks in advance!!! Attached Files Export.zip (375.4 KB, 9 views) Reply With Quote 09-21-2009,05:09 PM #2 hardtarget Novice Windows XP Access 2003 Join Date Sep 2009 Posts 3 Sorry I dont know the answer but you could export the data to excel then run a macro so it completes/makes the table you require?




Is there a general tutorial on the web for this kind of thing? I couldn't really find much.

All I want to do is "Kill" a specific file on a location in sharepoint, use cmdtransferspreadsheets to post data in a new excelsheet, and then save this file on the same location as the killed file on sharepoint.


I couldn't even get "Kill" to work. The code I use is "Kill 'sharepoint URL/file.xls' "

I also can't export queries to the file in mind, Status report Template.XLS

Code: DoCmd.TransferSpreadsheet acExport, , "Query", "https://sharepointsite/Status Report Template.xls", False, "TabName" Thanks




I have two problems that I would really like some help with.
1. I want to use the Create Email wizard within Access (External data > Create Email).
A. Does anyone know what templateis being used by Access when the form is exported to Outlook. The email that is sent out contains a form which I need to modify that says:

Type only in the areas designated for data entry. Your reply will be automatically processed. Therefore, it is important that the form or the message is not altered in any other way. For more information about filling out this form, see the following:

B. I tried setting up a filter and then starting the Create Email wizard, but it pulls all of the data from the table (not just the filtered data). Other than using views (which could end up being A LOT potentially dozens which would result in me creating a confusing number of buttons), is there a way to export the filtered data to a temporary table and then call/use that table for the Create Email Wizard? Or is there some other way to get the Create Mail wizard to use the filtered table?

2. Issue with Copying a field in Access. Does anyone know which Macro I could use to copy one field from a filtered table (i.e. to copy only the email address field) so that it could be pasted into Outlook from Access. I can do it from Access to Excel but it doesnt seem to work right pasting from Access to Outlook (plus if the end user didnt have to carefully select the fields it would be easier for them). I also seem to always get the header (field name) of the column/field when copying and pasting (so it has to be manually deleted). It would be a lot easier for others if they could skip the step of exporting to Excel and then copying from there to Outlook.

Any help would be greatly appreciated.
Matthew




Needing to export some query results to an excel template...I can get the query to a table and the table to the template...but it makes its own sheet in the workbook template instead of using the template sheet.

Any ideas??
Thanks.




I have a macro to export an Access table to a text file. Then I use an Excel macro to open the text file and copy/paste to an Excel template. In the Excel macro, I write a code below to close the text file:

Activeworkbook.close

The Excel prompts a standard massage with 3 buttons: save, notsave and cancel. Everytime, I click the notsave button to close the text file.

Is there a way to write some codes to bypass this standard message? What I want is to close down the text file without any change.

any idea?




Hi all who wish to help,

I have created a database that contains five different tables. Each linking to a main table through an ID.

The database opens asking for an ID. When ID is input and the relevant command button is clicked a form opens spplying details for this individual as well as any other data from the other tables in subforms.

The overall form and subforms are based on queries.

I want to export the data to excel, on seperate spreadsheets for each query which i have completed successfully using the 'Transferspreadsheet' function.

The problem here is I cannot reformat the column headings.

I would also liek the data to be exported into excel using a template so that each query has it's own worksheet but then each field is exported into a particular cell.

I have used the advice on the following link at tektips:

http://www.tek-tips.com/faqs.cfm?fid=7171

which works only for the data in the overall form. Does anybody know a way that I could use this to export the additional queries to worksheets within the same workbook and in their own cells,

Any help appreciated.

Thanks




Hi,
I'm pretty new to Access, and teaching myself as I'm going along, so any help will have to be explained in simple terms. Sorry.
To the point...
I'm trying to get access to export my tables to a new database, attach that to an email, send it and then delete the file once it's been sent. (There is a good reason for this)
Initially I had Access export the tables to an excel sheet and email it. Everything worked fine! Then I decided to change it to an Access database, and my problems began.
This is my code:

	Code:
	Private Sub OpenFormExport_Click()
Dim ws As Workspace
Dim db As Database
Dim LFilename As String
Set ws = DBEngine.Workspaces(0)
'Create new database in current folder
LFilename = CurrentProject.Path & "ExportWatwick.mdb"
Set db = ws.CreateDatabase(LFilename, dbLangGeneral)
'Export tables to new database
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatCrew", "WatCrew"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatElect", "WatElect"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatEngDataMonth", "WatEngDataMonth"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatEngDataWeek", "WatEngDataWeek"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatJobList", "WatJobList"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatMiscTab", "WatMiscTab"
DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatOOP", "WatOOP"
 
'Export via Email
Dim olLook As Object 'Start MS Outlook
Dim olNewEmail As Object 'New email in Outlook
Dim strContactEmail As String 'Contact email address
'Open Outlook
Set olLook = CreateObject("Outlook.Application")
Set olNewEmail = olLook.createitem(0)
strEmailSubject = "Watwick Data Report"
strEmailText = ""
strContactEmail = "EMAIL ADDRESS"
'strCc = "EMAIL ADDRESS"
With olNewEmail 'Attach template
.To = strContactEmail
'.CC = strCc
.body = strEmailText
.subject = strEmailSubject
.attachments.Add (LFilename)
.display
'.send
End With
'Delete File
Kill (LFilename)
 
End Sub

When I run this I get a run-time error '-2147024864 (80070020)' at
.attachments.Add (LFilename)
Help gives me this information:
Automation error (Error 440)



This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010. When you access Automation Objects, specific types of errors can occur. This error has the following cause and solution:An error occurred while executing a method or getting or setting a property of an object variable The error was reported by the application that created the object.
Check the properties of the Err object to determine the source and nature of the error. Also try using the On Error Resume Next statement immediately before the accessing statement, and then check for errors immediately following the accessing statement. The confusing point for me is that if I split the code to run from 2 seperate buttons then it works fine, as in one button to create the database, and then a sperate button to send the email. Unfortunately I need it all to happen from one button.
I presume that Access is still trying to access/edit the newly created database when it is also trying to attach it to the email. How do I force it to leave it alone? (Sorry for the terribly technical language!)
Any help would be greatly appreciated...




Can anyone post some example code for exporting a table from Access as an Excel file with a file browser?
Basically, I want to be able to browse for the path and use that string in the PATH part of the code below.
Any help would be great.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EP Import Template", "PATH" & "EP Import Template.xls", True




Was reviewing the Denver Area Access Users Group (DAAUG) and came across this excellent presentation. This is probably something that will be more in demand for the next Access version as well.
There is an excellent Power Point Slide of the presentation plus credits that include: http://www.access-programmers.co.uk/...d.php?t=196662

Access data macros are similar to Triggers in SQL Server.
Also an interesting tidbit on XML.

There are over a dozen more free Access Downloads at the DAAUG site The titles and short descriptions are listed below - the site to link to the downloads is:
http://www.daaug.org/download.asp

Access Excel Automation - 8/1/2012 From Keith Poulin's April 2012 presentation, "Access Excel Automation" This presentation will cover the basic Excel capabilities that Access provides out of the box, as well as more advanced techniques for importing flexible spreadsheet formats and producing richly formatted Excel reports.

Microsoft Access Logging - 7/31/2012 From Lindsay Wert's November 2011 presentation, "Microsoft Access Logging" Discover an approach for consistently and easily logging run-time information from Access and VBA.

Focus on Access 2010: Table Macros - 7/30/2012 From Paul Schnitzler May 2011 presentation, "Focus on Access 2010: Table Macros"

A Generic Lookup Table Editing Form - 3/2/2011 From Jim Pilcher's March 2011 presentation, "A Generic Lookup Table Editing Form"

VBA Table Wrapper Classes - 6/17/2010 Lindsay Wert's Table wrapper classes

Crystal's Analyzer... the ultimate Data Dictionary Tool - 5/6/2010 Crystal's free Analyzer application to document databases.

How to Make an Add-in - 5/5/2010 Aaron Kogan's presentation on how to make an Add-in which includes an Add-in Template.

Access 2010 Web Database Template Relationship Diagrams - 4/9/2010 Access 2010 Web Database Template Relationship Diagrams, documented by Crystal, March 2010

Search Buddy - 3/4/2010 Aaron Kogan's Search Buddy (aka 'Search Pane') from his March 2010 presentation.

Outlook Attachment Options - 3/4/2010 Outlook Attachment Options utility (from Slovak Technical Services www.SlovakTech.com/AttachmentOptions.htm). Briefly presented by Aaron Kogan during the March 2010 meeting.

Importing Excel Data - 3/4/2010 Samples from Patrick Headley's March 2010 presentation, "Importing Excel Data".

'Tips and Tricks Inspired by Student Questions' Samples - 2/8/2010 Samples from Sco's January 2010 presentation, "Tips and Tricks Inspired by Student Questions"

Disable Mouse Wheel - 1/31/2010 From Sco's January 2010 presentation, the sample from Wayne Philips' EverythingAccess.com 'A new method for disabling the Mouse Scroll Wheel in Access forms'.

Table Interface Class Builder for DAAUG - 10/12/2009 Access, PPT, and related files from Lindsay's Presentation

MSDN Access Team Contributors' Toolkit - 5/21/2009 Background info on contributing to Power Tips

Access Add-ins and Code Snippets - 4/7/2009 More of Aaron Kogan's "Little Buddies" from his Code Library

Office Automation in Microsoft Access - 1/17/2008 Phil Ferrero demonstrated several techniques for automating Microsoft Word and Excel using Microsoft Access. He also demonstrated the differen between early and late binding in VBA code. Download and run this self extracting zip file to access the files that Phil used in his demonstration.

Word Automation from Access - 11/16/2006 This zip file was provided by member Alan Ruff as part of his demonstration on automating Microsoft Word by using Microsoft Access. When you unzip the files a new folder named C:AccessAutomation will be created and the files placed in that folder. Everything will work from within that folder.

Hitting the Cycle with Outlook and Access - 4/20/2006 Mike Nindorf explained the application and processes that he built for his company to use in order to input data into Access from Outlook and then export that data into Word templates. Though he was unable to share the application with the group he has provided his presentation notes which includes code for gathering the data form Outlook and outputting it to Word.

The Access Sub-way - 2/16/2006 Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. This download contains the forms and subforms that Jim used in his presentation.

DAO Transactions - 11/17/2005 (447 KB) Demo files preapared by M.L. "Sco" Scofield for his presentation on SQL Transactions. SQL Transactions allow you to process a set of SQL commands and commit the updates or roll back the updates as a batch, instead of one command at a time. In this way, you can roll back the set of SQL commands if one or more of the individual commands fail.

Practical Ways to Use XML with Access 2003 - 10/20/2005 (1.33 MB) presented by Tim Getsch, Microsoft Access Program Manager, Redmond, WA

A One-form Application - 9/15/2005 (29 KB) "Export Access Table Structure" Add-in presented by M.L. (Sco) Scofield

Unbound Forms - 8/18/2005 (780 KB) Presented by Jim Pilcher

Upsizing SQL Server - 7/15/2004 (16 KB) Presented by Kevin Bell

Recordsets in Microsoft Access - 6/20/2002 (264 KB) Presented by Barton P. Haase.


Page 1 of 3.
Results 1...20 of 43