Emulating Notes View

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 Replies


ADVERTISEMENT

Modules & VBA :: Loop Skips In Lotus Notes View

Aug 28, 2014

I am looping through a Lotus Notes view through mails which comes with standardized content from our homepage.Some of them have one or more attachments, some mails do not have attachments. I loop through the view, read the content, write the content in a table, extract all the attachments (if there are some) and remove the mail from view this into another view.

The loops runs through without error, but is skips the mails without attachments, so that after the "first loop" all mails without attachments remain in the view, whereas all with attachments have been processed accordingly.With another start of the function all the mails WITHOUT attachments are processed accordingly as well.This is not logic for me, as all code I found on the web looks like this:

Do While Not LNDoc Is Nothing
Set NxtDoc = LNView.GetNextDocument(LNDoc)
'check if Attachments are in the mail !!!!!!
If LNDoc.HasEmbedded Then <----

[code]...

View 6 Replies View Related

Notes Log Help!

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

Forms :: Text Boxes Showing In Design View But Not Display In Form View

Apr 19, 2014

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.

View 1 Replies View Related

Forms :: Unable To View Object Properties In Form Design View (Access 2010)

May 16, 2014

Why the ability to view the properties of an object within a form is not available when you double click on it in design view?

I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.

I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.

Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?

View 3 Replies View Related

Lotus Notes - Help!!!

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

Best Way To Handle Notes...

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

4 More Recent Notes

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

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Jul 13, 2006

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View 2 Replies View Related

Access With Lotus Notes

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

Notes Field In A Database

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

Notes Field In A Database

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

Notes Field In A Database

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

Access To Lotus Notes

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

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 4 Replies View Related

Notes Calendar Problem....

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

Lotus Notes Emails

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

Notes/Observations Forms

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

Field In Design View Not Showing In Table View

Jul 2, 2007

I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View 7 Replies View Related

Forms :: No Filters - Cannot View All Records In Form View

Aug 27, 2013

I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?

I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.

Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!

View 1 Replies View Related

Forms :: From Pivot View To Filtered Datasheet View

Nov 14, 2013

I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.

View 1 Replies View Related

Link Table From Lotus Notes

Oct 25, 2005

hi,

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:

View 2 Replies View Related

Frustrating Problem With Notes Field..

Nov 13, 2006

I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo.

I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a 3rd select query which merges those two back together (This is the only way I have been able to get this to work in the past).

Now, whenever I run the query, the notes field is trashed... All that is displayed is a few strange Chinese characters and that's it.

Someone please help with this, as it is a very big problem. Thanks!

View 2 Replies View Related

Email With Lotus Notes Instead Of Outlook

Jul 22, 2005

Does anybody know how I can change the default mail client from Outlook to Lotus notes? I'd like to use the sendObject utility to create a macro which sends data I enter into my form.

Thank you to all ahead of time :rolleyes:

View 2 Replies View Related

Send Object Via Lotus Notes

Nov 14, 2005

Hi ,
In MS Access,

I used sendobject to send the object via Lotus Notes, but I want to skip to click the Send button from the Lotus Notes, everytime, when I sent, it goes to the Lotus Notes, then I need to click the send button again on the Lotus Notes for confirmation to send the mail. How can I skip it?

sendobject ........................, False

I used False or True, it still cannot be solved.

Please let me know, thanks.
Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved