Search results

are you sure your underlying database field is not set to text 255 rather than memo to match your text box.

I found the following code but it only loops through the first column, not then also the subsequent columns/rows Dim rs As DAO.Recordset Set rs = CurrentDb.QueryDefs!qryForDirectories.OpenRecordset 'Check to see if the recordset actually contains rows If Not (rs.EOF And rs.BOF) Then...

Thanks CJ, It's not a massive issue, in this case, to alter the spread sheet and import multiple sheets ImportID plus the columns and I can work with that in access

Thanks for the reply, however I think the title of each of my two posts clearly indicates two completely different questions which happen to relate to the same project. This question is not related to importing data.

Hi, I have the following example of code I have previously used which loops through columns where a column is called "Page1", "Page2", Etc. Etc. This is fine when the number of columns is fairly small. But in a new case I have 585 250 columns which may or may not contain some data which is the...

I have a project concerning lists of external files. The spread sheet holds the source data on a document per line basis. Each row contains vital data ClientID, ClientName, DocDate, DocDescription, MainPage, Page1, Page2, Page3.... up to Page 585 I have done previous work where importing up to...

Thanks Paul, Does this mean I will not be able to obtain the data by any method or do I need to use another method? Thanks.

Hi All, I am successfully using some code to open a web page and log in for me. Dim ieApp As InternetExplorer Set ieApp = New InternetExplorer ieApp.visible = True ieApp.Navigate "https://" & Me.txtIPAddress & "/login.cgi" Do While ieApp.Busy: DoEvents: Loop Do Until ieApp.ReadyState =...

Hi all, I have a question to pose... I have a spread sheet which on a per line basis contains columns whose cells contain the path to a file. It looks as if many of the files are tif, pdf, word and excel etc, so multiple file types. Does any have any suggestions in terms of writing a routine...

It was the column called Value which was causing the error. I have solved by not including the value in the INSERT and updating it afterwards. Value must be a reserved word Dim strUserName As String strUserName = Forms!FrmPrimaryData.FrmPrimaryDataInstallsSubFrm.Form!txtMacAddress Dim...

Oh yeah, ID is a PK but in the MySQL Db is not a integer type field or auto numbered!

Hi Paul, I should explain that the table referenced is a linked table and is a MySQL Db which as you have rightly observed is very badly designed. However, I don't have any capability to modify it. ID is a text field - even though it contains a numeric value Value is a text field - even...

I am a bit stumped as to why I get a runtime 3134 error on this piece of code. They are all text values Dim strUserName As String strUserName = Forms!FrmPrimaryData.FrmPrimaryDataInstallsSubFrm.Form.txtMacAddress Dim strIDValue As String strIDValue = Nz(DMax("[ID]", "radreply"), 0) + 1 Dim...

Hi All, After much searching I would like to ask for any pointers to being able to bulk import many xml files where the data from the xml files can be brought into access on a per line basis. Any pointers welcome? Thansk

I have a spreadsheet which will form the basis of a csv file to import circa 50,000 documents into a system. The import file will contain meta dataand a reference to a logical path to the document (to be imported). The problem I have is that many of the lines have more pages and the path to...

Hi All, I have been following a most clear and informative article on building treeview controls. The article described, and i have successfully replicated, creating a treeview with two levels. My issue relates to adding a second, undocumented in the article, child level. The website is...

I am really stuck/googled out on trying to find out why my connection string wont initialise? Imports System.Data.SqlClient Imports System.Configuration Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load...

Hi All, I am using the following statements (with the correct namespace references declared) for the following which works fine. I cannot work out how though to reference the connection string which is correctly referenced in my app.config file. Any advice most welcome. Private cs As...

Just followed the instructions and posted so that others can benefit too. If it comes across as though I created from scratch then please be advised it was created from code I found and then adjusted accordingly.

Thanks all for your posts. In the end I found the followng which worked really well. First: I created a module calling it a different name to the actual funtion Public Function ParseText(TextIn As String, X) As Variant On Error Resume Next Dim var As Variant var = Split(TextIn, "-", -1)...