Search:

Is anyone familiar with a way to automatically close a database if not used for x amount of time? I can obviously code it, but why reinvent the wheel

Thanks that is more or less what I ended up doing also. Just wondering if there was anything else.

I have seen different variations on code for this. Anyone have any favorites?
Thanks

here is some code from Dev Avish, that I modified to use a registry setting. I always appreciate his code and am very grateful

Is there an add in or code to do this? If so is there a way to code it to remove the recurring appointmnets but only for those days?
Thanks

This is not the place to discuss Office 2010 Beta. Moreover, this topic is about starting Excel from Access, please don't hijack it.
Sorry you are correct

Is Office 2010 on its' way?
I ave been using the technical preview (beta). Not any major changes in the front end of Access, did not yet get a chance to sue the new macro editor which look...

The code itself is correct, so there appears to be a problem with the Excel object. Does the problem persist after restarting your PC?
due to some other issues also I uninstalled 2010 and 2007 then...

The code itself is correct, so there appears to be a problem with the Excel object. Does the problem persist after restarting your PC?
yes. I think it might be because I have both 2007 and the beta...

Is there other code between the line

Set appExcel = CreateObject("Excel.Application")

and

Set wkb = appExcel.Workbooks.Add()

that you haven't posted?
no- just the rest of strsql that is...

Does it make a difference if you omit the brackets?

Set wkb = appExcel.Workbooks.Add
No, I had tried that first.
Thanks

I have the following simple code and have no idea why it is throwing an error:

Dim appExcel As Excel.Application
Dim wkb As Excel.Workbook
Dim wst As Excel.Worksheet
Dim intCount As Integer...

Open the database on a PC with Office 2003.
Delete the reference to the Microsoft Word 12.0 Object Library, then set a reference to the Microsoft 11.0 Object Library.
Check for other missing...

Brilliant. A lot easier than reacordset clone.
Thanks as usual

If I use the filtering options on a continous form, can I then use the recordsetclone to get only those records and then save them as a table or send them to word or excel, as the basis for a...

I just installed it. A 15 page report that I wanted to export to a RTF file, yesterday after 20 minutes of working, gave back an overflow error. Today it ran instantaneously. To me this is...

You can use the built in database documentor in database utilities

It still jumps back to the first record on the subfom.Istere any way to stay or retrn to the record I was editing


Try

Me.Parent.Recalc

When I change a record on the subform I want to refresh a textbox on the main form that is based on a DCount of the specific records on the subform. How could I do that but still return record I was...

Another option that is much more expensive is FMS Total Access Analyze ,but it does what you need and a lot more. I have used it http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

In other words there is no docmd.... that calls the mail merge wizard?

How would I call either in VBA or Macro the mail merge wizard to be already pointed at a particular table or query?
Thanks

I am going to try it in stages, but first I need to get my main computer repaired so it will take a some time. Thanks for the encouragement.
If I am using accdb and there is no replication support,...

Anyone have any experience using Live Mesh or something similar to synchronize a Back End in different sites. I am aware of the issue of making sure that you do not have simultaneous changes, but are...

I created a database in 2003. I then used 2007 to downgrade it to 2000 for someone, When I installed it on their computer, it refused to open and gave me a message "Cannot Create Database Window,...