Search results

I'm stuck and would appreciate any help! I have a main form based on a table of events. On this main form, I have a subform displaying the contact information for each event. The form and subform are linked by [contact] in the event table (long) and [ID] in the contacts table (also long)...

How do I add the date to a date variable when I have the month (integer), day (integer) and year (integer)? Thanks!

I have a report that looks like a monthly calendar of appointments. The report is poplulated by looping through a recordset and creating an array of each day's appointments. I need to format the text (change color) of each appointment depending on its content. Is this possible? I'm using...

I have such trouble with subforms...any help would be greatly appreciated! I have three tables: Groups Contacts Group-Contacts The Group-Contacts table keeps track of the contact person for each group, as there may be multiple contacts for each group. I want to create a main form with...

I've been able to set the LinkChildFields/LinkMasterFields in the OnCurrent event of the main form and it seems to work. How/where do I set the properties for the combo box on the subform?

Thanks Paul. I hope I can explain clearly. I have a table of EVENTS and I have two tables for CONTACTS (each is linked from another database). An EVENT can occur in one of two facilities. Each EVENT has a CONTACT person. This CONTACT person can come from one of the two linked tables...

Thanks Paul. If I set the recordsource of the subform at the OnCurrent event of the main form, can I have a combobox on the subform and select contacts from it? I don't want to edit the contact information, just select it so that it displays in the subform?

I have a main form with event information and a subform with contact information. Events can be from one of two facilities and the contacts for each facility are kept in separate databases. I'd like to be able to set the recordsource of the subform (with contact information) depending on...

I'm trying to create a report that looks like a weekly calendar. Is there a way to display the lines around the days in the same row (Sunday - Saturday) short of drawing the lines in the form itself? Some days contain data and others do not; I've set the text field to "can grow." (I hope this...

Thank you. I am posting a reply to be able to see the example.

I have searched but can't find code to delete an appointment item from local Outlook installation. I'm trying to start here to test the code, then move on to a shared Outlook folder when all is worked out. thanks!

Thanks Darbid. I'm at a disadvantage because I'm not on the network I'm developing for and have to rely on someone else to test the form. I'll try the code on my own Outlook calendar and see if it can delete. Thanks.

Thanks Darbid. The code above creates the appointment OK. It's deleting it that I'm having a problem with. sFilter = "[Mileage] = " & Me!RoomRequestID.Value & "" Set objAppointment = objAppointments.Items.Find(sFilter) If Not TypeName(objAppointment) = "Nothing" Then...

Thanks Johnny. To set up a room as a resource do I have to set up an email address for it?

OK, thanks. It sounds like this would be better done in Access.

Thanks spikepl. I think I'm lost here. Doesn't the participant have to be an email address?

I need to create a way to visualize room/facility reservations. I'm hoping someone can help in steering me in the best direction. Ultimately, what I want is a calendar-type format with dates across the top and rooms/facilities across the side to be able to see when the rooms/facilities are in...

Hi, I'm trying to export an appointment from Access to Outlook and then have the ability to delete it from Outlook. The following code works to create the appointment, but it gives the message "appointment not found" when attempting to delete it. I'm using the primary key for the appointment...

Hi, I'm trying to do the same thing. I've got the appointment creation working, but need to go the other way now and allow the user to delete the appointment in Outlook. I'm not sure how to search for the matching appointment in Outlook. Any help would be greatly appreciated! Thanks