Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention. However, there are 2 instances when this stops and waits for a human option to be selected: 1. When the spreadsheet is password...

Hi all! I have some Access 2000 VBA code which opens all of the Excel 2000 spreadsheets in turn in a particular folder. However, if one of the spreadsheets is password protected I want to ignore this file and move on to the next one...is this possible? Any help most appreciated. Neil

I need a simple line of VBA code for Access 2000. I am using Access to open a XML file via Excel 2000 spreadsheet. After opening I want to use SAVEAS to save the file to a different location. In addition I want to specify the file format as Excel. What is the code to specify the file type as...

I am having numerous problems importing a series of XML files to Access 2000. The only way I have found to do it is for Access to launch Excel 2000 open the XML file and work my way along each line picking out the fields between the " " marks. To speed up this process how can I get Excel to...

Using Access 2000 how do I copy a MS Excel 2000 worksheet called "X" to and existing worksheet in the same workbook called "Y"? Regards, Dalien51