Search results

If you set up your Column Headings in the cross tab, it will show you all the months weather there is data or not!

Then refer to this one! http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34424

Refer to this posting it might help you! http://support.microsoft.com/defaul...b;EN-US;q115915

Lookup nz function :)

Refer to this posting: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=6600&highlight=compact+database+with+code

I am just guessing! You might have lost connection to the network. Is your L drive your shared drive? Have you checked your folder and see if your path exists? Maybe, someone went to the folder and changed the folder name or one of the file names! These are the only things that I can come...

I don't think you can do it in the macro, but you can go to page set up of your report and set it to the tray that you want, and save your report. Try doing this in the design mode of you report.

Use snapshot viewer :)

Use crosstab query :)

You can link the table to one of your databases and make a union query!

The simplest way is to make a Macro and choose the Action: Output To. Then at the bottom you can choose your table or query or whatever to be sent to a folder. I hope that made sense to you:)

Refer to this posting: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=24035&highlight=DoCmd.RunCommand

Yes, there is :) DoCmd.RunCommand acCmdFitToWindow

You have to make a select query out of your crosstab and put the critaria on that select query, then it will work. :)

Try this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q115915 :)

Put this on the unbound textbox control sourch: ="From: " & [BeginningDate] & " To " & [EndingDate] But this has to exactly match the critaria in your query, otherwise it will not work!

Name: [LastName] & " "& [FirstName] :)

You should toggle the forms visibility with code. Put this code behind the onclick event of your button [Forms]![Main Form].Visible = False [Reports]![Main Reportt].Visible = True

You should only link your parent/child with ss# in your subreport.

Depending on how much data and how many queries, Tabs run very slowly anyway. I had a form with 4 tabs and it was running so slow that I changed it to forms and subforms. When the user opens the form they think it's tabed, but in reality it's not. I just made buttons on my form and everytime...