Search results

Thanks for that. Doesn't look good!! :(

It looks as though all of our MS Office (2000) help files have been broken somehow. None of the usual helpful icons that appear at the top of help subjects show any more. And if you do get a text link to show and try to click it you get the following error: "An error has occurred in the script...

Would love to, have suggested it, however we dont have any choice in the software we can use or buy. We are only a very small cog in the mighty wheel which is the civil service!!

At the moment we have an Excel front end feeding in to an Access back end via SQL (as we can't afford all the Access licences)

I have just been told that we shouldn't be using Access to build databases for sharing information. Instead it should only be used to build single user databases. Please, give me some ammunition to show what a stupid statement this is!! :eek:

Thankyou Thats perfect!

I am saving data to an XML file to be read by another application. Is it possible to set the file properties of this saved xml file through VBA? I want to make the file hidden and read-only.

I thought as this was a VBA question it should go in the VBA thread, not the specific Excel Thread.

Thanks I'll try that, unfortunately I can't use combo boxes as Im trying to emulate an existing screen which has been written in MSBASIC/DOS6 or something as ancient!! :eek:

Help please I have created a form in Excel with text entry boxes, in the first box the text required is either A,B or C. If an incorrect letter is entered I want to focus to go back to this cell. But I can t seem to manage this. The code I have is... Private Sub txt_ABC_Exit(ByVal Cancel As...

Thanks everyone However, as they are unwilling to spend, we wont be getting Developer "oooh, far too much money!!" and unfortunately we are not allowed to use any free software (!). The only official software we are allowed to use is what we already have. Access/Word/Excel/Powerpoint 2000...

Cannot view! Thanks, Unfortunately the firewall on our intranet wont allow me to download the attachment! :mad: grrr

Hi, My query is similar to this one here. I am part of a small intranet team who build internal applications, mostly in Excel using VBA. However Excel isnt always the answer and we would like to use Access more, however our employer wont pay for the number of Access licences required!! We...

I have this great little bit of code which creates a dialog box, from which you can select a program to run. However Im not happy with the "I dont know" parameters. :) Also the strings dont show up correctly, they just show square boxes, as if the correct font cant be found. Private Declare...