General

Vertical line width on report
I have got vertical lines in my reports where I want them using me.line method. Print Preview looks good, exactly as I wanted, but when I actually print, the lines are extremely faint, barely noticeable even. Is there any way to increase the width or make the lines thicker? ... 9 Apr 2010 19:00

From temporary table to master table and then join this in junction table
On Fri, 9 Apr 2010 01:13:32 -0700 (PDT), moso97ad <nyhusevej28(a)gmail.com> wrote: On 8 Apr., 17:52, John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote: . Do any of your spreadsheets provide a logical link between products and contracts? -- � � � � � � �John W. Vinson [MVP] I ... 9 Apr 2010 13:24

Clear All Checkboxes
I have a checklist that if a certain line is checked, i.e. a checkbox is checked, indicating inclusion a report will be generated of all checked items. However, when a user has completed the checklist I want the list to reset by unchecking all boxes in preperation for the next user. I tried this with "Setvalue"... 9 Apr 2010 12:17

Queries crash Access
We have several PCs running A2003 with a shared mdb on the server. They are all in a similar position re Windows updates (XP) and Office updates. On just one PC, running any one of our approx 40 queries causes Access to crash immediately and every time with that boring "has encuntered a problem etc etc" message.... 10 Apr 2010 06:57

Logical Expression as just a word?
I am trying to set the default value of a text box to say "Passenger and Cargo", but it is reading the "and" as a logical expression. I assume. It gives me a "-1" value when I view the form. How can I make it read "and" as just a word? ... 9 Apr 2010 11:10

Help with pivot
I have this strSQL = strSQL & " Pivot [Sales Analysis].[Quarter] In (1,2,3,4)" with text box named 1,2,3,4 and then i have this strSQL1 = strSQL1 & " Pivot [1a11f raw].[Quarterly] in (1f,2f,3f,4f)" with text box name 1f,2f,3f,4f, why doesn't that second part work?? ... 9 Apr 2010 11:10

How do I maintain macros on a Custom Toolbar
I converted Access databases from 2003 to 2007 format. The Custom Toolbar from 2003 came with to 2007. How do I add or delete from the custom toolbars. I want to add the macros for additional reports and queries on the current toolbars. ... 9 Apr 2010 13:24

Can A Tickbox Backcolor Change & If So How Would It Be Done??
Hi Does anyone know how to change the back color of a tickbox? I have a dropdown box (Listbox) that when a specific option is selected a number of different fields change colour so that the users have a helping hand in ensuring they enter details into the required fields. I have a tickbox that is needed t... 9 Apr 2010 10:01

Tagging
In my table i will have two months set of data. my text field [yr] and [mth] will determine the year & month. Sample of data is as follow [yr] [mth] [acno] [amt] 2010 01 123 100.00 2010 02 321 200.00 2010 02 123 150.00 What i want t... 14 Apr 2010 01:09

A problem occurred while xfile was communicating with the OLE serv
I have problems when opening the access file. The error message shown "The expression On Open you entered as the event property setting produced the following error: A problem occurred while xx was communicating with the OLE server or ActiveX Control" "Visual Basic for Applications (VBA) encountered a proble... 9 Apr 2010 12:17