Recent content by BrooksR

I did talk with the company in your link. They seem ok and have a solution, its just not inexpensive. I agree with your conclusion. Yes, I did post a couple of places because I wasn't sure of getting an answer. Thanks for your help, Duane. Brooks

Thanks for the post, Duane. It looks like that company offers the service but you have to use their server and the cost per month per user would be outside the budget of the non-profit that I'm working with. There's also the issue that a user would need to run Windows Remote Desktop Connection...

What is the easiest and least expensive way to place a ACCDB online so that anyone can use the forms and reports? Thanks

I already am aware of limiting fields and restricting records to reduce server traffic. However I was wondering what others approach may be to queries and loading subforms (which seems to take forever) when working in this manner?" You definitely want the fields linking a form and subform to be...

I'm a developer and have a non-profit customer looking for an easy to use PO system. They are not looking for anything too fancy - enter a requisition, have one or two levels of approval based on dollar amount and print a PO for the vendor. Their budget is $2,000. It would be installed on a...

Thanks for the post, Andy. I'm a professional programmer, so I write modular code. I've been doing tracing and haven't found any real bottlenecks yet. I'm doing thousands of select queries against a 3 million row table with a primary key consisting of 4 fields. strongm - yes, I did run the...

Does anyone has any suggestions on how to improve performance on a processing intensive Access application. There is a small frontend that is about 9 MB. There are 2 backend databases. One with static data that is almost 1 GB. The main table is 3 million rows of stock option quotes. The...

Can you create stock and/or candlestick charts in Access? If yes, then what version did they first become available in? Also, is it possible to add technical indicators, such as a moving average, to a stock chart? Thanks, Brooks

Hey strongm, That was an excellent suggestion, thanks! I removed the first table and the import wizard now works fine. It's great to have a workaround. Attached is another file in the same format, also with 2 tables that has no problem importing with the wizard. I do have to tell the wizard...

I'm an experienced Access/VBA developer and am having trouble with importing some html data files into Access. I've tried: 1. Toolbar wizard, External Data, html Document - gives 2 errors, first says it can't file the html file, second says the file may be in the wrong format. 2...

This occurs when trying to print from IE10 or OL2003. Says line 2378 - the remote server machine does not exist or is unavailable. Is this something wrong the in Java configuration/setup? I've looked at the Java (32 bit) settings in CP and don't see anything wrong. Any help appreciated.

Please keep sending suggestions. One of them will work ...

I followed the KB instructions. Most of the regsvr32 commands failed, 3 worked. Made no difference in printing. Still getting the error message. 1.Click Start, and then click Run 2.Type regsvr32 urlmon.dll in the Open box, and then click OK. 3.Click OK when you receive the following...

It gave an error: The module ole32.dll was loaded but the call to DllRegisterServer failed with error code 0x80070005.

Thanks for the post, Sym. I tried IE10 32 bit and it made no difference, same error. Not sure what your thinking was here ... Even if it helped with IE, I would still be left with the same problem in Outlook. I need a solution that fixes it in IE and OL. My guess is that this is somehow...