Search results

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 :)

Im planning a db client's dinner questionaire that will comprise of client's favorites (meals, games, transportation). Each client is allowed to bring a guest. So the client's will also be filling out "the same set" of questionaire for his/her guest. Meaning, a user will need to fill out the...

that extra "[totalTimeSpent].Value="" i had in there was evil ... LOL i was close :o

wow! *does a little break dance what would i do wihtout you? I've been battling that error for hours :o thanks quality guru :cool:

I have attached the db below. It's a smalldb with just one form :) I have a function called ElapsedTimeString that produces the Hours, minutes, and seconds time elapsed between two time fields (my function module is below). I have a continous form that i use for dataentry. the fields are...