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...
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 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 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...
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 am using Access 2003 to create an Access application using Access as the front end with VBA code and SQL
Server as the back end database.
If you were to add records to a new table titled...
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. ...
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 Data Project that has an ntext field. I want the end user to be able to enter a word and have the database search the contents of this field for that exact literal string. I...
I am developing an Access application in Access 2003 using Access as the front end and SQL Server as the back end database. I run a stored procedure that has a result set of approximately 43,0...
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database.
In the attached code snippet, I first display a routine that executes a sto...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
I am writing an Access application using Access as the front end and SQL Server as the back end database. I use the attached code snippet to perform an Open SELECT statement.
Do you know h...
I am developing an Access application using Access as the front end and SQL Server as the back end databse. I am using a combination of Access and Excel VBA.
In the attached code snippet, I...
Can we have multiple users accessing a Microsoft Access .adp file within Citrix using the same Citrix login credentials? We know we can have a single .adp file with different logins, giving re...
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...
