Recent content by AccessAM

Yes, the other time periods still work. I have found a workaround - by creating another form I'm able to create the graphs. I wonder if there is a limitation to the amount of graphics you can put on a single form?

I should add that the error message gives me the option to restart the program, which I have done but to no avail.

Hi, I keep getting "Microsoft Office Access has stopped working" error message when I try to create a graph based on a query in a form's design view. I have created the exact graph many times before (for different time periods), in the same way and same form, but unable to do so anymore. Any...

Yes, it now works perfectly - it was set as acViewNormal - my fault didn't follow the instructions. Thanks all

No probs - I really appreciate your help. For some reason it seems to want to send the selected report to print - must be a local computer setting or something - have you experienced anything like that before?

Any suggestions.....anyone......:confused:

Here you go - please see the form frmTEST where the combobox and cmd button are. Please be aware that for some reason the cmd button sometimes wants to send the selected report to print! Thanks

Hi again, I tried removing the "" as you suggested (and tried various combinations) but with no success........

I'm still struggling with this one. The code behind the combo list looks like this: Private Sub Form_Load() Dim NewValList As String NewValList = "" Dim obj As AccessObject For Each obj In CurrentProject.AllReports NewValList = NewValList & Chr(34) & obj.Name & Chr(34) & ";" Next obj...

Thanks for your suggestion, but I get the following error message: Runtime error 424 Object required Any ideas?

Hi Chaps I have a combo list that populates with all the reports in the database on load. I want to create button so that the user selects the report from the list and then clicks the button to run the selected report. I'm having some difficulties writing the code. Here's my efforts so far...

Hi again, I seem to have solved the problem by removing of the "look up" from the Technical Info table to the Business Function table for the Customer Dialled Number field (I've retained the join between both fields, though). Not ideal, but at least the query is now working. I still can't...

Hi again, This is the problem I'm having; the field isn't null, it has a value in it. See the attached which contains a shot of the Technical table containing both fields in question. Thanks

Please see the attachment which contains the details requested. Thank you.

Thanks for your reply. Essentially, new general data regarding customer assistance telephone numbers are entered into table 1, including the telephone number itself. In the related table (table 2), other technical data for each telephone number in entered. The telephone number is selected via...