Search results

Thank you everyone who replied! Harry, I used your code in Access 2000 and it worked like a charm! Even better than expected because I only need to compact the db before moving it to a seperate folder - so I didn't need to bother with the renaming, and deleting lines (I just specified a...

Thanks fuzzygeek! I'll look that up. Never heard of JRO before - what is that? Is it another name for ADO? Thanks again, -Sean

Hello all, I saw the SendKeys function - but how could I compact and repair another database? (preferably without adding any code to the target db at all). The reason is that I need a certain table deleted from the database I use for the web - so it would be nice to compact it afterwards too...

And if you have trouble with Nero's suggestion, then I would create a new db (linking to all the tables you need) - have the batch open the Access app using the AT function as mentioned earlier - then, have your VBA code execute in the On_Load procedure of the app. End your VBA code with...

Hello from Hull Erik! To get you started, look up the "at" function. It will allow you to schedule a file to run at a certain time. I can't test it here because I'm at work and they have disabled it (I would need Admin privileges) - security reasons I assume. Out of curiosity, what are you...

Hey Joe, I ran into a situation like this before. The culprit was that the user tried to run the sub again before shutting down the app. She agreed to always watch for that - my backup was going to be to research how to test to see if that certain app is open first, then proceed. If that is...

Hello, I work with many shared databases and the reason why I try not to refer to a query is because I don't want someone else to delete it either by accident or because they aren't sure wether it's even being used or not. It also makes it easier for people in your situation who have to take...

Hey Slate, To normalize - keep artist and cd seperate and then use another table to join the two: tblArtist artistID artistName ... tblCD cdID cdName cdYear ... tblMain artistID (foreign key) cdID (foreign key) Good luck! -Sean

Here is something I found from mstrmage1768 at Tek-tips. It works beautifully for reports (just need to learn how to tweak it for my use). http://www.tek-tips.com/faqs.cfm?spid=703&sfid=2533&newpid=703 -Sean

This is interesting, but I do not think that I can use this. I need to be able to open a certain webpage (using Explorer), select a printer and print that. Even forgetting the pdf part for now - do you know how I could just open and print a webpage? Thanks again! -Sean **EDITED** saw your...

Hey Fizzio - thanks for answering! The Shell function is where I started as well. Distiller kinda works by taking over the print driver. So if you were in a webpage for example, you print the page but you select Distiller instead of your printer. You will then be prompted for a file...

Hello Forum, There is a certain web page I need to periodically pdf. Rather than me open it up (always the same web address), select distiller, save as the same old filename - could I use vba to automate this process? (I know it sounds lazy - but there is a perfectly good reason why I would...

Thank you Doc_Man - DSum was what I needed (and it was a lot easier than my query). Thanks for the extra info too! -Sean

Hello, I'm trying to use a query result in my code and am obviously a little unclear on something. What I have is: Dim MyResult MyResult = DoCmd.RunSQL("...sql statement that I know works ...") The SQL statement is a sum - so it only returns 1 result which is why I thought the compiler would...

Thanks anyways everyone - I have managed to solve it. For those interested - it turned out to be kinda easy! Whenever "Notes" wasn't null, I assign the value to an empty text box in the footer. Then, on each page header, I assign "" to the textbox (this is so that your footer doesn't appear...

Hi, if you subtract today's day by itself, it will go back to the end of the previous month. I don't know if you can do this directly on the report or not. Here's how to do it in VBA. Create an unbound textbox (here it's called Text0). When you go into the VBA part, select Detail from the...

Hello Forum, this problem seems easy in theory - but I can't seem to get it! The last column is my report is one for misc notes (called "Notes"). It occurs very rarely so I would like to remove it to create more room for my other columns. What I'd like to do is add an asterix beside one of...

Hey Brian, Dim strEmail as String strEmail = lstBox.Column(0) DoCmd.SendObject , , , strEmail, , , "Here's the subject", "Here's the body", True (if you don't need to see the email to edit or verify, change the last setting to false). Hope that helps! -Sean

Hey Jonno, Something must always have the control - there is really no way around this! What you can do though is set one of the buttons to have Tab Index 0 (it will be distinguished by a dotted square within the button which is not as obvious). Really though - you should think of usability...

oops - here's the document (I do this with email all the time too!) :)