Search results

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

Got it working - it was this code Late Binding Dim WordObj As Object Set WordObj = CreateObject("Word.Application") Not sure what I did wrong the first time - lets call it a mistery.. Thanks for your help

I have tried both combinations the error occors at Set wordObj = CreateObject ("Word.Application") Am I missing a reference file although I have the word 11 library reference file ticked

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

runs fine before the onversion to mde, not sure if the combination of runtime & mde has something to do with it as the code does delete tables and recreates/relinks it.. will try it again

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

I have a access database with a number of back ends. This database is distributed to various users around the world in a Access Runtime package and use running access runtime. Although tables are in a default folder it is possible to move the locations and automatically relink the front end to a...

A useful function might be the following Function getSQLDate(datDate As Date, Optional strFormat As String) As String 'breaks down date to insert into a SQL string Dim strDateDD As String, strDateMM As String, strDateYYYY As String Dim strDateDD As String Dim strDateMM As String Dim...

I am adding a field to a table as DATE , but I don't know how to set the format programatically to Short date any ideas - using the following code Dim DB As Database Set DB = OpenDatabase("C:\Program files\Compair Service Management\SQSV2CUST.MDB") DB.Execute "ALTER TABLE TblContractQuotes ADD...

FORMAT ([fieldname],"DD/MM/YY")

Try to create a new table in an external database using the following code but when I run the code nothing happens any idea whats missing here (using access 2003) Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim tName As String Dim test As String Dim strDB As String...

thanks it working now

it seems it doesn't like some system files and falls over on the root directory. If I enter c:\program files\ it works fine Apart from this problem my idea was to find the file in any directory available on the server, not knowing whether it is on C or D or any drive on the server

tks tried your code while executing the code I get the following error runtime error 5 invalid procedure call or argument the debug line highlights the GetAttr line any ideas? entered the function in a module Public Function GetFullPath(ByVal sFile As String, ByVal sRoot As String) As...

Have been searching for a long time but cannot find what I want Using access 2000/2003 I want to search for the full path of a specific database (file) (not the current database) display the full path in a message box and use the result to relink my tables. I have a code for the relinking...