Recent content by ktwclark

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