Search results

I know how to search for files on the local pc or server, but not on the internet. the standard fileexits functions doesn't seem to be able to read http:// etc Now if I download a file that doesn't exist yet I just get the internet explorer download error message but I want to prevent that by...

Unable to find a code in vba that checks if a file exist on the internet. I run a mdb application that has been distributed to worldwide users. Updates are posted on our website. I managed to get the download etc automated, but still struggle to find a code that checks if a file exist on our...

In VBA I have a procedure that while it is looping through 2 record sets it adds new records to another SQL database table. I want to move this program to a web application using vb.net (visual studio 8) however as I am rather new to VB.net I donot know what is the best method I should use and...

tks that was the cause indeed, but can't remember making any changes.. still baffled but its running

in my application I used to run a code that checked for a valid connection string with the sql server or let me easily change SQL server / databases. Hwr is suddenly stopped working. All I can think of that has changed was loading XP SP3. the error I get is at the following line of code Set tdf...

Wasted half a day ggogling but still none the wiser I created in vb a text file c:\Sample.txt after creating the file I want to print it can't get the file to print, it just prints a blank document called document I have the following code Imports System.Configuration Imports System.IO...

Using VB2005 express. I am new to VB as I mostly programmed Access VBA only and struggle to find the right syntext to work with an ADO connection and retrieving a value from a record set I get the following error message, but not sure what I am doing wrong here I get the error message on...

Tks So if I understand the article correctly, other then ensuring any target computer must have the same references and also in the same location as the development computer. There is no way around it then...

I have a database (2003 version) that is distributed to users accross the globe running all running on different OS, MS office versions etc Most users will use MS Access runtime to work with the program. The problem I have is that for some advanced features, certain references are not present on...

Thanks before I start to test this code, just checking that it does what it wants to do: Problem I have is that if I install for example my application on a virgen PC or server, I need to create and ODBC. Normally I go to control panel, administatrative tools, odbc databases and set up an ODBC...

Thanks got the Server List working... had to add the SQLDMO reference to get it to work. However with creating an ODBC link programatically can someone give me a clue where to start, mind you I need to use it in VBA... for those interested in the code to list available sql servers Private...

I am actually trying 2 things: Using vba Programmatically List All SQL Servers And Their Databases so I can easily relink my application to various clients SQL servers. Each organisation has different server names. rather then going through Enterprise manager to find out the servernames, I...

When using the below function is an english/US date settings envrionment the funcionad is running fine, hwr when I move this database to a german environment where the date format is 01.01.2008 instead of 01/01/2008 it will not return a value. the TBLPeriod.StartDate for example = 01/04/2008...

I have a access 2003 database based on SQL tables through an ODBC link. One of the tables doesn't allow me to edit or delete once a record has been created, either in a form or straight in the table. I get he Write conflicy message " This record has been changed by another user since you...

got the solution in the end it seems that using ADO / access project doesn't require the # syntax #" & Format(strInput, "mm\/dd\/yyyy") & "# but instead use ' to turn the date into a string '" & Format(strInput, "mm\/dd\/yyyy") & "'

I got the following references . am i missing some? Visual basics for applications Microsoft access 11.0 object library OLE Automation Microsoft ActiveX Data objects 2.1 Library Microsoft ADO Ext 2.8 for DLL and security switched all of and on again but still same error

Starting to work with MS Access Project and trying to convert an existing database to Access Project. The old database was based on DAO references, now I am converting to ADO However I am having a problem with a DCount code that works perfectly in the Normal Access database, but not in Project...

I have a bound form, which is based on possible available workdates (unique dates). In the form I have an unbound activeX calendar7 that I use to select a date and then go to the record for that specific date I use the following on click event to find and go to that record: Private Sub...

thanks will give it a go

I distrubute an application created in Access 2003 however it is distributed with Access Runtime. One of the output functions is to write data to MS word templates. I only have Word 2003, hwr many of my users still have office 97 or 2000. In my references I can only add Microsoft word 11.0...