Recent content by bayman

That was it. Thanks!

The credentials work. The browser navigates to the next page, which is where the freeze occurs. I'm attempting to get in touch with the vendor's tech support.

I've got an Access app with a form containing a Web Browser object. In VBA, I I use the object to navigate to a particular B2B website, programmatically enter login credentials and execute the login 'Click' event. Afterward, I scrape the web page for data. This has worked fine for months...

Just closing and re-opening the database solved the problem. Amazing.

Tried opening without preview. Same error. Report contains no code. Recordsource is a linked SQL table.

Generic run-time error. The accompanying message is "The OpenReport action was canceled."

I'm attempting to open a report with a simple command: DoCmd.OpenReport "rptName", acViewPreview Executing the command results in a 2501 error. If I open the report from the Navigation Pane, it opens as expected. I'm using Access 2010. I've added code to ignore the 2501 error, which results...

You're right...I had been using Report View as opposed to Preview. It works. Thanks, much.

It didn't work...and I *do* need to set the CanGrow attribute to Yes so the subreport will display if there's data.

I have a report that calls a subreport. In most instances, the subreport will have no data and I won't want to show the subreport. I've tried various ways to deal with this: 1) Make the subreport property on the main report the minimum height and set CanGrow = Yes 2) Use the Report_NoData...

I've got Access forms/tables that I want to publish to a Sharepoint server, so users can use my Access app via a web app on the Sharepoint server. In such a scenario, am I prohibited from using linked tables in Access to publish to Sharepoint?

Can I publish an Access2010 database to Sharepoint2010 with linked tables? Or, am I limited to Access tables only? Thanks in advance.

Thanks, Bob. That's what I was looking for.

It's not perfect, as fields grouped in the report are repeated, but still works pretty well. Thanks!

I have form to generate a report, where the user selects certain parameters for which I use VBA to filter the report on, ultimately using the OpenReport method. No problem, as I wind up with something like this: DoCmd.OpenReport "rptName", acViewPreview, , "City = 'Springfield'" But, I now...