Search results

Sorry for being a bit dim here, but I can't seem to get it to work. Could you elaborate?

I have a table containing, amongst other things, procedure names and want to write a function that reads in each procedure name and then call the relevant procedure. How can I call a procedure where it's name is assigned to a string variable?

Thanks for confirming the problem but it is not possible for me re-map everything for all of the users. Isn't there a more scientific way of solving this, like assigning the full network path (in code if necessary)?

I have a problem with a database I am building on our server. The database is sited on a central server and a select group of users have access to the directory where the database resides. The problem is that some users are unable to use any of the forms based on linked tables and get an error...

Can't see how this would work, can someone explain?

Thanks, this is very useful. Presumably if you are using this with Access 97 in XP, there should be no reason why it won't also work with Access 2002 under XP? But will the file conversion process (from 97 to 02)screw it up?

I have a continuous form detailing many records and want to show certain records in a different font color (depending on the values of two fields). I realise Access 97 doesn't support conditional formatting but does anyone have a nifty trick to get around this?

As I do not have a copy of the developers software for Access 97 to generate the file open/save dialogue, I have cribbed some code from the Northwind database which uses the .dll route. This works fine but I am a bit concerned about upgrading to Access 2002 next year. I assume this code will...

Wow, I thought these things were supposed to get cheaper now that they're out of date. Is the copy you bought unused, boxed and packaged?

That's done the job, thanks.

Does anyone know whether you can add additional tabs/pages to a tab control in Access 97?

Can someone please explain how to programatically change the name of a form. I have written the code to build a form dynamically but can't see that there is a way of specifying a form name using "CreateForm". Hence it is saved as "Form1". This is ok as long as I can then rename it, can someone...

I need to build a form that displays data from a crosstab query. The problem is that the number (and name) of the columns in the query vary unpredictably from quarter to quarter. Does anyone know how to get around this other than by dynamically re-creating the form for each enquiry? (I'm...

Excellent, thank you.

Does anyone have the code for, or know how to, auto compact a database? I have a database that creates a number of large temporary tables. Obviously the database gets very big very quickly and I want to include some code that compacts the database automatically either at a fixed time each day...

Rich, Good idea, I'll give this a go.

Normally, it wouldn't make any difference, but the application I am building is a data collection application comprising of client software (run-time) that generates a file output which they submit and a central database (full Access version) that imports and consolidates those files from around...

Do I actually need the software though? DBL (above) appears to be saying that I can produce the run-time version with other software and that I only need a licence from Microsoft to distribute Access applications. If this is the case and I buy the XP version, presumably that will also cover me...

Can someone please summarise the major changes in the new XP version of Access for me. I've heard a number of conflicting reports on whether or not it is worth upgrading yet and would be interested to learn what is the general concensus of opinion ?

Thanks, but where do I get a copy of the software??? I've looked everywhere but nobody I can find actually sells 97 anymore. Can you buy an ad-hoc licence from Microsoft or alternatively, does buying a current version automatically cover you for deploying previous versions as well?