Hi - My Job May Very Well Depend On This.

Nov 1, 2006

I'm new to database designing, and my first project is to build a website and database for the proposal development department at my job.

After reading up, this is the design I've gone with:

Proposal Database

I know this is really complicated for my first project. There is a lot of many to many relationships that I'm not sure that I need. I've tried to normalize it as much as I could, but thought I would post it here to get professional opinions.

Also, is it possible to create a form that would update the junction tables between the make to make relationships? For example, if I wanted to add Criteria from the EvaluationCriteria table to the first Proposal in the Proposal table, would I have to go in and manually update the Proposal_Evaluation table each time?

Any help would be greatly appreciated.

View Replies


ADVERTISEMENT

2 Comboboxes, The Values On The Second One Will Depend On The Value Of The First One.

Mar 14, 2006

Hi,

I have a problem and I need any help I can get!

I have a master form (MasterForm) and a subform (SubForm).

in the SubForm I have 2 comboboxes (Institution) and (Office).

Each Institution has a number of Offices.

What I want is:

Based of the Institution the user choose, the offices that belong to this instituion will appear in the combobox.

How can I do that?

Regards,
CS.

View 6 Replies View Related

Howto: Second Combo Depend On Value From Another

Aug 22, 2007

Dear all,

I am trying to do the following on a form:

field "A" is a combobox listing filed from a table (Field= CustomerName, Table=Customers).
filed "B" is a combobox that have to list filed Contact.Name where Ciontct.CompanyName = <companynmae selected at te first combobox>. What is the field name containing the value selected in the first combobox? How to write a SQL that workds?

Thanks for your help.
Itschak.

View 1 Replies View Related

Dropdown List To Depend On Other Field

Mar 15, 2008

I'm trying to set up a database of books in a small library - each book has a prefix (Maths, English, Art etc) which I want users to be able to pick from a drop down list - I can do this, but the next field is a sub-category - is there a way of populating the dropdown list for the sub-category field depending on the chosen entry in the prefix field. eg if maths was chosen I would like the user to have the choice of number area, volume etc. but a different choice if the prefix was English.

any help very gratfully received - it seems to be a simple problem but it has me stumped.

View 14 Replies View Related

Forms :: Subtract Value From Combobox Depend On Value In Other?

Feb 22, 2014

i want to substract value in combobox, but the source of the other combobox is in other table then Form query shows. How can i do that?

View 3 Replies View Related

Forms :: Make One Combo List Depend On Another

Sep 24, 2014

I have a combo: cmb_TrainingType. The sql is:

Code:
SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;

My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:

Code:
SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];

Both of the tables that are referenced have the fields TypeID and Type.

View 1 Replies View Related

How To Make A Table Lookup Field Depend On Value In Another Column

Sep 20, 2012

I have a table called Locations that lists Countries and Cities:

USA, Detroit
USA, Chicago
USA, New York
UK, London
UK, Liverpool
UK, Birmingham
France, Paris
France, Le Mans

I then have another table for inputing details on people I know. This table would have columns called Country and City. I've figured out how to make the Country column a "lookup column" so that I can only enter USA, UK or France. But how do I make the City column show only the appropriate list of cities relevant to the country that I've selected (e.g. Paris or Le Mans if France is the selected country).

View 5 Replies View Related

General :: Creating Dynamic RibbonXML Where Statement Will Depend On User

May 17, 2015

creating dynamic RibbonXML where statement will depend on user that is accessing access database. I created DynamicXML no problem and it changes context depending on user but my main problem is refreshing ribbon. I see that UsysRibbons tables changes fine but it's not being loaded. I have to restart access in order to this to take effect. I tried gobjRibbon.Invalidate method but it doesn't refresh ribbon for some reason... Here is my code:I created new module with name "Ribbon" and put this in there:

Option Compare Database
Option Explicit
Public gobjRibbon As IRibbonUI
Public Sub CallbackOnLoad(Ribbon As IRibbonUI)
' Callbackname in XML File "onLoad"
Set gobjRibbon = Ribbon
End Sub

and then in form that validates a user I put:

If (Not gobjRibbon Is Nothing) Then
gobjRibbon.Invalidate
End If

View 7 Replies View Related

Convert Mins:Secs To Hours:Mins Depend On Units Built

Dec 15, 2007

This is something I've been working on that very nearly works until it get to point DM

What I need to do is convert a build time for a single unit which is stored as mins:seconds into a build time depending on number of units being built then display the time as Hours:Mins.

I don't know of any functions in access that do this so have been playing with the code below which works upto the point of DM where I need to add the mins together then if more than 59 add the hour(s) to hours and then use the mins part as the total mins.

It needs a lot of cleanning up as been playing but hope somebody can help.

T = The Time IE 2:43
N = Number of units being built

Function GetTotalTime(T As String, N As Long) As String
Dim M As Double, S As Double, Y As Integer, MZ As Integer, MS As Long, H As Single, Min As Long, MM As Long
Dim DM As Long, Z As Integer
Y = InStr(T, ":")
If Y <> 0 Then
'Do The Mins Convert To Hours First
M = Left(T, Y - 1)
If M > 0 Then
M = M * N 'Minutes * Number Of Units
'Convert Total Mins Into Hours
M = M / 60
Z = InStr(M, ".")
H = Left(M, Z - 1)
'The Left Over Mins
Min = Mid$(M, Z + 1, Len(M))
End If
'Do The Seconds
S = Mid(T, Y + 1, Len(T))
If S > 0 Then
S = S * N 'Seconds * Number Of Units
If S > 59 Then 'Has Minutes
S = S / 60 'Convert Total Seconds To Mins.Seconds
MZ = InStr(S, ".")
MM = Left(S, MZ - 1)
'Dont worry bout odd seconds
Else
MZ = InStr(S, ".")
MM = Left(S, MZ - 1)
End If
End If
End If
'Now Add The Mins Together then / 60 to get hour /mins and add the hours to hours the remaining mins are the total mins element for build.
DM = MM + Min

GetTotalTime = H & ":" & DM

End Function


Many thanks

Mick

View 2 Replies View Related

Forms :: List - Values From A Table Depend On Selection From Different Table

Jul 23, 2015

Situation: 3 tables. Manufacturers, Countries & Provinces/States. 1 Form for data entry in Manufacturers.

Countries table contains ID, Country and CountryCode fields. i.e. 47, Great Britain & GB

Provinces/States table contains ID, Province/State and CountryCode. as in 1, Alaska and US.

In the form the country is easily selected from a list refering directly to the Countries table.

Problem: How to make a list in the form from which the user can simply select the province for the country that has previously been selected. And not a list with all teh provinces and states from every country in the world. (This would be a really really long list...)

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved