Search results

Thanks for the explanation. Seems to make sense. I do normally use reports for printing, but in this case I had painted myself into a corner and needed the form itself to print out (I needed huge numbers of fields that exceeded the maximum for a report). Thanks for the help.

Hello. Thanks very much for the suggestion. Unfortunately, the code didn't make a difference in this instance. However, after trying the code out, I did happen to switch my text box from the Page Footer to the Detail part of the form where it mysteriously started working properly. Your...

Hello. I'm using an unbound text box with a datasource set to =[CurrentRecord] to show the number of the record currently being shown on my form. This has worked on all my forms in the past, but I am having difficulty with it on one particular form. There are 25 records in the underlying table...

Actually, never mind. On reflection, I think we must be using different versions of Access after all, so I'll use one of the alternative calendars posted elsewhere to get around the problem. Thanks anyway.

Can anyone help please? I have a database that uses pop-up calendar controls on many of its forms. On my computer, the calendars all look normal when they appear. However, a colleague who has started using the database never sees the calendars appear properly. The calendar control pops up...

Hello. I'm having some problems using the Mail Report command button to send a report as an email attachment. It worked perfectly at first when I chose to send the report in snapshot format. However, when I chose Excel as the format it caused the email program (Lotus Notes) to throw an...

Thanks again for all the help. I think I'll have a go at putting the FE on each computer as it seems safest - maybe the IT Dept won't notice I've done it! Good to know there's the option to use the Shared folder as a last resort if they order me to remove it though. Many thanks.

Thanks for the help everyone. Re: compacting the FE. I know I could turn Compact On Close on so the user doesn't have to manually compact the DB themselves. However, when the database has been compacted in the past, as well as being quite slow (which I suppose is unavoidable), the compacting...

Hello. I have spent the last couple of hours looking through the forums but have managed to get myself really confused. Lots of questions, sorry - if anyone can point me in the right direction with one or two of them, I would be hugely grateful! I have a database in a shared folder on the...

Brilliant! Amended the query as suggested and now working perfectly. Many thanks for help, and useful advice on naming controls that I'll keep in mind.

Hello. I'm a bit stuck and would appreciate any help. I have a table with a Date / Time field and a field to record Activities on that date. The Date / Time field includes some entries with just the date recorded, and others with date AND time recorded. (This is using UK date format by the...