how to handle meter readings
i have to create a table that will import meter readings
my first instinct is to just have a simple table that has meter number,
location and then readings by date (june, july etc) an | | 1 | 53 | 11/11/2009 7:14:05 AM |
how to best structure this?
i am upgrading a cost calculator from excel to access so need some advice on
the best way to structure this please!?
i'm starting with one spreadsheet called Linehaul Costs, which det | | 3 | 48 | 11/10/2009 5:37:01 AM |
shipping database
I am looking for a simple Access application (2003 or higher), much like the
FedEx QuickShip program, except I only need the Shipping (with capability to
print shipping label) and View His | | 1 | 58 | 11/10/2009 5:34:56 AM |
Format of temporary variables
I have a pointer stored in TempVars!MyIndex
Within DLookup( or DSum( references to TempVars!MyIndex work fine
but
IIf(tblField = TempVars!MyIndex, does not work.
As | | 0 | 46 | 11/9/2009 8:02:02 PM |
Invoicing database design
I am designing a database that includes the simple (!) functionality
of producing invoices (not an accounting package). I understand the
convention is to have a table for invoice headers an | | 11 | 41 | 11/9/2009 12:10:18 PM |
Need a little help with syntax
Hi Guys,
Having a little problem with some code. I'm wondering if anyone with a keen
eye can point out my error.
Private Sub Transaction_Type_AfterUpdate()
If Me.NewRe | | 5 | 55 | 11/8/2009 1:07:39 PM |
Appending table autonumber problem
I am appending one table to another. The autonumber field in table1 ends at
989. When I append the second table's records, it jumps the number from 989
to 575272. Why does it do that and | | 5 | 52 | 11/6/2009 11:41:07 PM |
Store similar types of records all in one table or separate tables?
Suppose you want to have four different types of records.
Each of these records have numerous fields in common, and a few fields
that are unique to each type of record.
Most | | 2 | 51 | 11/6/2009 9:07:19 PM |
Field Privacy
I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the d | | 2 | 54 | 11/6/2009 5:32:45 PM |
Where should relationships be created?
I am trying to clarify where the prefered location is for relationships. I
am working as a contract employee to "cleanup" a database created by someone
else. All relationships | | 9 | 47 | 11/6/2009 3:55:59 PM |
Date Format
I want to have my report display a date format for example 11-05-09, i want
it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out
if I try and format this in the table | | 2 | 50 | 11/5/2009 10:49:18 PM |
Show employees and others in combo box
I am trying to figure out a way to show employees and non-employees in a
combo box. The training database includes training records. Training may be
conducted by either employees or outside | | 3 | 49 | 11/5/2009 10:46:13 PM |
Need to have two autonumber fields in one table
Hello,
I've created an inventory dbase for a grocery warehouse and initially I
created one table for different types of invoices:
1) Incoming
2) Outgoing
3) Shrink | | 3 | 47 | 11/5/2009 7:58:45 PM |
Need Help Updating Table
I have a form that has some fields on it. When you click a button it opens
another form that the first form passes data to. For instance Form 1 is
customer information then you click on | | 4 | 56 | 11/5/2009 6:33:02 PM |
Need guidance for Inventory dbase, want to avoid calculated field.
Hello All,
I've searched through countless "calculated fields" threads but I've never
found an answer to my question.
I'd like to know the best way to set the fol | | 24 | 44 | 11/5/2009 1:44:56 PM |
real estate database design
I 'm creating a database with several commercial buildings, lots of tenants
and lots of car parking spaces - some spaces are included in the lease and
some are paid for separatly, also som | | 7 | 52 | 11/4/2009 11:42:02 PM |
Access auto numbers
I have just started using access 2007. I used 2000 in the past. I need help
with handling auto numbers. In my 2000 data base I had a Serial Number field
that I had populated by auto number s | | 3 | 47 | 11/4/2009 1:13:32 PM |
25 Hosting Web www.ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Host | | 0 | 96 | 11/4/2009 11:50:31 AM |
Strategy for groups within recordset
I couldn't think of a good, brief subject line for this thread. I have an
Employee database with EmployeeID (PK), FirstName, LastName, etc. Some
employees hold Certificate A, others hold L | | 4 | 45 | 11/3/2009 8:09:11 PM |
Defining Relationships/Primary Keys between two tables
Hello,
I am having difficulty in designing a database and specifically creating the
correct relationships and primary keys.
Right now I have two tables that have several fi | | 4 | 47 | 11/3/2009 7:11:20 PM |
Need help with several many to many relationships
Hi, and thanks for your help.
I am creating a database for creating multiple choice tests. I keep getting
stumped because there are several many to many relationships. Right now my | | 8 | 39 | 11/2/2009 6:12:46 PM |
Student class payments
Hi,
I building a database for karate classes and payments. I have these tables:
tblStudents - for basic info (name, address etc)
tblKarateCls - a lookup table for the classes
tbl | | 6 | 40 | 11/2/2009 4:11:13 PM |
Tracking competencies with Access 2007
I'm trying to create a (I think) simple db to keep track of a list of
employees in different work sections and when they pass several
different competencies. The employees can take the compe | | 3 | 50 | 11/2/2009 8:53:56 AM |
no political relations in internaional ....
Hi, I think should be better if the international thing such as
communication, electrical power, or any other international useful things or
ideas dosn't take any impressions from government | | 1 | 49 | 11/1/2009 2:30:23 AM |
Re :mail windows
ciao
| | 0 | 47 | 10/31/2009 10:25:31 PM |
Re :mail windows
ciao
| | 0 | 180 | 10/31/2009 10:25:31 PM |
Relationships bwtween more than one table
am working now on one database where i have 5 tables, each record from one
table is related to one another in other table with One to Many Relation
in other words, each record from one ta | | 4 | 43 | 10/31/2009 12:51:05 AM |
Organizing Table
Good Afternoon,
I have a very basic question regarding the organization of my table. I
will have monthly data that will be entered and it will be for various years.
Is it better to | | 14 | 44 | 10/30/2009 5:26:01 PM |
Data of many records of 1 form to populate another form via Cmd bu
Hi,
I am working on a database in which I need to be able to use a cmd button to
populate a new form but I need to be able to add many records from the
initial form in order to do so. < | | 1 | 44 | 10/30/2009 1:54:01 PM |
how to make name table and purchase table join and get data of sales?
Dear All
Thanks to this forum I have made some headway. Again I am stuck.
table1 with 50 names and staff code.
table2 with 100 items, price and stock.
With the | | 5 | 39 | 10/30/2009 5:48:00 AM |
Form Design
I am using Access 2007. I have a db with 2 tables (employees, discipline).
The tables are not joined because i keep getting the error that there is a
mismatch in the data. There is a common | | 3 | 47 | 10/29/2009 11:45:02 PM |
client/server setup
I'd like to create a client/server application where multiple users can
read/write access a single table, each user accessing a unique portion of the
table. If I create a link to the table i | | 2 | 54 | 10/29/2009 8:42:41 PM |
Database Design
I am trying to build a database for equipment maintenance for a construction
company and I need help with almost everything. I am using Microsoft Access
2007 and I am confused.
I | | 2 | 53 | 10/29/2009 8:14:41 PM |
client/server setup
I'm trying to set up a client/server application where multiple people will
be simultaneously editing a single table. (Each user will be restricted to
only those records belonging to him and | | 2 | 47 | 10/29/2009 7:44:29 PM |
Linking Two Tables
I have two tables in Access 2003, Master (Parent) and Hours (Child).
Currently they share a One-To-One relationship. I need a record to be created
in the Hours table every time there is a re | | 2 | 48 | 10/29/2009 6:21:02 PM |
DVD Movie Database Question
I am creating a DVD Movie Database using the template on Microsoft Office's
Web Site. My question is this and please correct me if I am wrong. It seems
to me that if you have a DVD of a tele | | 1 | 56 | 10/29/2009 4:15:47 PM |
Making a Database for 14,000 providers in Access 97 need resources
Can you guys point me towards some good resources to help me make a database.
I want it to be able to search by provider # and name. Each person will have
name, provider #, ss # and a big co | | 22 | 49 | 10/29/2009 9:02:17 AM |
Multiple Many-to-Many relationships
Hello,
I am working on an archival database of media materials related to the
accomplishments of a non-profit group. One section of the database is devoted
to articles. I have a ser | | 10 | 36 | 10/28/2009 7:43:41 PM |
combo boxes
Hi
Please help.
I have created a form with a subform. I have a 2 combo boxes in the subform.
When I choose an option on the 1st combo box it restricts the choices
throu | | 2 | 54 | 10/28/2009 7:23:01 PM |
simple address db question
i know in the back of my mind i know how to do this but...
when i select the suburb in the lookup field i need the table to
automatically update the postcode and state field from the loo | | 4 | 49 | 10/28/2009 1:56:01 AM |
Linking an ID number to a name
I want to have an autonumber ID number assigned to every entry, however is it
possible to recognize when the name is repeated and put the original ID
number in without having to do this all | | 5 | 49 | 10/27/2009 1:38:15 PM |
Table validation rule - allow only one occurence in a field
Hello,
Suppose there's a table (many side):
ID (PK)
ID_foreign (FK)
field 1
field 2
yes/no field
How can I allow ONLY ONE record to have "yes/no field" | | 4 | 50 | 10/26/2009 4:40:01 PM |
Need a database that I can use for a consignment store
Hello I am trying to figure out which database to use. Is it easier to start
from scratcha nd deisgn one or does a template help. If so, where are the
templates related to retail store. ie i | | 3 | 55 | 10/26/2009 3:38:27 PM |
table/database question
this is the information i want to store in my tables. i have an assembled
product, let's call it a car. The car will have several different assemblies
with each assembly having different c | | 3 | 54 | 10/26/2009 3:05:40 PM |
Developing a new DB; Organization, Relationships, Cascade Update..
Here’s the scenario. I have four tables, all with client-related data, for
instance, first name, last name, phone, address, notes about conversations
and discussions with each client, and a | | 6 | 42 | 10/26/2009 8:15:24 AM |
Query Speed
Hi,
I have a database which contains tables which are linked (via ODBC) to
tables in my company's data warehouse. The tables vary in size and number of
records, but the larger tabl | | 5 | 45 | 10/25/2009 8:42:22 PM |
Recording the frequency of Yes/No Fields
Hi all,
I'm designing a database that requires users to specify the number of times
a Yes/No field occurs. This number is not required if the choice is No but if
Yes, I plan to create a | | 11 | 41 | 10/24/2009 2:34:03 AM |
linked ODBC tables
is there any way to see the exact path of a linked ODBC table in Microsoft
Access? In the linked table manager, all I see is "Database=Claims".
Perhaps I am asking the wrong | | 1 | 56 | 10/23/2009 6:47:35 PM |
Random test generator
Hi,
Can anyone reccomend a sample question and answer database example. My needs
are:
Choose from a sample of 150 questions, multiple choice answer, to produce a
test of 50 question | | 1 | 52 | 10/23/2009 5:48:18 AM |
Can't see choices in lookup drop-down
I am creating a database that includes two tables of names, one for our
Admins and one for our Inspectors. In the other tables/forms, I am putting
text boxes as lookup fields so that the user | | 5 | 33 | 10/22/2009 10:10:52 PM |
top 5%
I have a list of applications that have help desk tickets and need to
determine the top 5% of defects by the number of tickets called in per month.
What would be the best way to set this up? | | 4 | 46 | 10/22/2009 7:52:02 PM |
Rule to prohibit someone from working on a project or in a time sl
Hi
I have a database table where you enter records of people with specific
tasks in certain time slots.
For example:
Record 1: Jim Smith Project A Tues 10-12pm
Record | | 4 | 40 | 10/22/2009 6:55:01 PM |
Non-limited table relationships
Apologies in advance for my basic understanding of access, although I know
what I'm doing with the rest of the office package I'm volunteering with a
local group (mainly older generation who | | 3 | 44 | 10/22/2009 5:32:01 PM |
Monthly Vendor Report
Need help and don't know where to start. Working in Access 2007 and need to
create the following.......
Need to create the following report
V# Vendor Name Jan Feb | | 30 | 51 | 10/22/2009 11:25:33 AM |
Appending a table by adding only records who are not duplicates
I am designing a database program for a Fantasy hockey league. table A gets
Players current stats from an excel spredsheet it is linked to. Table B is
to be updated with the current stats. | | 2 | 49 | 10/21/2009 6:51:01 PM |
Linking Multiple Front-end Database Files
I am having a problem with Access that I can not figure out. I hope someone
can help. I have three database files, two front-end and one back-end.
Front-end1 has two different users. Fro | | 3 | 38 | 10/21/2009 3:52:01 PM |
I have no "Attachemtns" option in access 07. Is it an option?
In Access 2007 there should be an "attachments" option in the drop-down menu
for a new field in a table. I do not have this in my software. Is it an
optional part of the install th | | 2 | 48 | 10/21/2009 2:13:01 PM |
setting parameters for numbers in a column
I need to have a column that only numbers 1-20, with a repeat numerical
system of 1 - 20 for a database of 200. The project: breaking down 200
employees into groups of 10 so I need to number | | 1 | 50 | 10/20/2009 9:21:01 PM |
Share a Db
I am using Access 2003
I created a database for a PM Program that sometimes requires more than one
person to use the program at the same time. Is there a way to allow this to
happen. I | | 2 | 44 | 10/20/2009 4:06:05 PM |
My database is deleting rows by itself??
I have a very small Database with 4 tables a few qrys and frms. This
database has been used for years with only one table. Recently I added three
tables to be able to keep some historical | | 3 | 49 | 10/20/2009 12:53:01 PM |
Personal Vendetta - Clinically Obsessive
Arno R
Personal Vendetta
Clicically Obsessive
Rarely posts help
self-appointed forum police
all of that effort goes for naught
Chasing after Steve | | 8 | 43 | 10/20/2009 12:49:01 PM |
Need help to figure out a strong look up for pay tables
I am in the military and building a medium sized Access database. I am
currently trying to figure out a good way to track a soldiers pay for the
day. First step would be to use their entry d | | 1 | 46 | 10/19/2009 7:59:01 PM |
Problem using Date() for default value in my Date/Time field
I just installed Access 2007 on my computer today. I created my database
using a previous version of Access.
For some reason Access 2007 does not like =date() as the default value in | | 4 | 47 | 10/19/2009 2:58:01 PM |
can you change from one template to another
This is my first attempt at using access so please be gentle.
I am uncertain at this time which fields I will actually need for my
database. If I select one template, can I convert or | | 2 | 50 | 10/19/2009 12:50:43 PM |
Relationships between tables and querys
Hello all, thanks in advance for any insight.
I'm trying to figure out the best way to utilize relationships with tables
and queries.
I have a table called tblItems, which | | 1 | 51 | 10/17/2009 6:21:01 AM |
UNC Question
I use unc to link all my tables from FE to BE. Most are like
\\arserver\fileshare\My.mdb Some users, because the IT people won't allow
us to set everything up the way we want it, don't hav | | 2 | 54 | 10/17/2009 12:29:01 AM |
Database Design help - Newer user
Hi,
I'm kind of new to the forum... I posted several days ago. I'm not
sure if older posts are read so I'm posting again and I've been able to
figure out a few things since my last | | 7 | 50 | 10/16/2009 7:08:01 PM |
Creating work queue list
What is the best method to create a main page that lists all of our open
files? This should work as a menu in that the info for each file cannot be
changed here - it would need to be select | | 2 | 50 | 10/16/2009 7:03:01 PM |
using a date as archiving trigger
Hello,
I have a question that I'm not sure if it's possible for Access 2003. I'm
creating a database where we would like to use a project's end-date as the
trigger for archiving the reco | | 3 | 38 | 10/16/2009 6:15:21 PM |
database bloat/size
I'm using Access 2003 and my FE is in 2000 format. I've been puzzling with
the file size of my secured FE. It's a project of 7 years in the making. It's
gradually grown in size however recen | | 11 | 38 | 10/16/2009 3:26:07 PM |
Date Format
I have a database with a date field which I have set to "short date". On my
input form, I set the default to date(), also formated to "short date". Then
I use a query to | | 5 | 51 | 10/15/2009 10:13:07 PM |
data validadtion
Hello All
I have a field 'ni_number' in a table which must always be 2 alphas then 6
digits then 1 alpha, and I have the validation for this in place. In fact,
however, the first 2 al | | 8 | 41 | 10/14/2009 7:23:22 AM |
Choose Profile pops up when going into design mode in Access
The Choose Profile message pops up when I go from Form View to Form Design in
Access 2007. This happens randomly and not always the same form. When I
press OK the database displays the hou | | 0 | 40 | 10/13/2009 9:53:01 PM |
recording multiple session dates for regular clients
I have just started to create a database for a psychology practice. I am
trying to enter all relevant details including session dates. With the Client
Name as the primary key I am having tro | | 1 | 44 | 10/13/2009 1:46:54 PM |
No Record Display after Click
In my form, "Form1" (which link to a query), there are 2 command buttons. 1
is to run the query and the other is to return to switchboard. When the query
runs, it open another form | | 0 | 46 | 10/13/2009 6:30:01 AM |