Search results for query: *

Hi Created a workaround. Separate drop down (with just: Tom, Dick & Harry). I then use the selected value from this drop down to change the page field of the pivot table. (I 've hidden the page field, and protected the worksheet to prevent it being unhidden) ActiveSheet.Unprotect...

Hi Been using Excel for years, with ok VBA skills. Thought this would be easy....... I have a pivot table, where I want to prevent the use from being able to select all items. E.g Data Salesman: Tom, Dick & Harry Sales: 2, 3, 1 Within the pivot table, I do want users to be able to...

Thank you very much. Fixed abover error, but my code did not do what I wanted it to do!!!! It is still exporting everything, even though the subform is filtered. The code below must be picking up the pre-filtered SQL. sqlstr = CurrentDb.QueryDefs(MySubFrm.RecordSource).sql How do I access...

Hi I'm trying to export the results of a filtered subform into excel. I can export the entire subform ok, but have not managed to export only the filtered records. I'm trying to get the code below to work, BUT when I run it I receive an error message: 3129 Invalid SQL Statement; Expected...

Hi THANK YOU VERY MUCH!!!!!! [2thumbsup] It worked: MySubFrm = MyMainFrm.Controls("ctrlCmtsDetail").Form I've learnt a lot from this, and it will be VERY useful!!! I'm happy now. [smile]

Hi Thx for getting bk to me. Run time 2465 Can't find the FIELD frmCmtsDetailQry referred to in your expression. Arrrrrggghghhhhhhhh [mad] Jason

Hi Thx For the reply. I'm Still struggeling though. :-( The two forms are as follows: UserForm=frmCmtsDetail DataForm=frmCmtsDetailqry I still cannot ref the dataform with this code: Dim MyMainFrm As Form Dim MySubFrm As Form stDocName = "frmCmtsDetail" DoCmd.OpenForm stDocName...

Hi I have two forms: 1. DataForm In datasheet view. 2. UserFrom The userform has no data directly on it. It has a Title, a button for closting the form. It will also have a button for filtering later on. Finally, it has the Dataform embedded in it. I'm struggeling to write code for the...

Hi I decided the easiest way was to: Calculate cumulative purchases AND sales by week, and product, using DSUM to provide the net cumulative movement by week. I had some fun with quotes until I found: http://allenbrowne.com/casu-07.html The calculated net movement can then be added to...

Hi I'm looking to build a simple stock forecasting system, and NOT a complex stock management model, and need some help on the design. The volume of data excludes Excel - where my real expertise is. Data 1.Products - circa 6000 (categorized into many groups) 2.Time period - 52 weeks...

Thanks Mate. With some minor changes this worked perfectly! Saved me loads of time. CHEERS, and av a star for your troubles! Jason

Hi I work in an office that has difference versions of MS office, AND we share databases. I need code that will change references depending on which PC the database is used on. Where Excel 97 is used I need the MS excel 8.0 reference ticked, and where excel 2003 is used I need the MS excel...

Hi How do you get Powerpoint to automactically run code when a file is opened? I'm used to using Excel & Access VBA, but not Powerpoint. I cannot find any 'auto_open' events. Does such an event exist? Is there another way round it? Thanks Jason

THANKS PHV - you are a STAR, which is why I have 'Starred' your post. [2thumbsup] [2thumbsup] [2thumbsup] Your code was VERY useful - it worked a treat. [thumbsup2] [thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2][thumbsup2] I have...

Hi I urgently need help on writing a query. I have two tables. One contains purchases by product and date, the other table contains standard prices by product and effective date. I need to return the relevant standard price for each purchase. See Example Below Table A: Purchases...

Thanks for confirming the Error Patrik. [2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup][2thumbsup] It was the error I was interested in (rather than a work around), but thanks for the workaround too. Jason

TYPO error on the thread Index range is A1:D1 (Not A1:A4) Jas

Hi Summary of problem: I have a workbook, that links to another workbook. The links works fine, when both workbooks are open - but fails to work properly when the linked workbook is closed???? Why would a link only work when the linked file is open???? Detail of my problem: The formula I am...

Thanks a lot Dickie. Worked a treat!.... [2thumbsup] [2thumbsup] [2thumbsup] [2thumbsup] [2thumbsup]

Hi I currently have 2 PCs networked together - sharing files, printers and a slow internet connection. I think the only kit I have is: 2 internal networks cards, a hub and a LOT of wires!!!!! I am about to move to ADSL, and buy an Ipaq. Additioanlly, I would also like to have a wireless...