Search results for query: *

We are upgrading to Windows XP from Windows NT. This means Access 97 will be replaced with Access 2002. As we currently have many many many Access 97 databases scattered around the department, what problems can I expect when we convert them all to the new version? I know I can read the MSDN...

Hi Anyone have any idea why the code belwo works for all my network drives but not if I do a search in the C: hard drive? With Application.FileSearch .LookIn = "C:\TEMP" .FileName = "*.mdb" If .Execute() > 0 Then MsgBox "There were " &...

Hi I wish to automate the detachment of email attachments from ny Notes (Version 5.08) to a given path. I am using Access 97 VBA to access the Domino COM on NT. The code below errors ("Object variable or with variable not set") at the indicated line. Any ideas anyone? Many thanks...

Hi I receive via email a number of batch reports as attachments (normally Microsoft Excel file) each day. If we are using Notes R5, what do I have to do so that, at a scheduled time each day, my email folders are scanned and specifc attachments are detached and saved down to a folder. I have...

Bear with me, I know very little.. If I go to Network Neighboorhood, and then scroll down to a specific ComputerName (eg. "ABC1245"), then the Username (eg. "bobhope") of the person logged onto that machine is usually listed. But,at my current company, the username is not...

Hi I would like to use MS Access 97 to query a Lotus notes database...is this: a) feasible, and if so b) difficult, and if so c) reasonable? Why do I ask? I have built a reporting suite for my department in MS Access 97 but there is a legacy Lotus Notes Database which need I also need to...

..help! Any ideas as to why the .ldb log file associated with my Access 97 database (which resides on an NT server) is not being updated when my users open and close the database? I was under the impression that the .ldb file should be automatically deleted if absolutely everyone close out...

Hi I would like users of an Excel 97 spreadsheet to be able to filter rows on a worksheet using the autofilter function but without being able to modify any data within the cells. Can this be done? If I turn on the worksheet protection, the autofilter cannot be used..... TIA Klopper

If I have this code in an Excel VBA module: Function MyFunc MyFunc = (Range("A1").value) + 10 End function And I enter in to any cell, lets say B2, in the spreadsheet: =MyFunc() I get returned in cell B2 the value in cell A1 plus 10. Which is good! But, how can I...

If I want to pass a array variable to another function, like so: Sub OrinigalProcedure ...etc Variable = CalledProcedure(PassedVariable()) ...etc End Sub Where: Function CalledFunction(PassedVariable() as Variant) ...etc...

Hi How does one refresh the screen programmatically in Excel VBA? TIA Klopper

Quick question: I have a coded a small procedure to extract data from a MS Excel 97 to a new .txt file. Is there any way to set this new text file as read only? Thanks in advance for any suggestions, Klopper

Hi I am using the GetObject to open a MS Project file from MS Access VBA. My question is: how do I programmatically disable the macro's inside the MS Project file? Nothing I have tried has worked! Thanks in advance for any suggestions. Klopper

I am trying to convert an Access db to and .mde file but a compile error is occuring with one of the forms. If I delete all the VBA for this particular form, the conversion will run successfully.... ..any suggestions?

Like one can with MS Excel (and MS FoxPro, dBase, ODBC etc.) files, can I use MS Access to directly query the data contained MS Project files?

Hi there! What is the best way to identify and report on changes to the tasks contained in four separate MS Project 98 files? I need to be able to do this so that upper management can trap those changes which affect project timelines. My current thinking is using MS Access to take a weekly...

Hi! What is the best way to "look" at the data residing in Microsoft Project file formats? Is it possible to link to a Project file like one can for an Excel file? Any suggestions appreciated! Klopper

From a given Access97 database, what is the best way to check and / or change the properties of tables and queries in OTHER access databases? Specifically tables and pass through queries with Sybase ODBC links. I have been playing with workspaces and opening databases but without much success...

I would like to disable each control in a form when the form is opened - can anyone tell me why this code does not work? Private Sub Form_Open(Cancel As Integer) Dim ctl As Control Dim frm As Form Set frm = Forms!form_name For Each ctl In frm.Controls ctl.Enabled = False Next ctl End Sub...

This should be a no-brainer for someone who knows what they are doing: I have a form which always only has a single record. I need to grab the data entered into a text box and then close the form. This causes a problem as the record has not yet been saved (I think 'committed' is the proper...