How To Save Meeting Info Into Access

Jun 29, 2007

My company has a meeting every tuesday where we discuss the status of all our construction jobs. I am trying to set up a database which will allow me to build a report which shows the job number and job status of all our jobs on that particular meeting date. I would like to be able to view the entire job list and pull up the job list by date. The fields I'm trying to store are job # and job status. But I'd like to be able to go back 3 weeks and pull all the job status notes for the entire job list. I can do this by entering a job status field in the job list table but I'll end up having alot of fields in the table which I want to avoid. Is there another way I can enter this info into the database?

Thanks,
Paul

View Replies


ADVERTISEMENT

How To Save Info From A Form

Oct 24, 2012

How do I type info into a form and then save it to the database.

View 4 Replies View Related

General :: Scheduling Meeting Appointment Through Access Command Button

Mar 20, 2014

I am trying to create a command button in Access to generate a Meeting Invite. I found code for creating an Appointment and it works great but cannot get it to invite attendees.

Private Sub AddAppt_Click()
On Error GoTo AddAppt_Err
' Save record first to be sure required fields are filled.

[Code].....

View 1 Replies View Related

Linking Outlook Calendar To MS Access - Appointment / Meeting Date And Time

May 30, 2013

I have linked a Shared Calendar from MS Outlook in MS Access. The fields that I need which are Appointment/Meeting Date and Time are not there, only creation date/time. Is there anyway for me to get the Appointment/Meeting Date and Time from Outlook into the table?

Windows 7
Office 2010

View 1 Replies View Related

Open Form Based On TableA / Add Info And Save Results To TableB

Dec 1, 2012

We have Cardiac Rehab patients that come 3 times a week (M-W-F). Once they are on program they stay there for 3 months. There are classes given hourly from 8am thru 6pm. There are 12 available slots per class. Right now this is being handled in Excel, but I thought I might improve things by putting it in Access.

The Excel "form" I built has fields for PatientName, MedicalNotes, DoctorName, and Notes. Because the names rarely move (a patient gets a slot and stays there) the user opens Excel, reviews the form to make sure no one cancelled-is out sick-etc, then prints the schedule. When the day is complete I have a macro that takes this information and saves it in a tablelike manner on another sheet. A dynamic pivot table references this info to give the user quick answers as to daily volume, etc.

The thing I can't get my head around is how to make this as easy in Access. My thought was I could have a PatientT, listing all of the fields mentioned above. I could have DailyF open, bound to PatientT, with additional unbound textboxes to add "today's date", cancellations or no shows, and then Save all of this in another table and print out the daily schedule.

View 7 Replies View Related

Modules & VBA :: Save Access Report As PDF And Save To Folder

Jan 10, 2014

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?

View 4 Replies View Related

Help With Duplicate Records!! Please!! I Need It For A Morning Meeting!

Jan 18, 2005

I have a table where for every customer I have they have two lines of data. Both lines of data contain their customer number and then one line has the qty of tickets they have ordered and the second line of data has their name. How am I able to combine this data into one line? I would really appreciate anyone's help. I need this for the morning and I am looking at combining it manually so any help would be appreciated. Thank you.

View 2 Replies View Related

Modules & VBA :: Adding Meeting To Outlook - Run Time Error 462

Feb 13, 2014

I have some code that creates appointment that i can send to colleagues, when I run the code first time it work all ok but the second time i run it i get a run time error see pic below

But I don't get any error's if i leave outlook open have also try the code on 2 pc's but stiil same problem

1392336756_tmp_run_time_error[1].jpg

Code:
Shell ("Outlook.exe")
Dim outMail As Object
Set outMail = Outlook.CreateItem(olAppointmentItem)
outMail.Recipients.Add (Me.txtsupervisor)

[Code] .....

View 3 Replies View Related

One To One Meeting Organizer Between Companies With Specific Time Slots

Jan 24, 2012

I would like to design and build a database that can match one to one meetings between companies with specific time slots.

For example, we have two sets of people: buyers and sellers. A buyer could specify which sellers they would be interested in meeting. The database would then work out which buyers could meet with which sellers, and when.

View 5 Replies View Related

Modules & VBA :: Send Meeting To Outlook - Address Item Line Causing Error

Mar 24, 2014

I'm trying to have a command button send info on the form straight to Outlook as a meeting. So far, the code below works apart from the address bit. I need the code to automatically add the same 2 email addresses as recepients everytime.

Error message highlights the red line below with the following message:

Runtime error '438'
Object doesn't support this property or method

I'm new to VBA, so don't understand what is wrong here. The reference is set, I've tried different permutations of the "To:" & "Recipients.Add" for the email address with no joy.

Code:
Private Sub cmdSend_Click()
Dim outApp As Object
Set outApp = CreateObject("Outlook.application")
Set outmail = outApp.CreateItem(olappointmentitem)

[Code] .....

View 10 Replies View Related

Update Order Info Based On Quote Info

Nov 7, 2006

I need help on this, from what the best concept is, to what I need to look into using:

I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.

As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?

Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...

Thank you.

View 2 Replies View Related

Access Database Info

Nov 24, 2006

When i"m creating a database and the tutorials tell me to select CHAR under DATA TYPE, that is not one of the selections. Can Someone tell me why??

Thanks,
aclcom

View 1 Replies View Related

Please Help- Need ACCESS Multi User Info

Sep 2, 2004

Hello,

Great forum

I am a virtual assistant and I have a client that wants to "share" their ACCESS database with me so that I can do data entry. How do we go about doing this? Is there a program that allows me to use the same database as my client and their office people? I would be working from a remote location.

Thanks in advance!

View 3 Replies View Related

Info Help: Emailing From Access Via Outlook

Jan 19, 2007

Hi to all!

I dont know if this is possible but can someone please suggest if this is possible and if so where I could find some info on how to do it or what I should be looking for in this group.

Can I set something up so that I can email from Outlook to all the customers in the query below?

I have an access database which I have creatged a query that pulls results from a table with 100 customers in it.

Lately I have been cutting and pasting information from the database and email every customer individualy.

An example would be as follows.
------------------------------------------------------------------------------
Dear JOHN,
Your listing with us contins the following results...
CAT
DOG
MOUSE
Your listing has been viewed 10 times.
------------------------------------------------------------------------------

The text in capitals are results from three colums in the database.
Colums are called
Name: JOHN
Email:JOHN@THEPETSHOP.COM
Result: CAT, DOG & MOUSE
Search Result: 10

Can I set something up so that I can email from Outlook to all the customers in the query above?

Where can i look to learn how.

Cheers
Mally

View 1 Replies View Related

VBA Access To Gather Info From External Site

Dec 29, 2006

Hello All

I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.

John

View 1 Replies View Related

Input Info Into Word Documents Using Access Information

May 10, 2006

Hi. I have been asked to find out if it is possible to automatically insert info from a access database into some word documents that require the same info i.e. a title or reference number so that, for example, if the title is changed in the database it will automatically change in the associated word documents.

Is this even possible as I have no idea or can something similar be done?

Thanks for any ideas!

View 1 Replies View Related

Change Logon Info At Running Time(using Ms Access)

Feb 28, 2007

hi there,
I'd like to ask the solution for my problem.
I made a new project using ms access 2003,crystal report 9, and visual studio 2005.

I just made a simple access dbase with 1 table(Table 1) and protected with password, o I forgot this table has 2 field(id and desc).
After that I made simple report that using DAO connectivity(save data with report option is disabled).

At last I made simple program(windows app) using visual studio 2005.
I put the CrystalReportViewer component, and these is the code :


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace prj
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void crystalReportViewer1_Load(object sender, EventArgs e)
{

}

private void Form1_Load(object sender, EventArgs e)
{
crystalReportViewer1.ReportSource = System.Environment.CurrentDirectory + "\Report1.rpt";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "Admin";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "12";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = System.Environment.CurrentDirectory + "\db.mdb";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = System.Environment.CurrentDirectory + "\db.mdb";
}
}
}


and the problem is when I move the access database file to other location, the viewer shows a box to be confirmed by my UserID and password,
my question is how must I write in the program so that the box doesnt come out.

thanks

View 1 Replies View Related

Viewing Database Info In A Data Access Page

Oct 18, 2004

I am very new to access and have a question which I think is very easy to answer. What I have is an access file with a listing of companies, their contacts and what services we provide for them. (each company/client/service is listed in a row with each new set of information on the row below it).

What I am looking to do it to create a data access page that anyone in our office can view. I want the access page to have a text box where they can type in the name of the company, then click a 'search' button. That will then display the results in a box below everything. The results would be the contact and the services (there are other columns in the datasource as well, but I didn't list them).

If anyone can shed some light onto my problem it would be most appreciated!

Thanks

View 3 Replies View Related

Opening Word Document With Info From Access Form

Feb 15, 2005

How is it possible to open a form letter word docment from an Access form in which information on the form (such as name and address) is used in the letter?

View 3 Replies View Related

Access 2010 Multi Info Inside Field

Jul 5, 2013

I Need After I Choose For De Code 2355.

The Field Show 2355 INTEL DH77EB MOTHERBOARD.

View 3 Replies View Related

Copy & Paste From Access Table To Excel Without Header Info

Dec 11, 2004

Hi,

Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted.

Thanks for the help in advance.

BJS

View 1 Replies View Related

Modules & VBA :: Save As Dialog Box - Allow User To Save Copy Of Current Database At Desired Location

Feb 12, 2014

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

View 2 Replies View Related

OPen A File And Save With Access

Dec 10, 2005

Good Afternoon,

Does anyone know where I can find a sample db that will let the user do the following:

Selected a file from their computer and upload to a the same folder as the db?

I am building an Investigation database. This function will allow the user to attach file to an investigation. (the files will be stored in a folder and logged on a table)

Any help would be great.

Thanks,

Bones

View 2 Replies View Related

ACCESS 2007 Save Emails

Dec 22, 2007

Hello,

I am building a databse that registers all communication between a company and a customer. here is my question.
If customer A sends an email to the company how can I store that email in my database. I dont want to copy and paste the contents of the email to a memo field.
Is there a way to automate this?

View 2 Replies View Related

Access Dont Want To Save Query Changes

Sep 15, 2006

I'm trying to save a change made to a sql statement in an access query but everytime I save it and close the database, when i open it up back again, the query returns back to the old unchange sql statement like it never got saved. I checked the user permissions and they are all checked (no restrictions). Any help would be greatly appreaciated.

View 1 Replies View Related

Modules & VBA :: Save Workbook To Access Db?

May 6, 2014

I have some vba code that exports the results of a query to a specific excel workbook. Code in this workbook then takes the exported data to "fill out" areas in the workbook. My staff will then use this workbook to perform analysis on a project. After they have completed the analysis, they will then save the excel workbook, and another person will then validate this excel and turn it into a PDF to send as an email attachment.

My question is, when my staff saves the excel workbook, is there a way they can save it directly to the access database? If not, would there be a way to use vba to "attach" this excel workbook to the appropriate record in the access db for future use?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved