Show Bid Request
Project Setup Tool
Bid Request Id: 38875
|
|
|
|
Posted by: |
Russ Green (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Dec 7, 2002
9:12:18 PM EDT
|
|
Bidding Closes: |
Dec 21, 2002
9:31:20 PM EDT
|
|
Viewed (by coders): |
134 times
|
|
Deadline: |
1/31/2003
TIME EXPIRED
|
|
|
|
|
Description:
I'm having a real hard time trying to get this funtion to work correctly
Public Function PopulateListContol(ByVal ListControl As Object, ByVal ValMem As String, _
ByVal DisMem As String, ByVal Database As String, ByVal DataTable As String, ByRef ds As DataSet)
Try
'connection stuff
Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM " & DataTable, _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Database)
da.Fill(ds)
ListControl.DataSource = ds.Tables(0)
ListControl.DisplayMember = DisMem
ListControl.ValueMember = ValMem
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function
So far so good, everything seems to work. All the combos populate with the CompanyName field from the correct tables. When I try to write to another table, the ValueMember isn't writing out correctly. The wrong number is being inserted everytime.
I have an access database that consists of 10 tables (Projects, ClientPvt, ClientCorp, Architect, Contractor, LandArch, ProjMan, QuantSurv, ServEng, StrucEng) All are address books except the Projects table which stores information related to jobs.
“Setup new project” form has various text boxes and a range of combos. Some of the combos are populated with the tables in the database. The only two fields required from each of the address-book tables are the "CompanyName" and "ID" fields. I want to display the CompanyName in each Combo but to to save the value in the ID field to the Projects table. Easy right?
In the case of the Architect table I have a combo called cboArchitect. cboArchitect is being populated with ArchitectID and CompanyName fields from the Architect table. CompanyName is being displayed in the combo and ArchitectID is being assigned as ValueMember (I hope). ArchitectID is the primary key in the table. When the new project form is complete and saved the ValueMember (ArchitectID) is written to the Projects table into a field called ArchitectID (a number field - Long Integer).
Please help,
Deliverables:
1) Resolve the issue described above and supply a complete and fully-functional working program in executable form as well as complete source code of all work done.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows 9x and 2K
Language. VB.NET
Must be 100% finished and received by buyer on:
Jan 31, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
|
|
N/A
|
Dec 7, 2002
9:48:22 PM EDT
|
10
(Excellent)
|
|
|
Being that this is not really a project bid, you may get better results in posting your question to a programming forum. I recommend www.tek-tips.com.
Regards,
Neil Konitzer
Freisoft
www.freisoft.com |
|
|
|
|
This bid was accepted by the buyer!
|
$40 (USD)
|
Dec 8, 2002
8:36:57 AM EDT
|
10
(Excellent)
|
|
|
At a quick glance, the code looks OK to me. Have you tried running the program in debug mode and ensure that you're passing in the right value of 'ValMem'?
The problem may also be due to a listbox property.
If you're still in a bind, then accept my bid and I'll get you through this.
Regards,
Neil Konitzer
Freisoft
www.freisoft.com |
|
|
|
|
|
|