Search results

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

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

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

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

Hi All, I am trying to work out a routine to extract a list of documents (with physical location) and meta data from ZyLab. Does anyone have any experience of this system and albe to advise me on the approach to take. Thanks

I have a colums with many rows of the following type of data: 3MIL001- 3mil I want to split the string at the "-" I am trawling the posts but not finding exactly what I want so any advice most welcome. Thanks

I have a query in my Db which contains a value in a column such as "1234 - ABC Company Limited" In my query I have two expressions using the Mid function to create separate columns to give 1234 and in another column ABC Company Limited I then want in my column with the 1234 to use...

Hi All, I am usiung the following code which is correctly running through a query and outputting PDF files. However, its not quite right. The query behind the report contains 194 lines and raltes to call records. I want to output 194 pdf files with each pdf the report just for the related row...

Hi All, I am using the following code to execute a batch file. The batch file runs a SQL script which in turn produces a CSV file. My batch file runs but doesnt produce the CSV file. The batch file works if triggered manually. Any help much appriciated. Dim wshThisShell As WshShell Dim...

I'm using the follow piece of code but I'm getting a resume error. I think the code is self explanatory but want to find the correct way to get the code to go to the next routine when it detects 0 Dim intCriticalCount As Integer intCriticalCount = DCount("PrimaryDataID"...

Hi All, I have created a module which runs a query and sends out emails. I would like to be able to specify a time that the module runs but think there may be limitations using the OnTimer event. Any thoughts/advice? Thanks

Does anyone know how to find out what day of the week it is using VBA? Thanks

Hi all, I'm getting a type mismatch error on the following DLookup syntax. strMonthlyTransferLimit = DLookup("Value", "radreply", "UserName =" & Me.txtUserName And "[Attribute] =" & "Monthly-Transfer-Limit") Any ideas? Thanks

Hi all, I'm using the following code and attempting to handle null but keep getting the afrementioned error?? Dim intAgentContactID As Integer intAgentContactID = Nz(Forms!FrmPrimaryData.txtAgentContact.Column(0), "")

I have the following date/time string 2006-03-08-00.00.00.000000 I need to convert it into 08/03/2006 Any advice most appriciated