I found the following solution, hope it helps:
Dim retval As Double
retval = Shell("MSACCESS " & "[Fil path]", 3)
The "3" maximizes Access and places it in focus.
Is there a way to customize the wrapping of text in a label?
E.g:
304 S Maple Ave (--> i want next line to start on a new line in one single label)
Some City, CA 23455
thanks.
Cannot install option pack 4 (want to install iis 4.0) onto server or workstation. First receive message that option pack has not been tested on os with service pack > 4( I have sp6a). I click Yes to proceed with the installation. Then I receive the message that Invalid program arguments were...
The MS solution worked, however, I had other code running in the background, which got messed up. So it's back to te drawing board.
I did set the recordsource with a sql statement, however, looks like the sql statement gets stuck. That is the form is use for various functions, so there are...
Thanks for the prompt reply.
I don't think it's a circular problem. I already have the controls named differently, adn it does work on one machine, but doesn't work on another machine.
Any other ideas?
I am having the same problem. It doesn't only occur with TRIM, but I've used format as well. It seems to me that functions cannot be placed in the control source of the report.
It is is definitely not a recordsource problem (i.e. for me), since I can get the report work to display properly on...
Hi,
I upgraded my machine from win nt 4.0 workstation to server. In thec process I was able to save my original configurations were saved. More specifically, the registry was unaffected.
Now, I need to reverse the process, and downgrade nt server to a workstation. I was wondering if there is a...
I think the access project is already using sql server authentication.
When the user opens up access poject, system prompts them for userid adn password to access sql server connection. Is that what I think you mean?
Thanks.
Hi,
I have a MS Accress project (adp) databae as the front-end and SQL server as the back-end. When I try to access a specific report, I get the message that there is a problem connecting to the OLE server. Then the mesage lists the possible fixes. I haven't tried htem as yet, since I dont'...
Does anyone know of a way to view objects of another Access datbase within an Access Database?
Right now, we have it so that when the users click on a button, it opens up the other Access database. WE want it so that the user can view the items (e.g. reports) of the other database within the...
We have an access project (adp) front-end, and a SQL Server back-end. WE've implemented field-level security module which uses the user's login name when they first login into the system.
The problem we're having is how do we persist security such that the connection to SQL Server does not...
Thanks for the suggestion. I looked into the system security.
I had forgotten to mention I'm using SQL server as the back-end and Access Project (adp) file, so I'm using SQL Server permissions.
Any other ideas?
Thanks in advance.
Hi,
We have 16 users who are plannign to use a centralized MS Access Porject. Is there a way to do this, so that we don't get the message that the database is read-only.
Also, what does this meesage mean? DOes this message mean that users can still insert, delete, edit the data, but cannot do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.