Search results

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

I am trying to use the Right(0 function in SQL, I used it in A97 and it worked, but it doesnt work in A2k. Example: SQL_ADD = "INSERT INTO TMP_E SELECT '" & strCNum & "' AS IP_CNum,'" & strDate & "' AS IP_Date,'" & strSNCut & "' AS M_Serial, Right(Name,10) As FC_Code, Data As FC_Count FROM...

Currently I populate one excel spreadsheet with data from lots of different tables. What I would like to do is say....populate one set of data into Sheet 1 and then change to a another Sheet...say Sheet 2 keeping my connection to that workbook open when I do this. Is there away? Cheers Will...

I gave my problem a shot, and pull things from different places and this is what I came up with. What I am stuck with now is how do I tell it to read the lines below "CustomerId" and do the IF statment in regards to the that data to said table. Then locate "ProductID" and do the other IF...

I have a .CSV file with has two sets of data, for example: "CustomerID","CustomerName","CustomerAddress" 132,"J Blog","1 London Street,London" "ProductID","ProductName","Qty" 10056,"13A Socket",3 10008,"Plugs",1 Brake down of the file: -------------------------------------------------...