|
Access 2002
I would like to track 10 vehicles expense.
gas, repairs, and by whom.
Any help out there?...
|
3 |
17.08.2006 17:45:01 |
|
|
Colums/Rows Link?
Hi
I am working on a database which would contain a skill matrix. So, if I
have Names as records, and the skill types as columns, then each name
would have a rating against each skill.
The problem here is, I want the users to be able to add new skills as
and when they are identified...But the skills are in the columns, how
do I get to do this? Maybe another table and link it?
Am not s...
|
13 |
17.08.2006 16:21:33 |
|
|
Archive Data
I have a table containing details of customer orders which has a dropdown
status field. When the status is changed to 'completed' I want the order
details to transfer to a separate table so that the first table only contains
details of incomplete orders. Would I do this with an append query?
Many thanks....
|
3 |
17.08.2006 15:53:15 |
|
|
Reading files from a drive
I've got a strange one for you access Guru's.
Everyday we download txt files and my access program extracts the data from
the files and puts them into a table.
When the user I have created the program for tries to run the program, no
files are found. when I run the program the files are found.
* The user has full access rights to the folder and parent folders
* The user can access t...
|
4 |
17.08.2006 15:42:08 |
|
|
Extract Date out of General Date
I have a series of rows that resemble 6/1/2006 5:34:34 PM type of
format.
However, I would really only like the extract out the 6/1/2006 portion
of this date. I have used left(fieldName,9) but this wouldn't work too
well if the month was a double digit, or if I left it as 10, it would
grab a portion of the hour in time.
Is there a work around for this? I have searched and attemped but ...
|
2 |
17.08.2006 15:36:12 |
|
|
multi-users, split databases
I have reviewed most of the post regarding :split databases and multi-users,
but have not found if the answer I was looking to find.
If the database has auto-numbering on the files; will the split databases
allow one user to enter a record, while the other user enters a record at the
same time, will the database save the second record? I have not used a split
database before now and need ...
|
2 |
17.08.2006 15:08:17 |
|
|
Changing Design view
I'm trying to modify a database that was made by someone else. The database
will not fit on one page when you view it. How do I change it so it fits on
just one page. I went into the design view but couldn't change it. I'm sure
it is something simple to do but I don't know how. So if someone could help
me I would appreciate it. Thanks in advance....
|
2 |
17.08.2006 14:42:26 |
|
|
Enable a field Based on the Length of another field
In a subform I am inputting records. If the length of alngzPatientNumber
field is 7 then I want to enable the chrPatientName field which is the last
field in the record, otherwise I do not want it enabled. Here is the code I
am using but when I run it the debug error window comes up.
Private Sub txtPatientNumber_Exit(Cancel As Integer)
If (Len(Me!lngzPatientNumber) = 7) Then
...
|
8 |
17.08.2006 13:31:02 |
|
|
Legal Database
I'm trying to setup a legal database that will essentially be a repository
for summarized info about court cases. One of the early problems I'm having
is with how to treat multiple defendants. Often, there may be three or even
more defendents listed in a case.
It seems to me that in SIMILAR circumstances, I've seen it suggested that a
seperate table is appropriate. However, this situ...
|
9 |
17.08.2006 12:58:00 |
|
|
What is the easiest way to learn Excel?
Can someone please give me some information on the easiest way to learn
Excel. I know a little but not a whole lot.
Thank you ...
|
4 |
17.08.2006 12:24:02 |
|
|
Switchboard as Default
Hi this is probably pretty apparent, but I can find anything on it.
I would like the switchboard to be the first thing the user sees as opposed
to the switchboard in a pop-up with the menu showing behind it.
And I would like it to open in full page view, and fit on anyone's screen
regardless of settings. Is this possible?...
|
5 |
17.08.2006 11:54:21 |
|
|
Silly Question - Icon Madness!
I created 6 reports. Four of these are shown with a dark green book icon and
two have a light green icon. I can see all of the reports in the menu, but my
boss can only see the dark green icons. For a minute I thought they had been
erased!! What did I do and how can I correct this so that they are all
visible?? What does the light green icon mean as opposed to the dark green
icon...
|
8 |
17.08.2006 11:20:57 |
|
|
Need Direction - Map one access mdb to another
Hello All,
I am really all turned around. New enough to not know better!!!!
Problem Setup:
I have made some changes to my VB application so it captures more data and
writes it th a database. In the writing of my Version 2 of my app, I took
my existing db and just added the necessary additional tables, and added a
few fields to some of the pre-existing tables, and created new relat...
|
2 |
17.08.2006 07:04:02 |
|
|
Access 2000 in form design view footer will not let me drag down
I am in Access 2000 for design view. Access will not let me drag footer down
in order to extend the page and continue inputting design. I have searched
for various ways to find this answer. I've tried single form, continuous
form, auto resize, yes, no, even inserting page break. Even my co-work (who
knows more) is stumped.
Shar...
|
10 |
16.08.2006 21:36:02 |
|
|
Password in back-end database
Both my front end and back end database have passwords.
However, I now cannot run the application since every time the application
tries to access a linked table, it gets a password failure. How do I get
around this?...
|
2 |
16.08.2006 20:18:29 |
|
|
Purchasing Log
I have a purchasing log. When I pull up a vendor to look at my order the
second page doesn't show up. It is blank. Any suggestions? Thanks in
advance....
|
7 |
16.08.2006 19:57:01 |
|
|
Query range of values?
If a field contains a range of values (example: 12345-67890). I have a
parameter query which needs to pull this record if the number entered falls
in the middle of the range (example: pull all records for 12348). Can this
be done? if so, how?...
|
7 |
16.08.2006 18:54:01 |
|
|
Pulling Back Duplicate Data
Hi,
I want to design a report to pull back data where there may be more than one
record for a client like so:
Client# Product#
123456 8888
123456 1199
111111 9988
111111 1199
How can I use the Client # to pull back all instances of product #s??
Thanks...
|
3 |
16.08.2006 18:16:48 |
|
|
How to create criteria query depends on control in form
I have main form (unbound) and subform (recordsource from query1), and want
to set criteria in query depend on control Text1 in main form.
Now my criteria in query is =Forms!Form1.Text1. My subform show correct
data, but my boss also want to see all records such as not type in control
text1. How can I write criteria in query (show all record if control text1 is
null or show record accor...
|
4 |
16.08.2006 17:40:02 |
|
|
Adding fields to a table that do not appear in a form
I am a newbie who is trying to create one large database to use as the basis
for several forms, in lieu of entering data in several Excel spreadsheets,
for a job placement firm. The idea is to use the large database to enter all
necessary information, and create forms for each scenario the company needs
(pending jobs, jobs in search stage, placed candidates, and closed jobs.) I
have succ...
|
15 |
16.08.2006 14:53:01 |
|
|
How do you change the color font for just one record in a sheet
I am working on a database sheet and want to highlight individual records
with color code. When I go to the format button on the tool bar it changes
the color of the entire database.
...
|
2 |
16.08.2006 14:49:42 |
|
|
Dcount function in query not work?
I want to find number of days between two dates form Table Holiday with
condition from TblVac (StartVac and StopVac field)
One field in query I type
Vacationdays:DCount("Dayoff","Holiday","Holiday.Dayoff between #" &
(TblVac.StartVac]) & "# and #" & ([TblVac.StopVac]) & "#"))
When I run this query, No any error message, Other fields work OK, but
result in vacation days is "0" all record W...
|
4 |
16.08.2006 05:19:22 |
|
|
How can I assign user permission
I assign user and group by user-level security wizard like these
Group User
Admins Admin
Full data user AAAAA, BBBBB, CCCCC
New data user DDDDD
and then I try to use user and group permission to limit some permission of
CCCCC
to open some forms by click open/runin permission box to deselect form.
I have Form1, Form2,,,,,,,,,...
|
5 |
16.08.2006 03:53:23 |
|
|
Finishing Project?
Hello,
Well, after weeks of work, every book the library had on Access, and
tons of help from this and other online groups, I have finally gotten my
first Access project working the way I want it to! Yippee! Now, would some
kind soul please tell me (in beginner terms) exactly what I have to do to
"finish" the project and get it set up for one or two people to use it at
the same t...
|
3 |
16.08.2006 01:34:06 |
|
|
Microsoft Office Outlook
I have Outlook 2003 and am experiencing trouble with duplicate and triplicate
emails. Regardless of whether I "mass email" my congregation or simply email
one individual, the recipient(s) receive multiple emails generally timed one
minute apart.
Is this a contact list issue? A virus? I'm clueless. Any thoughts or
suggestions would be much appreciated....
|
2 |
15.08.2006 23:55:46 |