Search results for query: *

I am creating emails in both English and French, and I wish to run a macro from the toolbar (one for English and one for French), which changes the LanguageID of the document and runs a spell check. Is there a way to change the LanguageID and initiate a spell check in VBA without using...

Many thanks for your help. Now, I must commit myself and tinker a little with a DSN-less connection. I was interested in creating a file DSN, just so to expand my knowledge, familiarity, and weigh my options as I am about to convert some of my applications from DAO to ADO. Thanks again,

I have been using Access since 1997 and am quite proficient. It is only recently that I have began to explore MySQL and Access. The differences are in the SQL syntax and ADO is required, which is simpler and faster than DAO and better geared for DSN or DSN less connection. Also, I find...

I just read your post and having the same problem, I wondered if you resolved it? I also noticed that there may be an error in your posting - a bad reference to sConn, which refers to itself without a prior definition. sConn = "File Name=H:\USERS\SHAREDDBs\UDLs\" & sConn If you resolved the...

I am in the same "boat" as you are. I prefer to use Access for its ease of use in VBA, DAO, ADO, forms and reports design. But, because of the very slow Access data retrieval in a multiuser environment, I have decided to switch to MySQL for the data tables. I have been studying the issue of...

The only way you can achieve what you want is to use an unbound text box, (instead of a label), on the left of the data column with the ControlSource property as ="Label caption". Then select the Hide duplicates property. However, using group or page header is a better option for column headers.

This is a simple problem but I do not wish to write an encyclopaedia. If you want help, upload a zipped sample copy of the database with a few records and I will provide the solution.

Change the cell format of all the cells of the Excel worksheet to text. You must be using the default 'General' format which is akin to a variant in MS Access.

Margin settings are controlled by the PrtMip Property of VBA. It is quicker and easier to manipulate the Page Header height per page and this requires tracking the page(s).

Does anyone how I can recreate/replace/repair the "Send to Desktop (create shortcut)" short cut? I tried numerous suggestions and VB scripts offered on the web. The closest help I found was a vb script which sent a copy of the selected item to the Desktop, but not a shortcut. I even copied...

Installation of SP 1 uninstalled Mozilla Firefox 1.0.3 and corrupted access to the Local security settings. While I don't care about Mozilla, I am unable to re-configure the settings. Any advise would be greatly appreciated.

I tried to log in at 4am (don't ask me why) from my workstation to the server (NT Server 2003 Standard, w/o Service Packs) and I received notification that I cannot log in between 1am and 6am. I am the OS installer and the administrator who maintains the server exclusively and there are no time...

Many thanks to all who responded. The problem is solved.

After installing Windows XP Professional and updated it, the Control panel Automatic update option is greyed out and I cannot disable automatic updates. Is there a registry setting which I can change to disable automatic updates - as well as repossess the control? Win2000P/Acc2000 - It's best...

Here is my address in plain text -> ineuw(AT)aei(DOT)ca Win2000P/Acc2000 - It's best to stay with products that work.

The way to to display query/calculation results as a column or line chart (vertical or horizontal), is to calculate the length of a label, textbox or a line based on the report's source values. For example: If a Table/Query field value is 58 and the bar's 100% length is is 4" then, the...

I just came across a website, which has some info for beckyh, about conversion issues from 97 -> 2000 -> 2002 -> 2003. Hope this helps. http://members.iinet.net.au/~allenbrowne/tips.html#flaws Win2000P/Acc2000 - It's best to stay with products that work.

To Ed2020: Could you kindly point me to a bug in 2000? I would be most interested in testing it since I am using it extensively. . . . . Thanks in advance. Win2000P/Acc2000 - It's best to stay with products that work.

I don't know about 2003. but it's not a problem when programming 2000 in Access XP. Also, you can simply export all your code from 2000 as text and reimport it to 2003. Just make sure you have the required libraries installed. Win2000P/Acc2000 - It's best to stay with products that work.

I have the right answer for you. Use a single character field. Here is the code as to how to do it. This comes from an application where the requirement was an "X" in the field instead of a boolean value! Private Sub VersionSpecific_Click() If Me!VersionSpecific <> "X" Then...