Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. r0nniem

    Refer to a textbox's name to change it's properties for a function.

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

    Refer to a textbox's name to change it's properties for a function.

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

    Refer to a textbox's name to change it's properties for a function.

    Perfect! Thanks Duane :)
  4. r0nniem

    Refer to a textbox's name to change it's properties for a function.

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

    using NoData & Error Handler - still coming up with 2501 runtime error

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

    using NoData & Error Handler - still coming up with 2501 runtime error

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

    using NoData & Error Handler - still coming up with 2501 runtime error

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

    using NoData & Error Handler - still coming up with 2501 runtime error

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

    Crieria based on Form

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

    If combo box has no data in dropdown, display error message.

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

    IIf statement with In

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

    Create table for filling in missing dates.

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

    Create table for filling in missing dates.

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

    Loop to fill in deleted consecutive numbers

    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 :)
  15. r0nniem

    Loop to fill in deleted consecutive numbers

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

    Loop to fill in deleted consecutive numbers

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

    Measuring time between consecutive rows

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

    First Monday of the Month

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

    First Monday of the Month

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

    Problem with AfterUpdate - Field shows code, not answer

    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)

Part and Inventory Search

Back
Top