Search results

You can always go to ur userCP to see the list of the threads you have recently opened or replied to (thread subscriptions)

Is it possible to email as attachment a FORM in snapshot format? I have a form that gets the results of a query. I'd like to send the data displayed on this form as snapshot format. Possible? Any alternatives? Suggestions? Please help, i've looked high and low.

great stuff!

Hmn...thanks CEH, I had seen this someone and read that the "_" causes problem. But why not? I used yours. It works, haven't had a problems. wheew..Thanks :D

I see. Thank you, your kindness warms my heart

the characters would either be 7 or 8. i.e. mmyy0001 (8060001 - august entries and 10060001 - oct/nov/dec entries). My jobid wasn't allowing the leading zero as in 08060001, so here's what im settling for and i am happy with it! :D

Thanks RG! :) that looks like what im looking for, i'll go try it. *sighs didn't think limiting characters in my textbox would be brain surgery :mad:

Thanks Chris makes alot of sense, but i like the approach of simply blocking more entries after 8characters :)

Thanks boss! :) Private Sub txtjobId_Change() If Len(Me.txtjobId.Text) <= 8 Then Else MsgBox "Only 8-digits allowed stupid!" End If End Sub Here's what i have, but this does not stop them, i just want it to stop allowing more text instead of my msgbox. how do i stop text..like anykey stokes...

I have some questions about the before insert/before update short lesson u have here ;) Do i need to put "If Me.NewRecord Then" in the before insert too? :confused:

Works like charm!!! I took out the format(). You rock buddy!

Is there a way to limit the number of characters that can be entered into an unbound textbox on my form? I have a search textbox, where a jobId is entered and button is clicked to search. The numbers are generally 8-digit. I just noticed one of my users trying to enter 9489858939349839434 :eek...

Hi there :) Thanks alot. Sounds interesting. never thought of it. I'll give it a shot

Great! Thanks Shane! :D

Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?

Thanks RG. I don't know how to handle that u suggested, so here's what i found. It seems to work most people, but not me... I've posted it here too http://access-programmers.co.uk/forums/showthread.php?t=31046&p=519211 You can please take a look also

Hello all, I have an identical issue i am trying to accomplish here. I have read all the demerits and i know waht the book says and what you guys advice but this needs to get done this way for the best reasons - break the rules a little :o So, I have choosen Pat's method, where the customer...

~Subscribing to thread :cool:

But in this case, i need it to be the JobId tho i have an autonumber primarykey, but thre's a search field in my application, where the users would like to type in jobIDs e.g. 08060001 (mmyy0001) to search for that ID. I was using the autonumber for the search field but the nubmers are going to...

Hi Rural Guy. Thanks. I swayed from that approach since i wasn't getting anywhere. I created a field in my table [jobIdSequence] and use this bound control on my form with controlsource (=Nz(DMax("[jobIdSequence]","tblJobDetails",Format([timeIn],'mmyy')=Format[timeIn],'mmyy')),0)+1) I have a...