Search results

It is going to be a static resource that opens with the database in a full screen view. It has information on it used as reference while navigating through other forms that are set as Pop Up forms. The report would stay in the background at all times in order to be used as a quick reference.

I've read many articles on how to turn a single long (page spanning) column of data into "snaking columns" or "newspaper-style columns," but all of the results are only available in Print or Print Preview. I am looking for a way to have the correct, multi-column, result visible in Report View on...

I meant that I did not know how to include "rounding" within the expression I am already using. I had tried to look in the field properties to see if there was an option to cap the length similar to a number a field, or decimal length. By your reply, am I to assume that the syntax of the...

I considered that rounding might help, but I am not sure the best way to do it. I looked for a paremeter to set the character lenght, but could not find one on a calculated field. - Brian

I have a a table that stores various financial information such as sales receipt totals and variance totals (if actual cash in drawer did not match receipts, etc...) that I use to help me track cashier performance and identify possible problems. Part of this process includes a query that I pull...

Darbid, the functionality of your example DB is what I was looking for. I'll mess around with it when I get some free time this afternoon. Thanks a bunch!

The web site is a public web site, not something I created. I'm just simply accessing it as a feature of a database i'm working on.

I discovered that same thing as well. Strangely, if you were to change the URL in the Web Browser control source to the final linked page, you get a different error. This is the whole crux of the issue. It seems as though clicking through the links on the list of names within Access somehow...

I tried the code, with several different variations, and had no success. I am attaching a sample DB as requested. Open the form, and type in a name on the right side to search. The next page will contain a list of names that match the search criteria. Click on any of the names to attempt to...

For this specific project, the page that opens with the error would be the final displayed product. So if there is a method to capture it within Access and display it correctly, that would work. Beyond that, for curiosity's sake, i'd feel more comfortable understanding the cause of the error...

Thanks for looking at it. For me, the issue is independant of any particular hardware being used. I experience the exact same results at work and at home. At work I am using a WinXP Pro 32-bit desktop with IE8 as the default browser, and Access 2010. At home I am using a Win7 Pro 64-bit Laptop...

Been kinda quiet for a few days. Hoping someone has an idea what is going on, and/or how to fix it. Thanks in advance.

You were able to make Access launch Firefox from within the database? To be clear, the problem is occurring from within an Access 2010 database. I am embedding a Web Browser control in a form, and assigning the URL to its control. When following the search & results steps from within the...

I'm not sure what your reply meant. Are you saying you followed my steps are did not experience any problems?

I am experiencing an unusual (to me) problem using an embedded Web Browser control on a form. I have stripped the entire database down to an empty table and a single form with a web browser control. The web browser loads the specified internet site, which contains a search form. After providing...

Thanks for the reply. I did some more digging today, mixed with a little trial and error, and determined the problem was caused by my Query pulling together data from 2 different Tables. Evidently, that affects the update-ability of the query. Now i'm playing with some work-a-rounds for this...

So i'm trying various things that I usually don't bother with, to try and gain some knowledge. The thing i'm messing with now is Continuous Forms which pull their data from Queries. The odd thing I wasn't expecting is that it appears the results in the Details section of the Continuous Form...

I figured it out. Basically I created a blank form, launched by an Autoexec macro, that has the following code in the OnLoad event: DoCmd.OutputTo acOutputReport, "rpt_InfoReport", acFormatPDF, "InfoReport.pdf", True DoCmd.Close acReport, "rpt_InfoReport", acSaveNo DoCmd.Quit acPrompt The MS...

I've created a database for the single purpose of tracking training expiration dates for employees. When opened, it displays a report that shows a list of employees who's training dates are nearing expiration. Combined with Windows Task Scheduler, I have it set to run on a Supervisor's computer...

Thanks John, this did the trick! I appreciate the quick response.