Search results

  1. wazz

    Using stored filepath to attach file to email.

    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 =...
  2. wazz

    vba classes forum

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

    Filtering Question

    that's great. tnx for replying.
  4. wazz

    On Click Event on My Form

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

    Database Project ~ Help/Advice needed ~

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

    Are there too many forums here?

    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.
  7. wazz

    Are there too many forums here?

    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...
  8. wazz

    Filtering Question

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

    Filtering Question

    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...
  10. wazz

    Null Date 31-12-1899

    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.
  11. wazz

    update query to convert time and minutes

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

    Filtering Question

    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...
  13. wazz

    Run a query between date ranges using SQL

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

    Run a Specific Query based on ComboBox Value

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

    Question question about combobox filter

    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
  16. wazz

    about sum function

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

    Run a query between date ranges using SQL

    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...
  18. wazz

    help with a popup form

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

    help with a popup form

    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
Back
Top Bottom