Save this Search

All JobsVBATime Left: Less than 7 days

 (4 results)  
Sort by:
  • Posted Date
Time Left: Less than 7 days
Fixed Price: $50 - $100   |  Posted: Nov 16, 2015  |  Ends: 6d, 8h  |   23 Proposals
Need help with VBA. I was given the following VBA code to update a sql table we are OBDC connected to in my Access database. Was told that I could just put it in a command button. But it doesn't work and the IT manager who sent it to me is not above sabotage. Need help getting this working properly. Set cnn = New adodb.Connection cnn.ConnectionString = "driver=SQL Server;server=metis\ccb;database=timekeepernew;Trusted_Connection=Yes" cnn.Open cnn.ConnectionString Set cmd = New adodb.Command cmd.ActiveConnection = cnn cmd.CommandType = adCmdStoredProc cmd.CommandText = "UpdateAuthorizations" 'Use this line to update existing table from Dynamo Data Set param = cmd.CreateParameter ("DataSetID", adInteger, adParamInput, 6, stDataSet) cmd.Parameters.Append param Set param = cmd.CreateParameter ("Destination", adChar, adParamInput, 2, stDestination) cmd.Parameters.Append param rs.CursorType = adOpenStatic rs.C...
Category: Database Development       

Sign in to view client's details.
| 3****ock
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Nov 11, 2015  |  Ends: 1d, 0h  |   28 Proposals
I have a specific set of data i need to pull from an email body. After that import it all to a csv format. Recipient address: Always the same Subject: Always the same Body: Pull data from third table column in the email body
Category: Other IT & Programming       

Sign in to view client's details.
| i****33e
|    United Kingdom
Fixed Price: Not Sure   |  Posted: Nov 10, 2015  |  Ends: 14h, 50m  |   5 Proposals
I am using an MS Access DB. I gave access to multiple people. I'm trying to secure the file and don't want any user copying the file and taking the file offsite. Was thinking of implementing a script in the event the DB file is opened in a location which is not typical (meaning stolen). Ideas on what do do from a stolen file include, but not limited to: 1 - deleting the file automatically when opened and then deleting the file from the recycle bin as well to permanently delete 2 - record the details of the computer the file was opened on (username, computer owner, IP location, etc) and then email the details to myself (i have email code) so i can see who took file. 3 - setting any referenced needed for this automatically within the code, as the user would obviously not be setting them. And changing the security level for ms access to low so the code can in fact run. 4 - and any other suggestions
Category: Networking & Security       

Sign in to view client's details.
| i****ace
|    United States
Fixed Price: $30 - $70   |  Posted: Nov 04, 2015  |  Ends: 5d, 1h  |   7 Proposals
This is a project for experts with experienced with software named WinAutomation. we have an EXCEL price list of many products with their product links, with information such as prices and shipping costs. This links are from different webpages including (USA). We need to have updated products from Amazon (price and shipping costs), so we need to create an application using WinAutomation (  [obscured]   ) that allows us to: 1) open the excel file 2) search a specific web page (given for us) the value of the exchange rate of the day and update the Excel worksheet 3) search in all the worksheets of the workbook for and only the Amazon links and update the price and shipping. 3) if the link does not exist or item appears unavailable or appears as "Available From These sellers" check "NO" option from the availibility field and skip to the next ... SPECIAL NOTE: 1)FREELANCER must to send us the flowchart and algorithm before starting to veri...
Category: Web Programming       

Sign in to view client's details.
| c****ell *
|    Colombia
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job