Tables :: Predefined Table Of Tasks Against A Case?

Aug 5, 2015

I'm creating a fairly basic case management system in Access 2007 and i'm wanting a way of populating a set of tasks when a case is created...

e.g.

I have a case table, which contains basic information about the case, case manager, ID, date created etc.

I've also got a task table with a list of tasks

When i create a new case I want it to pull in the list of tasks from the task table, the tasks are static so i wouldnt want them to update the task table but update progress on the tasks against the case.

Do i need another table for like casetasks where it populates the blank tasks and then they're updated with an ID linked back to the Case.

View Replies

Exporting Access Tables/queries To Excell In A Predefined Format

Jul 11, 2007

I have an Access database. Now I want to export the data of a table in the database to excel sheet in pre-defined format. e.g. i want that in the first row of the excel file, there is a heading called "Report". In the second row, there should be column header like "Name", "Age", "Gender". Also there must be 1 column gap between this header. Then in the following rows, there should be data.

View 2 Replies View Related

Predefined Table Fields Per Tab In A Form

Mar 4, 2015

I am trying to find a simple method to have predefined table fields per Tab in a form
OR
Fill in multiple table fields per control

IE: If I click a check box, option from a drop-box, or Fill in a text-box when that information gets entered into the table the results will be:

Primary Category
Sub Category #1
Sub Category #2
Input

FOOD
_____
FRUIT
APPLE

FOOD
_____
VEGETABLE
SPINACH

The red will be automatically inserted based on what I chose for the "Sub Category #2" drop-down. The green will be what I typed in.

View 6 Replies View Related

Forms :: Address Lookup From Predefined Table

May 15, 2013

Have been searching for a way to allow an address to be looked up from a predefined table.

What I am looking for is that the user can type just part of the address into say, a text box, and are presented with all options which match so that they can chose the correct one. Once chosen I want the form to be populated with one or more fields from the selected record in the address table.

View 2 Replies View Related

General :: Copy Single Record In A Table And Paste It Predefined Number Of Times

Sep 25, 2012

I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will vastly reduce the amount of work and time spent entering records individually.

The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cells back from Excel and then paste this range back into the Access table.

This works but is long winded; what I would like to know is is there a simply way of achieving this.

View 3 Replies View Related

General :: Input Data In Lower Case And Automatically Change First Letter Of Word To Upper Case

Mar 16, 2013

Is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital ...

View 4 Replies View Related

Changing Case Of Data Already In Access Tables

Dec 8, 2006

My database is now live within our office and is working fine.

The databases which I have imported the data from, where done by my dad, who being old fashioned, used CAPS for everything he typed. So for quite alot of the data, its all caps, and it would be great, but not essential if we could revert the text to normal sentences.

Is there any trick or code that I could run that would go through certain tables and reformat the text in to a better format??

View 6 Replies View Related

Change Case To Title Case

Aug 24, 2004

hi

help is needed yet again :-)

I know when creating a text field in the format option
you can use the > or < sign so that when text
is entered it automatically changes it to uppercase or
lowercase - but i need it to be Title Case, any one know
how I can do this....

View 11 Replies View Related

Too Many Client Tasks

May 4, 2005

Hi,
we use access for localisation in our application. The business object which accessess the access uses DAO connectivity and we often land to
"Too many client tasks" problem.

is it wise to change the DAO to ADO? if so the above problem will go off?
what are the chances that the problem still persists?

is that access has any limits on the number of connections? like 64, 255? or is that ADO/DAO has any limitaions on the number of concurrent connections to access DB?

Pls help, your help will be highly appreciated.

Thanks,
Venkat.

View 1 Replies View Related

Weekly Summary Of Tasks

Sep 17, 2007

I am just starting to use Access and have set up many simple forms, datasheets, reports, summaries, etc. I have not worked with macros, etc. and need help for this project. I have set up a task table

F1 - DateOfCall - date - now()
F2 - Client - text
F3 - DateCompleted - date
F4 - DueDate - date
F5 - problemDescription - memo
F6 - Resolution - memo

I need to run a query and/or report every week summarizing what has been done the past week. Would also like to view previous weeks. I need help. How do I go about doing this.

View 1 Replies View Related

Upper And Lower Case Mixed In Table

Jul 10, 2006

Is there away to change what is in the table field [surname] to the first letter being upper case and the remaining letters lower case.

Thanks

Sorry I found it. Just in a little rush.. Should have looked harder.

View 1 Replies View Related

Converting An Entire Table To Proper Case

Apr 27, 2005

I am trying to change all the fields of a table from All Caps to Propercase. I have used strconv propercase before, however only on a field by field basis. I have about 5 or tables that I have to do this to and am trying to save the typing. I know I can do this with a recordset (easily in asp), but am not familar enough to do this in vba. Can you do a for each fld, like in asp, or am I going at this the totally wrong way. I tried using an update query with the *, but access doesn't like that too much. Any help is greatly appreciated.

Thanks,
Josh

View 1 Replies View Related

Changing Fields In Table To Upper Case

Jun 19, 2007

Hi All, A quick question..

Is there a quick way to change about 5000 primary keys fields from lower case to uppercase?

Thanks Anna :)

View 4 Replies View Related

Convert An Entire Table To Lower Case?

Sep 24, 2007

I need to convert an entire table to lower case..

The table happens to only have one column in it, so each record only has one field..

How do I convert the entire thing to lower case?

I can not just convert the display info to lower case, this table is used as a cross-reference data table and I need to physically convert all the data in the entire table to lower case.

Oh, and I need this to be a macro of some sort, since the data is re-imported on a regular basis, and will re-convert to upper case on the import.

Thanks,

Bill

View 2 Replies View Related

Change Table Entries To Upper Case?

Sep 13, 2004

Hi All,
I want to change existing entries in a table to upper case format. I know that it is possible with a query (update I suppose) using an expression with the "UPPER" function. But I am not quite sure how to implement it in Access. A little help would be welcome...

View 2 Replies View Related

Selecting Open Tasks In A Timetracker

Feb 20, 2007

View 4 Replies View Related

Need To Preceed Control With Predefined Text

Mar 14, 2006

Hi, I just can't work this bit out. I am copying a description to another field but I want to add the word FastTrack - to it so that I end up with FastTrack - <whatever the description is>, I have included the code, can you tell me where I need to put the bit FastTrack - and whether I need " or ( or [
Thanks
Me.Enquiry_Desc = [Forms]![Frm_edit_Enquiry]![Enquiry_Description]

View 6 Replies View Related

Email Hyperlink With Predefined Message

May 29, 2012

I have a form with contact info (name, address, postal code, email etc.) and I have set up the e-mail as a hyperlink to outlook. I would like the hyperlink to not only start a new email to that person but also have text in the message field (a template). For example,

"Hi, [Name]

I would like to confirm your address of [Address] for delivery of a package.

Thanks"

Is something like this possible? The template would include much more text than this but if this works, I can do the template myself. If it is not possible to personalize the name and address automatically within the message, they can be entered manually in the message but ideally, I would like to do it automatically.

View 10 Replies View Related

From Query To Graph - Running Sum Of Tasks Outstanding

May 10, 2006

Hi,

I am still confuse after reading threads on producing running sum on queries. help!

This query is to produce a time line graph of Progress Tasks with 3 main categories - New, Completed and Outstanding. So I got months on the x-axis and count on the Y-axis.

sample data.
say we look back for jobs in the month in feburary
Date Added; Date Completed ; category
11/1 ; NIL ; Outstanding
11/1 ; 1/3 ; Outstanding
11/1 ; 14/2 ; Completed
1/2 ; NIL ; Outstanding
1/2 ; 1/3 ; New and Outstanding
1/2 ; 14/2 ; New and Completed

so the total count of the categories for Feburary
New = 2 ,Completed= 2, Outstanding=4

can anyone help?

thanks
galantis

View 1 Replies View Related

Queries :: Task List Max Tasks And Max Hours

Jun 14, 2014

I would like to make an action list based on tasks. I try to make a query that does the following things:

-Taken.Priority=1
-show maxium 5 tasks sorted on make date(taken.ingevoerd)
-OR with a total duration of maxium 480 minutes (Taken.[Geschatte duur (min))

The last one is to hard for me to make. For example if the duration of 4 tasks is 420 minutes, the fifth task (100 min) should not be shown, because the criteria of maximum amout of minutes is reached.This is what I have made so far:

SELECT DISTINCT TOP 5 Taken.ID, Taken.Omschrijving, Taken.Ingevoerd, Taken.Deadline, Taken.Priority, Taken.[Geschatte duur (min)]
FROM Taken
GROUP BY Taken.ID, Taken.Omschrijving, Taken.Ingevoerd, Taken.Deadline, Taken.Priority, Taken.[Geschatte duur (min)]
HAVING (((Taken.Priority)=1))
ORDER BY Taken.Ingevoerd DESC;

View 2 Replies View Related

Queries :: Put Sum Of All Records In Calculated Field And Divide It By Predefined Value

Feb 6, 2014

I want to take the sum of all records 'cost' i.e.
record 1 - 2
record 2 - 4
record 3 - 3

I want to take the sum and put it in a calculated field and use it to divide it by a predefined value 'no of responses.'

So I make the field in the query -> Calcfield: (Sum([cost])/[responses])

I am pretty new to this and i don't understand why this won't work? Is it something to do with the row Group by (total.)

View 3 Replies View Related

Queries :: DSUM - Calculating Monthly Tasks Given To Employee

Dec 6, 2013

I have a query, i need to get dsum of total task given to an employee.

I have grouped task_description and select count and it is now showing each employee as 1 which is correct.. i ma looking to get dsum based on this task count but with a criteria that i want to see these tasks sum month a have a month field which i get from assigned date the month field is showing like this december-2013.

Based on this i want to calculate dsum as first to see task count which i mentioned earlier, then employee id which is in query as ID and then month.. this sum will calculate monthly tasks given to each employee.

View 5 Replies View Related

Queries :: Combo Box Default - Locate Particular Record According To Predefined Value

Dec 10, 2013

I got a combo box with a few columns for locating query activity. However, how can I make use of it to locate a particular record according to predefined values, for instance in a loop, to locate records. The combo box got 3 columns, just want to know the syntax to define the combo box according to some values. I need to define only the first colmun or all 3 columns??

View 1 Replies View Related

Modules & VBA :: Way To Make A Text Box Populate A Predefined Number

Nov 3, 2014

Is there a way to make a text box populate a predefined number based off what time of day the form is opened?

View 2 Replies View Related

Modules & VBA :: Launch Access From Scheduled Tasks Without Interactive Login?

Sep 5, 2013

I have been searching the web for a solution to this problem. I have created a scheduled task on Windows 7 to automatically run a macro from a command line, however, it seems to only run when the user is logged onto the machine. Is there a way to run Access without the interactive logon? I would rather not leave the machine logged in with this account, but if that is the only solution, so be it.

View 7 Replies View Related

Modules & VBA :: Copy From A Location And Paste Files In A Predefined Directory

May 16, 2014

I would like to copy one (or multiple) file (-s) from a location (using applicatioin.FileDialog) and paste it in a predefined directory.

This is what I have written so far, but it doesn't work.

Code:
Dim strFil As String
Dim strURL As String
strURL = "xxxxxxxxxxxx" & Me.Internnr
strFil = Application.FileDialog(3)
strFil.allowmultiselect = True
strFil.show
FileCopy strFil, strURL

View 9 Replies View Related