Search results

Thanks Gasman and The_Doc_Man for your replies. It looks like a page footer containing a page number which had been inserted automatically in the bottom right of each "double" A4 page was the problem. It seems a little odd to me to treat two A4 pages side-by-side as a single page. Any book...

I am an occasional Access user and so please bear with me while I ask a daft question. I am designing a report to be printed in portrait orientation on A4 paper. I have selected those attributes in "Page Setup". I then find that the Report Width property is automatically set to 39.418cm which...

Thanks Arnelgp that works too. It is also useful to have an example of VB code to help me come to grips with the interface between Access and VBA.

Thanks for your help Gasman that works perfectly. I did teach myself Visual Basic about 25 years ago but then didn't use it much. What I need to get my head around is the interface between Access and VBA.

This is the message I get when I try to run the procedure. It is said that the error often arises when the database is not trusted by Access but that should have been resolved by making the database location a trusted location.

I have a database from which I need to send a form by e-mail to selected recipients. I use a combobox to allow the user to select each recipient in turn and then click a button to produce the email and its attachment. This worked perfectly in one database (Messenger email test.accdb) but when I...

Thanks DBguy I have followed that approach in the live database and it works. What puzzles me is why when I tried that approach before the queries failed to select any records, as I mentioned at #5. But the main thing is that I am now getting the result I was looking for and so thanks very much...

Yes I was just using the Event Focus table as a means of storing the Event Number for the report the user wanted to produce. It has no other purpose.

OK I have taken out the criteria statement in the queries for both receipts and expenditure. It still works but I would be fascinated to know how the correct records are selected without the criteria statements.

Thank you very much DBguy your revised version works fine. Can you tell me what you changed to get the result I was looking for? I will need to know that to make the changes in the live database. I haven't tried taking out the criteria in the query yet. Isn't it the criteria that selects the...

Thank you very much for your patience DBguy. I have followed the instructions on the forum to strip down the database for upload. So in the stripped down version go from the Main Menu to the Reports Menu and then the Event Receipts and Expenditure Menu where the malfunctioning combo box can be...

I am sorry I didn't make this clear in my earlier post. The two SQL statements are alternatives that I have tried to make the selection of records for the report. The first is using the value from the combo box after it has been assigned to a field in a table (ie the combo box bound to the...

This is the SQL statement using the table field to select the records to be included: SELECT [Receipt Categories].Description, [Cost Centres].Description, Sum(Receipts.Amount) AS SumOfAmount, Events.Description, Events.Date FROM [Event Focus] INNER JOIN (Events INNER JOIN ((Receipts INNER JOIN...

When I have tried to reference the combo box directly in the format you describe in my where statement in the query selecting the records to be included no records are selected and so when the report is opened the report structure is there but otherwise the report is empty.

Yes IBM 360 series and 370 series with a good deal less computing power than you might find in any wearable tech today.

Yes DBguy the combobox is bound to the table where I store the value. Perhaps what I need to know is how to retrieve a value selected from an unbound combobox.

I am trying to use a combobox in a form to allow the user to select from a list of activities and then by clicking a button on the same form to produce a report about the receipts and expenditure for that activity. The value from the combobox is stored in a table which is then used to select...

I am pretty ancient by most standards! I programmed in PL/1 and IBM BAL almost 50 years ago ... yes computers had been invented then but they were kept in air conditioned rooms and could be seen through a window from the viewing corridor. My career subsequently broadened but I retained an...