Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Syntax error when referencing a table in a Stored Procedure ?
Do you know how I can fix a syntax error: Error 107: the column prefix 'tblExclusion' does not match with a table name or alias name used in the query I believe this error is caused by the last line below: CREATE PROCEDURE dbo.procSpACSExcl @RptYear int AS If Exists(SELECT * FROM...- kpmvb
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Reporting Services
-
How to prevent 2 different file names from being Saved in a Word doc ?
In my Access Application using an ADP file, the user clicks on a report line titled IRA from a list box which is associated with a field value qryIRAFall. If the user selects this IRA report record from the listbox, then the paragraph IRAQueryFall gets executed in my Access application. This...- kpmvb
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to use VBA code to automatically modify an HTML type file in a Wor
I am developing an Access application and I click on a button which executes the following VBA code to open an existing HTML file in Word. --------------------------------------------------------- Dim wdApp As Object Dim doc As Object Set wdApp = CreateObject("Word.Application") wdApp.Visible =...- kpmvb
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
How to edit an HTML type file in Word from an Access Application
Let's say I use the following VBA code: ----------------------------------------------------------- Dim wdApp As Object Set wdApp = CreateObject("Word.Application") wdApp.Visible = True If Dir$("C:/UDL/Second Notice.htm") <> "" Then wdApp.Documents.Open "C:/UDL/Second Notice.htm" End If...- kpmvb
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to create an interface to create or edit a Word Doc/HTML file ?
I am developing an Access Application using an ADP file. I want to allow the user to be able to click on a button which would then cause the generating of the Windows interface for Microsoft Office Word. The user could then either (1) Create a new Word Document and save this document as ONLY an...- kpmvb
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
