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
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.
My database has a front end that uses forms to allow the user to navigate within it, each year we create a new database which is based on the previous year's database but with all the variable information removed.
Within the database each form has a caption that starts with '2014-15' then goes on to say the form name.
Most of my forms also have a yellow background, (last year it was pink).
Both these areas were set up so that each year our users can distinguish between our databases, as they may have last years and this years open at the same time.
What I would like if possible is to know whether I can get a user to change both these things from within a form. So something along the lines of a button that when clicked would check all form captions and if within the caption it finds 2014-15 then change it to 2015-16 (or whatever the user specifies) but keep the rest of the caption.
I would also want the same type of thing to happen with the colour so again within the background of the forms, if you find colour X then replace it with colour Y.
If this can't be done within a front end form, then could it be done behind the scenes, and if so how would I go about doing it?
Hi
Im an absolute noob when it comes to Access so please bear with me
For work I want to make a database to keep track of ordering, so thus far i have made 2 tables: suppliers and products
in my form to add products, i want it to display a drop down with the supplierName in it, but store the supplierID in the products table.
I figure this should be pretty simple, and could easily do it if this were php....
Can anyone help?
Hello,
Help appreciated,
trying to create a form so that when I type in a value it will bring back held in a table it will display two fields held in the same row. i.e.
Table 1
no
first name
surname
I want to type the no field and it displays the appropriate first name & surname fields for the row.
I have forms in a database that I am looking at. How can I tell which table the forms are connected to?
Easiest thing, I know. Help much appreciated.
-Mike
I am trying to incorporate a field in my customer order form for "Invoice Number". Not every customer order form will have an invoice number.
The Invoice Number field will default as null, or blank. I want to make it so the Invoice Number gets automatically populated ONLY IF another field on the same form is populated with "X".
Also, I would like the Invoice Number to equal the Previous Record that has an invoice number + 1. For example, if the previous 5 client records did not have an invoice number (blank because the client's form did not have a certain field populated with "X"), but the previous 6th record had an invoice number of 1001, then the current invoice number would be 1002.
So far, I just have the Form for the underlying table created. I don't have the invoice field in the table created yet. Not too sure where to start.
Thanks much appreciated in advance.
This is probably really basic stuff to most of you, but here goes.
(In the past, I have always had tables with zillions of fields, rather than having linked tables, so I have never had to mess with this stuff before...)
I have a db with 2 tables. A Main table with, say, contact names and addresses and a Lesser table with specialised info that I only want for some of those contacts.
The Primary Key in the Main table is fldContNum (autonumber), the primary key in the Lesser tables is fldNum. The two tables are linked 0ne-to-one on those fields.
There is not a record in the Lesser table for every record in the Main table.
I have a form showing records from the main table and a sub-form showing records from the Lesser. They are linked Child fld Num / Master fldContNum.
At the moment, I can go to a Contact from the main table and I can enter info for him in the sub-form, thus creating a record in the lesser table. That works ok.
However, if I move the main form to another contact and then go back, that info that I just entered does not show in the subform. In other words the subform is in "add new record" mode, whilst I want it to go automatically to the existing "Lesser" record with that number.
I can make it do this with VBA and searching recordsets and suchlike easily enough, but I feel that there must be a much more basic way of linking the two form and tables.
Also I want to make sure that if there is already a "Lesser" record with that number, I want to make it so that the sub form cannot even try to make a new record (because then I obviously get primary key violations).
I hope that I have made myself relatively clear here...
Thanks
George
Greetings, I'm a bit new to the world of MS Access and have encountered a problem when making a search form for my database. The query is using a Like Condition with the '*' Wildcard for a single field like so:
Like "*" & [Forms]![frmPickUpReport]![txtAgentName].[Text] & "*"
While the query on its own runs correctly from the viewer of course prompting me to enter the data manually the actual data from the form is being ignored. Instead of taking the text value within my form's text box, when I press the report creation button the same data box is prompted to me asking for me to enter the data manually.
anybody has a solution?
I'm using MS Access 2000 and cannot use any other application such as visual studion
Hello. 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 Relatedhello.. i have 2 tables
CUSTOMER TABLE
customerid
customername
customerphone
BOOKING TABLE
bookingid
bookingdate
customerid
At the moment i have 2 forms.. one customer form based on the customer table and one booking form based on the booking table.
at the moment, my user enters a customer record using the customer form.. they then save and close the customer form..
they then open the booking form.. and in the customer id field they enter the customers id.. this way, they successfully register that customer to that booking..
what i want to do is allow the user to enter the customer details and the booking details in one form..
i assume i would have to create a third form based on a query..
if i include all the fields from both tables in this query.. and then make a form based on this query, how can i make the following 2 things happen..?
1. when the third form is opened and customer details are entered... a new customer record will be added to the customer table (with a new customerid)..
2. this id will then need to be auto placed into the foreign key customer id field in the booking table.
do you get me?
Hi 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.
I have a form which I use for many different tasks, in order to save database size, reuse code and keep things at their simplest.
Sometimes, I'll click a button to open the form which will only show specific filtered data in "Form" view, using a default "Dialog" border style.
Sometimes, I click another button which opens the same form, filters different data and displays the form in "DataSheet" view, but this time, I want the borderstyle to be "Sizable".
What I need is a line of VB code which will force the form to open-up with "Sizable" borderstyle, regardless of the form's Design view settings.
Something that would look like this (which obviously doesn't work):
Forms!frmFormName.Borderstyle = sizable
Does anyone have suggestions?
Dear All.
I have a visual basic function, placed in a module.
I need to call it from a form field, and pass a value to it and the function has to return a value.
I tried it but it doesn't work
the value I get on the field is " #Name? "
any help will be very appreciated.
Thanks!
CS.
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
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
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.