Search results for query: *

Hi Folks, Does anyone have any suggestions why the out of office option might spontaneously disappear from the menu? I've managed to retrieve it using the add-in options but the users who've lost it would not have touched any of the options to remove it. Thanks, Jes

Hi Terry, It's just the standard Save Dialogue box with a filename given as the parent form plus an incremental number. SetWarnings has no affect on this. Jes

Hi Ben, Compacting? Well, it's bloody obvious really isn't it? You could have mentioned that a while ago and saved my fingers some typing stress :-) Oh well then Gerard, you'd better start reading the threads on programatically compacting db's. Regards, Jes

Hi Gerard, Well, you've exhausted all the options I can come out with so I'll have to agree and say that you'll have to distribute the mde to individual machines / accounts. I do think though that sort of defeats the object of an mde file. Best of luck, Jes

Hi Gerard, My idea there would be to either:- 1) Delete the contents of the table after you've finished with it as opposed to before you start using it, so that way the info will never be hanging around. 2) Create and Delete the entire table as you require it. Some basic SQL code will do...

Hi Folks, I'm trying to generate a form with controls through VBA in access 97 and though I can create the form, add the controls, etc, I cannot save the form without going through a dialogue box first. Does anyone know how to get past this? Thanks, Jes

Hi Joanne, Same person, different membership details. I'm using 97 at the moment and will be moving to 2000 in the near future. Thanks, Jes

Hi Folks, Can anyone point me in the direction of a grid control for access, preferably one I don't have to pay for as I'm just investigating its' use at the moment. Thanks, Jes

Hey Joe, Have you requeried the combo box after the user has selected from the first? Does the syntax not work at all? I know jack about .adb files by the way, but it might be something as simple as that. Regards, Jes

Hi Gerard, Well, you've got me stumped. The mde file should not grow if it has no tables attached - at least that's my understanding of the way it works. Does your program allow users to create their own queries/reports/forms through code as that might explain it? The only other thing I...

Hi Gerard, My solution to this is to have two database files - the mde and the mdb, with the mdb holding the tables and the mde linking to those. Then it's just a case of compacting the mdb as and when required. I find it's useful to separate the program and data in any case as it makes it...

Hi Terry, Thanks for the response - you deserve the top geezer accolade. Cheers, Jes

Hi Folks, I'm looking to move from Access to SQL server. Is it true that I can just 'drop' my access db's with vba source into sql and it'll be happy? Also, does anyone know if the same can be applied to sysbase sql server? Thanks, Jes

Hi Folks, Does anyone know the procedure to get outlook to remember my username and domain name. I don't mind entering my password each time I start outlook, but it grips my bits when I have to enter all three. Thanks, Jes

Hi James, I think I'm going to have to as I cannot understand it. I've just tried it again after having manually exporting the second query and it worked - this time for the first two queries. So it seems like it's unable to create new files! Doubly weird in that 1)the first time it created...

Hi, It's a standard access database and the info is quite happy to manually export. The difficulty is that it works for the first one in the list but not for the rest. Hmmm Jes

Hi Folks, I'm running some code that runs a query and outputs the result to excel using the docmd.transferspread command. This process takes place for a number of queries each sending to a different spreadsheet. When using access 97 there was no problem, but having upgraded to 2000, the first...

Hi folks, I have an excel97 spreadsheet that contains the name and Id of a client along with an embedded picture of them. I want to copy the image, save it under a filename made up of the name and Id. Oh, by the way, I know I can manually copy and paste, but with 1000's of these I'd rather...

Hi Dreamboat, Worked like a dream, cheers mate, Jes

Hi Dreamboat, I'll give that a go later and let you know, Jes