Search results

enlarge the field to be sure the date isn't getting cut off - I see #name when the field size is too small

I need to build a macro that will compare the audit date staff are trying to enter vs the current system date. Based on the current date - 45 days, I want to lock staff out from putting in any older data. I have built a message to display, and want to set the validation to check before...

Thanks. Will give it a try:D

I would like to be able to have users make a selection from a listbox which would then either open a data entry form or run a report, depending on the listbox. I have created a listbox based on a query off the hidden system MSysObject.Name object which displays the list fine. But when I...

That explains it - was referencing Access 2007. Good luck with the fix

What version of Access are you running?

Thanks for the tip, although I am aware of this information, and the problem does not seem to be the same. In my case, I do not get the dialogue box - it just goes to complete and on the surface, appears to be fine. That is until you try to enter data. After compacting, it opens the main...

Here is an option. Take the print icon off the short-menu taskbar and add the print preview from the customize list (make sure to pull the one which indicates "Office/menu..." when you hover). When uses select this icon it will pull into print preview and have a big printer icon on the ribbon...

I have been able to reproduce the problem in both situations - on a server and on different individual PC's. Microsoft has a copy of the Access database and has also been able to reproduce the problem.

Has anyone else run into this issue. After I compacted the database, I had no functionality. When I looked, all the tables were GONE and all but a few of the queries. All the forms and reports were ok, but unless the buttons were linked to other forms - they were non-functional. Thank...

Ok Bob, I see your wisdom, especially with a lot of reports. I duplicated your form and code and ran into a couple of issues. First, although I also have rpt_ at the front of all my reports, the rpt_ came over with the name of the report, and was not getting cut off as the code suggested...

possibly. I'm just storing text in the memo field. I don't have much experience writing VBA code, so an example would help. I was under the impression that memo would allow 64K of text whereas a text field was limited to 255 characters - so don't quite know what to make of the report...

text field does not refer to the Access field (it is a memo) - poor choice of words.

I have a couple of reports that I have placed a memo field, but the field is cutting off the entry at about 150 characters. I can enter a hugh text field in the forms and observe it in the query fine, but can't seem to figure out why the memo field cuts off in the report. Any suggestions?

Why not just add the autonumber to the report header? That way it will track back to the entry and by placing in the header, you avoid going through the field in data entry....;)

Another option is to add a button on the pop-up and link to report, print preview. Then you when you select print, you can select the pages you wish to print. Make sure you select Print and not QuickPrint. There is a difference and QuickPrint will only print all pages.

Here's an easier way. In the design view of the form, add a button and then select to "preview a report" Add button name, etc. Then when you click on the button, it will launch a print preview, where you can page through the report, zoom, etc. Then just print from the print icon. If you...

Here's an option... in the query, select a field that will always be entered for the country and add to the query. It's ok if it's already been added previously. Then on the menu ribbon, click on the summation icon. This will add another row to the query. Then change the Group By in that row...

thanks again

Great, I'll give it a try. :)