Search results for query: *

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 =...

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...

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...

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...

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

I'm wanting to select a [name] on the form, and it to automatically fill in the [acro]. I've added a msg so I can see what it's doing and it's showing the code "SELECT [Contractors Table].acro FROM [Contractors Table]WHERE(([Contractors Table].Name)=[forms]![frmcmcstaff]![cmbname]);", not the...

In a form, I've the following fields: Month, Year, BegTransDate, EndTransDate When Month and Year are updated, it fills in the BegTransDate and EndTransDate. Month = August Year = 2006 BegTransDate = 01/08/06 EndTransDate = 31/08/06 I've added a "Week" combo box, listing week 1, week 2 etc...

Hi there, I've been searching around here for sometime on this topic with no luck. Here's my data: Year Month No Month Tech ALL Not COMP COMP %_COMP 2005 8 Aug 2005 Weipa 3 0 3 100.00% 2005 9 Sep 2005 Weipa 1 0 1 100.00% 2005 10 Oct...

this is my code that's not working: iif(Weekday([answered_time])=1 or 7, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening") It will work if I use: iif(Weekday([answered_time])=1, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening") and...

Hi, I'm wanting to format a date to month then week ... eg June 06 Week 1 would cover date range thursday 01/06/06 to Saturday 03/06/06 June 06 Week 2 would cover date range Sunday 04/06/06 to Saturday 10/06/06 I would appreaciate your help thanks :)

Hi I've got these fields: Call Placement Time: 15/06/06 09:15:05 Time To Fix: 1.5 (Number format meaning 1hr 30 mins) I want to add Time to Fix to Call Placement Time so I can do a countdown of time left to fix. Can you pleae help? Thanks R0nnie:)