Search results

here are some excerpts and variations you can try: ... Dim objOutlookMsg As Outlook.MailItem Dim objOutlookAttachment As Outlook.Attachment Dim varAttachmentPath as Variant ... varAttachmentPath = ... ' Create the e-mail message. Set objOutlookMsg =...

as the title says. sry if this has already been suggested.

that's great. tnx for replying.

how about: Private Sub lstEvents_Click() MsgBox Me.lstEvents.Column(0) End Sub

"which at least - somewhat - impinge" just hit me. 'specially "impinge". nice.

whether or not it's proof may be a moot point, but i think that's essentially correct. ok. but i think you do see the point; you said as much above. same here. agreed.

hey david. this question came up a while back and i think the answer was no, you can't see the breakdown, unless, maybe, you're an admin. i'm curious about that too, and others have said the same, but noone has found a way to do it. could be an "issue" with vbulletin; i'm not sure how much...

try this: Me.Filter = "[Project Type] = " & Me.Text32 & " Or [Project Type 2] = " & Me.Text32

a type mismatch would indicate that you are searching for one data type when the actual data is another. you are currently searching for strings. is that the actual data type or is it maybe number type? that's good. that's not so good, if i understand. do you mean you have two Project types on...

had a very quick look. i'm going to leave them as is. merging puts all the posts in chronological order. sorting it out would be quite painful.

format(1542,"##:##") gives you 15:42 cdate("15:42") gives you 3:42:00 PM

rotflmao. :)

how about: Me.Filter = _ "[Project Type] Like '" & Me.Text32 & "*'" Or _ "[Project Type 2] Like '" & Me.Text32 & "*'"i don't use filter much so i'm not sure if you can do And/Or with a filter but i bet you can. by the way, your table should (could) be redesigned such that you move all...

oops. sry palpete for the diversion. for some reason i get hung up on using '.Text'. glad it's working.

you haven't said what's happening (or not). you might need to requery the combo box after changing the row source?

some things to try: - use the After Update event - change the + sign of the criteria to an ampersand (&) - also in the critera, remove the formatting: Format(Me.cboSelectArea_FAB.Value) -- change to just --> Me.cboSelectArea_FAB

look up 'total records' in access help. hopefully that will get you going.

i would suggest making four separate queries, add the Appointed field to each with the criteria. test each to make sure they are working with the criteria-form. do you try adding .Text ? looks like the tables may need normalizing, but that's another story. after the queries are each...

another way which should work (and better): on form2: sub form_load() me.txtname = forms!frm1.activecontrol end sub

one way would be to use OpenArgs. sub txt1_click() docmd.openform "frm2",,,,,,Me.txt1 'you might need Me.txt1.text end sub on form2: sub form_load me.txtname = me.openargs end sub