Search results

Thanks Banana :) I tried this onCurrent, but no luck, still same thing Private Sub Form_Current() On Error Resume Next 'Dim myGT As String 'myGT = Form_subfrmWorkDone.txtGrandTotalTime.Value If IsNull(subfrmWorkDone.Form!txtGrandTotalTime) = False Then Me.GrandTotalTime.ControlSource =...

Hello friends :D Can anyone direct me no how to get rid of the text "#Error" showing up on my form field when there's no value. This is the txtbox on my main form and it's looking up its value from another txtbox on my subform. The main form textbox produces #error when there is no record on...

Thanks all, i had to spend about 2days trying to figure out the changes i made and redoing them again. thankfully, i always try to keep documentation on big changes. I'll keep your suggestions in mind if i ever the error again...hopefully not. Thanks again

Hi Rural Dude :D thanks for replying. Im still looking around online for help files :o

I would really appreciate any suggestions. Thanks in advance!

I got this "AOIndex is not an index in this table" error with Access 2000 after replicating a database and storing it in the same network folder. I am not able to open my database now, i am afraid 2days work on my forms is lost. I usually have backup, but the last backup i have is 2 days ago i...

Good stuff!!!

I have some experience with vba and vb.

never mind. got it. Form_frmSearchResults.Detail.BackColor = 13893544

what's it? I want to open the same form with different buttons (cos different criteria are attached to those buttons). When i click i want the background to change based on the button. So im asking for just one line of code: What's the vba to change background property of a form dynamically...

ok coool!! that does it. thanks baldy :D

Hi Wayne, I get alot of syntax errors. Perhaps i forgot to mention that the query above is being done in the Access query design window?

Does anyone have any idea what to do here, cos i am stuck. I am trying to get a To and From Date as a criteria for my resultsform from this form, and it doesn't seem to work. When i comment out the date criteria (see color red), the form searches fine with the other criteria. Some please help me...

I have this criteria which should collect a date range (cboDate and cboDate2), it works well in collecting the date range if i put separate days (like 6/17/2006 and 7/18/2006, it'll collect the data matching those dates), but if i put the same day, say i want to get all the data for 6/17/2006...

LOL... found it!!! qryAlltime :D That was brilliant THANKS GUYS!!!

hmn....still looking so i guess u guys kicked my ElapsedTimeString aside :o RG, still can't find ur secret function ottay..! ;) =IIf(IsNull([timeStart]) Or IsNull([timeStop]),"",IIf(Format([Elapsed],"h")="0",Format([Elapsed],"n") & " mins",Format([Elapsed],"h") & " hours " &...

I love you guys!!! Both solutions work accurately. thanx alot :D RG, even tho it works. u mind if i ask. how you got [elapsed] in there. I don't have a function called "elapsed" and u didn't use my [elapsedTimeString] :eek:

Hi Rural guy, Ive come again :o I am trying to fillin the Grandtotal of all the timeElapsed to show up in the format of Hours, Minutes, seconds... into the txtGrandTotalTime (box at the very top right) can you help me take a look or work ur magic on it? ;) I thought simply making the control...

Oh i see! makes sense. thanks for the explanation I think i'll just leave it the way it is since it works perfectly, scared of breaking things here :D...Anyways, it's good to know. Thanks quality guru!! :)

Okay then, the idea sounds perfect! One table it is! I guess i can do a self join query on the table itself to get the guest for each client. Thanks workmad3 and KenHigg :)