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...
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 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 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...
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 (...
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...
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 have the attatched code.
When i run the code it creates a new record in tblcustomerdetails, there is also a column in tblcustomerdetails called AUTO that is an auto number. so i dont ...
How to open or access a log.ldf file
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 ...
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...
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...
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 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 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...
We recently upgraded to sql server 2005 WG edition and have an adp project connecting to it. Before this upgrade we used sql server 2000 and everything worked very well. However with the upg...
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...
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...
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...
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 have an access 2003 adp that links to an sql server 2000 database. i use some stored proecedure to populate a table with all the customers we had for a specific month. this table named bi...
I have an Access 2003 adp. Im trying to load another Access project from within where I build up the file name from a number of fields and parameters.
THe spaces in the path name is causing a...
Im hoping someone may be able to give me some advice on Access 2007 as I have come across a bit of a dilemma.
We currently have an Access 2003 ADP which links to a SQL Server 7 database. ...
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...
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...
