Search results for query: *

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!

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

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

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

It does! i have installed on XP home.

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