Find Jobs
Hire Freelancers

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.
Project ID: 3591603

About the project

6 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$170 USD in 14 days
5.0 (37 reviews)
4.2
4.2
6 freelancers are bidding on average $275 USD for this job
User Avatar
See private message.
$300 USD in 14 days
4.6 (143 reviews)
6.2
6.2
User Avatar
See private message.
$500.65 USD in 14 days
4.3 (80 reviews)
5.9
5.9
User Avatar
See private message.
$200.60 USD in 14 days
5.0 (15 reviews)
4.9
4.9
User Avatar
See private message.
$350.20 USD in 14 days
5.0 (1 review)
1.8
1.8
User Avatar
See private message.
$130.99 USD in 14 days
5.0 (3 reviews)
1.7
1.7

About the client

Flag of UNITED STATES
Lumberton, United States
5.0
335
Payment method verified
Member since Apr 24, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.