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 | | 0 | 16 | 11/11/2009 6:19:27 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 | | 0 | 8 | 11/10/2009 7:41:47 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 | 8 | 11/10/2009 7:41:47 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 | | 0 | 14 | 11/10/2009 7:41:45 AM |
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 | | 0 | 15 | 11/10/2009 7:41:41 AM |
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 | | 0 | 19 | 11/10/2009 7:41:35 AM |
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 | | 0 | 16 | 11/10/2009 7:41:33 AM |
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 tabl | | 0 | 13 | 11/10/2009 7:41:27 AM |
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 outsid | | 0 | 12 | 11/10/2009 7:41:25 AM |
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 an | | 0 | 18 | 11/10/2009 7:41:19 AM |
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 | | 0 | 13 | 11/10/2009 7:41:09 AM |
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 | | 0 | 18 | 11/10/2009 7:41:03 AM |
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 | | 0 | 18 | 11/10/2009 7:40:57 AM |
table not updating
I am adding records to tblEmployees using below, no connection:
strAddRecord="INSERT INTO tblEmployees() VALUES ()"
DoCmd.RunSQL strAddRecord
and this works fine. I then open the same tabl | | 3 | 82 | 2/6/2008 7:12:00 PM |
how to transfer report to pdf file?
hi,
Is there any code or thing that can transfer a report to pdf file?
many thanks
| | 1 | 78 | 2/6/2008 1:32:30 PM |
Many to many table realtionship
Hello,
I have read some explanantions about many to many table relationship, but it
is not so clear to me in practice.
My church membership database that I am going to make will | | 1 | 77 | 2/6/2008 12:32:43 PM |
stop duplicate records being created.
I have a table for OT(primary Key is ID that auto numbers) that the employee
goes in to a form and enter in the hours they are available to work for the
week and that does create a good rec | | 1 | 121 | 2/6/2008 5:58:24 AM |
querry of 2 different times -- I need the 6 minutes before and aft
I have 2 tables that have coorsponding data that are gathered in time. In
table A the time is (EX. 12:34:17pm) in table B the time is calculated every
6 minutes for the required data (EX 12 | | 5 | 85 | 2/6/2008 4:51:38 AM |
preventing users from changing date field
We have a Date of Birth field in a few different forms that are all linked
to the same field in a table. What I would like is for users to be able to
enter a date in this field for a new rec | | 10 | 68 | 2/6/2008 2:55:28 AM |
Annual Roll-Over
Hi all,
I'm hoping that my tables are normalized properly, but I'm stumped on a
particular layout and design structure.
I hav a table with faculty, which is always on the (1) s | | 6 | 73 | 2/5/2008 5:58:02 PM |
Is this do-able? Multi-random options
I have 12 locations, 4 security checks, and 16 different security check
times. They want to put in a db a months worth of random checks (so they can
see ahead at when they will do them), pe | | 2 | 77 | 2/5/2008 4:43:04 PM |
multi level design in need of help
This form has five sections (all on a tab control) 1. materials 2. up 3.
down and 4. take up and 5. properties. Each of these sections have parameters
associated within the tab.. Section 1 is | | 0 | 89 | 2/5/2008 4:16:56 PM |
Merging two tables together (more difficult than it sounds)
I have two tables table07 and table08 one has data for 2007 and the other
2008. What I need to do is to take the information from both tables that
matches and put it into a big table for a rep | | 1 | 87 | 2/5/2008 3:11:02 PM |
OLE object defaults
I have some records that I need to add a Visio drawing to. The
drawings are stored within an OLE object. It works fine.
However I need to be able to set some defaults for the OLE object s | | 0 | 96 | 2/5/2008 3:04:47 PM |
How do I download & upload data into MS Access2003 via RS232 Port
I have an in-house developed control room program receiving data from
different sources & I want to also receive data via a RS 232 port from a
radio transmitter. Help
| | 2 | 81 | 2/4/2008 6:56:35 PM |
Linking two forms
Hi there,
I have two forms linked as tables by a one-to-many relationship.
This is what I need. A control on the "one" form which opens the "many" form
but which filters record | | 1 | 68 | 2/4/2008 4:44:56 PM |
Multi-User Database
I would like your opinion on this; I have a ms access database that will be
used in a multi-user environment, across different Teams. Data will be loaded
from text files several times a day in | | 3 | 74 | 2/4/2008 2:49:41 PM |
Layers in client documents
I have a client who wishes to place several hundred documents into a
database. Then attach values to specific statements in the document. So far
so good.
But, the documents are inc | | 7 | 74 | 2/4/2008 2:31:01 PM |
design dilemma...
I am working on a database that, among other things, will be used to
record Chemistry Lab Values (it's for Cancer Treatment).
The structure of the table is like this:
CREATE TABL | | 6 | 66 | 2/4/2008 8:36:48 AM |
schedule recurring events an access database
I am trying to create an access database that will show upcoming appointments
with clients. These appointments are always recurring every month, 3 months,
or 6 months. I would like to enter | | 3 | 111 | 2/4/2008 6:53:22 AM |
Problem with normalization
We will likely be using Access 2007 ... We currently have Access 2000.
I am having a problem thinking though how to set up the tables in order
to get my design going in a reasonable dire | | 3 | 69 | 2/4/2008 3:46:54 AM |
Lookup Field
When using a lookup field, which gathers its data from another table, is
there a way to create criteria breakdown without doing a query.
For example. I have a large rolodex table with hund | | 1 | 68 | 2/4/2008 1:41:02 AM |
set focus on a specific record after adding new record
I wrote in Dec. 07 regarding a consultant with suspect programming skills
(majority of programming done with macros and multiple examples of empty code)
. I appreciate all the feedback. The | | 8 | 82 | 2/4/2008 1:01:23 AM |
Using Access to tally points
Ok, I am designing a database using access 2007. First of all i am trying to
make a table that tallys all Users points from an "Events" table. I am unsure
how to go about this. First of i ha | | 1 | 78 | 2/3/2008 8:58:23 PM |
Accumulate Time
This is probably a simple question for most of you, but I really appreciate
the help!
I have a table named "Issues" with a primary key of "IssuesID" (autonumber)
what I created a form ba | | 3 | 75 | 2/3/2008 7:15:40 PM |
Create a new table with fields from another table
Hi,
I have a table with a field "Question". I want to use this table to create
anothertable "Survey" and the fields in the new table must be the questions
in the "Questions" table. | | 2 | 93 | 2/3/2008 6:54:00 PM |
Help with a query design
I have three tables: Customers, Products and CustomerProducts. For
simplicity, the Customers table has two fields: CustID and CustName. The
Products table has three fields: ProdID, ProdName | | 1 | 73 | 2/3/2008 6:06:50 AM |
How can I change the file path/location of my tables
I have copied an application to a different location on my HDD in and
attempt to modify and and test changes without affecting my original
application. Unfortunately the copied application | | 2 | 79 | 2/3/2008 4:05:35 AM |
Conversion to 2007
I have developed a database in 2003 and now I need to install it in a mixed
enviroment some PC have 2003 and some 2007 is there an easy way to make sure
everything works the way it was designe | | 5 | 76 | 2/3/2008 2:46:54 AM |
modifying a linked table?
Access 2000
I want to add some columns to a table.
When I try to enter design mode I get a warning message saying I cannot
modify a linked table.
When I look at Relationships there ar | | 5 | 80 | 2/2/2008 7:42:24 AM |
Any advantage to me shifting from Access 2000 to Access 2007
I currently have an application that I developed about 4 years ago using
Access 2000/VB6 on Windows 98. I now use Windows XP.
I am a beginning programmer.
I have a need to Modify the app | | 7 | 58 | 2/2/2008 2:34:17 AM |
Excel Values Entered Then Values Populate In Access Table
I currently have a spreadsheet that when I enter data in Excel, am I able to
create a Table where the info in Excel will populate in the Access Table? If
so, how do I go about doing that. I | | 2 | 74 | 2/1/2008 8:31:10 PM |
ODBC Errors
I have an Access 2003 mdb that is an FE to a SQL 2005 database. I began
getting ODBC errors and discovered I am unable to simply open linked tables.
The error is odd:
ODBC--call fai | | 2 | 73 | 2/1/2008 4:16:02 PM |
Add/Edit fields
I am trying to have data entered into an add/edit field carried over to the
next add screen until the data is changed. Example - If I put "Name" in the
first screen when I enter into a new | | 2 | 79 | 2/1/2008 3:52:19 PM |
Database as Spreadsheet
I have not designed a database before, I have done queries, forms, reports
etc from db's that have already been set so I am in new territory here.....
I have inherited a database that wa | | 4 | 73 | 2/1/2008 3:33:57 PM |
where can I find a list of xml tags for Ribbon images/icons?
working on customizing the ribbon and need a list of the xml tags for icons.
Would also like to know what the xml coding is for using your own custom
images.
| | 1 | 92 | 2/1/2008 12:15:49 AM |
Database Design
I have a Deposit Date which has many Deposit Receipt Numbers which have many
details such as PayeeName, Amount, AccountNumber.
I'm thinking I need a Table for the Deposit Date and a tabl | | 1 | 87 | 1/31/2008 11:52:02 PM |
Dates
I'm using a form for a from/to date for users. I was using the calendar
control but I ended up with some bizarre "froms" and "tos". I set the "from"
to 1/20/2008 and got all the records fr | | 5 | 65 | 1/31/2008 7:36:36 PM |
CAN ANYONE HELP!
I have a database that I created that contains the following fields.
Date, Envelope Number, Name, Offering Type, & Amount.
Here's what I would like to be able to do?
I would | | 3 | 75 | 1/31/2008 6:10:56 PM |
need help creating a database for a school library in msa
I have basic knowledge using access and im trying to help my school get some
kind of database set up for checking in and out books. I need something
basic that will:
1) allow me to | | 3 | 76 | 1/31/2008 5:36:07 PM |