Recent content by DenMiller57

After much hair pulling, I determined that I needed to try a repair on the Office installation and that fixed the Message code. It also eliminated another problem I was having in another procedure which was telling a query was corrupt regardless of whether it was a query or an SQL statement...

Here are the Reference Libraries the program uses. Visual Basic for Applications Microsoft Access 16.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft Runtime script Microsoft XML v3.0 Microsoft Outlook 16.0 Object Library Microsoft Word 16.0 Object Library

I have some Access VBA code that creates an Outlook object and attaches a few documents to it, then displays the email in Outlook ready for me to click the Send button, after reviewing the attachments. This code worked great for many years under Office 2010 and Office 2013. I purchased a new...

The code is written in VBA in a web page. I will look for the correct forum.

I have a web page which uses a form to display and lookup data from a database table. The user enters a Student ID then clicks on a lookup button which looks up the details of their account from a database table. If a match is found in the table, I assign the results to the textboxes in the...

Automation One more bit of Info that I omitted. I am Office 2002.

I am attempting to send data from an Access form to a Word document using VBA code. The code creates a new document from a word template and has bookmarks where I need to place the data. This technique is defined in the KB article http://support.microsoft.com/kb/313193 It does not work. I get...

Thanks for replying. I am using sheet indices not names, such as Set xlWsMel = xlWb.Worksheets(1) Set xlWsERD = xlWb.Worksheets(2) Set xlWsRCPT = xlWb.Worksheets(3) I dont think the cells have any locks or conditional formatting. The Sheet is not locked, or...

I dont know if the cells are formatted so nothing can be written to them. What I have found is: I can post to the third WS using code. I can also type text into the cells of the second ws which wont accept text by code. I have also found I can auto retrieve data into the second WS if I post it...

Final note. The problem is not with the code, but with something in the formatted destination SS. The code post fine to a blank SS. Dennis

Have also tried using an ADO recordset with the following code, same results, posts to Sheet 1 but not sheet2. I think the problem is in the Excel code, but I'm very new to using Excel specific code. Here is ADO code, if it helps Dim rst As New ADODB.Recordset Dim strDB As String...

I cannot send to the second worksheet in Ex. The following code works great sending to sheet 1, but I get an undefined error with page 2. I have tried to use the activate method before posting. Here is the code that works. Im DOA, is that the problem? Dim DB As Database Dim rst As...

Here is some code I got working to send data to the first worksheet in a workbook. The code does not work on the second worksheet and I dont know why. Dim DB As Database Dim rst As Recordset Dim xlApp As Object Dim xlWb As Object Dim xlWsMel As Object Dim xlWsERD As...