Search results

http://www.lebans.com/printfailures.htm This link appears to address the problem of not being able to print reports with links to pictures. There is a sample database to download along with some code. I haven't tried it yet, but hopefully it can help me and others.

I googled microsoft access specifications reports and got the link: http://office.microsoft.com/en-us/access/HP051868081033.aspx Nothing about images or image size. Any other ideas?

. . .And how can 20 jpg images take up so much computer resources when I can take those same images and embed them in Microsoft Word or Excel and have it print beautifully? I can do 100 images in Word and it takes a while but it is successful. It appears that Access dominates my Workstation...

Thanks a bunch for the time to reply in such detail with more hints than I asked for. How do you look up Access specifications for reports?

Check out sample database posted by OldSoftBoss under "Sample Databases" off the main forum page. http://www.access-programmers.co.uk/forums/showthread.php?t=120834

Does anyone have a recommended way to deal with images (ie. linked to file, OLE object embedded, others I'm not aware of)??? I have a report which summarizes the history of a project. In this report I have a subreport which has task information. As a user enters task information they have the...

I have a problem with my report not showing all my linked images. I think I have found the problem (see background below), but wondering if anyone knows the solution, a work-around, or anything I can try. I need to be able to print my reports. HELP. BACKGROUND I found OldSoftBoss's...

That actually worked!!! I didn't get a response after a few days and I assumed this was just me who experienced this. I was looking into see how to remove the thread so it didn't take up space anymore. Thank you for your reply. Gratefully,

I have a report with 3 columns organized to fill accross and then down. I use this report as a sub-report in a few other places. It seems that whenever I try to use "Page Setup", it takes 30 or more seconds to open the page-setup dialog box. This is true for the report itself and any report...

I searched and found a very helpful thread for understanding and working with many-to-many relationships. The database Pat Hartman attached to the following thread was very helpful: many-to-manyDB Now I have an additional question that I will base on the database attached to the...

Thanks, That did the trick. That must be a difference between 2000 and '97. I just expected the translator to figure all that out for me.

I have encountered an error in converting my 2000 database back into '97. My database has the user check out the next available number for an experiment ID [TestID]. After clicking on a "Save" command button the code assigns this testID # to an integer variable and closes the form. The...

Thanks Pat. It seems like you have personally saved several of my problems. You should go into psychology. I think I found another issue that might need your consultation, but I'll start another thread. Thanks again.

I unchecked the "MISSING" reference (CompatUI 1.0 Type Library) and the database works fine, even when I shut down and start up again, so I should be ok. I was not able to find the library or reference in the list when I went into check the references again though. Does that mean that the...

It makes sense. I printed the references box from the computer at home and I'll compare it with the one at work tomorrow. In searching other threads I saw a few cases where people complained that it fixed the problem, but that the references needed to be updated with every use. I guess I'll...

I have a database (2000) whose code works fine on my home computer, but not when I brought it to work to begin implementation. I make the following assignment in code in a Form-Load event: Forms![Experiment_Num_FRM]![TestNumber] = LastTestNum [TestNumber] is a textbox and LastTestNum is...

Dan-Cat -- Without going into a lot of incoherent babble, I thank you for your input. While the 'hard-coding' was not to my liking, it got me thinking on a different path that I feel will work wonderfully. It does get rid of all those secondary queries, but uses a modified "Query1". Thanks...

Good Enough. Thanks Pat.

What if I do need to maintain the query structure that was in the original Db1? What is not shown in the database is that the Experiments_Search_TBL (which will always only have a single record) stores the user's search criteria from a search form (not included in Db1). After the user has...

Filtering a Form Using a Query - See attached DB Please find the 1 attached MS Access 2000 databases that has been considerably simplified in order to demonstrate my dilemma. I want to know why Db1 works and Db2 does not. Db1 is attached to the post, but you can create Db2 by deleting column...