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 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 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 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 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 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 ...
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...
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 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...
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 (...
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 ...
Hi all - I recently converted an Access 2003 mdb database to an Access.adp(2003)/SQL 2005 client/server set up. I'm trying to add a new record to an underlying SQL 2005 table via a form in the...
I have a long-established MS Access project that's linked to a remote SQL server installation. A recent system crash on my main development PC forced me to do a system restoration and to reins...
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...
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...
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...
Hi ,
i am a little bit confused. I am setting up an Watchguard Firebox X550e Core. I am using the System Manager Ver. 10.2.2 and i didn´t get the access via firefox to the www. My internet ...
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 have a MS Access project that connects to an MSDE database on the same laptop. I also have the same MSDE located on a server. Merge replication is set up between the two and is currently c...
How to open or access a log.ldf file
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 have a database with many tables and views.
It will let me use this code to export a table.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "vapproveddeclined", strFileLoc...
I am developing an access adp database with sql server 2005 backend. This database will be accessed by multiple site connecting over the internet, which is why I am using ADP. I need to create...
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. ...
