Search results

  1. R

    E-mail form

    I seem to have rectified the error. Could anyone tell me if there was a better way? I think this is OK... seems to work! I added: With Me!lstMailTo If .MultiSelect = 0 Then Me!txtSelected = .Value Else For Each varItem In .ItemsSelected strList = strList &...
  2. R

    E-mail form

    Thanks for this aleb! I came looking for something to do just this - your example is perfect! However, I ran across a problem. I use Office 2003, so I had to convert your document (I guess it was Access 97 based?). It ran fine, except one problem. If I select some names (or just one) in the...
  3. R

    Using dates in a dialog form

    Wow, works great!!! Many thanks for this :D Point noted about the naming conventions - again thanks for the tip :)
  4. R

    VBA Code

    just a suggestion... you might find someone more expert on this frequenting the VBA coding section of the forum ;) good luck! i took a look and got a bit lost! hehe
  5. R

    Using dates in a dialog form

    Ahh, new page. To recap (if you don't want to look back): My StartDate text box after update is: Me.EndDate = Me.StartDate + 5 This works great. However, I added OldSoftBoss' calendar method to StartDate, so that it pops up a calendar, and the date selected in the calendar becomes the value...
  6. R

    Using dates in a dialog form

    Any ideas on this? The beginning of the current week part isn't so important, but I'd like to get it so the EndDate text box auto updates after selecting a value in the calendar. I'm sure its something simple, but i'm still a n00b :o
  7. R

    Using dates in a dialog form

    As mentioned above, I used Rich's solution and all was fine and dandy. However, I then went back to OldSoftBoss' calendar method, and it no longer auto updates. It will if I type in a value, but not if I use the calendar. To recap, I have two text boxes: StartDate and EndDate, both of which...
  8. R

    Using dates in a dialog form

    Yup i've just been trying it, and that works great! :D Manymany thanks!
  9. R

    Using dates in a dialog form

    From what I can gather, this is what makes it work: In a module: ========= Public Function LstDayCurWeek(InDate As Date) As Date LstDayCurWeek = InDate - Weekday(InDate) + 7 End Function An After Update Event in the Form: ========================= Private Sub cmbFunction_AfterUpdate()...
  10. R

    Using dates in a dialog form

    its not my combo box ;) If you look back in this thread (page 1), there's an attached database. It is a sample for some date functions. Here's a pic: (if the pic doesn't work go here ) In that database, the combo box selects which function you use. It is then applied to the base date...
  11. R

    Using dates in a dialog form

    The combo box isn't mine... i guess that last post was confusing. I have a report that is based on a query. The report lists entries by week (its a sales by week report). Both work fine. However, I need to use a form to enter criteria. I need to be able to look at any week's report, not...
  12. R

    Using dates in a dialog form

    can anyone help????
  13. R

    Using dates in a dialog form

    Hi, Thanks for the reply. Unfortunately, that does the same thing (it adds 5 to the day part, but the rest resets to jan 1900)! I need a function, such as in the UsefulDateFunctions zip that was previously attached, taken from the MS article 210604. It works great in that table, I just need...
  14. R

    Using dates in a dialog form

    come to think of it, this doesn't do what I want at all! Maybe I can use what was in that previous database......
  15. R

    Using dates in a dialog form

    More date woes! I have sorted my form... almost! I have a text box called StartDate, which gets the date from the calendar as per the attached sample. I also have a text box called EndDate. This is where my problem is... EndDate has a criteria of Val(StartDate + 5). It has a Short Date...
  16. R

    Report criteria formula help needed

    Thanks! I was on the right track, just trying to over-complicate things!!
  17. R

    Report criteria formula help needed

    Hi guys, Thanks for all the help in the past... I'm getting on well with my project for a n00b :) OK, I have a report, based on a query. The one value in the query that I'm interested in is called Price. I have a text box called Total that I wanted to display a value, so I used the criteria...
  18. R

    error 3251 from recordsetclone

    You might also try... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacchbk/html/acsybex_chap6.asp "For table-type recordsets, you can specify the ordering by setting the Index property. (Access does not allow you to set the Index property of any other type of recordset...
  19. R

    error 3251 from recordsetclone

    I personally don't know the answer, sorry. Try this: http://support.microsoft.com/default.aspx?scid=kb;en-us;207836
  20. R

    Using dates in a dialog form

    To Oldsoftboss (or anyone who knows!!) How do I get that calendar into my database? I tried exporting the forms, but when you double click the text box, it says: The expression On Dbl Click you entered as the event property setting produced the following error: Error accessing file. Network...
Back
Top Bottom