Creating a Q&A Database
I work in a call centre in England and am trying to create a Q&A Database. I have tried looking online but can't seem to find what I am looking for.
The idea is - I want the agents in the call centre to be able to type key words or phrases in and answers will be presented. Simple concept really but can't seem to manage it.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
All I want is for access to recognize the name of the person who is currently using the database. The reason is that I have a memo section that is used for storing notes made by the user. Each entry is stamped with VBA code as follows:
Me.Memo = Me.Memo.Value & vbCrLf & CurrentUser() & ": " & Me.Text145.Value & " - at " & Now() & " : "
Thus, I just want the memo section to properly identify the person - or currentuser() - leaving notes.
I have created a basic login screen using [LINK]. If only I could somehow tell VBA to recognize the name of the person who has logged on.
I have most of the database constructed without too many issues but have came across one thing that I can't seem to find or get established.
In theory, Each RFI requires an Issue but an Issue may have more than one RFI and Each CO also requires an Issue. Issues may not always have an RFI or CO.
I would like to have a way of ensuring that each new RFI &/or CO is assigned to an Issue.
.Body = "1)" & Chr(13) & Chr(13) _
& s1 & Chr(13) _
& "2)" & Chr(13) & Chr(13) _
& s2 & Chr(13) & Chr(13) _
& "3)" & Chr(13) & Chr(13) _
& s3 & Chr(13) & Chr(13) _
& "4)" & Chr(13) & Chr(13) _
& s4 & Chr(13) _
& "5)" & Chr(13) & Chr(13) _
& s5 & Chr(13) & Chr(13) _
& "6)" & Chr(13) & Chr(13) _
It works perfectly but I would rather the results be shown in tables, like when you copy and paste selected cells from a select query into an email.
1. Creating a database from a template
2. Migrating a database from a previous version of Access
3. Importing information from other sources
4. Controlling the features available to database users
5. Assigning a password to a database
6. Securing a database for distribution
Creating the structure for a database is easy. But an empty database is no more useful than an empty document or worksheet. It is only when you fill, or populate, a database with data in tables that it starts to serve a purpose. As you add queries, forms, and reports, it becomes easier to use. If you customize it with a switchboard or custom categories and groups, it moves into the realm of being a database application. This article discusses six key things you should consider when creating a database application by using Microsoft Office Access 2007.
all works just fine.
I then returned to the main database I copied this table from & deleted the table. Next I linked to the table in the new database (Access 2003 & in the same folder on my HD). The link works just fune as I can see the data when I open the table.
My queries would range from searching for 1 transaction to creating monthly tables. Should I create monthly databases or tables and create relationships with them. If so, would a primary key be necessary?
Would you recommend a 3rd table which ties the responses from the tblQuestions & tblAnswers together? Forsome reason I'm stumped by this and I'm sure it's a very easy solution.
Submitted via EggHeadCafe - Software Developer Portal of Choice Design Patterns for .NET
My query creates a calculated field: Student Number where:
Student Number: "BR" & [Joining School ID] & "-" & Right([Joining Year],2) & "-" & [Student ID]
This gives something like: BR101-11-1. However, what I would like is BR101-11-00001 with the full value o the Student ID field. Is there a function I can use to get the full value with all the 0000s?