Search results

It's Ok I Worked It Out! This code does the trick! Public Function buildfieldlist() Dim myTables As TableDefs Dim myTable As TableDef Dim myField As Field Dim myStructure As Recordset Set myTables = CurrentDb.TableDefs Set myStructure = CurrentDb.OpenRecordset("tbl_Structure") For Each...

Access 2000: How can I populate a two field table (1. Table Name 2. Field Name) with the name of ever field within every table in my database using VBA code? Regards, Dalien51

I am using MS Access 2000 to open various MS Excel files and make alterations. However, on closing each file it always asks me words to the effect of "do you wish to refresh links?". Is there any way in code to set refresh links to NO rather than have to deal with this question each time while...

Within Access 2000 is there some VBA code i can use to remove the read only status of a MS Excel spreadsheet? Regards, Neil

Using Access 2000 is it possible to specify a starting location ie (c:\) and using VBA search every sub folder from this point for files ending .mdb or .xls? I want to be able to build a table with an record showing the file name and directory for each file found. Any help most appreciated...

Is it possible to change which table in an external database that my linked table is pointing to using VBA? (Access 2000) Example code appreciated! Regards

If i hold a record in a table with the path and file name held in one field, is it possible to code Access 2000 to check that this file exists? I want the database to perform a certain action should it not be found. Any help most appreciated. Many thanks

I have a Excel 2000 Spreadsheet with 21 worksheets. I want to a have a single linked table within a Access 2000 database which I can point to each worksheet in turn then carry out a few actions. However, when I repoint it in code its says I cant change the worksheet name (ie the Database Table...

Can anyone help with this? I will routinely be sent a Excel 2000 spreadsheet with multiple worksheets and each worksheets data is to be imported into a related named table in a MS Access 2000 database. No of course I have been using Transfer Spreadsheet to perform the imports but to make sure...

We have Excel 2000 Spreadsheet which contains some VBA code launched from a button. However, its the old story the person who wrote it has left and we need to amend the code and it's password protected!!! Is there any way of lifting out just the VBA code? Help! Regards

Su Doku Solver You got me the chink in my armour....yes I to think 20 minutes its excessive...ive racked my brains for a way of improving the speed but considering the number of combinations it is having to deal with I dont see how! In fairness this is the time relating to 'Fiendish' puzzles...

Microsoft Access The Poor Mans Database? You’re absolutely spot on to raise this as an issue as I totally agree. Having been a professional Microsoft Access developer for 10+ years now I am finding dedicated Access work harder and harder to come by. Every one now wants their system written in...

I have written a Microsoft Access 2000 Su Doku Puzzle solver. It can solve any solvable Su Doku puzzle in under 20 minutes on any reasonable spec pc. Has anyone else written a Microsoft Access Su Doku solver? Im interested in what logic you employed. Regards, Dalien51

Hi All! I have a problem with Access 97. On a timer each night a piece of code runs which executes a query that imports records from a ODBC connected table and puts them into a talbe in the database. However, despite having a "on error" trap within this code if it encounters a ODBC connection...

This problem seems crazy to me....... If I create a macro with a single entry consisting of Transferspreadsheet from a single Access table to Excel it exports perfectly. When I call Transferspreadsheet from VBA code it moves some of the data and puts them into seemingly random Excel...

Hi all, I am using Access 97 & Excel 97 for this problem. I have a Access query which takes the contents of three tables and exports them to Excel. However, the query has now reach 69000+ records and increases by about 1000+ records ever month. So what I need to do is create as many...

Hi All, Yes ok DDE may well be dead but it works for me so why change it? Basically I wondered what the commands where to format Excell cells. For example if I stamp a cell with todays date: DDEPoke intChan1, "R3C2", Left(Now(), 10) How would I say shade that cell black, change the lettering...

Is it possible to set which VBA reference boxes are ticked each time a database is loaded? A problem is created when a person amending the database to the person using it has different setups and so some of the references show as "missing" and so compile errors show on loading. We are using...

Does anyone know what VBA code I use in Access 97 to capture the mdb file name of the database I am currently in? I need to enter into a field on a table. Any help most appreciated. Regards, Dalien51

Dlookup Is Probable The Best Way If the persons details are brought up after entering a unique identifying code I would use the AFTERUPDATE property of that text box to use DLOOKUP's based on that code to populate the relevant fields. Regards, Dalien51