|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
|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
|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
|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
|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
|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 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
|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
|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
|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
|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
|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
||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