I was wondering if there is a comprehensive way to set Outlook appointments from a db?
If not, that's what I figured. It's not like Outlook and Access are bundled together into some sort of suite of software where it would be handy for a set of tools that allow you to do such things...
I am trying to set up a form that will tell me when people are due for reccuring training events. I would like it to highlight the record when they are 1 month away from expiring on their training.
ie. I need the database to automatically put in the date that the training will expire when I enter the date that they had the training.I also want it to highlight in yellow when the training is due and highlight in red if they miss the expiry date.
Can anyone help?::)
Hello all,
I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight.
I have two tables. One table for appointments and one table of all available time slots (ie 0930 is record 1, 1000 is record 2, 1030 is record 3 and so on).
If lets say there are records in the appointments table for eg today 01/06/2005 where there are two appointments (eg 0930 and 1000) I want to build a query that shows all the appointments that have not been used (so 0900, 1030, 1100,and son on). Adding to this, I need it to show these available timeslots for multiple dats (as the appointments table will have some appointments booked for the 01/06/05 and some for the 02/06/05 and some for eg 10/06/05).
I am aiming to implement this on a Active server page where the user selects the data and then the available appointments are displayed for that given date. However, I know that the query as descibed above is essential for this to be developed!
I have spent many hours trying to solve this with absolutely no success, so many thanks in advance to anyone that can help. Apologies for descibing the problem thoroughly.
Thanks
Ricky.
hi i will ry and keep this as simple as i can i have a form which a user enters appointment dates .....i need a sloution to have an option of repeating the appointment every day /week /month for a specified amout of weeks whats the easiest solution to this one ???cheers
View 2 Replies View Relatedhi everyone, i sort of run into a dead end trying to figure how to structure this. I have three tables for the 3 roles, tblClients, tblDoctors, tblBusinessContacts, each with a Primary key and some unique information about each role. I'm not sure how i can track appointments to each of these roles, i know how to do it if it was one role. I want to be able to later view all appointments for that day with all 3 of these roles.
Also, for clients i have a multiselect listbox describing their reason for the appointment and somewhow would like to associate that to the appointments. Some info i would like about these appointments:
1. date and time
2. details of contact
3. date for next appointment
What would be my best bet?
Thanks!
Joso
Hello
I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight.
I have two tables. One table for appointments and one table of all available time slots (ie 0900 is record 1, 0930 is record 2, 1000 is record 3 and so on).
If lets say there are records in the appointments table for eg today 01/06/2005 where there are two appointments (eg 0930 and 1000) I want to build a query that shows all the appointments that have not been used (so 0900, 1030, 1100,and son on). Adding to this, I need it to show these available timeslots for multiple dats (as the appointments table will have some appointments booked for the 01/06/05 and some for the 02/06/05 and some for eg 10/06/05).
I am aiming to implement this on a Active server page where the user selects the data and then the available appointments are displayed for that given date. However, I know that the query as descibed above is essential for this to be developed!
I have spent many hours trying to solve this with absolutely no success, so many thanks in advance to anyone that can help. Apologies for descibing the problem thoroughly.
Thanks
Ricky.
I have this code (below) that loops through a recordset and sends appointments. It executes the queries correctly and sends all appointments in the table, but sends them only to the contacts listed in the first record of the query. How do I get it to loop the contact details?
Code:
Private Sub SchedFollowUp()
Dim rsFollow As DAO.Recordset
Set rsFollow = CurrentDb.OpenRecordset("SELECT * FROM Follow_Up WHERE HR_Approved = True AND Added_to_Outlook = False AND Cancelled = False;", dbOpenDynaset)
Dim rsEmployee As DAO.Recordset
[Code] ....
I have been putting together code from bits I have found online that will create an appointment in Outlook from a date field in my form.
My form has a number of dates and I need to create appointments for each one. Is there any way I can incorporate that into the existing code? Or will I need to add command buttons for each date?
The date fields are:
[Date Template Made]
[Date of Top Cut]
[Date of Bowl Cut]
Code:
Private Sub CreateAppt_Click()
If Me.Dirty Then
Me.Dirty = False
End If
If Me.chkAddedtoOutlook = True Then
MsgBox "This appointment has already been added to Microsoft Outlook", vbCritical
[Code] .....
I'm creating a database for a sales team. They need a calendar where they can enter the reminder like "call peter at 10:30 on 11th july" and reminder like " call frederik on july12 at 12:30am,etc. And they need a popup when the reminder is due. Is this possible in access.
View 6 Replies View RelatedI have an appointment database with, of course a Date field.I would like to be able to filter the records to show appointments for a particular month.I want to see what appointments I have for September, for example.Ideally I would like to populate a combo box with month names and filter the form based on the month selected.
View 4 Replies View RelatedI created a form for scheduling appointments on access 2013 using a youtube tutorial. I got most of it work apart from the combo box that functions in a way that once the time slot has booked with a client it should no longer be shown in the list.
E.g.:-2/2/2014 10:00AM is already booked with a client
The combo box should no longer display the 10:00 AM timeslot but can be shown on other days
Below is the VBA code that i typed out. How to create the code to make the combo box work in that manner.
Option Compare Database
Private Sub cboTime_Enter()
Dim i As Date, n As Integer, oRS As DAO.Recordset, sSQL As String
Dim dLowerbreak As Date, dUpperBreak As Date, dDuration As Date
Dim dLowerPrecision As Date, dUpperPrecision As Date
cboTime.RowSourceType = "Value List"
[Code] ....
I found out that the combo box does not work like it does in the video i.e the option does not dissaspear even though their has been a booking with that time slot with another client.
Coding that is required to make the combo box work like that or is their an error within the code that is preventing the combo box to work in such manner ...
I am making a calendar form in Access and want it to look like Google Calendar as much as possible. I am wondering if there is a good way to go about setting up the form to allow for multiple appointments scheduled for the same time. Designing the form to be in Week View with half hour blocks has me at 210 text boxes. As far as I can tell, there isn't a way to dynamically add in controls unless you are in design view. However, how many appointments might be scheduled at the same time. I could add in as many text boxes as possible I guess, but that doesn't seem to be very efficient (and the base form is already at 210). Is there anyway to add in controls (such as text box or label) if a new appointment is added at the same time as existing ones?
View 5 Replies View RelatedI'm constructing a database to record appointments. I want my users to input their appointments on one half of a form (I can manage that bit) but on the other half I want them to be able to see a list of the appointments they already have booked that day (with any patient) or what the patients already have booked that day (with themselves and any other therapists).
The appointment fields they will need to see are:
start time
end time
patient/therapist (depending on if they are viewing their own or the chosen patients' appointments
type of appointment (physiotherapy etc)
location
The date won't need to be seen but will dictate which day's appointments are listed.
At it's simplest I could get away with a list of the day's appointments for the patient and date the therapist has typed into the form to start the record.
Ideally I'd like them to be able to choose whether to see a list of the patient's appointments for that day or their own. If there's room I would display both.
Here's the final, 'moon-on-a-stick' bit... it would be great if I could show the appointments in time slots rather than just as a list. From what I can tell that's quite tricky to pull off but i thought I would ask anyway...
At the moment I don't even know what keywords to look up - is this 'embedding a report in a form' or 'inserting a filtered list' and so on.
I am trying to create a report for 5 different dentists schedule for their current date ( and also allow a search for upcoming appointments)...
I know it requires a query but im not to sure what direction to take as i have never created a report before...
What needs to appear on the query? im aware it would be all the fields i want on the report but do i need to make changes in the criteria etc..
I also dont really know how i can create a report for each dentist because i dont want to have 5 different reports.. is it possible to have the report set where i type the dentist name and select which one i require and then i can view their schedule?
Working in Access 2007 - I would like to have an updatable calendar in the header section of a form, and when this is changed by the user I would like the subforms (there are several) in the details section to be updated with various appointments with dates corresponding to the date selected in the header.
View 3 Replies View RelatedI am creating a dentist booking system and i need some way to display appointments today for a certain dentist and then from their to click the customer and view their teeth details that the dentist will use to update...
View 10 Replies View RelatedCan we design our own form in the MS Access?
And then connect to Outlook?
Because I go to outlook, it doesn't have connection option to MS Access,
whereas MS Access has it, but the we cannot custom the field or design.
Thanks.
Can we design our own form in the MS Access?
And then connect to Outlook?
Because I go to outlook, it doesn't have connection option to MS Access, whereas MS Access has it, but the we cannot customize the field or design.
I have a database that keeps track of client information and future apointments. I would love to hav this data merge with outlook to go directly into my calendar. Is this possible and how do I do it? :cool:
View 1 Replies View RelatedHello,
I am trying to link to the fields in the Tasks section of MS Outlook. I am completing the following actions:
Under tables, right click, Link Tables
Files of Type: Exchange
Under my mail box selecting Tasks
Click Finish
The link table icon is displayed and a Tasks table is created. This contains all the data from the Tasks that I have in MS Outlook.
The problem is that it does not display all the fields. If I open MS Outlook and go to tasks --> Customise Current View --> Fields, there are a number of fields that can be added that are "Standard Fields." I have looked on the Microsoft site and it states that you cannot import custom fields. These however are not custom fields. They are standard fields that are not displayed.
Please Help!
Iain :cool:
Hi,
I'm sending an e-mail each time a spesific report is made. If the user has'nt opened Outlook, it is placed in Outlook's Outbox, and is sent first when the user opens Outlook. Can I somehow start Outlook using VBA so the email gets sent when the report is run?
Also, The user is prompted with a warning message that an application tries to send an email. The user has to allow this for the mail to be sent. I know this is a security matter so no applicatopn can send emails without the user knowing. Is there someway to do this without the warning?
I'm using WXP and A2K3
Thanks in advance.
Hi All,
Apologies if this question has already been asked. Im a bit of a newb when it comes to Access. I was wondering if its possible to create a input form/email in Access/Outlook in which I can send to a number of people via email that populate a Access database/xls when they reply?
Extra Info:
-Users may have a different version of office that I have.
-I have office 97, 2000 and 2003.
Hope that all makes sense.
Ollie
hi,
i have a table name datatable with fields TO,CC,BCC,BODY, and Buttons "get address","send mail","clear","save","Attachments",.
on pressing get address i want a new form from where i can add recepients from outlook address book to TO and CC fileds.
on pressing Attachments i could be able to attach multiple files.
on pressing send mail it should send the mail.
on pressing save it should save in the datatable.
on pressing clear it could clear the form.
plz help
Let me preface this thread by stating I'm an Access noob. However, I am fully capable of using the "search forum" section. Unfortunately, many of the answers given to somewhat similar queries are out of my range of understanding.
Here's what I am looking to do:
I work for a R & D company. My lab receives media and reagents of all sorts with various expiration dates.
We have an Access Database setup for what is in storage and from who... but it's really quite basic.
What I have been asked to look into is:
Is it possible to have Access automatically send an Outlook Reminder or Email based on the expiration date field within the database?
For example:
4 days to expiry of a Tryptic Soy Agar Plate, Outlook sends a reminder to the relevant people with a message that says something like:
Notice
You have <number of days until expiry> days until <item description> Lot # <lot number> expires.
----------
of course, i'm not even sure how to setup the email so it pulls the relevant information. I would be fine with it just sending out an email telling which item expires a set amount of days before.
um..
help please
I am using outlook to send/receive mail. That is OK but I want to know that who send me mail(from: name of sender mail).
View 6 Replies View RelatedHey there, folks,
Got one I need some help on. Perhaps one of you has tried something like this before...
I need to create a tool that will allow me to do the following:
1. Search an Outlook email box for all emails that have a keyword in the subject line that I have chosen from a drop list
2. Open all qualifying emails
3. Print all of them, including all attachments associated with them
4. Close the emails, and move them all to a folder
I've got the email box linked to Access (we've got 2003 running here), and I have no problem accessing the emails and even deleting them, etc. I can see if they have an attachment, but am unable to discern where it is or how to get to it to open it. I also cannot get the emails to show as "read" when I open them using the db. There is a col for "contents unread," but it is a number variable (I cannot change this since it's a linked table), and all rows are blank anyway.
It is important that I am able to print them including the attachments and move them out when done.
Whaddya think?? I'm open to any and all suggestions!
Thanks in advance,
Ceejay