Search results for query: *

Does anyone have a “formatting” solution to getting the Date to show on the first line and the Time on the second line (in the same cell) ? Here’s what I’ve done... First, checking off “Wrap text” under Alignment does not work (no surprise as the date is a number). With the following formula...

I have an intranet-based Access database that will be accessed by users with different operating systems, making it a challenge to force users to join a workgroup. Is the only option to send users a different batch file based on their OS and place the /wrkgrp...xxx.MDW on each user's command...

Hi, I'm relatively new to VBA for Access, and would very much appreciate help with setting up code for setting the Paper Size and Page Orientation. I'd also appreciate if you can be specific. My end-users (using Access '97) are forced to "manually" specify the page settings - for several...

Hi all, Regarding a Word Table, does anyone happen to know the keyboard shortcuts for: a) Inserting a new row - a row with a &quot;new line&quot; - i.e. NOT an additional <return> within a line. b) Deletion of a row within the table. Thanks for your help. ...Dale Watson dwatson@bsi.gov.mb.ca

The following thread was posted today in the VBA for Applications Forum... thread707-462398 Because there will be some MS Office members who don't frequent the VBA forum, I thought I should copy the posting I made. It reads as follows... For those interested, here's an alternative (formula)...

BACKGROUND ========== This posting relates to the use of a NEW product called &quot;VMware&quot; that apparently is supported by Microsoft and will allow the use of previous operating systems to be run in separate windows &quot;within&quot; Windows XP. This of course means that any particular...

Hi guys, Calling a Private sub from another Module is probably covered in VBA &quot;101&quot;. Unfortunately, because I've never taken any formal VBA training and Microsoft's help isn't cooperating, I can use your help. I have a Private routine attached to a ComboBox_Change event (on a...

Something simple - yet so difficult. Objective: Using VBA, have the cursor stop at a cell located in the TOP-left-corner of the current screen. Using manual methods, this is not a problem. For example by using the &quot;Go To&quot; function, or by <End> + <Up Arrow>. Problem: In using VBA...

I have a Combo Box where I want the selection chosen by the user to trigger an update to a list used by a second Combo Box. I have a VBA routine that works perfectly when run independently. However, when I attach this same routine to the ComboBox_Change event, it errors out. It appears...

What ever happened to CorelCHART ? ? ? ...And, does ANYONE happen to know if Corel Corp. has yet “come to its senses” and developed the required “filters” that allowed the “seamless integration” of CorelCHART with CorelDRAW 5.0, and with other Windows programs like PowerPoint ? For those who...

For some odd reason, the following code recently keeps &quot;popping up&quot; in all the worksheets I open. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub I've double-checked my &quot;Personal.xls&quot; file, with no indication that it originates from there. When...

BACKGROUND: As we know, Excel allows for what Microsoft calls &quot;Macro virus protection&quot; ( under Tools - Options - General ). However, this option is really NOT &quot;virus protection&quot; in the same sense as the protection offered by Norton or McAfee virus protection software which...

OVERVIEW: This EXCELLENT &quot;Hidden Feature&quot; permits Excel users to print disjointed ranges on ONE page. BACKGROUND: I've been complaining &quot;long and loud&quot; about Excel's printing limitations, specifically regarding the fairly common need to print on ONE page...

To my knowledge, in order for Excel to update formulas which reference other files, those other files MUST be loaded into memory. They can be opened &quot;manually&quot;, or they can be saved in a &quot;Workspace&quot; file which opens ALL the files associated with the Workspace file. My...

Does anyone know the method of retrieving data DIRECTLY from Access &quot;system&quot; tables (the tables Access uses internally to maintain the database) ??? Your help will be GREATLY appreciated. ...Dale Watson dwatson@bsi.gov.mb.ca

In case you missed it, Dreamboat has achieved the &quot;100 Vote&quot; Plateau. To accomplish this feat, Dreamboat has submitted exactly 1,111 postings to assist fellow Tek-Tips users. The &quot;What Are the Odds&quot; (part of the heading) refers to getting exactly 100 votes based on 1111...

I have developed code in Access which exports data to an Excel file, but I would like to be able to add a line of code which will LAUNCH the Excel file (from within Access), and then return to Access once the Excel &quot;Workbook Open&quot; code has completed its task. Does anyone know the...

...Print 2 separate ranges on 1 page. Excel's competition (Lotus 123) can !!! - so why not Excel ??? In fact, printing 2 separate pages on 1 page is something that many spreadsheet users often want to do, and have been able to with Lotus 123 for SEVERAL years, so WHY NOT EXCEL ??? With Lotus...