Search results

I'm trying to buuild a proofsheet view on a form that will allow me scroll thru all photos to do a quick visiual scan. I know with reports you can do multiple columns but it does not appear to work with forms. I could use the report to display this but I'd like to have click functionality to...

If you haven't found anything that works already. Check out the "transfertext" function under macros. I'm using this and it works great. Simple and effective.

I have a Autoexec macro that runs thru an update process several times a day automatically and when complete sends an email to me that tells me all is well. I'm tired of deleteing these confimations now and would like to change the macro to only send the email on error or when the macro does...

I have a macro that runs thru an update process and when complete sends an email to me that tells me all is well. I'm tired of deleteing these confimations now and would like to change the macro to only send the email on error or when the macro does not complete running. I'm hoping it is a...

Thanks! There's a lot of good information here. I'll see what I can do with it.

Thanks pdx_man, I'm not worried about the kerf. The 20' stick is actually 20'3". I guess the problem with just doing division by 20 is that you won't always get a clean whole number. ie. if I need 1 @ 20 1 @ 20 1 @ 18 1 @ 15 1 @ 10 1 @ 8 1 @ 7 1 @ 6 1 @ 6 1 @ 6 1 @ 2 the total length...

I have a series of queries that take in part numbers for stocklength materials, qty and cut size needed. It process a Bill of Materials that tells our shop what to fabricate. I am trying to determine how much stock material to pull from inventory to give to the shop to be cut. I am able to...

I want to have a user enter a MM/DD/YY value and then have access populate a table with the Monday and Friday Dates for each week. I think if I can tap into the system calendar it may be possible. Has anyone done something like this? Your help is greatly appreciated. I don't want the end...

Thanks for the input. I've not heard of an Import Spec. I did a quick search, is this new to Access 2000? I'll have to look around to find it in 97. Always good to hear something new. Thanks.

formating Lost on import BINGO! I guess mine is looking at the first record it imports. I slipped a mock record into the first line to force the format and all looks good. It would have taken me forever to think of that. Thanks for your help and fast reply.

I'm importing an excel spreadsheet into a table in access97. The field in question has text formating though most of the contents are numeric. When the import script runs, I've told it to delete the existing Access table and import the new Excel version to replace it. This happens as expected...

I had the sendobject in a macro to send an email to me when it finished running. Out of the blue, it stopped sending emails. It will run correctly from all machines except mine. I've seen this message before but whatever the problem was always went away. Now it appears permanent. Does...

I think I found a solution. Dim appPPt As PowerPoint.Application ' Set a reference to the PowerPoint Application object. Set appPPt = New PowerPoint.Application If appPPt.Visible = True Then ' Close the previous presentation. appPPt.ActivePresentation.Close...

I'm opening powerpoint from access to display a powerpoint presentation. At the end of the presentation the viewer clicks a button to return to Access and view other presentations. The problem is Powerpoint stays open. I need a way to close powerpoint when the presentation is over or before...

Holly Smokes, That was easy! Thanks for the tip.

In my database there are many tables... :) I have installed a new version of an application that has revised the names of these tables in a new database. I want to try to equate my old tables to the new ones so I can rebuild the links. Is there a way to pull a list of all tables and export...

Maximum Database Size We do have many queries running in normal operations and we also run queries that update many tables that feed other DB's. Data appears to be intact and all is well! Thanks Again.

Maximum database Size It Dropped from 1.04 G to a little over 6 M

Maximum Database Size Thanks to everyone for the help. I finally realized that the database had compacted but Access had not deleted the orginal huge DB and renamed the new compacted version to the old name. It had named it 'db1.mdb' and it got mixed in with all my other DB's. I went in and...

Thanks, Good Suggestion.