Tetelestai
Last Activity: May 18 '11, 04:26 PM
Joined: Nov 20 '06
Location: Wisconsin
-
Thanks, I'll test this out tomorrow! -
hi,
not maximum, I should have included more example data. it would return all PartLength's of MaterialWidth X that are not found for MaterialWidth Y
adding this data
For width 3.5 the length returned would be 20.5, 62Code:62, 3.5 72, 3.5 72, 5.5 84, 5.5
For width 5.5 the length returned would be 36.5, 84
For Both widths 14.5, 72 would be returned...Leave a comment:
-
query to return recordset
I'm having a mental block on this
I'm trying to get a query to return a recordset that contains PartLength lengths of a certain MaterialWidth where they do not have the same length of a different MaterialWidth, Also a separate query would return duplicate lengths that are present for both MaterialWidth's
Example Data - Material Width will only be the values 3.5 or 5.5
...Code:Partlength, MaterialWidth 14.5, 3.5
-
For posterity
I am still unable to solve the relations above, so I decided to change the structure as follows:
Orders - remains the same
SubOrders - remains the same
Floors, Roofs, TrussFloors combined into 'Assemblies'
Panels, RoofTrusses, FloorTrusses combined into 'Items'
Relations:
Orders have 1:M SubOrders which have 1:M Assemblies which have 1:M Items
...Leave a comment:
-
Could it have anything to do with when the information in the text box gets the current records information vs when the form's current event fires?Leave a comment:
-
I'm running 2007.
currentuser is a instance of a class i made, if you change due dates and such it records who you are and when you did it. I did not check that 'currentuser' was used elsewhere.
QStatusType is defined as a number (long)Leave a comment:
-
On Current control.visible not working
I have a command button on a form that should be visible or not visible depending on a value in the current record and the current users user level. The code below is working as in the immediate window i get true and false when appropriate. However the command button will stay in its current state for several records. At times when I switch to the immediate window and back the button will do what it is supposed to do (ie be visible or hide). I tried... -
Are you using me.textbox.setf ocus?Leave a comment:
-
Any Luck or Applied Skill?
Thanks...Leave a comment:
-
my example was for VBA code sorry, here is it's usage in a query (paste in the Query builder in the 'field' row)
As I look deeper you may want to restructure your shapemultipler table. Read NormalizationCode:Multiplier: DLookUp("[1]","[tbl:ShapeMultiplier]","[Square Feet] = 1600")
I would suggest these columns
ID (Auto#), Square Feet (text), Shape {or what you...Leave a comment:
-
This should work to get the value of column 1 where square feet is 1600:
it is placing the value in a variable call sngvalue...Code:sngvalue = dlookup("[1]","[tbl:ShapeMultiplier]", "[Square Feet] = 1600")Leave a comment:
-
Here is a link that may help
Managing multiple instances of a form:
http://allenbrowne.com/ser-35.html...Leave a comment:
-
Or if not using the 'with' statement it would be
MyRS![Field1]="text"Leave a comment:
-
Thanks for the reply Mary,
I have read the normalization article. (read it again too). Can you take this statement too far?
I've created a table for each SubOrder type and each of those tables have a suborder parts table (Panels,Trusses ). See Below
Here is my table structure:
Table: Orders
...Code:JobOrderID, Auto#, PK Model, Number, FK Lot, Text, Subdivision, Number,
Leave a comment:
-
Relational table structure
I'm creating a database for housing component manufacturing plant. I have relations of Orders can have one to three Sub-Orders which can have one or many Levels(floors) which can have one or many Parts(trusses or panels) each Part belongs to one Shipment(has one or many Parts) many shipments make up a delivery Run.
I have read http://www.thescripts.com/forum/thre...elational.html and do have a similar situation but was looking... -
Is this just because of my construction of the query? Cause this is right out of the access help (2007)....Leave a comment:
-
Doesn't TOP 1 return more than one when there is a tie (the same date in this case)?
Example output where there is a tie.
...Code:Job Model JobReference Floor DesSchDate LR3-SG 1545 1st Floor 6/6/2007 LR3-SG 1545 2nd Floor 6/6/2007
Leave a comment:
-
Thanks Rabbit
I looked up your other post as well. Here is what I have so far. This is my actual tables and field names:
[code=sql]
SELECT [JobID] & "-" & [JobSubID] AS Job, Ordr.Model, Ordr.JobReferen ce, tblFloors.Floor , tblFloors.DesSc hDate
FROM tblOrders AS Ordr INNER JOIN tblFloors
ON Ordr.JobOrderID = tblFloors.JobOr derID
WHERE tblFloors.DesSc hDate
IN (SELECT TOP 1...Leave a comment:
-
Select query earliest child record by date
I would like help with the syntax of a query that will return 1 childs' record field that has the earliest date. I assume this could be done in a query.
example of tables:
tblOrder - Parent Table
OrderID - PK
OrderModel
OrderDesigner
tblFloor - Child Table (One or More instances)
FloorID - PK
OrderID - FK
FloorDueDate
FloorComplete
I would... -
The Access Runtime will be a free download for Access 2007 users
http://msdn2.microsoft.com/en-us/office/bb229700.aspx...Leave a comment:
No activity results to display
Leave a comment: