Search results

Check out Stephen Lebans site for a utility called RotateTextWMF at http://www.lebans.com/products.htm Hope this helps Regards Trevor from http://www.sparkdb.co.uk [This message has been edited by accesswatch (edited 08-06-2001).]

You ask why. The reason is as follows: Once you know that the RECORDCOUNT property does NOT mean a count of the number of records in the recordset but in fact is a record of the number of rows accessed so far or The higest record number accessed within the recordset so far then it starts to...

I've got a sample database with commented code which shows a number of search and filtering techniques. Check it out here http://www.sparkdb.co.uk/html/download10.html It's the third download (bottom of the page) It uses both Search techniques and Filtering. Hope it helps Regards Trevor from...

Check this link for the following: http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM Printer control from Access - Book Chapter - Do you want to be able to control your printer directly from Access? This sample chapter from the very popular Access Developer's Handbook [Getz et...

What version of Access are you using?

ACG Developers do an email class library at http://ourworld.compuserve.com/homepages/attac-cg/ The email classs library greatl extends the functiopnality of sendobjects. Not sure if they have a free version but they do have a demo Pro version Hope this helps Trevor from...

I'm not sure if you are aware but (someone correct me if I am wrong) the Office Assistant (Clippy) is being dropped in Access XP. So your future upgrades may have to be recoded to take this into account.

Not so much competition more a complimentary site, more than happy to direct people to this fine site when appropriate. On the error number not being found. The error number is in the database but some of the characters in the text string have been changed during the extraction phase so looking...

Sorry missed the first part of your question Builtin means it is 'Built In' to access i.e it is installed with access and is always required. The always required libs with 97 are the DAO lib and VBA If your property reads Builtin FALSE then this applies to a lib that you, or another install...

Confusing isn't it Version 4.0 is the Typelib Version Not the file version Try this link for further info about the DLL http://support.microsoft.com/servicedesks/fileversion/dllinfo.asp?sd=MSDN Try this link for infop about Typelibs...

An alternative method, if you do not want your calling form to be visible whilst the (UserDetails) form is in use, is to set the (callingform) to visible = false. You can do this in the (UserDetails) onopen or onactivate event. Likewise when you leave the (UserDetails) form you make the...

Check the help file for the GROUPS Collection and the GROUP object These contain anumber of examples that may be of use to you Regards Trevor from www.accesswatch.co.uk

The only thing I can think of is that at some point a reference has been set up to the VBA5.DLL by another program or install. VBA5.DLL is not required by Access 97. The libraries required by Access 97 are VBA332.dll (Builtin) MSACC8.OLB (builtin) DAO350.DLL (not Builtin) In any module goto...

The docmd.runsql action can only be used for running Action queries or data definiton queries i.e any of the following query types ...Action Query type... Append Delete Make-table Update ..Data-definition queries.. Create a table Alter a table Delete a table Create an index Delete an...

Your welcome I have not used this so would be interested to know how easy, or not, it is to use and what sort of info it produces. Has anyone else used the Jet UserRoster? Regards Trevor from www.accesswatch.co.uk

The following method works for Acc2000 ACC2000: Checking Who Logged into Database with Jet UserRoster http://support.microsoft.com/support/kb/articles/Q198/7/55.ASP Hope it helps trevor from www.accesswatch.co.uk

Try this link they do a PDF and Mail Class library for Access which may meet your needs. Quote from there site: "The e-mail class supports auto log on (no profile choosing) and easy inclusion of any number of attachments (Now there's something you cant do with Access' SendObject method!"...

You could also use the reports On No Data Event to display a message box and then cancel the report Hope this helps Trevor from www.accesswatch.co.uk

This does not answer all of your question but one issue to look out for is that Access does not allways close after it has been used in automation. this is a recognised problem and the solution is to allways use a QUIT. The CloseCurrentDatabase is not allways sufficient. The help file example...

Check out this Kb article I believe it applies to 97 also http://support.microsoft.com/support/kb/articles/Q200/5/48.asp regards Trevor from www.accesswatch.co.uk