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
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
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
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
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
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
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
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
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
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