Hi
In order to work on VBA access application, I open the mdb file by holding the shift key and double clicking the mdb file.
I find this process not very accurate. Half the time ...
I am developing an Access application with Excel VBA using Access 2003 as the front end and SQL Server as the back end database.
I use the following Attached Code Snippet containing 2 funct...
I have an Access project linked to SQL server data.
In my VBA code I want to get the result of a query into a variable. The stored proc returns one value, with a field name of "count". In...
I am developing an Access application with Accesss as the front end and SQL Server as the
backend database.
I have an existing table named tblMutualFunds comprised of the following fields...
I have about 50 separate fixed width text files that I need to pull into SQL Server 2000, so I want to automate the process. They are BIG files, with 731 fields and a sum of 250 gigs.
I ...
I am currently using an Access 2002 data project to connect to a sql 2000 database. I am interested in converting this to a windows forms vb.net project using a sql 2005 database since Microso...
How write a VBA and stored procedure code that handle optional parameter.
Access Version: 2002
SQL Version : SQL 2000 Server
I have an ADP Access database and a form that has a combo box ...
Much has been written about this subject but I am struggling to find a workable solution for ADP/ADE files.
The perfrect solution would be this one:
http://www.utteraccess.com/forums/sho...
Requirement: Display the sum of a calculated column in the footer of continuous form and keep the column and the sum updated when rows are updated. The recordsource can be a stored procedure (...
A few days ago I asked the following question and received this reply from a former programmer of the system I've taken over "Unless you plan to replace all the code with the Insert into pro...
Any idea how i would populate the contents of a ListView control with the results of an Sql String?
example:
Function PopulateListView(Sql As String, LV As Object)
Usage:
PopulateListV...
How to open or access a log.ldf file
I have a cmd button on a form that I want to call a Stored Procedure. I need to pass a value from a field on the form - "month" which would have values such as January 2008, February 2008, et...
I had posted this question before, but just found out the solution didn't work. Here's another attempt...
I am using Access 2007 adp to SQL 2005. During the conversion, we've discovered t...
I have a well established Clent based recoding system using Access 2003 adp fronthend with SQL Server 2000 database.
All is working absolutely fine. Some users us terminal services, and some ...
Here I sit with what I thought would be a fairly straightforward upgrade from an Access2003 MDB to an Access2007 ADP using SSMA. After MONTHS of work, I've actually got the ADP working almost ...
I am developing an Access 2003 application using Access and Excel VBA as the front end and SQL Server as the back end database.
I have a subroutine which is called to provide sub totals in...
I am in the process of upsizing from Access to SQL Server 2005 with Access frontend. In the application I have several forms that use comboboxes to pass parameters to my report queries. Now th...
I am developing an Access 2003 application using Access and Excel as the front end and SQL Server as the back end database.
I am trying to give the user the option to either SAVE or DISCARD...
I have an Access Database Project already connected to a SQL SERVER 2000 database, but would like to establisth a link to a table in an MDB database. On the other database I don't have the ti...
Have Bound Object Frame in MS Access 2003. Insert PDF file into the frame. I can open the PDF file just fine, but on close I get the perpetual hourglass and Adobe crashes. Have unistalled a...
Hi, I have an Access ADP project that needs to call a stored procedure that drops a table.
Unsurprisingly to some (but not me hence the question!) the stored procedure will not run because ...
I am designing a MS Access database (2003) to handle the registration of new employees in a company. I want to set up a web page (on the company's intranet) that allows managers (concurrent us...
Hi,
I have a new SQL Server 2005 Install and can't connect my MS Access 2003 ADP file to it any more. I've done this in the past without issue, but now it's not working.
There are a cou...
I am creating an Access Project (Access 2003) connected to a SQL Server 2005 database. I need to present the results of a query (Stored procedure? -- ADO? -- View?) to the user on a form and ...
