Recent content by danian

When i remove the Call the line goes red i then removed the call . and still the line goes red.... .OpenDataSource("C:\connection.dsn", , , , , , , , , , , sConnection, sSQL, , , wdMergeSubTypeWord2000)

I did not write the originla code, i am trying to use the existing code on another project, so not a clue why the call is being used. Why do you ask? is it done better a different way? What do you suggest? thanks, DW

Please see attachment...

Hi, I am tring to create a Word VBA Mail Merge. I have a MySQL database that runs on a local machine and have a view setup called vwprintqueue. I am able to manually run the mail merge from inside Word but want the mail merge to complete automatically from a click of the button. I have created...

Thanks, But the command is on Change: Private Sub txtSearch_Change() ' SEARCH FOR THE NAME If LastKey = Asc(" ") Then Exit Sub End If lstClients.SetFocus lstClients.RowSource = "SELECT ID, Name, Surname, Address, Postcode FROM tblclients WHERE (Name LIKE '*"...

Can anyone help?

DCrake, Many thanks for the help. I have tried to edit the code you gave but unforyunitly i am unable to get it working. Would somebody kindley help me convert my code, so i can try the example given. I am very new to vba Thanks, D

All, I am currently running Office XP and have a database in Access. The DB has a form that contains a textbox and a listbox. When you enter text in the textbox it automatically filters the listbox to find any data that contains the letters you type, letter by letter. This is all done using VBA...

Does anyone want to help?

Can Anyone help? :confused:

Guys, I recently had a developer create me an acccess database for my plumbing business. It basically looks at contacts that i have with clients. On a monthly basis i run a form that looks at all my clients contracts that are ending in that month (I choose from a lstbox). It then runs the...

I found a piece of code here that works great, but have found a little bug. The code is: Dim dbs As DAO.Database Dim rstMergeThese As Recordset Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Visible = True With oApp .Documents.Open "C:\Temp\Service_Plan_Schedule.dot" '...

Can Anyone help?

Hi All, I have attached a DB that I am trying to create for my small business. Every month we have renewals of the client’s yearly contracts. I have created a form called frmRenewells, on this form you need to select a month and a year (please choose October 2006) this then runs query...

I have a form that needs to enter some data into a form. I can not do this by bounding the the textbox to the table, therefore i am having to use ORs. I am using the following code in VBA but is not working: 'Save Payment Type Dim oRS As New ADODB.Recordset oRS.Open "SELECT PaymentType FROM...