Up |
|
|
  |
Author: Bob LoveBob Love
Date: Aug 19, 2008 08:21
This hopefully is a very simple answer but I just can't seem to get it. I
want to track my orders with my venders. I'm trying to use a Main Form/ Sub
form format. The main form has my vender and ordeer fields from that table
and my sub form shows the order details (I.E. Quantity, description, unit $.)
I use a query to find all details that match the order # in the main form.
I have a field on the query the uses the expression of Qnty * Unit $ to
calculate the extended $ but I can't seem to get the sum of the extended $
to the subtotal block on the main form. I know this should be simple but I
can't seem to figure it out. Thanks in advance for any and all help.
--
Bob Love
|
| |
|
| |
6 Comments |
|
  |
Author: sadie32sadie32
Date: Aug 19, 2008 08:00
I am looking for a way to create a 'database' notebook of many
minimizable/expandable text boxes. The idea is to have one place to track
work done on numerous related tasks, and the minimized version of each
section should ideally show three lines: the title of the work area, date
last addressed (and by who), and next required task (with a due date).
Willing to try anything, but I'm a novice. This needs to be something I can
place on my organization's server for multiple accessors as a
password-protected type document. Due to the variation of duties, it does not
need to have special fields, so it is mostly a lineup of many note-pads that
can become short/small objects to allow viewing of the other notepads.
|
| |
|
| |
no comments
|
|
  |
Author: SaylindaraSaylindara
Date: Aug 19, 2008 06:51
I'm using Access 2003. First database design.
Database is for courses employees go on. So each course will have many
employees and each employee will go on many courses. I have a table of
employees and a table of courses. I also have a link table with 2 primary
keys - employeeID and courseID. In the info I got from a course I did it says
I can add fields to the link table. I'm trying to add a Mandatory yes/no
field and Notes field to the link table but when I add those fields to the
course subform it won't let me enter anything. Where am I going wrong?
|
| |
|
2 Comments |
|
  |
Author:
Date: Aug 18, 2008 19:21
Hihi, I have been trying for days.
I'm using dlookup but is returns the autonumber of combo box.
I have simplify it and here is how it goes,
I have 2 table name [tbl_Process] & [tbl_Stations]
[tbl_Stations]
Auto= AutoNumber(primary)
Stations=Text
[tbl_Process]
Auto=AutoNumber(primary)
Model=Text
Stations=ComboBox (tbl_Stations,BoundCol=1,ColCount=2,ColWidth=0,1)
Seq=Integer
In my form,
Private Sub Command0_Click()
MsgBox DLookup("[Stations]", "[tbl_Process]", "[Model]=""A"" AND Seq=3")
End Sub
it keeps returning the value of [tbl_Stations]'s Autonumber..?
pls help..
|
| |
|
3 Comments |
|
  |
Author:
Date: Aug 18, 2008 16:44
I have a Notes table linked one-to-many with the Clients table. The Notes
table has a date field to record the date a note was made. I'm trying to
create a report that will show me just: client name & the age of the most
recent note entry. I don't know how to make a query that will select JUST
the most recent note. [This allows us to determine how recently action was
taken on a given client, without having to page through all the clients.]
Thanks for your help.
|
| |
|
2 Comments |
|
  |
Author: lostlost
Date: Aug 18, 2008 16:34
My computer crashed and i need to load the office back on. the office progam
can be loaded on to 3 computers i have loaded it on the one that crashed and
my desktop. i need to put it on one more lap top. If i reload it on the one
that crashed dose it take up the thrid copie.
|
| |
|
1 Comment |
|
  |
|
|
  |
Author: RobsRobs
Date: Aug 18, 2008 04:16
Hi
Iw ould like to know how to delete duplicates in the same table, using a
query, as opposed to importing the data again, and declaring a primary key.
How would I go about doing this?
Thanks
|
| |
|
1 Comment |
|
  |
Author: reidapplereidapple
Date: Aug 17, 2008 23:23
Hi,
how do i enter number that starts with 0 into the table? like a phone number
for example?
thx
|
| |
|
3 Comments |
|
  |
|
|
  |
Author: WookawshWookawsh
Date: Aug 17, 2008 19:17
Sorry if this is a repeat question, but Im not sure if my original message
was posted.
Im trying to set the default value of several of my fields to the value of
one of my primary key fields.
Essentially I have a patient ID field called "STUDY ID" (primary key) that
is in One to many relationship with the STUDY ID field in other tables.
Instead of inputting this value over and over again in the various tables, I
would like to just enter it one time in a Form that I have designed. Then the
"ID" fields in the other tables will automatically get updated.
Im using the expression builder in the "Default Value" Menu, and putting in
for the other fields: =[STUDY ID] as the default value. When I try to save
this, an error message pops that that says that "STUDY ID" field cant be
found.
Any suggestions would be appreciated. I have very limited coding ability.
Thanks
--
Lukasz
|
| |
|
3 Comments |
|
|
|
|
|