Recent content by meboz

Ive found that every time I have a line of code 'Docmd.echo false' i ALWAYS get an error. So I left it out. When code stops running echo seems toreturn to normal. Just some observations ive made, i dont know the ins-and-outs of echo very well.

Check out the filesystemobject thingy. You can get hold of all the files in a folder in a collection and loop through doing whatever it is you need to do.

Well look at this, Modest is causing more trouble. Is there possibly a way that the Moderator can have you barred from making comment in these forums?

Modest, your a clown. Every time I read a post with your input it involves some animosity. Meboz

docmd.openquery "myquery" Not sure if thats what your after. And to Modest, how about you answer the question rather than ear bashing with your own preferences for the way things should be done.

Are you wanting to display a msgbox if a customers total orders are >5?

Hi there, Im trying output a report to a word document, well its actually .rtf format, and then id like to password protect the document. Heres a snippet of the code, everything works a treat except for the password protection, please help. With DoCmd .OpenReport...

Very nice, thanks for the reply

HI all, I want to open a DAO recordset for the sole purpose of appending new records (.addnew). Thus, I do not wish to return any records (im a bit of a network conservationist), since I do not need them. My current method is to use an SQL statement with a WHERE clause on the primary key with...

Well, I never thought counting records was such an interesting topic!!! Have we all forgot about the overhead of domain aggregate functions? If you guys (modest etc) are so experienced, should you not be attempting to give the pros and cons of methods when suggesting them, rather than...

hey modest... what r u talking about?

ive had a similar problem b4 where access would display the built in error on the second run through the error handler. It wouldnt use my error handling. If someone could offer some light that would be handy

Hit the spreadsheet directly with an SQL statement Check this out... http://www.access-programmers.co.uk/forums/showthread.php?t=81742

True, but you didnt answer my question Pat. Yours is not to reason why... Can you tell me if there is an alternative in DAO to creating the user roster (ADO) that is suggested in the Microsoft Security FAQ? Also, I had another issue recently where i wanted to query directly some CSV files...

Just a thought, i havnt actually tried, but maybe turn of warnings when you open the form, and turn them back on when you close the form Dont forget to turn them back on in the event of an error, and youll also have the problem of an ungraceful exit...