Hi.
I want to select a product then be able to select a colour from a list that relates to it.
I want the colour lists to be different for every product. (clothes)
Whats the best way to do it?
Thanks
Jonny
How would i set up a table for a list,.. ie.
For each product there is a list of 5-10 things?
Product1.....Product2
a...............f
b...............g
c...............h
d...............i
e...............J
There can be new products added and new subs in the products. How can i build my table to correspond with data integrity?
One Manifest can have many line items. One line item can only have 1 designation. Each manifest may have many line item with same designations.
For example:
Manifest #0001
Line Item 1: N
Line Item 2: H
Line Item 3: U
Line Item 4: N
Line Item 5: P
Line Item 6: H
Table set-up
CurrentCY
CurrentCYIDPK
WasteCategoryIDFK
LineItemInformation [Line Item 1, Line Item 2, etc]
ManifestDataIDFK
ManifestData
ManifestDataIDPK
ManifestNumber [0001]
WasteCategory
WasteCategoryIDPK
WasteCategory [H, N, U, etc]
I'd like to query the line items for each manifest so the end result has the manifest number (Manifest #0001) in a field and the designations (N, H, P, U) in fields on a report.
I'm writing a simple job scheduling database, so I've got resource availability (by week) and job list (by week). I've written a single-column query whose only output is a unique list of weeks with resources available, and another single-column query whose only output is a unique list of weeks with at least one job allocated.
How do I join these so that I can get a single-column list of weeks that have either (or both) of resources and jobs?
So Query1 returns:
25/08/2014
08/09/2014
15/09/2014
while Query2 returns:
01/09/2014
08/09/2014
15/09/2014
22/09/2014
I want query3 to return:
25/08/2014
01/09/2014
08/09/2014
15/09/2014
22/09/2014
I am new to Access and am trying to reduce a dataset I am working with to make it managable for Excel. I have three columns which have three unique parameters and one column with numberical content.
Column A Column B Column C Column D
NJ Red Monday 10
NJ Red Tuesday 20
NJ Yellow Wednesday 30
NY Red Monday 35
NY Green Tuesday 40
NY Green Wednesday 60
I want to elimiate column C from the dataset, and sum column D for every unique combination of Column A & Column B. I have figured out how to reduce down the dataset to get a list of all unique combinations of Column A&B,what formula I can use in a query to sum column D on my table for every unique combination of column A&B. This is a simple SUMIF in excel, but my dataset is too large for excel.
I am trying to figure out create a new table from two other tables. It is a tax document and one has a pin field that is unique and the other the pin field is not unique. So in the table the that doesn't have a unique pin field, the pins occur multiple times for all the different tax enitites people pay to. I need figure out how to make one table that combines these too. I have tried using the relationshop function but i am not sure if this is what i need to do and i am not that familiar with access. If there is anyone that can help me please let me know. or if you need any more information.
Thanks
Justin
Mclean county regional planning commission
Hi,
I'm having problems relating a pivotchart with search criteria automatically after the search - all on the same form. This will be a nifty trick if it is possible, and I can imagine other uses for a form like this.
Without being overly wordy, I attach a mdb in hopes that someone with a bit more skill than I will take an interest and set me on the right track.
I'm sorry if this is obvious, but I have asked local professionals and scoured this site for answers before posting...
I have a database that I'm using to store and analyze language samples (basically, the mistakes that students make when trying to speak in another language). For each bit of language, I want to be able to say what domain the mistake belongs to - e.g. the 'clause', 'phrase', or 'word' domain. I have a table containing the five domains. I also have a table for each of these domains, containing the specific types of mistakes relevant to that domain. It is conceivable, but unlikely, that I will ever add to the domain table, but highly likely that I will add types of mistakes in the five related tables.
As I analyze bits of language, I will be appending each analysis (record) to a table as shown in the attached image. So far so good. The part that I cannot fathom, though, is how to display (let alone perform calculations on) this data: While the ErrorDomainID is a foreign key to the ErrorDomain table, the ErrorUnitID could refer to one of five tables, so that an ErrorUnitID of 2, for example, could refer to one thing if the Domain is 1 but quite another if the domain is 1 or 5 or whatever.
I've tried all kinds of coding and SQL workarounds, but I have a feeling I'm just missing something very basic here. If anyone could offer some guidance, I'd be extremely grateful!
James
Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful
Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation.
In other words if X combo box is chosen (There are many combo boxes to choose from) populate xx text box with the sum of a calculation.
Refer to the print screen example of my program: http://www.roofmart.net/Rest.asp
Notice under the label felts the 15lb 36” felt combo box is chosen and it displays the value of 11 and next to the combo box is a text box that displays the value of 25 The calculation will be (11*25) = 275 this value of 275 must be added to the text box values that are being shown in the forms header under 30yr where it reads $4,606.80 and 40 yr $6002.80 only, this is because the 30yr comp and the 40 yr comp combo boxes are the only chosen roof types under the label roof types above the felt label.
Hopefully this makes sense.
Thanks -- Any help with be greatly appreciated.
How does Access relate a label to a control?
We can delete the label, and then re-'attach' it, but there seems to be no visible property that retains this information - in either the label or the control (only done the detailed comparison for text box so far.
The reason for this is to be able to export enough data to recreate an Access form in html, and I need a label value if it exists. (And for most controls, of course, it does!)
I am a new access user and I have several questions primarily can i relate field names to a primary key in another table?
View 9 Replies View RelatedHello. I have just added some tabs (pages) on one of my forms. The problem is that the background is gray and I cannot seem to change it. How would I go about changing the background colour of each seperate tab(page)???
View 1 Replies View RelatedIs it possible to create a combo box showing colours. I don't mean the wors Blue, Red etc I mean a list of actual colours?
View 14 Replies View RelatedHi all,
Is it possible to have different colour fonts in forms automatically?
i want the user to add numerical data into the form but the middle numbers must automatically be coloured red. these numbers are then matched to stickers in the same format for easy identification.
it should look like this 878802
any suggestions?
Many Thanks
Sam
Is it possible to change the colour of scroll bars in subForms?
Seems odd that you can easily customise all the colours, yet have to settle with a horrible looking grey scroll bar!
Any help or a 'work-a-around' to the problem would be welcomed.
Thanks
I got the following code from:-
http://www.microsoft-accesssolutions.co.uk/alternate_row_colours.htm
This is to give me alternating row colours in report detail section but cannot make it work.
Please could someone tell me where I am going wrong?
Not sure where to put the bit "Private m_RowCount As Long"
The Rest apparently goes in the report detail section OnFormat event.
Private m_RowCount As Long
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
m_RowCount = m_RowCount + 1
If m_RowCount / 2 = CLng(m_RowCount / 2) Then
Me.Detail.BackColor = 15263976 'Change value to the color you desire
Else
Me.Detail.BackColor = 14811135 'Change value to the color you desire
End If
End Sub
Thank you Guys and Gals.
Hi there,
I have being creating some forms with Access 00/02 and I have come across one for me particular strange and somehow annoying item “Colours”.
My question here now is, how would it be possible to use instead of the say ”Back Color: 65280 numbering” a colour scheme similar use in web design i.e. hexadecimal or where at least could I find a list of colour numbering??? as used in Access.
Thanks aktell
Hi I've got some code from http://www.lebans.com/alternatecolordetailsection.htm
It allows for alternate bands of color to be displayed for alternative records in Forms in Continuous View. I've looked in this forum for other alternatives to this but the only ones that are available change the background of a control rather that display a whole row that is filled with colour. So therefore the background of the row is say in red, the background of the text controls are in red.
I've managed to put the code into my form and download the class. The only problem is that I can't seem to set the colour in the actual class file - it's all a little bit confusing! Can you help? Pleaseeeeeeeeeeeeeeeeeeeeeee........... :D
You can download the sample database from http://www.lebans.com/alternatecolordetailsection.htm
:)
Hi,
I have a continuous form which has a combo box limited to green, blue, yellow, red, purple and N/A (for blank).
It is possible to make the back ground colour = what is entered into the combo box?
I have been searching and searching and have seen conditional formatting everywhere but it wont help as i need 6 options. I only have basic VB skills and usually can only hack and change not write from scratch:o
Anyone able to help me please.
Hey,
Got a simple question really...
Designing a form and I have boxes where the data is entered.
The form background is grey and i would like the data boxes to be grey
as well, unless the box is "active" meaning its selected.
ive done it for one form but i can't remember how on earth i would do it on another from i need to do.
Many Thanks
Does anyone know if the command buttons in access 97 forms can be changed?
thanks
How do I format:
First 25% of records - Gold
Second 25% of records - Green
Third 25% of records - Yellow
Fourth 25% of records - Red
I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs).
The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done.
Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol).
Anyone shed some light on this? :rolleyes: :D
I have a company logo that has 2 colours to its name
I want to put that logo onto me report. I have tried but I am unable to do this
company name APICAPACITORS, API IN RED CAPACITORS BLUE ,is it possible without making 2 words
Hi guys,
i saw a sample DB here somewhere but cant find it now...on the mouse move event (when hovering on an image) it made the colours lighter (as if someone has shone a light on the button). Just wondering if anybody knows the code for this event?
thanks
I'm using access 2003. I've got a textbox placed ontop of an image that I want to make it seem to disappear on a conditional format.
The back color property of the textbox I want to set is "13160660". How do I choose this colour when applying conditional formatting as I only seem to be able to choose from the swatch of 40 default colours and no option to define custom colours.