Search results

Since converting to Access 2010, when I use the "PDF or XPS" button to create a PDF from a report, after the save dialog it opens the PDF in Adobe reader, and then after I close it there is another dialog with the option to save the export steps. Is there any way to just be able to save the PDF...

That did the trick. Very little of the date field is cut off, almost a trivial amount. Thanks

I just checked my old version of the database (mdb file) and the font name and size is exactly the same in each of the forms/reports that this happens in.

Just switched from Access 2000 to 2010 and now on many forms and reports where dates are displayed, you see ###### instead. I realize that widening the field fixes this but there are a lot of forms and reports in this database to go through and change all of them. Is there a setting somewhere...

Yep, that was the problem. Once I unchecked that all of the rectangle properties were like they should be. Thanks

Well, it seems that all you need to do is change the color to the name "Text Black" and that fixes it. For some reason using hex color #000000 does not turn out right. When I changed the hex color to the closest thing to black without actually being black (#010000) it also worked. Thanks!

Perhaps you misunderstood my explanation of the problem. The problem actually IS with the rectangle shape. I am finding that the only solution to the problem is to make a rectangle using 4 lines. If you look at the sample I had attached you will see what I mean.

Hey all, please see the attached Access 2010 database. Notice how in the form, the 4 rectangles are a border width of hairline, 1pt, 2pt and 3pt respectively, but the first 3 look identical and the borders almost look gray even though black is the color. However, when drawing lines, you can...

Well, the problem with the ribbon not hiding is not an accdb vs. mdb issue either. I converted to accdb, imported the form directly from the sample DB and set it as the startup form and the ribbon does not hide. Very strange....

Yes it was Lebans' module I was using with Access 2000. I just checked and yes, the PDF is only half there so I will need to change all of those. I won't need to make it work with both versions because we will be using 2010 for everything for this day forward.

I will give that a shot. Originally when I toyed around with 2010 several months back I did convert to ACCDB and I know I ran into errors with PDF creation because I am using the ReportToPDF module from A2K so every instance of that will need to be changed. I know there were a couple other...

Thinking about doing that but a little hesitant because of the errors I expect to encounter. I read about the advantages of doing so and it didn't seem like anything that I really needed. I heard about being able to mix regular and bold text in a memo field with 2010. Is that feature only...

Ok that's a puzzling one because it works with the sample DB that was attached but when I copy that same code into my form it doesn't. I even imported the form and that didn't make a difference. All I can guess is that it's because my DB is still in MDB format while the sample is ACCDB. That...

I was hoping to hide it without the user having to do it themselves. Ctrl + F1 does the same thing as the arrow in the upper right corner. If I hide the ribbon myself it will not appear but when I am regularly designing and copying over the updated program to the user it's hard to remember to...

Yes, I have tried it with and without that line, same result.

Well, my opening form is called "Main". That is selected as the "Display Form" under current database options. In that form I have put the lines of code into the OnCurrent event. Have also tried the OnOpen event. It works when I open that form from the panel containing the list of objects...

That's what I did from the get go. :confused:

Not sure what you mean by "Open DB" or "Click on file". Open Access by itself and then choose the DB I want to open, or open the actual MDB file?

That's what I did, tried in both the OnLoad and OnCurrent event. In both cases it hides the ribbon only when opening the form from the form list.

F11 only toggles the "All Access Objects" panel.