Search results for query: *

I need to devise three CR9 queries to pull data from 100000's of records. We've simplied it to pull at three specific times during the day. 09:00:00AM, 14:00:00PM and 16:00:00 PM. It's an oracle database with both date and time probes in the report. I've used datevalue, datetime etc. to no...

I have to color code bars on a chart based on specific conditions. For example: For sites that have more than three outages a month, I need to color code those bars red. Else, green. I can't seem to find where I can place a formula to do this. If I use a text box behind the chart, the bars...

Hello, I'm testing a field for null values and then color coding the background based on who the record belongs to. I can not get it to work. If I change the default color to black (meaning it will change the records that have data to be completely black) as opposed to white, it works. So the...

Hello, I've inherited a workbook from a former colleague. This workbook has 7 worksheets; of which, 3 are charts, 3 are pivot tables and one is for the rawdata. The rawdata is pulled via Microsoft Query from a Oracle database. There is nothing in the query that references to two additional...

Hello and I'm new to this forum. I've just taken on a new role of being an SMS Administrator for my Department and I'm looking for Administrative Tid bits to help me along. Like quick ways to set up Hardware & software inventory, coping collections to a new collection to be modified for...

I have a drop down list to select criteria. After selecting from the list, record in form does not move. Please help. :( Private Sub Combo54_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone Recordset.FindFirst...

Simple question I'm sure. But I need assistance. The goal is to print one mailing label at a time. Maybe 4 etc. Pick and choose who they want to print labels for off and on all day long. Prompt for additional info and have it all placed nicely on a label to be printed and placed on a...

2 Tables Funeral Homes Cases Funeral Homes primary key is "Vendor" Cases primary key is "Case Number" Funeral Homes contains two fields where one represents "Funeral Home Names" and the other is "Vendor" which is a short version of Funeral Home Names...

Boy I need help. I keep running into walls and it's becoming very frustrating. I've searched all over the net for resources on building Data Access pages. Most deal with deploying Data Access Pages, simple creation of data access pages, or bunches of dead links. Personally I would have...

I'm looking for a Access 2000 Data Access Page Forum. There is so much to this feature, especially when you combine it with security issues, sharing of objects, etc. Any help would be appreciated. I've scanned through four Access 2000 forums here and can't seem to find enough answers to many...