Search results

Sucess!!!! Yeah!!!! Thank you,

So far it is easy to open the database with various methods being available. But it appears that we have not found anything that could tell us if a specific database is already open. It is easy to see if an instance of Access is running but not which database. This seems to be the major hurdle.

Our security is unique I think. We have fe/be databases. The be network have Windows Group Security Policies. The fe is a password protected mde with the shift function disabled. The is a seperate mde (again with the shift function disabled) that opens the fe. The users do not know the...

I do change the caption. I tried using what I change the caption to and it does not work either.

A couple of questions. 1) Guus2005 Instead of FindWindowLike, do you mean FnFindWindowLike? Also what does if FindWindowLike("Microsoft Access") = 0 then ' Not found do??? 2) mearle This looks like an easy solution without opening a new instance if it is always running. But how would you open...

I can run this and it works except: If the app is already open it tries to open another instance. It can't so it opens a blank DB window. 'Define as Static so the instance of Access 'doesn't close when the procedure ends. Static acc As Access.Application Dim db As DAO.Database Dim strDbName...

When I run this with Calculator as the input it works (when the calculator is running), but I cannot seem to get it to reconize and Access window, email window, web window etc??? I have tried entering the full caption and the partial caption. What am I suppose to use as the input???

How does this work?

I have been looking at the code from Microsoft for looking for applications to see if they are running. If you change the lpClassName to "OMain" that works for Access. The caption is a bit of a problem since in Access the caption is not only the program (application) title but also the form...

I have to publish a new version this week anyway. I'll try it then. It is important but at this point only the IT dept is running Office 2007 so that gives me a little time to sort this out. I'll let you know. Any idea why it did not work in 2007 but works fine in 2003? Thanks,

Well, I am not really sure. I believe that DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide does the same thing as [Tools] -> [Startup] and unchecking [Display Database Window]. Is this true? I got this code here and have always used it. Do you think this is my...

This is part of code I got from this forum. This part of code reads 'Hide the database window DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide I am hiding the database window with it. What table would I declare and how? I have been using this code for a while and...

I am having problems running my Access program in Office 2007. I have included two screen prints that give an error message. The only Select Object I have is DoCmd.SelectObject acTable, , True in my 'Starting_Definitions' code. This is called from the AutoExec macro. The file is an MDE file...

Yes that is a good idea except I would only have to edit the form(s) the sort exists. Rather than added another physical field to the underlying table, I probably could just add an expression to the query that is being used. Making that expression visible should work in a sort. Thanks, I'll...

I'm sorry but I am not following. Correct the queries are working fine. The subform works/displays fine when opened, used, printed, viewed etc... If I programatically change the order of the subform and back using the above, (just like the queries) then they no longer sort like the queries...

Good idea, Unfortunately, it is part of a larger field and used in several queries. Editing each query to sort by a new table that is created programitically isn't the best solution on this project. I think it is easier to not use the Val() since it does not work consistently. It isn't what...

Googled Ping and it works great thank you.

If I put a pause in the code, Which means I have to tab to the dos window and press the space bar or enter key it works. So I think this is a timeing issue of sorts. Do you know how to put a delay in the shell file?

how do you do that??

Same OS. When I had a desktop the 'My Doc' was server based, now it is physically local. Other than that I am unsure.