one to many or many to one2678 (11/17/2009 1:01:01 PM) UtfThe last time I did anything with a database was with dBaseI. And I know this
is a very simple thing for you all......But
Using access 2007 I have two tables.
how to handle meter readings231320 (11/11/2009 6:09:01 AM) Utfi 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) and then create a new
Help with pivot table3591 (11/11/2009 2:54:50 PM) JimboI want to know how many employees I have working in a given half hour
with the state licensure they have.
I have a table that has my employees, state licensure and each
individual half hour segement they a...
command button not opening related fields4491 (11/12/2009 2:08:10 AM) UtfI've made a command button with the wizard to open a related form from the
main form. Ex: On the contact main form, push a button to see all their
contributions. The wizard asks which form to open, I say ...
What tables forthis database1456 (11/15/2009 5:44:14 PM) BobI have a excel spreadsheet at work for shipments comming in to the
country for us, and then delivered by a transport company to a said
Among some of the 17 column headers, there are:
Questionaire1474 (11/15/2009 8:10:01 PM) UtfHow do I make up a questionaire that would ask additional questions based on
answers to previous questions?
ie: Did you hurt your upper body or lower body? Ans: upper Body
The next question to pop up should...
coin collecting database1928 (11/15/2009 1:23:01 PM) UtfA coin collecting database that will allow pictures to be added.
2 different Qty in order details in northwind5749 (11/12/2009 9:57:51 AM) Coco111Hi,
im pretty new with access 2007, i decide to use northwind template.
In order detail both form, i have 2 different Qty, the original Qty is the
Qty that will link to Inventory and I add another field ...
Sum of every page in a report11489 (11/13/2009 8:11:04 PM) UtfI have a multi page report which includes a field to calculate the
[Qty]*[Rate]. I would like to have a sum shown at the bottom of each page
and a grand total at the end of the report. Can anyone suggest ...
Nested combo box1657 (11/13/2009 8:12:45 PM) OceanSeventyTwoI have a database where I have a combobox field that you can pick the
raw materials that are used to make up a product.....
[ RAW MATERIALS V]
referential integrity and tables4493 (11/12/2009 10:26:02 PM) UtfI have several tables.
Let's say that Table1 is Inventory - it is a superclass table and contains
all inventory ids as its primary key and some other general info that applies
to each inventory item.
Need a little help with syntax6378 (11/7/2009 6:00:20 PM) plisvbHi 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.NewRecord Then
Me.invID = Nz(DMax(...
how to best structure this?3354 (11/9/2009 6:33:01 AM) Utfi 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 details the
Format of temporary variables0641 (11/9/2009 8:02:02 PM) UtfI have a pointer stored in TempVars!MyIndex
Within DLookup( or DSum( references to TempVars!MyIndex work fine
IIf(tblField = TempVars!MyIndex, does not work.
As a work-around I tried this...
(Object invalid or no longer set)5620 (11/6/2009 3:23:17 PM) MarkMy client's database is suddenly issuing this message and users need to
close and open the db. The Access database is on one server and the backend
(SQL Server) on another. I run across this on a personal d...
Field Privacy2390 (11/6/2009 3:06:01 PM) UtfI 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 database can not se...