Recent content by egptech

John, Thanks for the assist. I had already re-written the offending section and the problem went away. I had already deleted the old queries, tables and reports so I don't know if your suggestion was the problem but the new stuff works perfectly and I only have the tables joined at the...

A curious thing occurred with the above solution. The query "loses" a couple of hundred records. For example; There is a series of silver dollars called "American Eagle Silver Dollars" with about 18 coins in the series. I don't have any of them in the collection but the...

Thanks John, Shortly after I posted I found that Find Unmatched wizard and tried it. It did just what I wanted. All I can say is don't try working on anything important when you have just come from a root canal. It tends to cloud your mind, vision, etc. Mea Culpa, Thanks, Gene

I have a coin inventory DB with the following tables; tblCoins - Holds all possible coin types available for this collection ID - Autonumber - Unique ID Country - Text- Country of mint CoinType - Text- Denomination and type of coin Year - Text- Year and Mint mark Remarks -...

Thanks, It was another case of looking so hard for the difficult answer that I totally overlooked the easy one. Thanks again, Gene

I have three reports that I print out after each piece of equipment is set up. All three reports are based on the same qry. I am just starting to learn some VBA and was wondering if there is a way to create one control that will run all three reports with the option of viewing them then...

Sorry for the double post. The site gave me an error message when I tried the first post and indicated it didn't take. Gene

I use an HTML page as a menu for PDF files on a CD. Is it possible to open the PDF files in Adobe Acrobat from a hyperlink with out having it open in a browser window? I can open it in a new window with <a href=&quot;#&quot; onclick=&quot;window.open('http://www.egp.com')&quot;>Here</a> but...

I use an HTML page as a menu for PDF files on a CD. I would like the PDF files to open directly in Acrobat reader when the link is clicked, rather than open in the same or new browser window. Is there a relatively easy way to accomplish this? <a href=&quot;#&quot...

I have a table of customer names and info. I want to be able to enter the customer's name in the name field of a form and have the address, city, zip, tel. etc. fields automaticaly filled in with the customer's info. I am suffering from severe brain fade on this one. I pretty much have...

Kev, That's what I was looking for. I had done it once before but couldn't remember it. Must have had a brain fade. Thanks, Gene

I want the Switchboard to open maximized when the database is first opened. There are also other forms I would like to force to open maximized. Is there a way to do this built into Access or with code? GEne

Peter, You hit it exactly! I knew it was referencing a different type of value but could not figure out how to avoid it. I guess thats part of having to teach myself. Thaks for the solution, Gene

I have a spread sheet with the following columns: A(Date) Formatted as Date; B(Total Dividends) Formatted as curency with a constant value of $3.45; C(Liabilities) Formatted as curency; D(Shares) Formatted as number, 3 decimal places with a constant value of 38.880; E(Current Price) Formatted...

Added Information; The FIND function works with all my other tables; it does not work with the aforementioned table or a form based on that table. I saved the table as an excel spreadsheet then imported that spreadsheet to a new table. I can now search the data in that table. I renamed the...