Recent content by Matt_Hirst

I have an app that creates a lot on linked mysql tables in my access front-end. What I am wanting to do is add a form with a combo box, a text box and a button. As soon as the form is loaded the combo box is populated with the fields held in all of the tables - need the names to be unique...

Banana, Thanks for the reply. The database I am connecting to has 370 tables, it is the output from a rather large model. It is held on a PC and depending on how many times the model runs depends on how many databases there are on that computer. Initially I am wanting: A. To have a list...

I have been given the task of updating an old databse that I wrote about 2 years ago. Basicly the database updated anumber of linked MySQL tables to allow a group of analysts easy access to the data. The new/updated database needs to look at a new version of software that uses mysql 5.0. Now...

At work I have been asked to create a MS Access front end for a mysql system - all simple enough. The MYSQL system is rather large, so you run a set of criteria and it outputs a data warehouse with 270 odd tables, you then alter the criteria and re-run creating another 270 tables. What I need...

I am having a total brain fart with this... I have a form with 22 datagrid controls on it, they are populated from an Access database. I am wanting to read the data from the datagrid controls, the access data provides base data that the user may want to modify, but I can't for the life of me...

I have been given the dubious task of writing a front end to a data processing tool, basicly the front end needs to write a text file, it should then call the data processor(dos based fortran) the data processor then produces two output files. I have used shell ("d:\matt\matt.exe"...

Hi, I have a form with a drive list box, directory list box, file list box and two other list boxes. The file list boxes bring up names of .mdb files found in the directory. What I want to do is populate the first list box with the tables held within the file selected by the file list box...

I have an app where I have split the data from the code , if the app is moved to a differnt location the link between the front-end and the back-end is unchanged. Question is how do I change this through code? regards, Matt P.S. I know I can do it manually, but just wondered how to update it...

I have been given the task of updating a program that reads a hex file and converts it into meaningful data. * First problem is that the file is completely uncommented, so I need to go through and write comments. * Second thing I have never done hex conversion before so need a few pointers on...

I am told it is a hex file, not 100% sure though and the guy who gave me the file is unsure. Is this what I have to do, read it in as a binary file??? Does anyone have any links to a basic guide to hex and converting? regards, Matt

I have to read in some rather large hex files, convert them and then populate about 20 tables with the info. First question is where to start? I seem to remember covering hex when I was at college 14 years ago. Hope someone can point me to a dummies guide to converting hex files. regards, Matt

Thanx for the help guys, I managed to figure it out. regards, Matt

I have written a small access database, it sits in d:\matt directory. In the modules I have referred to the database path c:\matt, obviously if I move the database it'll produce an error. What do I need to do so that the database looks at it's current location\path and continues working no...

Thanx for the help on that... Anyone help me out on third bit...removing the headers??? regards, Matt

Simple Access questions, I hope... I have numerous comma seperated data files, the names of which are all in the following format ???1 to ???10 and then ???a to ???z I am looking to do a loop that will automaticly import these files into an access database. The numeric ending files are simple...