Recent content by tonyireland

Dan although I posted this thread last November I hadn't got a clue as to what the problem might be until yesterday when I found this article http://support.microsoft.com/default.aspx?scid=kb;en-us;837150 on the Microsoft website. Although it refers to server 2003 my suspicion is that missing...

A bit late I know but the note at the bottom of this Microsoft article tells it how it is. It doesn't work if you only have a runtime version of Access. http://support.microsoft.com/default.aspx?scid=kb;en-us;210613&Product=acc2002

Tom, I'm just using Windows copy and paste to restore the files. DOS XCopy is used to create the backed up files in the first place. Tony

I have Version 4 of Vision on my system which is being used on many sites and working fine. On one site I've found that when I copy the two portions of a file (e.g. PYNT and PYNT.vix) from the backup folder to the live folder the system seems to 'forget' that this is a vision file and returns...

Tom this code might set you on your way. Good luck. The real secret though is to use as few references as possible. I normally get away with 3. VBA, Access 10.0 and DAO 3.6 (for Access 2002). Sub FixUpRefs() Dim loRef As Access.Reference Dim intCount As Integer Dim intX As...

I have sent out a CD to my users which installs an Access MDE + Access XP Runtime files on their machines. However one user (and no others) who is running Windows 2000 SP 4 gets the message that the installation requires Windows NT 4.0 Service 6.0 or above!! It seems to occur when they're...

That's the solution, thanks very much Ken, I am changing all my forms as we speak. What had happened was that although the regional settings in control panel showed the short date format as dd/MM/yyyy when I looked at the register setting HKEY_CURRENT_USER\Control Panel\International\idate it...

I have a form in my Access Runtime application which accepts three dates. They all use an input mask of 00/00/00;0;_ and a format of short date. This works perfectly well on loads of PCS running a mind boggling variety of different set ups. However on one PC running Windows 2000 with short...

Something like this? Whenever you leave the form call this function as below clear_form(me) Function clear_form(f As Form) Dim c As Control Dim f As Form For Each c In f.Controls c.Value = 0 Next End Function

Are you sure that Access 2002 runtime has actually installed? I've found that if you run setup with run time included it doesn't always install properly on NT machines(even with SP6), but doesn't tell you about it. This can be because 1) The MDAC components are out of date, latest obtainable...

to disable/enable the X button for the app paste this into a module and call disablex/restorex as appropriate [code] Option Compare Database Option Explicit Public Const SC_CLOSE = &HF060 Public Const MF_BYCOMMAND = &H0 Declare Function GetActiveWindow Lib "user32" () As Integer...

you could try something like this. Public Sub test_connect() Dim strTest As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For Each td In db.TableDefs If Len(td.Connect) > 0 _ MsgBox Mid(td.Connect, 11, 1) ' This is the drive letter...

This article explains linking to backends using the common dialog box http://support.microsoft.com/default.aspx?scid=kb;en-us;181076

This Microsoft article tells you most of what you need to know http://support.microsoft.com/default.aspx?scid=kb;en-us;181076

If I want to close all the open forms in an application I just loop thru all the forms and attempt to close each one. As no error is generated if you attempt to close a form that isn't open this is simple and works fine. I place this code in a public sub e.g. [code] Dim myDoc As Document...