Search results

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...

I have a command button (cmbBarcodeEnter). After update i want the it clear itself of text and the be ready for the next barcode to be entered. At the moment the button updates and then tabs to next button and leaves the text in the cmbBarcodeEnter button. Thanks D

I have looked at the Northwinds mdb and the table employees. This is a OLE object and stored the image inside the mdb. I don’t want this. I want to have my images external and point a link to them. I then want to be able to call the images into a form. Correct me if I am wrong Thanks D

I have a DB that has a table called tblproductList. In the table i have a field called Image. I have made this field a Text Field. I have entered product details and have entered ghd.jpg in the Image field. this reflects the image i have stored in the same directory as the DB. I have a form and...

Thanks for that. Is it the possible to user a different combination i.e. CTRL & Q ALT & Q Thanks D

Is it possible to use F keys to call Forms/Queries. I have used the code below and found when i press F7 spell ceck runs: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyF7 Then Dim stDocName As String stDocName = "qryDepartment1"...