Search results

Apparently i can't use this, as *.snp is not available in the format types of forms. It looks like only reports can do snapshot :mad: I was just reading somewhere that i can print my form to pdf and attach to email. I guess i should go do more research on that. If anyone has any knowledge of...

Hi Banana, what do you mean by "screen dump"?

So i guess it's not possible to email a snapshot or view of data on my form :rolleyes:

Thanks Curtis. See, there are other controls on the form, like print, and a details button right beside each record that opens up the mainform containing the information of that particular record. I'd only like to have a snapshot of the results form. Is there a way?

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