format header cell in excel-TJ
Fri, 21 Nov 2008 10:38:00 -0800
I've programmatically created a new tab in an excel workbook and I'm having
trouble formatting the header cell text. I want to bold the text and then
format the rest of the column as a percent with only one decimal place.
The code below is what I have so far.
Any ideas??
TJ
Range("AD1") = "Percent"
...
|
Disabling Sub-report
Fri, 21 Nov 2008 11:21:06 -0600
I have a report which contains a sub-report that can be quite time consuming
to run - such that I would like to give users the option to "disable" the
sub-report.
1. Setting the visible property to "no" does nothing.
2. Setting the visible property to "no" and clearing the sub-report's record
source does t ...
|
Limit messagebox to security group
Fri, 21 Nov 2008 09:06:11 -0800
Greetings all, I have a timer on a sub-form that counts down a pre-defined
number of minutes. I would like to have a messagebox popup when it hits zero
but so that only members of a certain group can see it.
Is this at all possible or should I just create a form to look like a
messagbox have view access only ...
|
Changing Maxlocksperfile Temporarily and then Permanently
Fri, 21 Nov 2008 09:04:08 -0800
I am using Access 2000.
I have a table with 70,000 names and addresses. When I try to access the
table through a combo box, it will only go to (w)s. For instance, if I want
to search for a particular name of which I don't know, and I key in a (w), it
will bring up the first name that starts with a (w) but ...
|
MultiSelect listbox question
Fri, 21 Nov 2008 08:39:08 -0800
Hello,
I have a Multiselect listbox that I am using to filter a report. My problem
is that my listbox has 2 columns. I want to be able to filter by the second
column when it doesn't equal 0. Is there a way that this can be accomplished?
Thanks in advance.
Chris ...
|
Recommendation/Questions
Fri, 21 Nov 2008 07:37:18 -0800
I have MS Office 2003 to use for this project.
The current plan is to have an Access DB out there on the network and assign
users (360) throughout the organization access to the folder housing the
database for data entry purposes.
Over the next twelve weeks data will be collected and reported on. Every ...
|
Search Form Syntax
Fri, 21 Nov 2008 06:58:02 -0800
Iâ??m trying to search more than one field using only one field in my search
form.
Search Form
Name:
Address:
Phone:
When a user enters a number in the phone number search field, I want the
form to not only search for matching phone numbers but also fax numbers,
mobile numbers, etc.
This is what ...
|
|
|
record won't insert
Fri, 21 Nov 2008 03:26:01 -0800
Hi there
I have a line of SQL that inserts a record to a table. It runs fine
sometimes and doesn't run sometimes. I can't figure out any reason why...?
Here is a line that runs and inserts with no problems:
"insert into tblTrans (AccNo, TDate, Ref, Amount, Bal, CatID, Split, Income)
values ('10821468, #24 ...
|
Error 2046 when using OutputTo
Fri, 21 Nov 2008 01:09:01 -0800
This is a re-post from Forms Coding in case I was in the wring place:
I am using 'OutputTo' to generate a report in snapshot format.
It works perfectly when I bypass the StartUp form with the shift key, so
that it goes into edit mode. But when I start the database as a user would
do, and get to the snapsh ...
|
Editing photos- ActiveX control?
Fri, 21 Nov 2008 01:06:01 -0800
I have a databse that displays linked photos.
I need a software module (preferrable linked to a form field) that will
allow me to manipulate the pictures (and later save the results):
1. Resize the picture to a predefined resolution / color depth.
2. Draw on te picture (marking selecting areas with a "pencil"- ...
|
