Recent content by wavp

Needs to be in excel, so the graph and data can be sent around via email.

I have written some vb code in access which generates an excel report, with a pre-draw graph. And what I want to do is to adjust this graph to fit the data which has been dumped in the excel sheet. Below is some of the code, I just can get the data source changed on the chart sheet that’s all...

Maybe someone could point me in the right direction: What I am trying to do is convert a XLS file to CSV by the press of a button, how would I go about doing this? Cheers Will

Have a go with this code below: Private Sub UpdateConcept() On Error GoTo ErrorTrap Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection Dim SQL As String SQL = "UPDATE ConceptMaster SET " SQL = SQL & "ConceptName = '" & Trim(Me.txtName) & "'," SQL = SQL &...

Trying removing # as shown above.

To answer your questions: 1) Have you been mucking about in the .MDW file lately? No I havnt 2) Or your permissions? No aswell I have moved a step closer in solving my problem, what I did was to add "OpenExclusive:=True" to my string, see below: objDoc.MailMerge.OpenDataSource...

Is there anyone who can help me on my Mail Merge problem??? Does anyone else have this issue with Mail Merge (Access 2003) ??? Cheers Will

A while back I downloaded InetTransferLib from http://www.mvps.org/access/modules/mdl0037.htm I integrated the FTP module into my Access 2000 project - and it worked. However lately when I came back to test the upload/download function after converting to Access 2003, it connects and the then...

I have started having problems with MailMerge in my database - it has worked before but now I get this error: Runtime error 5922 "Word was unable to open data source" Here is my code: Function MailMerge(strMMTemplate As String) Dim objWord As Word.Application Dim objDoc As Word.Document...

I have started having problems with MailMerge in my database - it has worked before but now I get this error: Runtime error 5922 "Word was unable to open data source" Here is my code: Function MailMerge(strMMTemplate As String) Dim objWord As Word.Application Dim objDoc As Word.Document...

I have client which wants to store his data online in s MySQL database, and then use a MsAccess front end to access and use the data. How do I link the tables in the front end to the tables in the MySQL database? Will

I have started using .NET VB, creating Windows Apps - I have decided to convert one of my access dbs to a windows app. I don’t want to start from scratch, so I was wondering is how do I convert my access forms etc. to VB forms? Are there programs which can do it? if so which one is the best one...

I have some data in a stored in a memo field in a table, for example: How would I go about going making an array which will loop through each line of the data stored, so that I pick up specific data??? Thanks

Cheers mate

I am trying to convert my code to ADO from DAO, but I am getting errors...below is bit of my code have converted to ADO, but I am getting this error: Any idea what is wrong with the code below?? Cheers Will Dim cnn As ADODB.Connection Dim rsDBStatus As ADODB.Recordset Dim strDBStatus As...