Indexing Notes By Date
Dec 30, 2004
I have an Access 2000 customer database with a hidden unbound text field that feeds customer history notes into a Main Notes section. The problem I have is the order of notes after they are given a default time stamp. At the moment the first note in the main field is the oldest but I would like to arrange the notes so that the newest note is placed at the top of the field. Can this happen?
Below is the code I use for the Notes section, where Text_14508 is the unbound hidden text box and Details is the Main Notes section.
Thanx in advance
Private Sub Text_14508_AfterUpdate()
Me.Details = Me.Details & vbCrLf & Now() & vbCrLf & Me.Text_14508 & vbCrLf
Me.Text_14508 = ""
End Sub
Private Sub Open_Notes_Click()
Text_14508.Visible = True
End Sub
View Replies
ADVERTISEMENT
Oct 30, 2014
How can I add unlimited notes window to Access Database? Since, I would like to see on each account of my clients every single note I have been taken through out the years.
View 1 Replies
View Related
May 20, 2014
I have a form containing two memo fields - Fld_Note and Fld_History.
What I was aiming for is that when someone enters info into Fld_Note, that either automatically when they leave the form - or when a button is pressed - the text from Fld-Note is copied to Fld_History and date stamped.
Any future notes are also date stamped and appended to the info in Fld_History (ideally most recent first) so that users have an audit trail in Fld_History of what notes have been added and when e.g.
20-05-2014 Contacted group treasurer regarding transfer of funds.
19-15-2014 Application for grant funding approved.
12-05-2014 Grant application received.
View 3 Replies
View Related
Sep 5, 2005
I was told by an access programmer that since the total number of records that's going to be in the db is around a few thousand tops it would be a good idea to index everything as that would speed things up. Is this true?
thanks,
scratch
View 1 Replies
View Related
Apr 4, 2007
Could anyone tell me about the pros and cons of Primary Key and Indexing?
View 3 Replies
View Related
Oct 10, 2006
G'day,
I have a products table which contains products from 4 vendors. The records have the following fields "Vendor", "Vendor Part Number"," Description", "Unit" and "Price"
I have indexed same by Vendor Part Number and Description.
The vendor's describe the same product using different descriptions.
VENDOR ....DESCRIPTION................................... .........PART NUMBER
Acme........TEKS METAL HEX+SEAL 10X16MM 100 (PKT)..123456-01
Banner.......METAL TEKS 10X16 MM..............................93a-1234
If I search by part number the search is extremely fast.
However a search on the DESCRIPTION field looking for individual words say 'Like TEKS*' and 'Like METAL*' are very slow. Obviously the indexing on the description field is probable based on sorting the 1st character of the Description field by A-Z then the second character etc.
I am wondering is there a smart way of indexing the Description field at the point of importing or creation of the Products Table where I could identify all the records with say 'TEKS' or 'METAL' or '10X16' etc. By doing this the search should be a lot faster.
Has anyone done this or do you have a pointer to an article that covers this. (I did try the search function without a suitable result)
Thanks in advance
View 3 Replies
View Related
Mar 21, 2008
In my table, I have a number field set to Index (dups OK). I have another field that I do not want to index but need "no dups." Any ideas?
View 4 Replies
View Related
Apr 1, 2008
Indexing fields can dramatically improve efficiency by speeding up sorts and searchs. My database tracks mail sent on various mail dates to multiple customers with insurance policies that are assigned unique policy numbers. I've indexed the policy number.
Question 1: Is there value in indexing a mail date field which has duplicate values even for a given customer that has received multiple mailings?
Question2 : Should one index every field in every database ? Are there scenarios where one would choose not to index a fied ? If so, can someone provide an example ?
Thanks in advance for your assistance.
View 4 Replies
View Related
Dec 14, 2005
Hi folks!
I'm a new user and need a hand. I'm running a query with two tables joined. I have 4 columns: Name, Day of Week, Date, Start Time. I want to create a 5th column that will number each record: 1,2,3,4,etc. I've tried researching help with indexes and primary keys etc. The main reason that I want to do this is to match up the uniques value with another query. The other query is identical with the exception of stop time versus start time. Bottom line is I want to automate a schedule for people but I'm trying to deal with shifts that go from one day into the next and I need a common denominator.
Any help would be appreciated.
View 1 Replies
View Related
Oct 23, 2006
Hello All
I have a field called MEMBERID
I wish to index the following so that all members in 2005 can be idexed A to Z and all members in 2006 can be indexed A to Z:
00125/05
At the moment, the last two digits that indicate the year of joining are ignored when sorted in a query, and they are all jumbled up. I have about two hundred antries for 2005, and 160 for 2006. What am I doing wrong?
Regards
Terence
London
View 5 Replies
View Related
Sep 20, 2007
I need an advice by indexing fields with low entropy.
I have some large tables with some columns that i use in selects, but they store only few vaues like (0 or 1) or ("R" or "N" or "F").
Somewhere i read, that fileds like these (with lov variety of values) do not need (or should not) to be indexed.
http://www.dbpd.com/vault/9801xtra.htm
Is this true also for access databases accessed via ODBC, or not?
Please give me an advice.
Marcel
View 3 Replies
View Related
Jan 2, 2014
I have a complex series of calculations to perform, and I have found the best way to achieve my end is to create new tables by the Make Table queries.
The trouble is I have many tables to create and the downstream tables refer to the previously created tables; I have recently discovered that queries perform much quicker if they are indexed (duplicates OK). I've looked at my tables created by the MakeTable queries, and they all seem not to be indexed.
How do I make them indexed automatically?
View 2 Replies
View Related
Mar 19, 2013
I would like to Create a database for indexing / organizing PDF documents. My Company currently use a 3rd party accounts program and we raise sales and purchases using numerical numbers ( but we can Jump to a new range of numbers within the program) for example if the purchase order numbers become simliar to the sales order numbers. But this 3rd party software does not let us scan documents into it hence the need for an alternative database.
For the data base I was thinking if only creating a index of the sales order numbers to start with. the first few question I have are.
1.) Should I Use the Autonumber as my first index column or should I replace it with our own sales order numbers in that column.
2.) is there a way to autopopulate the sales order numbers in a table for historical sales numbers.
3.) can you scan directly into Access
How to start planning the design off the database as I know this is almost the most important aspect of a database.
View 2 Replies
View Related
Nov 20, 2006
Hey everyone,
I am trying to create a notes log so I will have one field for new notes and another field with the entire notes history on that issue. How would I go about doing this since I am relatively new to Access? Thank you:)
View 3 Replies
View Related
Oct 25, 2007
Can anyone help me send an email with an attachment from within Access using Lotus Notes as the mail client?
Huge round of drinks to anyone who can crack this for me!!
bottoms up!
View 1 Replies
View Related
Jul 10, 2006
Hello,
What is the best way to handle notes on a form?
The DB is for recording Quotes and Orders taken over the phone.
Is it best to have a seperate table w/ a NotesType field so that all notes are stored in a central location? Or is it better to store notes for each quote/order in the Orders / Quotes table itself?
Also, if data is entered into these fields using subforms, is it possible to have the notes displayed outside of the subform in a box format, to allow plenty of typing room?
If anyone has a good example of a smart notes system implementaion, it would be very appreciated.
Thanks!
View 3 Replies
View Related
Apr 29, 2008
Hi, I have a a table that keeps notes about the status of an invoice. It can have 1 or a lot of notes per invoice. I need it to just display the last 4 notes for each invoice. I used TOP 4 but it only shows the top 4 notes and note the top 4 notes for each invoice. Can anyone help?
View 8 Replies
View Related
Nov 4, 2005
Noob needs guidance.
I've worked with Access before but I've never had to setup mass mailing using Lotus Notes retrieving the data from Access.
I'm basically working with Access 2003 with a database containing all the clients information with email and personalised messages and it needs to be sent out through Lotus Notes R5 Release 5.0.11
I've done searches on this site and I've found many codes but I was wondering if there was a beginner's guide to this.
If anyone has links to where I can read up on it that would be great too.
Your help is much appreciated. Thanks in advance for your help.
View 3 Replies
View Related
Jan 25, 2006
I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be contained. Therefore, if we call several times the dates and note information all go to the same field. Any suggestions on setting up some type of table that would allow multiple note fields? how would I link the table to the main information table?or another approach? Any suggestions would be helpful.......
View 1 Replies
View Related
Jan 25, 2006
I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be contained. Therefore, if we call several times the dates and note information all go to the same field. Any suggestions on setting up some type of table that would allow multiple note fields? how would I link the table to the main information table?or another approach? Any suggestions would be helpful.......
View 1 Replies
View Related
Jan 25, 2006
I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be contained. Therefore, if we call several times the dates and note information all go to the same field. Any suggestions on setting up some type of table that would allow multiple note fields? how would I link the table to the main information table?or another approach? Any suggestions would be helpful.......
View 4 Replies
View Related
Jun 14, 2007
Hi all,
I have a list box which has several columns. What i'm trying to do is have a button that when clicked takes the values of the selected list box item and put them into a new lotus notes email. It doesn't need the address or any other detail, just the info into a new mail. I have seen some post's here but not sure i understand them (bit of a noob to access/vba).
Is this possible to do and can someone please point me in the right direction?
Thanks,
Spinkung.
View 3 Replies
View Related
Feb 16, 2006
Hi there.
I was wondering if its possible to emulate the way lotus notes views work using a query.
Say i had three different tables for three different order types and each table has several common fields like datecompleted,amount and customername.
Is it possible to create a query that will display those three fields in three columns even though they are from three different tables?
If not a query is there any way to achieve this in access?
Any comments would be much appreciated chaps.
View 3 Replies
View Related
May 10, 2005
Hi
Anyone have any ideas on this please?
I need to create a facility using the standard MS Calendar control to enable users to log personal notes as reminders of 'must do' operations for the following days/weeks. I envisage this working as follows :
User selects date to enter note from date picker control
User enters note in subform
Reocrd is stored with 'created date' info.
The note will display each and every day thereafter until the 'Signoff' checkbox is filled. But those records with a 'created date' greater than the current date selected on the date picker control- will not display.
Thanks
Guido
View 6 Replies
View Related
Aug 24, 2005
Hi guys, here is my problem.
I am sending emails when the user press a button, but the problem is:
1 - How to check is LNotes is open
2- How to know if the user needs to enter the password.
With the following code an email is sent ONLY if notes is open AND the psw is not required.
Public Sub Sendmailf(Task As String)
Dim nSession As Object
Dim CurrentUser As String
Dim DataBaseName As String
Dim nDatabase As Object
Dim nMailDoc As Object
Dim nSendTo(60) As String 'array for 60 e-mail address
Dim EmbeddedObj As Object
Set nSession = CreateObject("Notes.NotesSession")
CurrentUser = nSession.username
DataBaseName = Left$(CurrentUser, 1) & Right$(CurrentUser, _
(Len(CurrentUser) - InStr(1, CurrentUser, " "))) & ".nsf"
Set nDatabase = nSession.GETDATABASE("", DataBaseName)
Call nDatabase.OPENMAIL
Set nMailDoc = nDatabase.CREATEDOCUMENT
With nMailDoc
nSendTo(0) = vemail
.Form = "Memo"
.Body = Chr(13) & Chr(13) & Chr(13) & Chr(13) & _
"Status: " & Me.status & Chr(13) & _
"Creation Date: " & Me.Open_dt & Chr(13) & _
"Effective Date: " & Me.effective_dt & Chr(13) & _
"Completion Date: " & Me.completion_dt & Chr(13) & _
"Requester: " & vreq & Chr(13) & _
"Actioned By: " & Me.Assignee & Chr(13) & _
"Description: " & Chr(13) & Me.description & Chr(13) & _
Chr(13) & Chr(13) & Chr(13) & Chr(13) & _
Chr(13) & Chr(13) & Chr(13) & Chr(13) & _
"Validation Signature: ................................." & vreq
.sendto = nSendTo
.Subject = "Task: " & Task_Num & " is Ready to be Validated"
.Importance = "0"
.SEND (False)
End With
Set nDatabase = Nothing
Set nMailDoc = Nothing
Set nSession = Nothing
Set EmbeddedObj = Nothing
End Sub
thx for your help
View 5 Replies
View Related
Jul 13, 2006
I have a main form that holds all the data entry info for records except "notes" (which is just general internal notes) and "Observations" (like "notes", but client friendly)
Instead of having the text boxes for these fields on the form, i created 2 buttons to open seperate forms for these records, simply to save room.
When the button is clicked, the openarg is the ID of the created record.
The notes and observation forms are supposed to open this record so you can enter notes in for this record.
Unfortunately, both forms are being bitches and creating new records. When i say "no additions" the forms don't show anything.
Private Sub Form_Open(Cancel As Integer)
Me.RecordSource = "SELECT Notes FROM Results WHERE Results.[ID]=" & Me.OpenArgs
End Sub
that's what i got and it wont work!
View 3 Replies
View Related
