Search results

I want to combine several reports, and also some query outputs, into one pdf file. I can do this currently by running each report or query, using PrimoPDF to print it, and then manually selecting the "append" option to append the next report to the existing file. However, this is cumbersome...

Is there a way to force continous lines on a chart in Access? So, for example, if I have series A and B, I can get a continuous line for series A, but I just get 3 dots for series B. I want those 3 dots to be connected by a line. Data looks like this:

I have recently upgraded to Access 2010 and Windows 7, along with a new PC with a very high resolution display. But now, when I view reports which contain pictures, nearly all the pictures show up on the screen in VERY poor resolution. My pictures are stored as jpeg files external to my...

I have a report which displays images located outside of Access. This is a fairly large report, with and all the images are jpg's. When I print the report, intermittently, some of the jpg's just don't show up. It's different ones each time. When I view the report on screen, when it gets to a...

I have an Access 2010 database with about 30 frontends all linking to the same backend. The frontends and backend are both located on my company's internal network. I've set all the frontends to compact on close, but if anyone but me is logged in, they all get the "file permissions" error...

I want to add a button to a form that, if clicked, will add a check mark to a field. There is a wingdings checkmark character, but: 1. I can't figure out how to use vb to get the wingdings character into the field.I can insert it using the windows xp character map application, but....character...

I need to be able to disable/enable controls on a subform based on various entries on the main form and/or subform. But when I try to reference the "enabled" property, I get error "Object doesn't support this property or method". For example, using the immediate window, with main form...

I have a form in my database named DataEntrySummary. In the Class Objects list, I see two entries: Form_DataEntrySummary and Form_dataentrysummary When I right click on the class object and select View Object, both class objects open the same form. But they open two separate copies of it...

I have Access databases that have been running fine for years, unchanged. They all reference a common "library.accde" database which contains many commonly used functions. Recently, we've intermittently been experiencing that the databases cannot find any of the functions in the referenced...

I have a time field in my table with the default value set to Now(). However, it seems that when I open my table, the value gets set for the next record (even though I haven't started entering it), and if I wait for 10 minutes... or an hour.... to enter the record, the time gets set to that time...

Can some one point me to something like "Making Access Database Available on the Web, For Dummies?" I have many years of experience with developing complex db's in MS Access, and a few with SQL server. But NO experience with web applications of any kind, or with Sharepoint or anything like...

I recently made some minor changes to my db. Now, when I open it, I am getting "The expression onload you entered produced the following error: File not found", with no opportunity to go to a debug window and no clue what is causing this. If I click OK, it goes away and everything seems to work...

HI, I am using Allen Browne's method for handling multiple instances of a form. See http://allenbrowne.com/ser-35.html for code and details. Using Access 2010. However, I am having a problem where sometimes the instance does not close properly. I've posted my entire FormMultipleInstance module...

1. Is it possible to "autoorder" the tab indexes of a section of a form, using VB? (I know how to do it manually) 2. In the object explorer, under "Section" I see "SetTabOrder", but can't find any help on this. What do you suppose it does?

Hi,I have a db created in 2007, but my users have now upgraded to 2010. The db works fine mostly, but I am puzzled: When I open the db in 2010, at the top in parentheses it says "Access 2007". Fine, I thought it was just warning me that it was still in 2007 format and maybe I should consider...

Hi, I have code that creates links to pictures on a form. The pictures are external .jpg or .pdf or .bmp files, and different files are linked to depending on user choices prior to opening the form. This works fine on some PC's, and not so fine on others. Some PC's can open the bmp files but...

I have about 25 forms in my database (Access 2007), each of which contains between 3 and 6 unbound object frames. All of these are linked, NOT imbedded. Yet the presence of these linked OLE objects seems to cause the db to bloat, by something on the order of 1 to 5 MB per frame! The links are...

I have a form called "Hidden" which opens in hidden mode, via the db's autoexec. The autoexec also logs a "login" record to a table. Form Hidden's close event logs a "logout" record.... at least most of the time. Sometimes the logout record does not get recorded, and I don't understand why. Any...

Hi, I am in the process of adding tab controls to a bunch of forms. I'm not adding anything to the form other than the tab controls, then moving most of the existing controls on the form to one of two pages on the tab control. After doing this for about 15 forms, my db size has grown from about...

What's up with the Statistics Tab under Database Properties? 1. Why does "last saved by" and "revision" show up blank? Is there any way to make use of these? 2. Is any of the info on this tab available from VB? Even just read only? I'd love to have the "modified" field show up on a form...