Create a VB6 and similar VB.NET function for displaying messages
$100-500 USD
Completed
Posted over 12 years ago
$100-500 USD
Paid on delivery
Need a function in VB.net and a similar function in VB6 that will display a form with a message in it that is read from a table containing descriptions of new changes made to the underlying form it appears within. In addition an input form is needed to add the message text into the ChangeMessage table. This is a form that will allow the user to add the following pieces of data : MessageText, Program, and Formname. The Message_id and Date should be auto-generated. We also need an additional form that can be used to view all the records of who has read the messages for each change. The form should use a grid that displays the info from ViewedMessage table and the grid should be sortable by any column (do not need the Rec_id displaying). A smaller table should display above the grid listing a snippet of the messagetext from the "ChangeMessages" table so a user can click on a particular message and have the grid below display only those records associated with that message_ID (the link between the two tables is the message_id).
## Deliverables
Need a function in VB.net and a similar function in VB6 that will display a form with a message in it that is read from a table containing descriptions of new changes made to the underlying form it appears within. In addition an input form is needed to add the message text into the ChangeMessage table. This is a form that will allow the user to add the following pieces of data : MessageText, Program, and Formname. The Message_id and Date should be auto-generated. We also need an additional form that can be used to view all the records of who has read the messages for each change. The form should use a grid that displays the info from ViewedMessage table and the grid should be sortable by any column (do not need the Rec_id displaying). A smaller table should display above the grid listing a snippet of the messagetext from the "ChangeMessages" table so a user can click on a particular message and have the grid below display only those records associated with that message_ID (the link between the two tables is the message_id).
The message would only appear as a user goes into a form for the first time after a change in its functionality has been made. We want this function to fire and display the text regarding the change to the underlying form. Once it has displayed it will then save the date and time and username of the person visiting the form when the functioned fired and displayed the message box. The information needed is described below:
The tables associated with this project would be as follows:
Table = ChangeMessages:
Message_ID Same as a Rec_id
Messagetext text
Program text
FormName text
DateCreated date (timestamp)
Table = ViewedMessage
Rec_id
Message_ID
Program
FormName
DateViewed
Ext
Username
The function should fire on the open form routine. The function will be passed the program and formname it is appearing within along with the ext value and username. The function should than check to see if this user has seen all the messages associated with the form that just opened. This would be done by checking for the latest changes in the ChangeMessage table and cross checking against the records in ViewedMessages. If it detects that it has a message or messages that has not been viewed by the user, it will display all of the unviewed messages in a scrolling message box and request that the viewer initial that they have viewed the message/s. The user will acknowledge and close the message form by pressing a command button that should appear only after at least two letters have appeared in the initital's textbox. The command button will display the following text : [Yes, I have read the messages on the (formname) updates.] (The formname should be inserted into the command button caption.)
When the user presses that command button a record should be created in the ViewedMessage table recording each message viewed. (Multiple messages might be viewed at one time so you would have to create a record for each message for that user.) The next time the form is opened no message box should appear if no additional associated message are created for that particular program/form.
In creating the 2 forms to manage the data use VB.NET and show us the mock up of the forms before you create a lot of logic and code behind it. We want to save you time and money by making sure you are making what we really need created.