Recent content by Old Gnome

Have you looked in C:\Windows\Fonts? oldgnome

I think you may want to consider keeping the allowed values in another table. Then, you can run a query against that table with your originating field. oldgnome

Try File - Page Setup - Page Tab. If your printer supports A2 size, it will appear as an option. Otherwise, you can create a report from another size paper and adjust the margins to give you the printable area of an A2 sheet. oldgnome

Oof. So the original code should work? I am going to try it on Access 2000 soon and see if that doesn't pry the error loose. Anything else you can think of? oldgnome

Shep: Thanks for the assist. As soon as I saw your answer, I realized the single- and double-quotes were missing. I replaced the code and now I get the error: Run Time error '3464' Data type mismatch in criteria expression. The same line is referenced [Progress, but not as far as I had hoped...

The following form code runs just fine in a colleague's database, but gives an error (Runtime error '3077' Syntax error (missing operator) in expression) in the application I am trying to build. Can anyone help identify the source of the problem? The line of code highlighted by the error is...

You may need subreports if the total length of the defined reports exceeds 22 inches. Besides, printing the same data and report formatting on individual reports takes a whole lot longer than printing the same data and formatting as a report with subreports. oldgnome

If your original query is a Create Table query, you should be able to copy the SQL code by highlighting the code, right click with the mouse, select copy....then paste into a new query in the new database. Otherwise, can you give us some more details? oldgnome

The ability to power down after Windows shuts down lies with the computer, not the operating system. For example, my laptop at work will power down when I request, but one of my desktops at home will not. I'm not sure a BIOS update can take care of this, but if the computer is old enough, you...

You can create a master report that includes subreports. Go ahead and save your different forms to different reports. Then create your 'master' report and add the other reports to that. oldgnome

In Access 97, select Tools | Startup... | and then deselect the checkbox marked 'Allow Full Menus.' oldgnome

A number of years ago, I created a table in Excel that renders all the displayable characters from 0 to 255. In fact, there are fewer than 10 that do not display. To directly enter the ellipsis (…), for example hold down the Alt key and press 0133 on the numeric keypad of your keyboard. I...

The three periods are saved as an ellipsis. It is a single ASCII character #133. The conversion from three periods to the ellipsis is caused by AutoCorrect. Go to Tools|AutoCorrect, then select the appropriate entry for converting to the ellipsis and select Delete. That will keep the...

I was trying something similar, but the only way I could get it to work was to add another field that calculated the number the way I wanted it displayed (in your example, that would be NWT_Divided_by_2000 or some such), then use that field on the report. If you find another solution, I would...

That helps enormously. I needed to put a marker object on the page so I could select something other than the tab header. Once I did that, it worked fine. Thanks! oldgnome