Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jaydeebe
  • Order by date
  1. jaydeebe

    Dlookup / Dcount ? Stumped!!!

    This is quite complicated. I have a working booking system that uses dates without times. The way to check for collisions is to use a recordset check like in this thread - http://www.tek-tips.com/viewthread.cfm?qid=834753&page=2 or I have used three queries to achieve a similar result. You...
  2. jaydeebe

    Date populates +1 at next record

    Try adding this to an event - cboDate.Value = cboDate.Value + 1 Only dead fish (and shit) go with the flow!
  3. jaydeebe

    Stuck with User Input Query/Form

    When a user selects a product this could trigger a query (use the after update event of the combo box) to populate the other combo box(or list box for multiple selects) with relevant suppliers. Only dead fish (and shit) go with the flow!
  4. jaydeebe

    Http Error 404 / Help to resolve

    Check what eamil program IE is set to by clicking Tools menu - Internet Options and then click the Programs tab and see what the email program set to. Hotmail has recently changed and no longer allows you to use outlook to view mails. this could be a problem.
  5. jaydeebe

    Requerying a subform control from a form

    Forms![Main]![Topicsub]![Topic].Requery also works for sure (access97), i tested this one! Only dead fish (and shit) go with the flow!
  6. jaydeebe

    Adding calander entry to Lotus Notes

    Reposted in the Lotus Notes forum - http://www.tek-tips.com/viewthread.cfm?qid=1002107&page=1 Only dead fish (and shit) go with the flow!
  7. jaydeebe

    Requerying a subform control from a form

    having the same name is no problem. It helps to avoid confusion. What about this - DoCmd.Requery Topic
  8. jaydeebe

    Requerying a subform control from a form

    Try this - Form_Mainformname.subformname.controlname.Requery check the subform name is set to what you get when you right click properties the subform while in design view on the main form. Only dead fish (and shit) go with the flow!
  9. jaydeebe

    Adding calander entry to Lotus Notes

    i have the following code which adds an entry to the calander in lotus notes. The problem i have is that unless i turn off the alarms feature from within Notes i get the alarm dialog box pop up when the entry is added. This i supposed to be automated so i dont't want to have to manually set...
  10. jaydeebe

    Controling where a message is placed

    Ok cheers for the info. I will stick with what i have as i have no wish to edit the message before i send it. My Access app tells me emails have been sent by way of a pop up form when the emailing code is triggered. Only dead fish (and shit) go with the flow!
  11. jaydeebe

    Controling where a message is placed

    recipient = overdue_rst!Firstname & "." & overdue_rst!Surname & "@amra.co.uk" DoCmd.SendObject acSendNoObject, , , recipient, , , "test message", "blahblahblah", False, False overdue_rst.MoveNext Ok sendobject works for both notes and outlook which is helpful...
  12. jaydeebe

    Controling where a message is placed

    I'm on version 5.0.8. I already have set up the signature in notes and it works fine when i go into notes and send an email. It is only when sending from Access that the signature doesn't appear. Does this sendobject work for access 97? At the moment i have this code for sending via outlook...
  13. jaydeebe

    Controling where a message is placed

    When i send mail through Lotus notes the signature doesn't get attached at all. Could you tel me what version of notes are you using? & How do you get the signature to appear (even if it's in the wrong place)? I would be grateful for any input. Dim notes_session As Object...
  14. jaydeebe

    Calendar Control?

    Why not have a table to keep entires for each date. Then on a form have a text box that fills with the data from that table upon selection of a date from the calander control. Only dead fish (and shit) go with the flow!
  15. jaydeebe

    Stuck with User Input Query/Form

    You need to look at parameter queries. Here are two very good tutorials that i think cover exactly what you want - http://www.fontstuff.com/access/acctut01.htm http://www.fontstuff.com/access/acctut08.htm Only dead fish (and shit) go with the flow!
  16. jaydeebe

    Dialog boxes

    Just found this M$ article - http://support.microsoft.com/default.aspx?scid=kb;en-us;824272
  17. jaydeebe

    Date and time picker control 6.0 (SP4)

    How might I get the user to input the date and time easily. I have tried having seperate controls for time and date but can't combine the values to save in one date/time field - DoCmd.RunSQL "INSERT INTO tblbookings ([StartDate],_[EndDate],[UserID],[ResID],[FileLocation]) VALUES...
  18. jaydeebe

    Dialog boxes

    I don't think you can do what you want that way. You seem to be using VB code not VBA. You can create custom dialogs by making popup forms instead. there is a very useful tutorial for creating custom dialogs here - http://www.fontstuff.com/access/acctut08.htm
  19. jaydeebe

    Does developer edition run on XP

    It does! i have installed on XP home.
  20. jaydeebe

    ORDER BY month problem

    BTW r937 can you explain how that works. I don't get how grouping by makes the difference. SELECT Format([StartDate],"mmm") AS Month, Count(*) AS Bookings FROM tblbookings WHERE (((tblbookings.StartDate) Between #12/31/2004# And #12/31/2005#)) GROUP BY Format([StartDate],"mmm")...

Part and Inventory Search

Back
Top