Show Bid Request
Project Help
Bid Request Id: 6906
|
|
|
|
Posted by: |
DS-R (13 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 9.09%
|
|
Posted: |
Dec 27, 2001
2:39:15 PM EDT
|
|
Bidding Closes: |
Mar 27, 2002
2:39:15 PM EDT
|
|
Viewed (by coders): |
403 times
|
|
|
|
|
Description:
I am looking to find a VB programmer to work with me on various projects. I would like to build more of a long-term relationship. I have some immediate questions today, small projects($30 - $100) and the potential to outsource some larger projects($100 - $1000) depending on my needs. If some of the questions are not easy to answer and require research, then let me know. I'll set the price on a project by project basis.
(1) Question: I am trying to open a second Access database at the same time as the first. I seem to be OK on the SQL updates, deletes and inserts to both databases, but it seems to be reading(Select) only the first one of them?? Related to the data1 control?
Data2.DatabaseName = App.Path + "\Main-Remote-1.mdb"
Set Cdatabase2 = OpenDatabase(App.Path + "\Main-Remote-1.mdb")
Data1.DatabaseName = App.Path + "\Main-1.mdb"
Set Cdatabase = OpenDatabase(App.Path + "\Main-1.mdb")
?? Data1.RecordSource = Lsqlstring
?? Data1.Refresh
If Ldatabase = 1 Then Cdatabase.Execute Lsqlstring
If Ldatabase = 2 Then Cdatabase2.Execute Lsqlstring
(2) Project: Simple sample program to read/update a remote Access database on a server(ODBC?)
(3) Question/Project: Locking on the remote Access database? Multiple remote users... how are the tables locked for updates?
(4) Question: In creating a text box, is there a way to make the text wrap around to the next vertical line in the box? When I use a text box, it just stays on the one line horizontally, going past the edge of box... showing part of the line visibly.
(5) Project: Code/error handling example to check if an E-mail address is valid (Ping), and also code to check if a URL address is valid (Ping).
(6) Project: A reliable spider routine that reads a full website and extracts the E-mail address.(I have sample VBscript program provided as starting point)
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
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 27, 2001
3:43:55 PM EDT
|
10
(Excellent)
|
|
|
1. Generally, when working with two databases, you should use either two db controls, or 2 connection objects.. I generally use an actual ado connection object for each db connection, and hand-code any transactional data, to keep it light.. this is especially better with access db's that are shared among different users.
2. if you have access to the server through fso, then you can use access.. otherwise, you will need a proxy program for the actual data exchange, this can be done through a soap object, a custom tcp/ip object.. or even via web through asp with rds.
depends on the locking used in the connection/recorset object, and when you open the database.. note: access is not the best choice for a multi-user db.. there are free alternatives like mysql, which perform much better..
4. change the multiline property to true, and scrollbars property to 2, vertical.
5. checking for valid syntax is easy.. after that, what is needed is to ns lookup an mx record for the given domain, then connect to the smtp server, and attempt to start a message, if no error is returned the address is valid.. a url, just need to create a connection using ms's xml-http object, and check for the response code.
6. not too difficult.. can be done easiest with a browser control.. load a given page, go through the dom, for any links.. load those pages to x pages deep.. and match against an email pattern to extract emails.
I am capable of doing all of the above, and would be more than interested in a long term relationship for given projects.
If you have the need for code for any of the above, setup a separate bid request for the given item, and would be happy to bid on indevidual requests. |
|
|
|
|
|
|
