Hi,
Is there a way to set the background color of a datasheet? I don't mean the color of the cells, but the datasheet itself outside of the rows/columns as shown below (dark grey color):
http://img.photobucket.com/albums/v368/flemmo/datasheet.gif
Thanks
hello,
I have a txtBox. Its backColor property changes according to what I do on the form. Now, when I close the form and reopen it, the backColor is not the same one with which the form was closed.
Ex. red, green
if I close the form having the backColor = green, then when I reopen it, it changes to red.
Can anyone tell me what I am missing
Thank you
Hoi,
When i'm select a record, i want to change the background color of all textfield in that record.
Does someone know how to do this?
greetings
koen
I open form and get parameter in the openArgs
I have a tabular Form
and I want change the color if the ID is aqual.
for example:
I open the form like this:
DoCmd.OpenForm "frmMessageShow", , , "fID=" & Me.fID, , , Me.AssighmentId
[the Me.AssighmentId is the openArgs]
I want in the second form to color the textbox if AssighmentId = me.openargs
I try do it:
If Me.AssighmentId = Me.OpenArgs Then
AssighmentId.BackColor = vbRed
End If
and its not work :mad:
is there is an option to do it?
thanks!
Hello,
I have the following code for changing the back-color of a field:
Private Sub txttekst1_AfterUpdate()
Dim lngRed As Long
Dim lngGreen As Long
lngGreen = RGB(0, 255, 0)
lngRed = RGB(255, 0, 0)
If Me.txttekst1 < 100 Then
Me.txttekst1.BackColor = lngRed
ElseIf Me.txttekst1 > 200 Then
Me.txttekst1.BackColor = lngGreen
End If
End Sub
Problem: When I change to record to record the back color is not
the same as I have write the code.
mulderm
Hi all,
Is it possible to change the Background color of a command button?
Whan I right click in the properties of the command button I cannot see a BackColor property. Further, when I programatically try to change the BackColor property in VBA I get an error message.
Thanks in advance
Kabir
I have a randomized table named tblRandomBoxes with the following data:
ID RandomID
1 4
2 5
3 2
4 6
5 1
6 3
I have 6 command buttons named command1,command2,command3, etc. and 6 Labels named Label1,Label2, Label3, etc. On Click of each command button, I want to lookup the ID based on the RandomID and set the backcolor of that label number to a different color.
ie) on command1 click me.Label4.backcolor = 39835
How can I 'build' the label number with the lookup? Here's the code I'm trying, but it doesn't recognize my 'built' label number:
Private Sub command1_Click()
Dim ctl As Control
ctl = "Label" & DLookup("ID", "tblRandomBoxes", "RandomID = 1")
Me.ctl.BackColor = 39835
End Sub
Thanks,
Sup
I am trying to change form backcolor with a cmd button via VBA.
View 6 Replies View RelatedA user requested a change that would change the form header and detail back ground color to white when they click the button print record and then change the color back all in one click after the record prints. I keeping getting a run time error, type mismatch on the line where to code is to be changed. The colors are numbers not vbColors. I am using Access 2007.
Code:
Me.FormHeader.BackColor = "#FFFFFF"
Me.Detail.BackColor = "#FFFFFF"
I am trying to color code text boxes based on the data entered in. The column is "PHASE" and the items entered in are either "1" "2" or "3". 1 is supposed to be Red, 2 Yellow, 3 Green.
I have Microsoft Access XP (I'm sure). I've tried to do it on VB and had no luck. I couldn't figure out Macro and I don't have On Click or Code Builder.
I have tried a couple of different expressions and no luck. I'm definitely an amateur to Access. I'm only using it cause it's what we have in the office.
I would like to know if this is possible using VBA ( or other method)
I want to determine the back color o a cell based on a color value stored in another cell in other word
backcolor of cell A = the value of cell B
So if I change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B.
I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".
I have tried vba. plced on the after update
if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this
Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".
I think conditional formatting is the way to go but i think i need an expression to complete this.
I wish to change the backcolor of a field on a current record being dispalyed in a 'multiple items' form. However when using me.A.backcolor = makes refrence to all fields called A on the 'multiple items' form and therefore all fields change colour not just the current record.
View 2 Replies View RelatedHi,
There is a requirement for
1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented?
2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet.
Pls let me know.
Thanks,
Savita
I'm new to this.
Is there a way to make a Form Datasheet (including calculated cells) update the corresponding Table Datasheet?
I have an access 2000 db. My users open the DB and I have it launch a simple “startup” form with various buttons for the most used features. I have one button that launches another form. The default view of the form is supposed to be in ‘datasheet’ view. However when I click the button it opens in ‘single form’ view.
What can I change on this vb code to allow it to launch in datasheet view instead of single form?
Private Sub cmd_su_checkpaid_Click()
On Error GoTo Err_cmd_su_checkpaid_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_ACCOUNTING_BILLING_VER"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmd_su_checkpaid_Click:
Exit Sub
Err_cmd_su_checkpaid_Click:
MsgBox Err.Description
Resume Exit_cmd_su_checkpaid_Click
End Sub
Hey guys.
Well this is a new on for me, the idea is this.
By using a datasheet view in a subform and a custom popup menu I can allow users to filter down to the records they wish to view, in whatever order they want, and then allow them to open/edit said records with a Double-Click Event.
Fact is there are so many ways that different departments wish to filter this works in theory and in a sample I have created. A search or filter form would be huge. This seems simpler.
Ok, all good in theory, I can restrict “new” and “edit” etc, but I can just see users resizing the datasheet view to something only brain dead users could do or hiding columns. <SHUDDER>
So my question is, can or is there some why that I can use the OnOpen or OnLoad event to re-size the datasheet to a default size? (Well the fields in the datasheet mainly) This would allow you average bi-polar user to mess and re-size until their coffee mugs run out and the next user doesn’t get left a mess. (Which would then force them to ring me!) <SHUDDER>
I hope this makes sense, I really hope someone can point me in the right direction.
Have a look at the sample database attached to get a better idea of what I mean.
Thanks :)
Exporting datasheet to word, how is this possible using vb. Actually, I do have a thread in Form forum. But, I think not a lot of people visit that place. Anyways, I have created bookmarked and used datavariable to export the data (by ansentry's help). But the only thing that it exports is just one selection on that datasheet, instead of all the chosen rows.
I am exhausted now after searching everywhere, and not finding a clue. How to resolve that situation. If there is an example that I can use, that would be gr8.
Thanks In Adv.
I have subforms that are datasheet view, if the user rearranges the coloumns, or resizes etc , I would like to save what they have done so it is as they left it next time they open up the screen.
This works fine with an mdb (all my forms are set to close acsaveNo).
However in an mde this doesn't work.
Can I get this to happen in and mde.
(A button that saves a layout change would be fine for my purpose)
Thanks
Paul
Is there any way you can specify the size of a datasheet?
Say the datasheet opens up with 600x800 size?
or 10cm x 15cm?
HI
i never needed help this much.
i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird.
I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell.
This works fine in 2003. De datasheet is displayed, and when you click on the plus, the other datasheet opens in the maindatasheet.
But in 2000, you dont see the plusjes.
It is a major issue that i fix that! can some help me to solve this?
Joost
I have a form and a datasheet subform in Access. A form has person info and datasheet subform has 4 fields: QuestionID, QuestionNumber, QuestionName and Answer fields. The Answer field is a dropdown field and has 3 items: Yes, No and N/A. If QuestionNumber from 3 to 6 the answer was Yes or No then lock the Answer field in Question 7. Any idea how to do it?
View 1 Replies View Relatedwhen you select the Data sheet View you display error messages in the Accounts Sub reports fields.
The database has been included as a reference:
Forms- Double click Accounts Form By Discipline -data sheet view
Under Current balance,Spent, and Encumbered Columns you get error message instead of the actuall totals.
Please tell me how to correct this prolsdms
hello,
I'm working on someone elses database, and I'm not too familiar with access.
He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.
The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update:
However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.
Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.
Any help would be greatly appreciated.
Thanks
Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?
I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!
(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)
I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies.
Is this the way sub-forms look in datasheet view or is something else involved?
Thanks