Search results

Many thanks Bob I will look into your advice. Thanks again Daz

Thanks Yarp Will do.

Afternoon Folks Please can somebody help me with a problem. I have an Access form with a command button - the button runs a access macro which uses the transfer spreadsheet command to export a table into an excel workbook. All this works fine but I would like to apply some formatting to the...

:cool: Superstar!!! Thank you so much!! Works perfectly now!

Can someone help me with this problem please? I'm sure it is pretty simple but can't seem to figure it out. I have a form with a subform on it. When users enter data onto the subform and presses back - the data is saved into a table. Here is the code behind the table...

Sorted it - I did as above. Thanks for your help. Daz

Sorry I think I mis-understood your thread. Do you mean EG: FullPupilName Pupil Name: FullPupilName Thanks Daz

Thanks for replying. Is there no way I can point the code to use the captions instead? The database is huge and has lots of code in different places and would rather leave the query and table as it is. Thanks Daz

Can someone advise me how to use Captions and not Access actual fieldnames when transferring a query into Excel please? I have the following line of code which exports the query - it works fine but I need it to use captions instead of the fieldnames. /code DoCmd.TransferSpreadsheet acExport...

Bingo!! Thanks for that - it was because I had Group By enabled (can't remember why now). Thanks for your help! Daz

Hi Thanks for your reply - no it is set to allow. I checked that earlier on. The form only displays when there is a record in the contract table and a related record from the other table. Daz

Thanks for your response - I will see if I can get it working. Thanks again Daz

Hi Can someone help me please? I have a form based on a query. The query has 5 related tables in. The main table in my database is called contracts. If there are no records in the contracts table - when I open the form - it just displays blank. Can someone advise me of a work around to...

Thanks for all your help anyway. :cool: Daz

Hi I have sorted this now.... I downloaded an add in from http://www.contextures.com/xlfaqPivot.html#FindSource which shows you the data source and also lets you edit it. All I did was run the add in and change the file path and it's all sorted now. Works fine. Thanks for all your...

Hi Thanks for replying. I have done this. I executed it under the Macro's menu but nothing happened. Apologies but I am a noob with Excel VBA. Thanks Daz

Hi Please can you tell me where to place this code? Many Thanks Daz

Thanks for replying. I think I may give it another go. I have since heard the original developer is back in tomorrow so I might have been let off the hook! I am still going to try it though! I will give it a try and post back this afternoon. Cheers

Hi Thanks for your reply. The Excel file has 3 sheets. I am really stuck on this one. The 1st sheet holds the main pivot table. Sheet 2 holds the info (based on the query from the access database) and for some reason Sheet 3 has a blank pivot table on it. Not sure why the originator...

Hi Can someone help me with this please? I have inherited a access database which has a hyperlink to a excel pivot table on a form. The database has had to be moved to another network drive. All the queries still work apart from this pivot table. Once you click on the hyperlink - it...