Search results

Good Morning community, I have a couple of questions about using Excel 2010 with Access 2010. I have an application that I have written in access with a sql server 2008 back end. My first question has to do with exporting an access table into excel. I can do this with...

Good Morning community, I have an access 2003 application that I am trying to convert to access 2010. The one issue that I am running into is exporting a report that I have to an excel sheet. Here is the code that I currently have in A2003 (NOTE - outReportData is a string containing the...

Anyone know of an easy way to search through my forms and determine everywhere a certain table is being used without looking at the properties for each individual form? I have an application built using MSAccess 2003 with a SQL Server back end. I am looking at making changes to a certain table...

Good Afternoon Community - I could really use another pair of eyes looking at my sql statement. I have an Access application with a SQL Server backend. In the following code I am trying to update a table called Results with a value in a text box on the form and certain fields equaling...

Good Afternoon Community - My organization uses an application written using Access 2003. Part of what this application does is print and preview reports. We recently added a new printer to our network for these users. Now when the users have this printer set up as their default printer...

I have been racking my brain and surfing all over the net for an issue I am having. I have a button control in a worksheet. When it is pressed it saves the current workbook, closes it, and then opens an new version of the workbook. However it is not opening the file. It opens excel but...

First - looks like I have found my new home. This site is exactly what I was looking for. Have all ready found some great tips here so thanks! OK, now on to my question... I have a subreport that I am using to grab the date that an order set was entered into the system. The issue is that...