Recent content by DALIEN51

  1. D

    Football fixtures problem

    I know this topic has been done to death previously... but actually I have a unique spin on the problem. I have developed a crude football management game (just for my own enjoyment not for the world to see) based upon the 4 traditional pro leagues in England (Prem, Champ, L1 & L2) but I need...
  2. D

    Closing a rdp session with a dos command

    Does anyone know what dos command I run to close a Windows RDP connection on my PC? Any help appreciated.
  3. D

    Import internet explorer content into access table

    Hi, Is it possible to open a XML file in Internet Explorer create a DDE link and read the content in row by row to an Access table? I am using MS Access 2000. I have started with the following which works so far and establishes the DDE connection - but how do I actually read in the content...
  4. D

    Referencing A Variable

    I want to be able to reference a variable dependant on where I am within a loop. I have myct1, myct2 and myct3 looping then a mycount loop and I want to add a record to a table taking the relevant myct value dependanct on the current mycount value. Any ideas anyone? Here is my code: for...
  5. D

    Automating Windows Compression

    I have a MS Access 2000 application which, using code, every night, creates a folder on a external drive named with todays date (ie Christmas Day 20071225) and copies various files into it. What I want to be able to do is then use Windows Compression to compact the files into a single Windows...
  6. D

    Access 2007 Html Linked Table

    Has anyone else encountered this? I wrote a Access 2000 database which has a linked table to a HTML file which worked perfectly. However, I Have recently installed Access 2007 and now when I use my database to try to open the HTML linked table it says it is either empty or not in the right...
  7. D

    Create A Ms Access Report Index

    I am using MS Access 2000 to handle a help desk system. Each job is given a task number and users are able to output a report of all of there tasks, with full notes. What I would like to do is create a index front page or section which lists just the task numbers and the page number they...
  8. D

    Set Desktop Webpage

    In Windows XP you can go into the Properties on your Desktop and select a WebPage to appear as part of your Desktop wallpaper. Is it possible to set the WebPage file using code within MS Access 2000? Any help most apprecited. Dalien51
  9. D

    Count Down Wallpaper

    I am running MS Access 2000 on Windows XP PC. Ok the deal is this - I have created a MS Access database alowing the user to set a "going home time" and have the database refresh the remaining hours, minutes, seconds to go onto a form every second. So far so good but what I'd really like to...
  10. D

    Viewing Tasks In Windows Task Manager Using Ms Access

    Is it possible for MS Access 2000 to capture in a table, the list of currently running tasks in the Windows Task Manager, on a Windows XP machine? Regards, Neil
  11. D

    Ms Access Recording Remote Desktop

    We have a number of Windows XP PC's using Remote Desktop to access various IP Address and take control of the computers at those addresses. Is there someway MS Access can collect information from our PC's to a centrally accessable location to tell us who is accessing which IP addresses...
  12. D

    Ms Access Controlling Windows Media Player

    I want to have a MS Access 2000 database open, load a Form with various option buttons on and get Windows Media Player to play a MP3 music file. However, when I click a option button on the Form I want the music to stop. Any ideas of code to do this? Regards, Dalien51
  13. D

    Finding Sequence Of Fields Making A Unique Record

    I have a MS Access 2000 database with 136 data tables in it. What I would like to do is execute a piece of VBA code which will list for me in another table, (for example: Field1: TABLE NAME Field2: FIELD NAME 1 Field2: FIELD NAME2 etc), starting left to right, how many fields would have to be...
  14. D

    Setting All Fields In All Tables

    I have an Access 2000 database with several tables in it. Against each field in each table I would like to set every REQUIRED and INDEXED value to NO. Is there a way I can do this using VBA? If it helps, one of the tables has 2 fields in it named TABLE NAME and FIELD NAME with every field...
  15. D

    Is This Impossible???

    I have a table with 3 fields: CUSTOMER, START INVOICE NUMBER and END INVOICE NUMBER I want to populate an identically formatted table with a consolidated list of start and end invoice number ranges for each customer. HOWEVER! Heres the rub.... The ranges for each customer in your starting...
Top Bottom