Search results for query: *

Hey John, Thanks for the attempt. I didn't know about that property. It was set at 2000 by default but I went ahead and bumped it up to 5000. I'm still having the same issue, though. Jeremy

I am perplexed by an issue with a listbox on a tab control. Here's some background: the tab control has three tabs and all of them have a listbox on them. In the Form_Load event, I run functions that update each of the listboxes. The first two load fine, but the third one just appears grayed...

Great, thank you!

I am using the Handy Access Launcher freeware utility to automatically open a database and execute a macro (which calls a module to do some data manipulation). Everything is running well, but I can't figure out the proper way to close out of everything when I'm done. I used...

The way I handled this in a project was to use a function that adds one month to the date passed to it, then subtracts one day from the result. This gives me the last day of the month. Here is the VB function I used: Public Function GetLastDayOfMonth(sDate As Date) As Date Dim sMonth As...

I had a similar problem with an unexpected parameter window appearing. I removed the "total" column from the xtab query but hadn't removed it as a sort option in the report.

OK, I now know exactly how much space is available in the column! How do I programatically insert a specific image into that spot? Is it possible to do that?

I'm creating a report that has a few levels of grouping. Since I don't ever want a group heading to appear at the bottom of the page with no room for detail beneath it, I set the "Group Keep Together with First Detail" property to true. As a result, some columns have blank space at...

I'm using Access 2000 but I think this pertains to Access 97 as well. If your query contains the employees name and then the path to their picture, in the reports detail section, drag an Image control from the toolbox. Then set the properties for the image control like this: Set the Picture...

In Access, "nz" is a built-in function that replaces a "NULL" value with another specified value. However, I think it should have two arguments, the first being the expression to test, and the second being the string to return if the result of the expression is null. To use...

I just ran into this same problem. There is a knowledge base article about this on the MSDN site, but it calls for reverting to a known good backup of the db: http://support.microsoft.com/support/kb/articles/Q304/5/48.ASP?]Error - Network Connection May Have Been Lost If there is an easier way...

I just ran into this same issue, except that I developed a report on a machine running Win2000/Access2000 and emailed my client a report. Upon importing the report to their machine (running Win98 and Access2000), they got the error you mentioned. There is an article on MSDN which addresses...

I actually figured it out. For those interested, I had the column width in Page Setup set too wide. Once I narrowed that down to about half the page, my two columns showed up quite nicely!

Is it possible for the report body to be in two column form while the Report and Page Header and Footer span the entire width of the page? I have a report that groups items by category, then displays a picture of an item and then item details (there are multiple items to one picture, and...

I have a report that generates a custom document of products that have associated images. On the report, I have an image file with PictureType set to Embedded. When I click the "Export to Word" button, everything exports except the images. Does anyone have any idea what I need to...

Thanks for your response. I think the best example of what I'm referring to is Quicken-style reports where, if there are five bars on a graph each representing sales for a different month and the user wishes to view the underlying data of a specific bar, they could basically trigger another...

Does anyone have any input about adding drill down functionality to Access Reports? I'd like the user to be able to click on a graph that's on a report and get underlying data. Any help is appreciated! Thanks