|
Import 6 digit # for date How to format
I am importing data into MS Access 2003 from an external source. the dat
format is numeric 0digit number. ie: 107017 is Jan 17, 2007. Any Idea how I
can get the date to display in access... I've tried the format function but
it won't let me format as a date...
|
4 |
2/15/2007 5:36:53 PM |
|
|
AutoNumber Question
I would like to design a DB which would track the expenses of 40 customers
..The problem is i need to understand the concept of using the autonumber or
the actual 5 number account as the primary key in the customer table. The
customers would be billed monthly so the account would be repeated in the
field each time a new invoice is entered. Is this correct since primary keys
do not allow ...
|
7 |
2/15/2007 2:49:13 PM |
|
|
Employee attendance database help
Hello, I have an excell workbook that keeps track of employees attendance by
coping the correct Attendance code and pasting in the correct day and month.
I want to ncorporate something simmular into to this excel workbook into a
databse that I have. The database already has a tbl_EmployeeInformation which
has Name, Clock Number, Date of Hire, Department and some other spersonal
stuff lik...
|
5 |
2/15/2007 2:46:52 PM |
|
|
Calculations in VBA or queries?
I am developing some fairly complex reports involving detail data summary
data and calculations. I need to be able to save the results of some of the
calculations to be used in different reports.
To complicate things even more, I would like to be able to present the data
in a spread sheet format.
Would it be better build functions to do the calculations in VBA or try to
create queries ...
|
5 |
2/15/2007 3:05:05 AM |
|
|
Normalizing - HELP!
I cannot for the life of me wrap my brain around this. Maybe I don't
need to do anything for this particular table (and that is what's
making it so hard for me to grasp), but I'm pretty sure I do as a lot
of information repeats.
As I understand it, normalizing table design means you break a table
down into multiple tables so that you don't have any fields in a
single table that repeat. R...
|
11 |
2/14/2007 8:33:12 PM |
|
|
sendobject isn't available now
Out of 9 computers running access xp, 2 of them give me the error :"The
command or action 'SendObject' isn't available now".
I am using the sendobject to do a simple email of a report. Here is the code.
Private Sub Send_Email_Confirmation_Click()
On Error GoTo Err_Send_Email_Confirmation_Click
Dim stDocName As String
Dim stName As String
Dim stsubject As String
Dim st...
|
1 |
2/14/2007 1:54:07 PM |
|
|
Calculations Between Tables
Table #1 contains records of publishing events. Each record will collect the
hours needed per month to accomplish each event. Table #2 contains several
variations of monthly hours for different scenarios.
I need a publishing date (ex. 6/15/07) from a field in table #1 to cause
data from several fields (1 to 12 fields with several variations on different
rows) in table #2 to be placed in...
|
4 |
2/13/2007 10:58:33 PM |
|
|
Auction Database
Hello,
Has anyone heard or know of a Auction Database design? I trying to come up
with a very simple database to have item description, date, Current Price
(locked field), new bid (coded to add to Current Price) and a hyperlink field
to click on to show the picture of the item. It is only for a fun commitee
thing within a department. I thought instead of raffles, auctions would be
coo...
|
3 |
2/13/2007 8:24:00 PM |
|
|
Table to report design
Hello,
I am looking to create a report down the road where sums of categories are
created.
I currently have a table with a field that is populated by a calculation in
a query. It is further categorized by an account. For example:
2 dogs 100
1 cats 200
3 birds 300
3 dogs 150
If on a report I need to see:
dogs 250 cats 200 birds 300
How would I do that? Sho...
|
4 |
2/13/2007 6:15:42 PM |
|
|
Event Mgmt 2000
Membership Database is currently kept in 2000 Access; I now want to start
tracking event(s) and registering attendance for such events. I was going to
use the sample database for Events; Importing from the Mbrship Database the
Contact Information. How is the best way to accomplish?...
|
3 |
2/13/2007 2:49:21 PM |
|
|
Establishing relationship necessary with lookup table?
Because of a search on the web, I now know why I have been
encountering problems with queries in the few databases I have made:
due to using the lookup table wizard in tables.
If I understand correctly one should create a combo box, in a form,
that will be used to choose data from a lookup table (or a query based
on the lookup table). The chosen data is then used as input in the
intended f...
|
4 |
2/13/2007 10:10:21 AM |
|
|
unlinking linked image files.
I have a database cataloging art works. It has thumbnail images created
specifically for the database. when they were added as each record was
created I clicked on the link file box when I was adding the thumbnail image.
I believe this means if I change the thumbnail.bmp file it will change in
the database. But if I moove the database I would have to tell access where
the thumbnails ...
|
7 |
2/13/2007 5:43:02 AM |
|
|
Identifying the entity ...
Hi all. Can someone help me identify the right entities with their attributes
from scenario below?
HelpFit LTD runs a chain of fitness clubs in Kano. The Fitness club provides
exclusive fitness training for its customers. The club has so far maintained
its records manually but is now looking to setup a database application to
support its functioning.
Each fitness centre is managed by a Ce...
|
4 |
2/13/2007 4:29:17 AM |
|
|
Createdatabase (Save to a folder, name, import tables)
Hello;
Wondering if someone could help me stop pulling my hair out…. I am trying to
programmatically create a new database. When a user clicks on a command
button I would like the user to select a folder where to place the new
database. VB would then name the new database RMS – “The Users Name†(the
contents of a drop down comboBox “Team Nameâ€), then the current date.
Secondly...
|
11 |
2/13/2007 1:51:36 AM |
|
|
Exclusive Access to Database Message
Hi,
I have a shared database on our network. The database has a "STARTUP FORM"
that opens automatically when the databasee is opened. Database users are
now seeing a message that says "You do not have exclusive access to the
database at this time. If you proceed to make changes, you may not be able
to save them later". This appears even though the form is set to allow
design chang...
|
4 |
2/13/2007 1:41:14 AM |
|
|
how can import pdf files to microsoft access ?
...
|
1 |
2/12/2007 10:29:01 PM |
|
|
Hidden & System Tables
I have several Access 2003 databases containing tables with the usys prefix
and they are also hidden. I have imported onne of these databases into Access
2007. I cannot find in MS Help any way to show these hidden system "usys"
prefixed tables.
--
malcolm...
|
3 |
2/12/2007 8:36:01 PM |
|
|
does anyone know a good return track database for RMA?
I am looking for a database to keep track of the returned material from our
customers. RMA DATABASE that allows me to keep all the information regards
that RMA and easy to retrieve and add other defects into the same part
number. I.E. P/N 123456 was returned once in the RMA 6000 for poor crimp
12/12/2006 and now the same P/N is returned for bas soldering RMA 6060. ...
|
1 |
2/12/2007 8:36:01 PM |
|
|
Multi-tiered keyword table
Anyone got any ideas about the following.
I have a table of keywords. The keywords can be 3 levels deep so the table
has 3 columns Tier1, Tier2, Tier3. Tier1 is always present but Tier2 and/or
Tier3 may not be. If Tier2 is blank, Tier3 must be blank. I know this is not
normalized.
The user will be able to drill down to the lowest level. ie. I present all
unique Tier1 keywords and a "...
|
3 |
2/12/2007 5:23:02 PM |
|
|
Setting an Alert/Reminder in Access
I haven't really used Access before, however, I'm a little familiar. There
is a database that's been created for our customer complaints, which
different departments are assigned these complaints. We have a monthly
meeting discussing the status of the customer complaints. Between the
months, I would like to set reminders or alerts for updates with the assigned
departments. Is there a...
|
5 |
2/12/2007 3:05:02 PM |
|
|
inventory input
i don't have any idea on how to set this up but i need a datbase that i can
plug in my equipment one piece at a time. my headings in excel are
Tag | Type | R/Sp. | Make | Serial# | Description | Purc. From | Quan. |
Priced At | Initial Cost | Freight | Mis. Exp. | Tot. Cost | Sold for | Comm.
| Profit | Pd.√ |
& | Location|
then i need to be able to put an expense distributed to my ...
|
2 |
2/12/2007 2:39:37 PM |
|
|
exporting data to Autoroute from MS Access...
Does anyone know if mappoint will allow me to import a list of locations and
draw
me a route in the order in which they are stored/imported in the table; point
A , Point B, and so on...
I don't have mappoint, and can't get a demo, and don't want to comit to a
purchase until i can be sure it will do this accurately. (fed up spending
money on software that doesn't deliver what it promis...
|
2 |
2/12/2007 3:47:38 AM |
|
|
Database design
I have a database which tracks client investments. Periodically we
have to recommend a change to these investments. When we recommend
changes I need to print off a form, which shows the old investments,
the ticker, and the investment category along with all of this same
information for the new investment.
I have a table that has all of the investments offered for all
clients. This tab...
|
8 |
2/11/2007 12:50:40 PM |
|
|
Access "lost" updatable connection
Access 2002, fully service-packed, with linked SQL-Server 2000 tables.
Somewhere between Wednesday morning (everything worked as expected) and
Thursday, sometime, the front-end Access .mdb file "forgot" that a couple of
the SQL-Server tables were supposed to be updatable. Refreshing the link to
those did not make a difference -- the tables were not updatable (no adds,
no edits).
Add...
|
7 |
2/10/2007 12:27:01 AM |
|
|
Architectural Issue
I have a split application (tables in one database and apps in another) that
is now up to 13Mg and contains some 150 reports and 50 screens. I am
considering adding a whole new set of functionality which will probably add
another 5Mg. It will have some new tables, but much of the data is in
existing tables in the back end database.
My question is how would be the best way to add this ...
|
4 |
2/9/2007 11:26:08 PM |