Search results for query: *

Hi I'm using the MonthView ActiveX control in Access to select a range of dates from 2 consecutive months. I'm displaying 2 months using the control. If I select a range of dates and then press the next or previous buttons that come with the control the next months shift place by 1 month but...

Hi I'm using Access and have a query that returns the total number of records in another query. The field is called "Total". The Query is called "Totaller". How do I transfer the result of the query in to a variable in VBA? I currently have a text box called "txtTotal" on a form call...

I have an Access 2003 database with a report that has 3 graphs and a sub-report linking to another report. The problem I have is that the recordset that is used to populate the sub-report has 19 records. I can get these 19 records to display in the sub-report fairly easily, except that 19 pages...

I've upgraded from Office 97, to Office XP, to Office 2003 and had a few problems. I think multiple registry entries for the different office appliactions was getting windows confused. Everything seemed fine at first but then I noticed I couldn't record macros in Excel, although I could in Word...

I have an access database with and import specification already defined. I'm looking to import a text file using the specification through a VB front-end. The Access code is: Docmd.TransferText acImportDelim, "ABC Import Specification", "ABC", "C:\Reports" which...

Hi I'm a bit confused about connecting to an existing Access 97 database through RDO or ADO and being able to run queries, etc that have already been set up in the database. Can anyone give me some pointers, please. thx kc

Hi I'm having a problem with my PC in that I can't send emails with suspect attachments such as zip files or exe files. I realise this has to do with some security setting but can't seem to find the option to change this. Can anybody offer some help.

Hi I use macros on an Excel worksheet and I also use protection of the cells. I can protect and unprotect no problem but I'm not sure how to determine if protection has been applied or not. If I apply protection to an already protected worksheet I get an error. I can workaround this using error...

I'm having a problem automating Powerpoint through Excel. I want to do a bit more than the code below shows but it highlights my problem. I'm running Windows 2000 and Office 97 and have this procedure in an Excel module. The code is called by a toolbar button. The problem is that when I release...

I'm looking to automate Powerpoint through an Excel toolbar. I want to be in Excel, open a workbook, check it is the correct workbook, click a button on a toolbar which opens a Powerpoint Template, updates the links in the template with information in the Excel workbook, break the links, and...

Hi I know this isn't really an Office question; I was unsure which forum to use. I was wondering if anybody else has noticed this, come across it before, or could have a reason for it: I have two Tahoma.ttf fonts in my Windows\Fonts folder. I noticed this on a friends PC, and thought they may...

I have a CSV file that is produced from one of our corporate systems every month and is processed using a macro I have written. The problem I have is that if the CSV file has more than 65535 rows then it is too big to be imported in to Excel. However, Excel will import 65535 rows of data from...

I've got some strange goings on with my macros. There doesn't seem to be any specific instruction that's causing problems but there is definately a problem. I make Excel invisible when I run my macros as several workbooks are opened and things can get a bit flashy and sore on the eyes. I've...

Hi Any idea how to use the histogram from the Analysis Toolpak in Excel through VBA. I can use it fine manually but not through VBA. I recorded a macro of the steps I took to manually produce one, but the code doesn't work when I make it part of my macro. Here's the code Application.Run...

Hi I've created a toolbar that's used within Excel. It was originally written for Office 97 on Windows 98, updated to handle Office 97 on Windows 2000, and am now updating for Office XP on Windows XP. My problem is that when you create a toolbar in Excel on Windows 98 or 2000, a toolbar...

Hi All Since I get a quicker response through here than I do trawling though MSDN, here goes... I'm looking for a way to determine the drive letters of mapped network drives through Excel VBA. I'm look to automatically save Excel produced reports straight to the correct folders on netwrok...

Simple question. Is it possible to determine what version of Windows is running through Excel?

Hi I'm looking for an easy way to determine the Regional Settings within Excel. I'm looking to determine the short date format. Any ideas? Thanks

You've solved my other probs, hope you can solve this one! I've been developing toolbars and macros for use with Excel and Access for my employer. I develop on/for systems that have either Windows 98 or Windows 2000 installed with a copy of Office 97 Professional installed also. I also do a...

I have a macro that links from Ecel to Acces and back again. During testing an Access form wasn't closed, the system halted, after a restart I couldn't open Excel. I've narrowed down the line of code that's causing the problem but am stuck. The line of code is for reading in data from a text...