Do not use on any
shared computer
August 30, 2008 02:19am pdt

250 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 
TechSoEasy

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top Microsoft ADP Solutions: 1 - 25 of 46
 
log.ldf file
How to open or access a log.ldf file
How to avoid the runtime error '1004' - To prevent possible loss of data, Microsoft Access cannot shift nonblank cells of the worksheet ?
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...
How to resolve runtime error '50290': Method 'Quit' of object '_Application' failed ?
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...
Access 2007 ADP Crashing
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.  ...
updateable recordset
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...
adp project performance very slow with sql server 2005
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...
Insert into help with autonumber.
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 ...
Microsoft Access 2007 ADP On Client Crashes Windows Server 2003
Our company purchased a new computer with Microsoft Office Pro 2007.  We've been running a Microsoft Access 2003 ADP for years with no problems.  Since Access 2007 has been accessing our Windo...
Using views in a TransferSpreadsheet export
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...
Insert new records based on listbox selection
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...
Insert/Delete Triggers not functioning properly
I have an Access ADP file linking up to SQL 2005. There is a trigger attached to each table that adds a record to a table for auditing purposes (see code attachment for trigger script). My ...
How would you prevent from displaying the Excel automatic message box question "Do want to save the changes you made to xx.XLS" when an Excel file is closed ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. I use the DoCmd.Transferspreadsheet command to transfer an Access table to Exc...
Attaching two report types to one email
I have a command button that sends a report as an attachment to an email. I would like it to send as RTF and HTML. How do I do both? Below is the code for sending in RFT that I use, can I make...
List Box recordset problem on Access 2000
I was a stored procedure, which I use to return a recordset, which is then dsiplayed in a list box. I wrote the code in the attached snippet. All works fine in Office 2003. However, on Office...
How to set up a message box to ask the user whether or not to save an Excel file that was transferred from an Access table ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. I use the following routines to transfer an Access table to Excel and display ...
Is there a way to rewrite a subroutine to ask the user if they want to save the Excel file and if they say no, to delete the file ?
I am using Access 2003 with Access and Excel as the front end and SQL Server as the back end database. I use the following subroutines to create and save an Excel file. Is there a way to...
How would you cause Excel to generate only 1 customized message box asking the user whether or not to save an Excel file ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database using an ADP file. I use the DoCmd.Transferspreadsheet command to transfer an A...
How to exit an attempted change to a radio button via a MsgBox and backout of the change if the user changes their mind ?
I am creating an Access 2003 application using Access as the front end and SQL Server as the back end database. How would you change the following routines to cancel a user action to change...
How to reformat a date so that a month such as January is stored in the format (MM) with a value of 01 ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. I have 2 text box input fields for the user to input into 1) a FROM DATE ...
How to go to a web site from an Access application when the event is the click of a button ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. How would I be able to go to the following website based on the click of a...
Start ADP without setting the connection to SQL
My goal is to use the same ADP on 2 different networks, with 2 different SQL Servers and 2 different database names, so the connections strings are different. I programatically change the c...
How to correct the syntax to delete a table with a dynamic name made up of a fixed table name + the current date ?
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. How would you rewrite the following statement to DROP a table if it already...
Where is equivalent Access 2003 - Tools/Options/Advanced tab in Access 2007?
I need to increase the default max records value in Access 2007, (as per http://www.experts-exchange.com/Microsoft/Development/MS_Access/ADP/Q_23314833.html ) but what is childs play in Access...
Is it possible in an Access application using Access 2003 to use Excel 2007 ?
This is probably a dumb question but I am using Access 2003 with Access as the front end and SQL Server as the back end database. Is it possible to use Access VBA with Excel 2007 to avoid the ...
How to print a date in an Excle file passed from a subroutine in Access ?
I am developing an Access 2003 application using Access and Excel as the front end and SQL Server as the back end database. I use the 2 subroutines in the Attached Code Snippet: Private ...