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...

I have an application written in Access 2003 that we are bringing over to Access 2010. I have several places in my application where I export a report (with the report format) to an excel sheet. However, this does not seem to be working in Access 2010. Does anyone have any ideas, tips...

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...

I played with the space inbetween the " and From and it didnt make a difference. I keep the space in anyway just because it reads easier. Uncle Gizmo - Access uses '#' for dates but SQL Server does not so it cant be that. I put a break point on the first 'aStr' line and the...

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...

Resolved the issue. I'm not exactly sure why this worked so if anyone has any ideas I'm open to hearing them out of curiosity. For each report I had to go into Page Setup and specify the new network printer for that report. Then I open the report in Design view. Then I go back into Page...

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...

Yes, the first date entered would actually be the first result in the query. So knowing that, I figured using TOP(1) would get it for me. But for some reason it is still grabbing multiple results.

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...