|
Bread down numbers by categories based on value with uneven steps
Hello
How can I break up a column of numbers by categories with uneven steps
without going to long iif statement
Thank you for your help...
|
7 |
01.08.2006 20:12:02 |
|
Lost Alignment and Sizing
I used to have a dropdown in a toolbar that let me choose from "Narrowest",
"Widest", "Tallest", "Shortest", "Align Left", "Align Right", "Align Top",
and "Align Bottom." Well, maybe it was two dropdowns - one for Alignment
and one for Sizing. These dropdowns are gone. I'm able to get
similar-looking tools by choosing the "Alignment and Sizing" toolbar in
"Toolbars Customize," but the...
|
2 |
01.08.2006 18:40:25 |
|
auto fill ins
I have a master employee list with personal information. I want to make up
some forms that will auto fill in the fields when I input their Emp.ID
numbers. I am new to access please help in easy to understand format
--
Have a great day...
|
2 |
01.08.2006 17:49:55 |
|
I'm confussed!
I have know idea if I am even posting correctly, but I am so confused, I
could toss PC in the trash. I have a preloaded HP that has been restored so
many times its awlful! But I am not a develeper or tec or anything so why am
I getting all the updates for it? Its windows XP home edtion just have got
sp2 was told it would solve all, but I can't even move desktop icons or start
screen sav...
|
4 |
01.08.2006 17:46:35 |
|
ODBC -Call Failed?
What does this mean and how can I fix it?
IT recently conducted a server change (moved data from old server to new)
When I attempt to run a report in Access (which is linked to SQL) I get the
ODBC error.
Help please and please use laymen's terms as I am not too familiar withthe
program.
Thanks...
|
5 |
01.08.2006 14:52:02 |
|
I need help with setting up an attendance register
I have 10 classes that I see for 1, 2 or 3 hours per week.
Each class has about 30 students.
I have set up tables for the student details (FirstName, LastName,
ClassGroup, etc (personal details, etc....). What I want to do is set up an
attendance register that brings up the classes (determined by the day of the
week), capture the date, record who was present, absent (or Late but
attende...
|
8 |
01.08.2006 14:35:02 |
|
Multiple Tables linking
I'm trying to develop a database with three tables as follows:
Vendor
Vendor#, Vendor Name
Specification
Spec#, SpecName, Paragraph#
Results
Vendor#,Spec#, Paragraph#, Yes,No, Comments
The work is all done at the RESULTS table. To update I will select a Vendor,
a specification and a Paragraph number and will answer Yes or No and add
Comments.
I've tried to do this with a Querie b...
|
3 |
01.08.2006 14:25:55 |
|
how to change color in cell
I am access rookie. How do I change color or highlight individual cell in
datasheet without changing color of entire datasheet....
|
3 |
01.08.2006 14:15:02 |
|
how to get SQL query update time
Dear all
i have a bulk insert statement and i want to find out the time how it
will take to run form
query analyzer...
Raghu "manab"
...
|
3 |
01.08.2006 11:53:05 |
|
scanning a document from my office scanner
I want to scan some listings from my office scanner & send to an email
(client) in my office we have a large bulky konica 7145, how do i do this?
--
diyonne raines...
|
2 |
01.08.2006 03:49:40 |
|
IS there a simple book or tutorial on how to use Access 2003?
Is there a simple book or tutorial on how to use Access 2003? Microsoft
offers an 18 Part training course -- no doubt for money. I don't need that. I
am an database expert. I have designed databases. I have written database
applications. I sat on the ANSI database groups for several years to
standardize SQL databases. I have worked as a DBA. I read documentation very
well. But I cannot f...
|
4 |
01.08.2006 00:40:02 |
|
we need template for investment/insurance sales
Consider giving the client user defined field creation control...or make
accept suggestions for industry ....specific... templates.
Goldmine.. ACt... have user defined field creation freedom ...in addition
to provding industry templates
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggest...
|
1 |
31.07.2006 22:59:01 |
|
Triplicate
I completed an Access/SQL Database Linking but now when I attempt to run my
reports one of two things happen:
Each line item is in triplicate or
I will get the following error message and the report won't run:
Undefined function 'sGetBudEmp' in expression
How can I fix? What do I need to change or delete? I am an absoulte newbie
so please be gentle!
Thanks for your help. It is g...
|
2 |
31.07.2006 20:33:36 |
|
Run report on a forms I'm currently editing
My Form has a button which unts a Macro which prints a Report which is run
off of a Query whose criteria is [Forms]![My Form]![ID].
After having no luck with it displaying the current record I was editing,
through testing and debugging, I was able to determine that once the current
record I'm in is in edit mode (you know, with the little pencel icon), my
report won't print the changes I...
|
5 |
31.07.2006 20:28:13 |
|
Word
I was typing in Word and after about 30 minutes rec'd an error message below:
Run time error!
Progrom: C:\Program Files\ Microsoft Office \ Office 10\WINWORD.EXE
abnormal program termination
When I hit the OK button Word closed entirely. I got back into it and my
document was saved and I can open it but cannot type any more or print it.
When I try to type or print that same error...
|
4 |
31.07.2006 19:45:39 |
|
IIf statement and age
I'm wanting to calculate an age either by date of death or current date in a
query. How do I do this?
I currently have expressions to calculate current age, but if a patient is
deceased, I want it to display age at death instead of the current age.
Thanks.
Philip Wright...
|
5 |
31.07.2006 19:06:01 |
|
I want Access to import an Oracle table..
How do I get Access to see my Oracle tables. What, on Access, do a click?
The odbc driver seems to be set up. ...
|
4 |
31.07.2006 17:53:02 |
|
slow printer
printer will start fast, reach the middle of page, halt for 30 sec. and then
start again. It takes two minutes to print a page. How do I get it to move
faster?...
|
2 |
31.07.2006 14:54:01 |
|
How do I connect 2 databases?
I am having difficulty with combining Inventory Control and Order Entry. I
need to be able to put in received merchandise and take out inventory sold
without doing it in both databases? Supplier and Vendors in the same database
would work perfect. Also my UPC cades are not validating as text. Not sure
what to do.
I am not that savvy and just learning, however this is needed. If there is...
|
4 |
31.07.2006 14:51:42 |
|
Multiple dependent combo boxes
Hi,
I'm currently building an Inventory DB for entering HW and users. In
the DB I have created a form to define hardware. For this form I've
created several tables where I've defined Type, Brand, Line, Model, CPU
and RAM. On the form I've made combo boxen and linked them to these
tables. Now I would like to make the choices of these boxes dependent
of each other. I think I'll manage to cre...
|
4 |
31.07.2006 14:46:07 |
|
quarterly report help!
Hello All:
I have a database of clients, and I need to generate quarterly reports.
I have a field called "Successful at Discharge", where "Dry" and "Cured" are
two of the options. I also have a "Death" and "Other Complication" as open
text fields.
The report needs to contain (disaggregated by quarter):
1. # clients successful at discharge (either "dry" or "cured")
2. # clients wit...
|
6 |
31.07.2006 14:07:10 |
|
Help out a friend and get their data back into their newer app?
I have been working on a friends app over the week or so and I'm ready to
bring it back to him. Of course he and his company have been putting in
data in their version of the app.
So how do I get their "poo" from their app into my newer version?
20 tables with 2000 rows in a few of the tables, plus a few lookups.
TIA
...
|
3 |
31.07.2006 12:48:26 |
|
How can I re-call information?
Actually...i haven't finish the program yet....
I just want to see how it look like after finished....
so I have press the "start to use" button and I have choose the start
up page and do not want to
show information details and panel...
now....I can use but I can't add or change any information....
how can I re-call back those things? please help....
thx if anyone can!!!
...
|
2 |
31.07.2006 12:44:06 |
|
Saving access
Is it possible to save a .mdb project as a .exe so that when the program runs
you can't see all the access toolbars and stuff?
Thanks Ian...
|
2 |
31.07.2006 12:37:01 |
|
Printing a report from VB
I need to print a report from VB but I can not find any referenc to a command
in any of my books. Is there such a command that I am missing here? (there
must be)
Thanks Ray C...
|
3 |
31.07.2006 08:42:01 |