Search results for query: *

Hi Missinglinq, Thanks for the suggestion. I looked into the Conditional Formatting option and I saw that it allowed me to change the background color, but I'm also changing the special effect property from raised to sunken too. I'm not sure if you can change this under the conditional...

Hey guys ... thanks for your assistance ... again. I'm sure each of you have helped me out sometime in the past and I've read many of your posts. I appreciate all the experience and knowledege you have! THANK YOU! I'm just a mere reporting gal and just trying to improve things (and...

Perfect! Thanks Duane :)

Hi there, I have 41 textboxes for a calendar. When I click on a text box I need it to change it's visual properties to indicate its been selected and if clicked again to be unselected. Not wanting to do this 41 times ... what do I call the "Current Text Box"? If CurTextBox.BackColor =...

I tried it out on another PC and it all works fine ... both are Access 2003 SP3 ... so the code is fine ... have to investigate further. Thank you for your assistance.

Thank you genomon and MaZeWorX, I tried both your suggestions and still no luck. When I stepped through the code just as you said MaZeWorX, the report it doing the right thing, it's the form's code at the doCmd to open the report. It's like the error handler isn't working. Here's updated...

Ji JoeAtWork, Sorry ... it's in the title. At the first DoCmd.OpenReport [cmbReport], acViewPreview, it comes up with the message from the report "There is no data for this report. Canceling report." then steps back to the same line (DoCmd.OpenReport [cmbReport]) and comes up with the Runtime...

Can you please help? This form opens several reports based on the criteria entered - select the report name, and select/enter data to view report. In each report I have: Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report." Cancel =...

Hi, I have a form with different job types to filter for queries and reports. If Job Type = ALL is selected, I want the query to filter Job Type <>"GUARD", or; if Job Type = Guard is selected, to filter on job type = Guard. Not sure how to do this in the query criteria ... the Iif...

Hoping you can help me out. I've got a tabbed form with subforms. A couple of the tabs are: 1. Tariff Info 2. Rates Info with Tariff Combo box. Example of Tarrif Data: 1-MonToFri 08:00 to 16:59 2-MonToFriAH 17:00 to 21:59 In the Rates Info tab, the Tariff combo is linked to the Tariff...

I'm wanting to look at everyday info (weekdays and weekend) for all Zones, except only weekdays for Newcastle, Gold Coast and Perth zones. What I've tried in the query, is creating a new field with: iif([RptZoneCat]=(In ("Newcastle","Gold Coast","Perth")),8,[DOW]). It doesn't like it. Is...

This is for a field tech utilisation report. I need to know when there are no jobs completed as well as when jobs were completed. I have a table with manhours listed for each day of the week in each zone. I need to total the daily man hours and can't link when no date is there. Thanks...

I have a form where users enter a date range for a query (field techs utilisation). The data in the query is missing some days when they didn't do any jobs that day, but I need know if a tech didn't do any jobs so I can make the data 0. After thinking about it, here's my method for filling...

That's done the trick, thank's heaps. I've just got to work out how to get it to apply to the last record on the form now :)

Thanks for your response TheAceMan1 ... btw I'm fine :) U? It's not an autonumber but thanks for that info. I'll explain a bit more. The number is an ID number relating to a person in a call centre so only each person know's their number for the reports. When someone leaves, we don't want...

This is probably really basic, but I'm new to "behind the scenes" side of things. I have a field "ID" listing numbers. Say 1, 2, 3, 5, 6. I want the next record to be 4 - filling in the blank. I know it's a Loop thingy, but now sure how to go about it yet. If you could get me on the right...

Here some sample data. I wanting to measuring the time for each activity, eg. total time he was available, unavailable, oncall & aftercall each day. How do I do suggest I do it? ID User Time Activity 3105590 eloc 12/07/06 06:36:27 AVAILABLE 3105599 eloc 12/07/06 06:38:09...

Thank you guys for your assistance, you saved my brain from going musshy ... or mushier ... it's all working fabulous now :)

From thread705-664946 Apparently this is for the first Saturday of the next month. DateSerial(Year(mydte), Month(mydte) + 1, 1 + (7 - Weekday(DateSerial(Year(mydte), Month(mydte) + 1, 1)))) How can I make this work for the First Monday of the current month? Thanks Veronica

coco86 thank you for your help. I'm not familiar with the dlookup function so I didn't get it working that way. I did get it working by giving [name] 2 columns; Me![txtAcro] = Me![cmbName].Column(1)