Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ms access - Helpdesk ticket system

Posted on 2017-05-03
5
Medium Priority
?
299 Views
Last Modified: 2017-05-19
I would like to create a ticket description field on MS Access, which grab a data from other fields and create a ticket description Automatically.
1. field - PC or Wyse
2. field - Location
3. field - trouble type
4. field - extension
5. field - urgency
0
Comment
Question by:Hiroyuki Tamura
  • 3
  • 2
5 Comments
 
LVL 40

Expert Comment

by:PatHartman
ID: 42119740
If you want someone to attempt to write code for you, you'll need to provide more details.  What have you tried yourself?
0
 

Assisted Solution

by:Hiroyuki Tamura
Hiroyuki Tamura earned 0 total points
ID: 42120606
sorry, i would like to create calculation field.
On filemaker, they can use calculation field to create a text string like
[Field Name A] & " " &[Field Name B]
do you know how to create those field on MS Access?
0
 
LVL 40

Assisted Solution

by:PatHartman
PatHartman earned 2000 total points
ID: 42121651
The easiest place to do this is in a query.

Select fld1, fld2, fld3, [Field Name A] & " " & [Field Name B] As fldAB
From yourtable;
0
 

Assisted Solution

by:Hiroyuki Tamura
Hiroyuki Tamura earned 0 total points
ID: 42122108
Thank you, Pathartman,

if i want to set new line between [Field Name B] and [Field Name C]
what symbol could I use?

[Field Name A] &" "&  [Field Name B]
[Field Name C]
0
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 42122252
You can use vbCR or maybe vbCRLF but I wouldn't do this in a query.  I would do it in the report.  In fact, if you lay out the report correctly, you shouldn't even be concatenating the additional lines.  Access is able to suppress printing an entire line if it contains no data so for the typical address label with four lines - name; addr1; addr2; city & state & zip, the third line is usually suppressed.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question