Search results

LadyDi Sorry I should have also added that you need to select an Access driver when you set up the Access database datasource. Select the Access Driver that has accdb in the list of extensions. Open Microsofts ODBC Data Source Administrator >> go to the System DSN tab >> Add >> select the...

Hi HGMonaro I think you're talking about a UNC path. Instead of using any Drive letter, the path is written in the below syntax; \\Shared1_svr\Shared1\WGroups\Network\Orders.xls. Use the path that you paste in when you map your shared network drive. Another way to get this string is to...

Hi LadyDi If you create an ODBC connection from Excel, you can connect to the Access database & bring all the results of an Access query into your Excel spreadsheet. Open Microsofts ODBC Data Source Administrator >> go to the System DSN tab >> Add >> select the Microsoft Excel Driver (*.xls...

Hi LadyDi You can create an ODBC connection to an Access database & use the tables from the database. Is that what you wanted to do? I'm using Office 2007, what are you using?

Hi Irish_Wertzy Sounds like this is built in MS Access?? & not Excel, is that right? If this is in Access, can't you set the Combo Box properties to 'Limit to List'? This will give the Users a easy to understand message that the value in not permitted. If you're using Excel & use a Data...

Hi LadyDi This article might help you, it applies to line graphs but the point is the chart can be made to ignore plotting '0' values. HTH. http://support.microsoft.com/kb/302672

Do Libraries need to be Referenced by Users?? Hi I'll change this post to a simple sentence that may be clearer than the original text below; New Post; If I'm a User of a file that (for example) is built in Excel but also references Outlook do I need to ensure I have the Outlook library...

Hi You would need to add a loop statement that copies each value from the first workbook & pastes to a cell in the other workbook. If the formatting needs to be fixed, you can record a macro & use that in the final code to set the formatting you want. Hth

Hi I have an Access database & an Excel Workbook. I want toi do most of the reports I need in Access but would prefer to use Excel for the charts. I don't want to link the Access tables to Excel or have a copy of the tables in the Workbook. I'd like to use a Formula as a Series for the...

Thanks NBVC That's perfect, Cheers

Thanks NBVC That's an interesting article. I think I have a different problem here. I tried recording a macro to see if it would work but no good. I don't get why telling the code to replace a question mark is deleting all fields values?? even the heading !! Changing the columns format...

Hi I'm importing a spreadsheet into Access & want to change some data before it is imported to suit the database. I have a field that is of the 'General' datatype, most values are doubles eg; '1.7' When add code to replace '?' with '0' or just "", it still won't convert correctly & deletes...

Thanks Again Brian I should point out that the 'Overflow' error occurs when I try your code on the real dataset rather than the dummy data file I uploaded onto the forum. The difference is the a/c nos have 13 digits & there are approx 36,000 records in the real file. So to overcome this, I...

Thanks again Brian Please don't get the impression that I'm second guessing your code, I am amazed that it runs so fast & will now apply this logic in similar cases. I just didn't think it would be faster so i didn't try that method. Chergh has also assisted me in the past so I don't doubt...

Thanks Brian Your code is very efficient! I'm surprised how fast that runs considering the code holds an A/c number variable & runs through the whole column of A/c numbers on the 'RAW_DATA' wksht each time to find a matching value. I thought the less steps or 'Loops' the code went through...

Hi Brian Apologies I still didn't attach a 2003 version for you once I'd fixed this. The file will explain things better. As I wanted to hold an a/c no from the 'PIVOT_SUMMARY' wksht >> go to the 'RAW_DATA' wksht >> find all the same a/c nos >> save the value that is in column 'f' for...

Hi In case anyone needs to do this as described above, I have the answer, in order to save the 'found' value for pasting later & avoid the error codes, the code is as follows - working example attached; Firstly - To activate the 'Found' cell; NOTE - 'acno' is the variable name...

HI I followed this link & you need to sign up & give CC details to get the answer... Any chance you can post the answer on the forum ?

Here's the same file in 2003, Cheers

Hi smig I'm not sure what you mean & the snapshot isn't helping me much. You probably know that you can have (or not have) Sub Totals for each value in the 'Row' area & you will get an overall 'Grand Total' at the bottom of the pivot. Is it the Sub Total you're talking about when you say...