Search results for query: *

Hello... I've been running queries all day, and exporting them to excel spreadsheets with no problem. For this last problem, I have a query that shows all the necessary information in the Access table, but when exports to spreadsheet, it writes only the column headers and nothing else. Anyone...

xlbo No offence taken... As it stands, my working knowledge of Excel is limited to the point where I wouldnt know where to start looking, leading me to put myself at the mercy of the forum experts. Whilst many beginners could find the answers on their own by looking things up, it is...

Thanx for the help combo, et al... And xlbo, as described at the bottom of this very page, "DESCRIPTION: Microsoft: Office technical support forum and mutual help system for computer professionals" I had a task, I needed help. If you dont like the question, don't answer...

Hey all... I know this is probably basic but I'm a little pressed for time to look it up at the moment. I have a cell value in the format as follows: (194) 3151-05B PAR TELSET MLS 12B BLK 7311H05A How can I write a formula that will extract just the number in parantheses? The numbers change...

dale, Thanx a lot...still learnin some of the syntax...worked like a charm... GP

Hey ppl, I have a script running where information is filled into columns and rows dynamicly, meaning if certain criteria is checked off then it will appear in the next unused column. This means I dont know what column I'm going to be in when I need to move to the top of it in to fill in a...

Hey all... I'm a bit new to VBA so bear with me... I currently using a UserForm to have people input 5 different spreadsheets that will be merged. I used the GetOpenFile method to store the filepaths & filenames in a variable so I could open the spreadsheet by using the...

'smudge, Nice perspective....I think I've been staring at this for too long :)...I think I can definitely use this! Thanks for the help! Regards, gestaltphoenix

Hasit... Many thanx for the quick response... Pardon my ignorance, but doesn't Access 2000 support SQL queries? Also, if you have a minute, I'd be interested in a summary of how you designed that access dbase. I'll be working with up to 10,000 different codes, each of which has about 20...

Bastien, Many thanx for the speedy reply... It is definitely two rows....its not a spillover... (i.e. A2="Material" A3="Code") If I'm going to do this in Access, that is still a big problem....If it truncates the titles by taking the bottom cell only, then fields like PEC...

Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...

Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...

Ok, heres the deal... I have 3 different Excel reports coming from our SAP database that I need to merge into 1 customized report. In other words, with reports A,B, & C, I need to to merge parts of B&C into A. All 3 reports have a particular column (Material Codes) that need be merged with...

Suggestions on how to import a spreadsheet by typing the file path into the text box. A browse button would be even nicer :o)....Any suggestions??? Sorry for the noob question.... Thanx