Search results for query: *

Hi Mike Try this... Private Sub ListBox1_AfterUpdate() 'Use AfterUpdate event to detect changes in listbox after the selection has been made 'The Click event detects change in listbox during the selection process 'ListBox1.ListIndex is position in ListBox list of the selected item...

Found the answer: I have a monthview control called mtvCalendar on a form in access and this code. Private Sub mtvCalendar_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long) Dim iResult As Integer Dim dtMyDate As Date iResult =...

Thanks for the tips. Don't quite understand reading point 16 about a two way forum. I've answered a few questions on the forum. Anyway, if I use the X and Y co-ords do I not have to take into account screen resolutions, if the form containing the control has been moved, i.e the x and y co-ords...

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...

Thanks for all the replies. But I'm having a problem now executing delete queires already set up in the database. I get an error message "The connection cannot be used to perform this operation. The connection is either closed or invalid." I've used the code above and called a...

thx for the reply. I've been using code similar to the above for producing recordsets but was wondering if I can run a query that is already set up in the database or is it easier/quicker to create a new recordset through VB. I have queries set up already that work within Access but when I set a...

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

Thanks for the tips guys. I'm using a server but it did accept zip files and exe files when I was using Outlook 2000. Now I've upgraded to Outlook XP but the zip and exe files can't be attached to emails. I'm convinced it's an Outlook issue as oppossed to a server issue. Currently I rename the...

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.

FAM When you have the toolbar and template open, ensure you set the button links on the toolbar to the macros contained in "This Workbook" as opposed to "All Open Workbooks" or "Personal.XLS". You have to make sure your macro code is contained in the "This...

I didn't mean to cause offense and I appreciate this is an open forum. But every time I reply on this forum I get a message ticking me off. By no means do I purport to "know so much". At no point did I claim this. The fact I asked a question should show this. I simply asked a...

Activesheet.ProtectContents it is. Thanks to all who replied. I've learned something new and I hope you guys did too! KC

Sorry, but it's not as simple as that. You should test what you say: Put a command button on a worksheet and add this code to it: Private Sub CommandButton1_Click() 'Focus must be on a worksheet cell, not command button, 'before messing with protection Range("A1").Select...

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...