Recent content by DataMinerHome

Thanks, but I am really looking for a way to do this without buying a full version of Acrobat, as this is just a one time project for a volunteer organization (ie, no money available).

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...

I figured it out. Replace blank fields with "#N/A" and the dots all get interpolated and connected. Works beautifully!

I can't see that this makes any difference. Now I am back to getting just separate dots with no line in series b.

But this will make the line go to zero, which is not what I want. In series B, I want a line going from 3 to 8 to 7, NOT 3 to 0 to 8 to 0 to 7.....???

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 can't show you the pictures, they are proprietary info. IN any event, it's not the particular picture that's the problem. All pictures work fine as long as I don't include more than about 15 records in the report.

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...

Maybe.. what's your exact question? All you should need to do is add something like rst!YourListBoxData=selectmultiple(YourlListBox, Youroptions) to your code.

Pat, yes, that's what I keep telling our IT department, and they keep telling me that all the permissions are there. Besides, if it's a permissions issue, why can the others, when logged in, still create and delete files?

Hope this helps. Let me know... Function SelectMultiple(ListBoxName As Control, Txt As Boolean, Optional NumberData As Boolean) As String Dim ListBoxItm As Variant, Separator As String Dim ListBoxCriteria As String ' this is the criteria string to be used in queries Dim txtList As String '...

Thanks for all of your replies. To give you some idea of where I'm coming from: I have created and managed Access DB's nearly full time for many years, since the days of Access 2.0. It's only since I've started using Access 2010 that I've encountered this problem. Pat, I do not use compact on...

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...