SQL SERVER AND VBA ACCESS FUNCTION
||...millions of records (900 million rows)
Write SQL function and VBA function to do the following:
1. Sort Ascending...sample data attached.
When I run the function in SQL Server 2010, it should do the above steps. The function...indexing.
I also need the same function in VBA – MS Access
I need this job to be done within 1 – 3 hours
||SQL, Microsoft Access
||Aug 21, 2013
||Aug 21, 2013Ended
101475 Access 2000, SQL,,VBA
||...required to an existing Access 2000 database, you will need strong Access, VBA and SQL.
I estimate this...weeks of starting.
Please supply an example of Access work you have completed previously.
||Visual Basic, .NET, SQL, Microsoft Access, Anything Goes
||Nov 27, 2006
||Nov 27, 2006Ended
Logix With Access and VBA
Front end: Access 2010 (with vba)
The Project entails good knowledge of access 2010 vba and...and Sql database.
It is an application to combine products/customers with different prices spanning over
||Apr 14, 2014
||Apr 14, 2014Ended
VBA classes MS Access
||For some tables in a MS Access database we need classes to get data, to update data and to add data....
The used code should be compatible with SQL server for future upgrades.
||Jul 11, 2012
||Jul 11, 2012Ended
MS Access/VBA Developer
||...developed a small Student Management system in Access/VBA. There is an One issue with searching functionality...
You should have a strong knowledge in VBA and SQL, you will be able to debug this and fix it within
||PHP, Windows Desktop, Project Management, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, Microsoft, MySQL, Visual Basic for Apps
||Mar 23, 2008
||Mar 23, 2008Ended
Access VBA code
||I've got a vba code that looks like
qCount = GetQueryCount3B
Do Until qCount = 0
Dim rst As DAO.Recordset
Dim sql As String
sql = "SELECT COUNT(*) AS total FROM Boyd0315All...
Set rst = CurrentDb.OpenRecordset(sql)
If Not .EOF Then
||Visual Basic, Microsoft Access
||Feb 11, 2014
||Feb 11, 2014Ended
Macros/VBA and Access
Need an expert on Excel, VBA, Access and SQL. Small budgeted work but could potentially have steady
||Visual Basic, SQL, Microsoft Access
||Dec 11, 2009
||Dec 11, 2009Ended
MS Access / VBA or SQL or Web ASP Programmer
||...for some one that knows MS Access / VBA or SQL or Web ASP.
Wanted: MS Access programmer who can build...can program VBA. ASP Web programmer a plus, as is QuickBooks, MS SQL Server, ..NET , and VBA interface
||.NET, Excel, SQL
||Jun 8, 2009
||Jun 8, 2009Ended
VBA & SQL coder need for ACCESS DB
||Need someone profiecient in MS ACCESS 2003, VBA, & SQL.
Need someone who can code manually inputted...inputted text in the text boxes of my access DB and store this information in the tables. Also can code the...know what the codes are doing. specify if VB or SQL and where you place it.
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps
||Oct 7, 2006
||Oct 7, 2006Ended
||...accomplish. Essentially, it is a SQL Server backend database with an Access (.ADP). The program is working...module rebuilt. It involves taking vba code which dynamically builds SQL for searching, and converting it...it to using Stored Procedures in SQL Server. The word doc has all the images in it, but I am also sending
||PHP, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, MySQL
||Apr 5, 2006
||Apr 5, 2006Ended
VB.Net MS Access VBA and data conversion to SQL
||I need someone who specializes in VBA for Access 2000-2007 and who is very comfortable with VS 2008
...reverse-engineer an Access app consisting of several data Tables, a few Forms, Queries and a few modules of VBA code...Tables in a SQL Server 2005 database.
I will suppy details, screenshots etc of the current Access tool and
||Visual Basic, .NET
||Jan 20, 2011
||Jan 20, 2011Ended
Simple Data Access in VBA
Excel 97, VBA, Access, SQL Server, MySQL
||PHP, Windows Desktop, Linux, Engineering, Excel, SQL, Powerpoint, Software Architecture, Oracle, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||Aug 11, 2004
||Aug 11, 2004Ended
VBA Count(*) slow in access, SQL pass thru
||I've got the following code in my access VB code. It worked fine before I added the round() sectin of...ran it in SQL, it takes 7 seconds to run.
I've been waiting for over an hour through access though....0
Dim rst As DAO.Recordset
Dim sql As String
sql = "SELECT COUNT(*)AS total " _
||Mar 25, 2014
||Mar 25, 2014Ended
VBA in Excel and Access
||...experience in VBA (Visual Basic for Applications) and some desktop VB.NET
I have a number of SQL (2005 and...databases with Microsoft Access (2007 and 2010) front end. These use Microsoft Access and VBA as the user interface...need to develop a data collection form in Excel and VBA. The form will be e-mailed out and will be completed
||Visual Basic, .NET, Excel, Microsoft Access
||Sep 18, 2013
||Sep 18, 2013Ended
SQL SERVER AND VBA ACCESS FUNCTION - Rehire
||Hello, I love your work and I need a similar code in SQL SERVER 2010 and MS Access.nnPlease see requirements...equip_no.nnPlease I need this in SQL server Procedure and Access VBA. Similar to the last project you
||SQL, Microsoft Access,
||Aug 26, 2013
||Aug 26, 2013Ended
VB/VBA and SQL
||We have an application made in Access 2000 who uses odbc to retreive the content in some files from Visual...in excel via macroes before they are imported to access.
Our main goal;
We want a wellfunctioning application...does not have to be in Access. Some sort of SQL would be ok. We already have MS SQL so this would be a preffered
||PHP, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, Website Testing, MySQL, Visual Foxpro, Website Management, Web Hosting
||Dec 7, 2006
||Dec 7, 2006Ended
VBA to SQL Server 2005
||Need to have 2 (related) VBA modules converted to stored procedure or CLR in SQL Server 2005. Need to return...'mode' settings.
Need somebody who knows VBA (from Access 97) and convert code to needed format. Coder...with 9 or higher rating.
- Utilize Access 97 database working example to understand module
||PHP, ASP, .NET, Engineering, SQL, C# Programming, Software Architecture, Microsoft Access, Software Testing, MySQL
||Nov 23, 2007
||Nov 23, 2007Ended
Three webscrapers with VBA and SQL
||...operated from within Excel, and communicate with SQL to upload filtered results. Excel "clients" download...from the SQL.
The overall process looks like this:
1) Scrape from site through an Excel VBA button...operations)
3) Uploading results to SQL
4) Users can query the SQL to provide results relevant to them
||SQL, Visual Basic for Apps
||Jan 20, 2014
||Jan 20, 2014Ended
Private project or contest #493405
||Aug 22, 2009
||Aug 22, 2009Ended
MS Access to SQL Server Conversion
||Immediate need to help convert VBA code in MS Access to stored procedures in SQL Server.
||Mar 14, 2006
||Mar 14, 2006Ended