I have made a table for prospective clients and want to add a notes section where I can add notes when I call them or they call me with the date. I have a comment section but thats not quite what I want. I would like them to be separated by date.
View RepliesI am creating a table in access 2010 for my consumable and bench stock report. I made a 12 fields which I name it the month of the year and another 1 field to add the total disburse materials in one whole year. I did this formula to add the 12 fields
[Jan]+[Feb]+[Mar]+[Apr]+[May]+[Jun]+[Jul]+[Aug]+[Sept]+[Oct]+[Nov]+[Dec].
But the problem is its just adding the complete consecutive months that I disburse and the row with blank section the total disburse doesn't show on the total disburse for the whole year. I try to use the code =Nz([Total Disburse],0) but it shows on the screen i cannot be used in calculated column.
My database is almost complete. I am just having trouble with adding a a Required Field to the General Section (down below) in my tables. Two of my tables already have the Required Field there with the drop down Yes/No. My other 2 tables to not have one at all? How to sort/group things in Reports?
View 4 Replies View RelatedI'm having an issue with pound signs in my table for specific items. I've create a DB that when you click a command button it opens a form and in the form it has a notes field. In the notes field once where i had data is now pound signs.
The DB is setup so when you click another command button to close out, it saves the record. It works 98% of the time but the i'm concern about the other 2% of the time.
I have a main table that is imported weekly from another Access DB which I have no control of. I also have a new table with a notes field and a product ID field. The issue is the product ID field in the main table is constantly growing. When I created a query with all of the fields from the main table and the notes field from the notes table I could not enter any data into the notes field unless the product ID was already listed in the notes table. Is there a way to make a query update the notes table or a macro to add the missing product IDs from the main table to the notes table?
View 3 Replies View Relatedhi,
i'm using access 2000 to create an application. i need to get the information of Staff, but the Staff informationis in Lotus Notes 6.
my problem is how to link table from Lotus notes document?
an for your information exporting from Lotus Notes then access 2000 link table to that exported file is not an option.
anyone help?
regards,
askaccess :confused:
I have a split form (frmPatient Schedules) that shows me my records in the datasheet view at the bottom section of the form. My records have a field with a checkbox (ckbxHOLD).how can I get the records that don't have their checkbox checked to be copied as new records to a different table (tblHome Visits)?
View 9 Replies View RelatedHey 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:)
I don't know how can i use the Administer Section in Ribbon bar
in access 2007 .
http://img413.imageshack.us/img413/2513/hhyt2.png
I know it's appear only with this file extension .mdb not with .accdb
and I don't know why also that's happen .
anyway , I will be thanks for anyone help me in this problem :(
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!
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!
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 RelatedI currently use
Me!frmPatientLookupResults.Form.Visible = False
to hide a subform on my form that is in the detail section of my form.
Is there a way to collapse or Hide the Detail section of the main Form??
I notice that their is a property under the Detail section called Visible
with an option for Yes or No.. How would I manipulate that option through
VBA? I am assuming that is the option that I am looking for
My report has the Section's Footer.
Each time the section runs, it will take up a different amount of space.
I have already run all the code, to move all the different controls to the top (and be invisible) when they are not needed.
So to the best of my knowledge, I have no controls sitting in the lower part of the section.
The last thing I run is:
Code: Me.S123.Height = Me.S123.Height - 300
s123 is the name of the Footer SEctions. The idea is that it gets progressively smaller.
This is all running in:
Code:Private Sub S123_Format(Cancel As Integer, FormatCount As Integer)
All the other things work.
Here is a sample of it all..
Code:If Me.txt2 = 0 Then Me.a2.Visible = False Me.b2.Visible = False Me.a2.Top = 0 Me.b2.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End IfIf Me.txt2 <> 0 Then Me.a2.Visible = True Me.b2.Visible = TrueEnd IfIf Me.txt3 = 0 Then Me.a3.Visible = False Me.b3.Visible = False Me.a3.Top = 0 Me.b3.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End If
This runs through 8 different numbers.
as I said, all the other things operate properly. They get hidden and move.
Any thoughts?
Thanks.
I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.
What I have are 3 levels of auditors
Level 1 are the basic auditors which I will need 1 per shift per day
Level 2 Are operationl Auditors I will need 2 of the per week
Level 3 are management auditors and I need one of those per week.
When I get these compiled per week I will need to make a report to e-mail out.
I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.
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.
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 RelatedI 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 RelatedI 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 RelatedHi 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.
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
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.
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
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
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!
We have several users that access the same database. Is there a way to make it so that the users can add comments to the "coments" field on the form, but not remove any comments once saved?
View 1 Replies View Related