Recent content by dazstarr

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...