Access
Thu, 13 Nov 2008 19:20:59 -0800
Is there a way to include a value from a text box on a form as part of the
path name when using transferspread in a macro.
C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls ...
|
Permissions Error
Thu, 13 Nov 2008 18:41:55 -0800
I have designed 3 individual data bases in access 2003. These data bases have
been installed on a computer that runs access 2000.
One of the Data Bases opens without a problem. The other two will not open
with an error message that says:
"You do not have the necessary permissions to open this data base"
...
|
Enabling combobox based on output of option group, and how to filter
a report
Thu, 13 Nov 2008 15:22:23 -0800 (PST)
Hello!
Two questions:
a) I have an option group with 2 radio buttons. If the output is 1, I
want combobox to disable. If the output is two, I want it enabled.
I have put the "If opgroup.value=1 then combobox.enabled=false End if"
in the Form_Current, the Form_AfterUpdate(), the Opgroup_BeforeUpdate
(), a ...
|
Auto fill
Thu, 13 Nov 2008 14:21:02 -0800
How do I use a list of names on one spreadsheet and have it use the list for
inserting each name into a certificate, one for each name printed? ...
|
How do I move row information down several spaces ?
Thu, 13 Nov 2008 12:52:13 -0800
In 2003 Access how do I move row information down several spaces in the same
column? I want to add new information in between. ...
|
How do I do this in Access 2007?
Thu, 13 Nov 2008 12:26:03 -0800
Hi,
I have Access database has a customer table.
The customer table has a customerID field datatype is autonumber (prim. key).
I made a CustomerEntry form base on customer table.
On customerEntry form has a textBox lookupCustID field.
What should I do if I enter a value in lookupCustID, onexit event it
lookup ...
|
leading zeros in autonumber
Thu, 13 Nov 2008 09:31:02 -0800
Hi, I'm an old SQL/FoxPro type, and the help here is great for dragging me
kicking and screaming into the foibles of Access!
My question: can I force a fixed-format onto an Autonumber field? I need
the autonumber to display on a report with leading zeros, e.g. "000016." Do
I need to convert it to text fi ...
|
|
|
force uppercase in part of expresssion
Thu, 13 Nov 2008 01:06:01 -0800
I want to combine fields first name and last name, but I want Last name in
upper case. The last name field in the table is forced to upper case with
">", but that does not work in the expression (well I can't get if to work.
Probably a super simple question, but thanks.
M ...
|
Can I do this in Access? Please help
Wed, 12 Nov 2008 15:05:00 -0800
The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since ...
|
How do I use count if in access?
Wed, 12 Nov 2008 11:42:01 -0800
I am trying to add a count if fuction to my report. I run this query and I
want it to ountif like Copy only. How would I show this on the last page of
the report?
SELECT [Vault Audit].[Loan Number], [Vault Audit].[Date reviewed], [Vault
Audit].[Original Signed Note?], [Vault Audit].[Scanned Note?], [Vault ...
|
