Search results

Hi, I currently have a number of graphs within an Excel 2000 spreadsheet which I have set up as linked objects within a number of reports which update automatically when you open the reports in Access 2000. I would like to use code to update this link by pushing a button within a form and set...

Can anyone help with the above problem.I've been working on it for days. Thanks DFINN

1. I've created a field on the mainfrom with the control name linking to the search field name on the initial sub form. I've also done this on the other tab page which I am trying to link to. 2. I've set the controlsource of this field to refer to the control in the subform. 3. I've set the...

Hi Fizzio The problem begins with the link criteria. I am receiving a prompt to enter a parameter value for both forms to link. I think I have a problem with the form reference. Do I need to be referencing the tab page somewhere in the link criteria? If I manually type in the parameter values...

Right click on the task bar and select properties. Select Auto-hide the task bar from the listed options. This should hide the windows task bar whenever you are working in another application. HTH DFINN

Hi, I have a main form which consists of 5 tab pages. Each of these pages has a sub form. I have a search page where a user may input search criteria to filter out the data accordingly on the customer detail page which is on another tab.I am having problems with the syntax that should be used...

Thanks David for your help. I've had a look at what has been said in past discussions and I should be able to use their advice to finally implement a solution. Daniel

Thanks David for your reply. I have made use of the crosstab query function, however I seem to be coming unstuck with the order that the query is arranging the columns of months. It is sorting them alphabetically as opposed to the order I need which is dynamic depending on the current month...

I have tried to develop a dynamic query which will allow me to extract a rolling 12 months of budget data from a table. The table contains the following data: Code, Period (Month), Amount and Year. I need to show this data in a report which will dynamically display the column headings in order...