Making Outbound Call Tracker For Company

Feb 10, 2012

I've been asked to come up with a method of tracking outbound calls for my company. This is a new job for me and I'm aiming to impress.. but I'm a touch out of my element so I'm not trying to reinvent the wheel here.

I've found this starting point: [URL] .....

But I'm having difficulty conforming it to function the way I need it to. Basically, I want the applet to

-store the employees name
-store customer names that were called
-a checkbox for whether or not an appointment was set
-a textfield storing an appointment date/time [if applicable]

-four radiobuttons to select which area of the business the call pertains to

The employees would submit new values everyday, and ideally I would like the data to be accessible in a real time line graph.. I totally assumed this would have been done and redone before and that there would be a plethora of templates to choose from online, but for the most part my search has been fruitless and the only solid lead is the one posted above.

View Replies


ADVERTISEMENT

Making Call List In Access

Jul 5, 2012

We have 4 managers and 16 foreman. Each month a manager is tasked with calling 4 foreman for progress reports.

I'd like to create a simple program with Access to have the foreman assigned to the managers differently each month. It would have to remember the past 4 months so the same names aren't assigned to the same managers. It also has to randomly assign the foremen so the managers don't have the same foreman after 4 months (if that makes sense).

View 1 Replies View Related

Making A Form To Call Up Information From A Table?

Jan 27, 2005

I'm making a customer survey database. Also be aware I'm not proficient with access.

All the customer information is being imported from an excel spreadsheet. That will include ServiceRecordID, ServiceDate, TechID, CustName, ServLocation, PhoneNum, and DeptID.

Another table will include records for answers to 5 questions that will be asked by a manager on the phone. That table is called TblQuestions. This table will also have ServiceRecordID to go with the answers.

What I'm trying to do is create a Form that at the top has a box for ServiceRecordID. I'd like to be able to type in the Number for that ID, and then all the information shows up on the form for that specific ID. And below all that, fields to add the answers to TblQuestions for that specific ServiceRecordID.

The reason I'm doing this is because the manager will get a report with the customer information that needs a follow up call. So I want them to be able to call up that information on the screen with the ServiceRecordID number, and also be able to add in the information that they get back from the customer with the questions that will be asked.

I don't know why I'm having so much trouble with this. But I'm not experienced with access or VBA both.

View 2 Replies View Related

General :: How To Make Sound Like Making Call To Another Computer Using Vba

May 19, 2014

I'd like to make noise to another computer, or start same sound file or simply to call another computer on lan or through vpn connected computer using vba...

That will be nice if I can press button on access form and user on another computer hear some noise or to loo like it is call

View 1 Replies View Related

Modules & VBA :: Static Shell Function Call Works But Dynamic Call Fails

Sep 4, 2013

I'm having to recode some old MS Access DBs so they will run in the following environments:

Office 2000 on WinXP
Office 2003 on WinXP
Office 2010 on WinXP
Office 2000 on Win7
Office 2003 on Win7
Office 2010 on Win7

When I wrote my code for Office 2000 on WinXP things were simple because directory paths were the same across all computers and I could hard code pathing when using a shell command to launch other files.

My new approach is to make a function call to the Windows registry to determine the default executable and path for opening a file based upon its extension (see apicFindExecutable in basWindows API module).

I'm able to use code to create a shell call and debug print it to the immediate window. If I put my cursor in the immediate window at the end of the shell call and hit [enter] the external file will open as desired. If I try to open the external file directly through code, I get a file not found error.

To recreate the error take the following steps:

(1) browse to files that are accessible from your computer
(2) click the PREPARE DATA AND OPEN MAIL MERGE DOCUMENTS command button

Shell function call is made by the fnOpenFile function located in the basOpenFile module. There has to be a trick here that I'm missing.

View 5 Replies View Related

Help With Tracker

Dec 11, 2007

Hi Guys,

I am really stuck here. For some reason I am not able to link tables together.
I am not sure if i have separated the tables correctly.

The Employees are related to the ODF number

Here's what I want to happen

2 tables
Employee
- LastName
- FirstName
- Extension

ODFNumber
- Queue
- ScanDate
- Status
- SentDate

Please help.

Also, I am having problems with creating the forms

I want to be able to just enter the ODF number and know what the status is and who is processing it.

Thank you very much.


19879

View 8 Replies View Related

User Tracker

Feb 15, 2007

I have a database which I have written for part of my coursework for school. However I have a small comany interested in it, I have added security to it using the wizard in access and what I would like to be able to do now is to be able to see when each user has logged in and logged out so I can track how much use it has had when I go to carry out maintance on it.

I know this one might be pushing it but I would also like it to say what each user has accessed while they have been logged on.

Do any of you know how to do this? or could you give me some pointers about were to start?

View 1 Replies View Related

Financial Tracker

Nov 1, 2005

I would like to keep track of 5 seperate funds (or stocks) by price, daily change, total change...etc.

I was thinking of having a table with date as the primary key containing the daily price of each fund. I will enter the prices into this table manually every day.

A second table will automatically makes appropriate calculations and save these changes on a daily basis based on the date. With no user input.

Is this possible?

Can I have the second table automatically grab the dates from the first table? Would the second table use date as primary key for calculations?

Thanks,
~dnnymak :eek:

View 4 Replies View Related

Update Tracker

Oct 12, 2006

folks,
need to know if there is a simple way to
1) find whether an access database has been updated
2) if so send an email to an address

is there an easy way to accomplish the above

need to monitor an access db for any updates and notify upon any changes.

tx

View 2 Replies View Related

Yearly Attendance Tracker/Calendar

Jan 29, 2008

I'm currently attempting to setup a small database to track a few things for the company I work for, namely attendance. Currently they use an excel spreadsheet that covers the current year. This worked great for them when they were still a small company, but with the number of employees shooting from 50'ish to a couple hundred the spreadsheet is just not a viable option any more.

What I need is suggestions on the best way(s) to go about implementing this.

First, I need to do a 1 year look back, on a montly level is fine. So from January 2008 back to January 2007 will work fine. What i have currently setup is a form with 12 of the basic Calender controls built into access 2003. Unfortunatley these wont quite work.

Basic layout of my database so far will be an employees info table, a lookup table for Attendance codes and their infraction values and an attendance (or I suppose more technically an absence) table. I would like to have a form that displays a calendar view for the last 12 months, that will allow me to view / update any absences for an employee. I would also like a way to insert company holidays / shutdowns in to the attendance table in a way that marks it on any employees calendar as a scheduled day off. I assumed i could do this with a simple "all" employee along with the dates and have the calendar search for entries with the Employee ID as well as the All flag and mark those on the calendar.

I think if i can just get the calendar setup covered I can figure out the rest of the data aspects, I'm just stuck on finding a decent way to implement the Calendar Aspect.

Thanks in advance!

View 14 Replies View Related

Forms :: Time Tracker - Access Split Database

Sep 15, 2014

I am currently preparing a time tracker in my office where there are similar task assigned to different users.

I created a form and split it for front end user and back end user. front end database was copied by each user in their local. However problem is that whenever a front end user update their database it is also reflected in other users database. Is their anyway front end user can see their database only....

View 1 Replies View Related

Tables :: Creating A New Main Table - Quotation Tracker

Nov 7, 2012

My Main Table in my Database is "Quotation", what do i need to do in order to create a new Main Table called "Quotation Tracker" and "Quotation" would now be under "Quotation Tracker"

View 8 Replies View Related

DB For Rental Company

Dec 26, 2007

My company rents equipment to our customers. I am looking for a db to track our stuff. There are three possible locations of everything. Warehouse, employee trucks, and Customers. I assume that warehouse can be added to the employee table. I can set up these 2 tables and one for our equipment list, but the hardest thing I am having with is with the table for transactions(I believe it should be a table), this needs to allow batch transations, because typically more than one piece of equipment is moved at a time.

I will need a report that will show each equipment id number in a customers home from date to date (date it was placed and date it was removed), one that will show a list of all equipment locations on a given date, and one more that will show equipment that has been in a customers house for 5 days or more so I can verify that it is still there, becuase equipment typically should never be with a customer for more than 5 days.


Right now I am using excel, but its not working well. I would greatly appreciate some help! The attachment only has the info I need for the 3 tables I mentioned above that I know how to do, and my best guess at what the transaction table should look like.



See atached.

View 8 Replies View Related

Company Database

Apr 27, 2008

Hi.
if anyone has the MS Access database which includes the Employee, Project, Department, Works_on, Dependent tables, plz post here...

Thanks.

View 2 Replies View Related

Showing Primary Key As Company Name

Sep 28, 2005

how do I set up supplier name in the order table like the example in the
northwind database?

what I mean is set supplier ID so that it shows combo box with names instead of numbers.

View 3 Replies View Related

How To Pass A Company ID Thorughout All Forms

Jul 5, 2005

Hi,

I have a database that controls donations for a Charity. There is to be a sister charity added to the database and a lot of the previously created objects can be used to provide for the new Charity.
My idea was to create a "company" ID and label the categories of the donations. I could then use this company ID to identify to whom the data captured belongs.

I have used the switchboard manager to enable navigation, in this I have a ONload event procedure that requests the Company ID (1 or 2).
That's as far as I have got.

How would I get Switchboard to open each form (some being based on queries - a couple direct on the tables) and filter the data on the company ID?

If there is a better way, please enlighten me!! :)

Many thanks in advance

daz.

View 6 Replies View Related

Table Structure For Company Database

Oct 26, 2004

Hi all,

This is a fairly simple one, but im not sure exactly how to go about it...

Lets say a Company can have many Divisions. Each Division has 1 Division Manager (CGM), and manages many Cost Centres.

Each Cost Center has 1 Cost Centre Manager (CCM) and employs many Employees.

Im thinking of 3 tables:

Divisions, Cost Centres, and Employees. And if you hadnt already guessed, CGM's and CCM's are part of the Employees Table.

What is the appropriate table structure and relationships?

Thank you in advance...

View 2 Replies View Related

Pulling Most Recent Records For Each Company

Jul 10, 2007

Hello All,
I've searched and searched and can't find anything but it might be because I'm not sure what to search for.

Here is what I'm trying to do. (I'm simplifying this to make it easier to discuss)
I have a table that looks like this:
Company Date Sales
1 5/5/07 $1,200.00
1 6/5/07 $4,200.00
1 7/5/07 $2,200.00
1 8/5/07 $4,300.00
2 5/5/07 $1,200.00
2 6/5/07 $4,200.00
2 7/5/07 $2,200.00
2 8/5/07 $9,200.00
2 9/5/07 $1,200.00

I need to run a query that grabs the last 3 months for each company.

So the correct output from the above table would be:
Company Date Sales
1 6/5/07 $4,200.00
1 7/5/07 $2,200.00
1 8/5/07 $4,300.00
2 7/5/07 $2,200.00
2 8/5/07 $9,200.00
2 9/5/07 $1,200.00

Any help would be appreciated. I'm sure this has been asked in the past so even if you could help me with a keyword to search for, I would be greatful.

Thanks in advance,
Randy

View 4 Replies View Related

Company Db With Multiple Product Categories

Jul 12, 2005

Hi!

I need to create a database of the info of a few hundred companies. Each company (food producers) specializes in various product categories, not just one. This is my problem/question: each company entry should then have a possibility to have as many product categories as needed. How can I do this without using "free text" fields? The website user should obviously also be able to search the db - by clicking checkboxes with the categories maybe?

(+Also: When the admin user needs to add the info of a new company (with, say, 9 product types) into the database, what kind of an SQL clause I need to INSERT INTO the db? For example if the product categories where laid out as checkboxes, and the user would just click the ones he wants.)

View 8 Replies View Related

Queries :: Company Two Tables On Same Column?

Aug 13, 2015

In query, I would like to compare two tables and get the result but I always get the round robin result.

Table1

OrderQty Company Order# 8 Oop BBS 12 abc AAA 3 abc AAA

table 2
OrderQty Company Order# 7 Oop BBS 12 abc AAA 3 abc AAA

Result I get which I don't want What I want is the last table
Order2.OrderQty Order2.Company Order# Order1.OrderQty Order1.Company 3 abc AAA 3 abc 3 abc AAA 12 abc 7 Oop BBS 8 Oop 12 abc AAA 3 abc 12 abc AAA 12 abc

The result I need. How to get this?

Order2#Company Order# Order1#OrderQty Order1#Company 3 abc AAA 3 7 Oop BBS 8 12 abc AAA 12

View 4 Replies View Related

Code To Link From Access To Company System

Oct 21, 2004

Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?

View 2 Replies View Related

Queries :: Delete Duplicate Company Names

Nov 18, 2014

The charity that I volunteer at has a web site through which they receive donations.

Most of the COMPANY names that they receive through their website are JUNK.

I would like to have a system to delete duplicate company names:

A = first programmatically delete all company names that are GOOGLE and this will remove about 60% of their spam
B = next group all Duplicate Company names, which will be removed manually

View 6 Replies View Related

Making Specific Fields In A Current Record Copy Themselves When Making New Record

Mar 28, 2005

;) Hey everybody,

I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...

Thanks

gunwax

View 9 Replies View Related

Setting To Allow Duplicate Company Names In A Contact Management DB

Jun 22, 2005

Hi,

In a contact management DB I want to be able to record the addresses of a number of contact people and braches of the same company. In other words, a company has several branches and I want to record their different street addresses. What settings do I need to specify in the field "CompanyName" or elsewhere?

Another question is how to set a Text box, especifically "CityName," so the name of the city fill out the text box when I start typing the first letter of the city name but without using a predefined list of city names.

Thank you for your help.

Orlando

View 1 Replies View Related

Web Hosting Company That Supports Data Access Pages

May 30, 2006

Hi. Does anyone know a web hosting company that supports Data Access Pages? Thank you.

View 4 Replies View Related

General :: How To Share Access Database On Company Intranet

Jan 14, 2015

I want to consider ways of sharing an Access database within our company. This could be web-based via our intranet or done some other way.

I understand that Microsoft's preferred way of sharing via an Intranet is to use SharePoint. However, as we don't use SharePoint (we use Atlassian Confluence) the cost of that route would be prohibitive.

Any methods of sharing an Access database across, say, 20 people? Simultaneous read/write access would be required but in reality the usage will be low, so performance is not really an issue. I would like to consider web-based or other methods.

I have chosen Access 2013 simply because we use Office Professional 2013 and Access will be familiar to some developers. We could use a different product. But I would certainly prefer a tool that supports RAD design of forms.

View 1 Replies View Related







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