Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ktwclark

    UserForm Advice Request

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

    MonthView Control - Detecting Next/Prev Button Clicks

    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 =...
  3. ktwclark

    MonthView Control - Detecting Next/Prev Button Clicks

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

    MonthView Control - Detecting Next/Prev Button Clicks

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

    How to test docmd query results

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

    Displaying Access Table/Query on one report page using sub-reports

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

    Access 2003 Lost Import File Extensions

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

    How to import to access through VB

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

    Run An Access Query From VB

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

    Run An Access Query From VB

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

    Run An Access Query From VB

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

    Cannot send zip files in Outlook

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

    Cannot send zip files in Outlook

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

    Macro's and Toolbars

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

    How do I determine if Excel worksheet Protected?

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

    How do I determine if Excel worksheet Protected?

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

    How do I determine if Excel worksheet Protected?

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

    How do I determine if Excel worksheet Protected?

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

    Powerpoint Reference isn't released

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

    I'm looking to automate Powerpoint

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

Part and Inventory Search

Back
Top