Search results

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

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

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

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

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

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

I used some of the code from Pat Hartman to attempt to send a record string to a table in MS Word In the line Set objTable = WordApp.Selection.ConvertToTable(Separator:=vbTab) I get a Object required message I know I am missing some declarations but not sure where & what So no doubt I get...

I am trying to create a word document combining varous records sets from Acces. The first part is easy as my first record set only produces 1 record and I use book marks to populate word. The problem I have is when I have a variable number of records, in my code here sqlservicetask I only need...

trying to run word automation using access 2003, but I keep getting an run time error 13, type mismatch I have a simple test function to ensure that the coding is right but I keep getting the error on the Set WordObj = CreateObject("Word.Application") line I have a microsoft word 11 object...

I need to some advise on which is the best course of action. I have a MS database with an SQL back end as a client server application. Now the next step is to give stand alone versions (with a mdb back end) to off-site laptop users, to make updates or entries when not connected to the office...

Rather then writing a complicated code is ther is code to replace the menu option File > Link tables I basicly have hidden most of my toolbars in a runtime version, and when required I want to click on a button in order to (re)link my tables. Is there a code that I can use that brings up the...

I am converting an MDb to an mdb linked to a SQL back end In one of my normal mdb tables I had a table with service dates for a specific machine. This table had no primary key as this had an impact on my function that would update the service dates. It worked fine in access. The problem with a...

It is the first time i am attempting to create an access project file I have an existing mdb application I want to move to a SQL back end. I looked into the possibilities, hwr the problem is I have many subs or functions using the VBA sql syntext and also a lot of DAO references to open record...

I have a database that users run in MSAccess Runtime I have a sub that opens another database. It runs OK when I am using access 2000/3 the normal way, but won't play ball when in runtime Is there a way I can open that other Dbase in Runtime as well? Dim accapp As Access.Application Dim...