Search results

so how do i code it?

Well it is the first form that opens and will display if transactions are pending or in progress. So what I would like is to have it color coded with reference to the date that it was requested. Say a request that came in today will be green up to 10 days and the request that came in after 10...

I would need some help on how to do this please. don't know how to code it

thank you very much

Hello, Can somebody show me(i honestly don't know how to code this) on how to set the bacground color of the details section of the form depending on the date. For example If date entered is 05/05/09 - say this date is today the color of the details section pertaining to the records should...

I have a table which I want to have a particular field be presented as graph (Pie chart). In this field I have 8 different values which I want to count and present the total of each in a graph. I honestly don't know how to do this. can sombody help me please?

Thanks John. It's working now. thank you! thank you!

It's the one you posted

When you choose any option on combo box 1, combo box 2 will only give you the first option with reference to combo box 1. If you choose the other options it will revert to the first option in combo box 1. Why is that? e.g. combo box1 have 3 options = it will only accept the first option...

I think that is what I have right now. but once the second form is open it doesn't display the records that was clicked(double clicked)

I've a form with query as my record source. When my form opens I would like to be able to click on any fields and another form would open having all the data of the particular row of data displayed. Right now what access is showing me when I do this is just an empty form where I am suppose to...

Thanks John, can you tell what you did for reference purposes.

the form's name is frmFacilitiesEntryForm and also frmQryInProgress&Pending is the first form that displays when I was just using tables as source and not query when I click on the record selector on the side it will bring up that record but when I changed it to query as source it will not...

It's the same thing on one table

yes it is bound

This is on the first combo - SELECT DISTINCT tblMaintenanceCategory.MaintenanceCategoryId, tblMaintenanceCategory.MaintenanceCategoryDescription FROM tblMaintenanceCategory ORDER BY tblMaintenanceCategory.MaintenanceCategoryId; This is from the second combo SELECT DISTINCT...

I've a cascading combo box that when I choose the first box I get a message runtime error '-2147352567(80020009)' You tried to assign the Null value to a variable that is not a Variant data type. I use query as a record source. Any Idea?

Ok thanks. it works fine.

Is it possible to just click any of the fields and then it will open another form?I've attached the first form (attachment) where the user will choose and the form (attachment2) that it's suppose to open after choosing from the fields.

I've a database that when opened would display any work that is pending or in progress. what I want to do is when the user click any record it will open a new form and go to that specific record.