Search results

Great! Let me know if you need any more help.

Hi Grifter If Jim only has a 'Ford' & you make a selection from the 'Page' area, filter, you should only see data for Jim. Are your filters in the 'Page' or the 'Row' area? Can you post an example?

Hi Emma I have some example code I got from the Internet to send an e-mail below for you to test. If you could advise how familiar you are with VBA, it would help me to help you. The next step would be to remove the commands to Print the document & replace them to send an email instead...

Hi Laxster I'm looking at your attachment but you'll need to clarify. I can the "item family 711046" but can't see any "totals for 31,33,34,35"? When you say '271', do you mean ' 271794'? Can you supply Headings for the columns clear & refer to them. I may then get an idea of what...

Hi Marvel Can you advise what you mean by 'slicer'? Do you mean the 'Page' or 'Report' area value in the Pivot?

???? Do you have an issue with this answer ?? If so, let me know why, I don't propose to know everything so it may help. If not, save your effort for something constructive ...

Hi mbaue002, The below link deals with this situation using VBA, it's the only solution I'm aware of. http://www.mrexcel.com/forum/showthread.php?t=488988

Hi Bloodrayne, As you have 3 dimensions of data, Month, Level & Part, I suggest a Pivot Chart to do what you need. This involves some slightly different formatting of your data, creating a Pivot table from that table, & Inserting a Pivot chart onto the Worksheet to get your line graph...

Hi Chaper, Try changing your Query type from a 'Select' Query to a 'Make Table' Query instead. Connect to the 'Make Table' table that is created from the query to Excel & try again. HTH

Ho Donbettis, The matching of the 2 parameters is not too difficult however, the difference in the address name will cause problems. I can't think of a way to guarantee that the addresses will also be correct when the Ship_ID is copied over. If there's any sort of other field to use OR if...

Hi Chaper You'll need to write the VBA in Excel as the Objects are different in Access compared to Excel. What do you mean by "Connecting to this query in Excel"? You can access the results of the query to do something like export to Excel, can you explain what you're trying to do? Thanks

Hi JinsRox, There's no Userform there as yet in the file you've posted. Is this part of the question? - you want to create a userform that selects data & highlights it on the spreadsheet? I've got 9 Columns & approx 140 rows of data, can you advise what you want to do starting at the...

Hi RONMYKELLANG I'm not sure what you're after, are you trying to see whether the records being transferred from Excel to Access are being appended to an Access table OR are overwritng any already exisiting data that would cause a duplicate? If so, a copy of the db might help to look at...

Hi GPSPOW, Try going to the design view of the Userform >> click on the Combo Box object & go to the 'Locked' property of the Combo Box & change it to 'True'. I haven't tested this with any values but it won't let me add any new value into the Combo Box with this Property set. I'm using...

Hi Joe8915, Have a read of this VBA info from Ron De Bruin. http://www.rondebruin.nl/saveas.htm It may explain some of the issues, Cheers :)

Hi Dick7Access, There's more than one way; Easiest click on the corner of the spreadsheet between Column 'A' & Row '1' & it will select the whole spreadsheet, then hit the Delete key. OR Use VBA as per the below for the whole sheet & then for one Column (depending on what you need)...

No Problem, happy to help :)

Hi Dick7Access, Thanks for posting the DB, I may have what you need. Checking out your DB & Trevors tip, I found you can create a macro by going to 'Create' >> 'Macro' & adding the details as shown in the attached gif file. Note I'm using 2007 but it should be at least similar & avoids a...

OK, I'd suggest you start checking out VBA (Visual Basic for Applications) which is programming code for the MS Office suite. After a bit of study of VBA, reading 'VBA for Dummies' & watching You Tube vids like the one below will help you. Overall if you're going to be using Microsoft...

Hi Dick7Access Do you mean you want to automate sending data from 2 Access tables to an Excel workbook that has a table of data to be updated using VBA? More info please, Thanks