Search results for query: *

Hopefully someone can answer this problem for me. I am trying to update a code module in Excel using the following code Sub ReplaceModules() ' Export Module from this workbook strFileName2 = ThisWorkbook.PATH & "\tempmodxxx.bas"...

Hi All I'm considering using the MS Date & Time Picker 6.0(SP4) ActiveX control in an application. I would like it to display on a form with the Year selector buttons displayed, rather than hidden (which is the default). When the Control is displayed, it shows the Month and Year at the top...

Does anyone know of a way to force a textbox on a form to always display the scrollbars? The default behaviour is that a textbox will only display scrollbars when it is the active control. I need to display a textbox with some Help info for the users while the focus remains with the control...

Using Access XP -> Word XP I'm exporting data from Access to three Word templates using automation. The code I've developed consists of three nested loops to extract the data and import it into bookmarks in each of the word templates, and then combine the separate documents into one document...

Hi People This is cross-posted in the Access - Other Related Topics forum. I have an Access 97 application that automatically sends out data updates to six state offices by attaching the updates to an outlook message. There are six individual updates sent because each state receives slightly...

Hi People I have an Access 97 application that automatically sends out data updates to six state offices by attaching the updates to an outlook message. There are six individual updates sent because each state receives slightly different data. My problem is that I need to send these updates...

I posted this problem in the VBA forum, but had no response. Hopefully someone here can help me resolve this problem. I have an Excel 97 workbook which consolidates data on a monthly basis from 5 different text files (semi-colon delimited). I have written a macro for each workbook which...

Hopefully someone can resolve this problem for me. I have an Excel 97 workbook which consolidates data on a monthly basis from 5 different text files (semi-colon delimited). I have written a macro for each workbook which opens the relevant file, copies the data to a worksheet in my main...

OK, Here's an easy one for Excel developers. I need to consecutively select a number of different sized ranges in an excel spreadsheet in code. The catch is that I don't know how many cells will be in each range. All I know is the starting cell and the number of columns wide the range is...

I have a worksheet with some numerical data imported from a .txt file. Because some of this data is Null, I am getting a number of cells that contain "#NULL!". I need to convert these cells to 0 using VBA, but I'm not having much success. Could somebody tell me what is wrong with my...

I have a workbook which imports data from two delimited text files. I can import the data with no problems, but I cannot get the delimited files to close after the data has been imported. Can someone look at my code and tell me what is causing this? Be nice - this is my first attempt at...

Can anyone help with setting up an automated process for linking word documents to a form? I have a database that tracks legal processes. I now need to link court orders (MS Word documents) to the relevant case. I can link these directly using Insert|Object without problems. However, the...

What is the correct syntax for using wildcard characters in the TransferDatabase method? I need to import data into a summary db from up to 100 similar db's. Each of these db's is named "RegionalOfficexxxx", where xxxx is a four-character alphabetical code. I have tried using...

I have a db with many forms which each have a number of mandatory fields. I need a generic function to display an error message if the user either tabs through the field(s) without entering any data, or tries to close the form without entering the data. I am using the following code to call...

Hi All I have a form consisting of a Tab control with 4 tabs. Each tab has a subform control displaying one page of a multi-page form. I need to synchronise each page of the form so that when I tab from page to page, each page displays the same record. I have the form working correctly for...

Hi All I have a form with about 50 Check boxes on it. These are used to indicate which of the forms within a survey db have been completed, and which still need to be completed by the user. What I am trying to do is display the check box's label in red if the indicated form has not been...

Hi Gang! Does anyone know of a way to display a control's ControlTipText through code? For various reasons, I need to display additional information for each control on a form. I need to ensure that any user who uses the TAB or ENTER keys to move through the controls also sees this...

I have a report which is a govt prescribed format. Depending upon certain criteria, some of the paragraphs need to be ruled through. I have set the report up by setting line controls over each of the paragraphs and tried using a Select Case statement to set the appropriate lines' visible...

I'm developing a database for a client with a steady rate of staff turnover. I've implemented Access security and set up a form where the system "administrator" can add new users to the security file. This runs a function which updates the .mdw file through code. So far so good...

On a main form I have a combo box which lists Account numbers.  When a user types in a number which is not in the list, I use the Openform command to open a secondary form to enter the new data in the Account Number field, and then move to the next field (on the secondary form) for the...