Search results for query: *

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

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

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

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

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

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

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

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.

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.

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

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

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

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.

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.

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

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

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

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.

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

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