Recent content by jaydeebe

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

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

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!

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.

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

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!

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

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!

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

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!

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

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

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

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!

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!