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 Rhinorhino 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: *

  • Users: regava
  • Order by date
  1. regava

    CHANGE INDICATOR WHEN USING THE TAB

    Thank you. If I find a solution I ill posted. Have wonderful day.
  2. regava

    CHANGE INDICATOR WHEN USING THE TAB

    PHV, sorry, you are right, I meant the ACTUAL field I'am in.
  3. regava

    CHANGE INDICATOR WHEN USING THE TAB

    Access 2003 - I have a form in my application that has several fields. When you TAB from field to field there is a very thin vertical indicator (it is not the mouse pointer) to show where the next field is. However, this indicator is so thin that sometimes is very difficult to detected...
  4. regava

    CHANGE SHAPE OF CURSOR

    PH thank you for your help. Your answer help me with something else that I had in mind. However, I did not explain clearly what I wanted. He it is, I hope. I have a form in this application that has several fields. When you tab from field to field there is a very thin vertical indicator to show...
  5. regava

    CHANGE SHAPE OF CURSOR

    Access 2003 - Currently the cursor in my application (MDB) is a very thin vertical line which is hard to visualized. Is there any way to change the shape to something else? May be a square, trinagle, and arrow or something that is easy to visualized. Any ehlp is appreciated. Have a wonderful...
  6. regava

    How to add time (120:15 + 10:15 = 130:30)?

    Skip: It is a matter or semantics. In my particular case StTim1 refers to the number of hours and minutes that a person has accumulated for vacation or sick time, and stTim2 is the number of hours and minutes that the person earned (add) or the person used (substract). You are absolutely...
  7. regava

    How to add time (120:15 + 10:15 = 130:30)?

    I want to thank all of you. I came up with the following function which solved my problem. I hope it helps Private Function AddSubTime(stTim1 As String, stTim2 As String, SA As String) As String 'stTim1 is the first time as "hhh:mm" where hhh > 0 and mm = 0-59 'stTim2 is the second time as...
  8. regava

    How to add time (120:15 + 10:15 = 130:30)?

    PHV and SkioVought thank you for your input. I got the yeast of what I have to do. By the way, 120:15 means 120 hours and 15 minutes. It is appreciated. Have a wonderful day.
  9. regava

    How to add time (120:15 + 10:15 = 130:30)?

    Access 2003 - Is there any function in VBA that would add time as in 120:15 + 10:15 = 130:30? Also, I need one for substract. I tested in excel and it can be done very simple. Any help is appreciated. Thank you.
  10. regava

    Eliminate rows

    Leslie, I like your solution better. It works perfect and makes it easy to understand. Thanks a million, it is appreciated.
  11. regava

    Eliminate rows

    Randy, I tried your suggestion and got the same result. Thank you PHV, Thank you for your wonderful solution. It did what I expected.
  12. regava

    Eliminate rows

    I have the following query: SELECT "BRIEFED" as Type, T1.Name iif((T2.a < Date and T2.b = "N" and T2.C <> "Y")1,0) as Pet iif((T2.a < Date and T2.b = "N" and T2.C <> "Y" and T1.D = "Y"),1,0) as Cas T1.Dp, T2.a, T2.b, T2.C, T1.D FROM tblTrack as T1 INNER JOIN tblCdr as T2 ON T1.No = T2.No WHERE...
  13. regava

    Adding and Substracting Groups

    hneal98, thank you for your answer. I think I understand what you are telling. I will try as soon as I can. Sorry I could not reply earlier. I will post the result.
  14. regava

    Adding and Substracting Groups

    Access 2000 - I have a report that consists of 3 groups. Also, I have totals for each group. The requirement is that a grand total be produced as follows: GroupA + GroupB - GroupC. I have not been able to come with a solution. Can this be done? If so, please help.
  15. regava

    Unable to print zero values

    I have the following query which will be used to create a report. I must create a report showing zero (0) values if there is no value. PARAMETERS [As Of Date] DateTime; SELECT "BRIEFED" as Type, T1.ALJName as Judge, 1 as Pet, iif(T1.Consol <> "C", 1 ,0) as Cas, T1.DisplTatno as DTatno, [As Of...
  16. regava

    Union Query - Getting More that expected or None

    Golon, Thank you very much for your help. Everything is working as it should, nice and smooth. Have a great day.
  17. regava

    Union Query - Getting More that expected or None

    I have modified my original query to call the function ActionZero, which returns what I need. However, the way this query is written it will go through more than 6000 records in tblTracking when it only needs to go through no more that 60 records. This is my problem, I do not want to execute...
  18. regava

    Need to Loop in an Index Table

    Golom Thank you for your wonderful suggestion. I works. Sorry I did not reply quicker but I was away for the last 3 days. You deserve a start.
  19. regava

    Need to Loop in an Index Table

    Access 2002 - I have the following routine: [code] . . strSql = "tblX" set deb = currentdb() set rec = db.OpenRecorset(strSql) rec.index = "IndexA" rec.Seek "=", strZ if Not rec.nomatch then rec.edit . . rec.update end if rec.close set rec = Nothing [\code] I want to loop thru it since...
  20. regava

    Union Query - Getting More that expected or None

    Can someone help me with this. Please give me something to work on I am reaching the end of the rop.

Part and Inventory Search

Back
Top