Search results

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

I created a multi-tab form the other day for my project that works just fine. Today, I needed to add a button to each page, and to my surprise, I only needed to add the button to the first page and all the rest had it. I figured, "why mess with success?" However, today I am trying to create...

That did it! Many thanks. We've lived in Green Bay for nearly 6 years now and I have started getting tired of 'all Packers, all the time.' And I grew up in Milwaukee.... oldgnome

Well...I thought it worked. It turned out the first time printed the first record twice, then the second record. I am only selecting two records to print while testing. I have also, while trying to tweak the code, run into a couple of other near solutions. In all, they are: 1. Print first...

Denny: It works! Many thanks. (Understanding that I don't have a clue what continent you are on,) the next time we are in the same city, I owe you a beer, a meal, a cup of coffee or tea, whatever. oldgnome

Denny: I feel I am so close I can almost taste it. After some working with the code this morning, here is what it looks like: Dim dbs As Database, rstRecords As Recordset Dim strRptName As String Dim strRecord As String Set dbs = CurrentDb Set rstRecords = dbs.OpenRecordset("T Calculated...