Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.
View RepliesI working in a database. I want to open another database and go directly to a specific form (not the default form). How do I make this happen? Below is what I have so far.
Dim accapp As Access.Application
Dim appname As String
Set accapp = New Access.Application
appname = "M:MPFMPF_Mgmt_Info_SystemSGLIPrepToolSGLIPrep Tool.accdb"
accapp.OpenCurrentDatabase (appname)
accapp.Visible = True
I want my db to open with only the Main form visible. Nothing else. I don't want the users to be able to see any of the tables or menu options etc.
Can I do this and if so how?
I have built a database and setup my Queeries and Reports and setup my securities. What I want to do is make the Form open from a short cut. I can create the short cut with the security privilages but after the proper name and password is entered I want it to open straight into the Form. How do I get my database to do this?
View 14 Replies View RelatedI've made my database, now I can remember in older access I could make it so when I click the database you would only see the form and not access its self. Is it still possible to do this in access 2010.
View 1 Replies View RelatedI have a button on my main db, that opens a second db using hte following code:
----------------------
'Dealing with external objects, use inline error trapping
On Error Resume Next
Dim appAccess As Object
Dim db As Database
Dim strAppPathName As String
Dim strAppName As String
Dim strTimesheetPathName As String
[Code] ....
This code works great to open the other db, and handles wheter the other db is already open or not, but I cant seem to pass the variable to the other db using the startup switch /cmd.
I suspect if I used the shell method it would pass the cmd , but I havnt found any way to test if the db is already open with the shell method.
How can I pass a variable to the other db when opening it using VBA?
i want to ask is there any way to open another access database using when click button at form.. for example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb. can these possible for me to do it..?
View 3 Replies View RelatedI'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open.
Code:
Private Sub btnDetail_Click()
DoCmd.OpenForm "fJob", , , , , , Me.Name
Forms![fjob]![txtJobNumber] = Forms![fJobAlphabetic]![fJobAlphabeticSub].Form![JobNumber]
End Sub
I want to ask is there any way to open another access database using when click button at form.. For example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb. Can these possible for me to do it..?
View 4 Replies View RelatedI have an Access DB with a form that allows the user to select a new backend database. I can connect to the backend and then .refreshlinks but nothing on the form is updated. I have tried requiring the form but that doesn't do anything. I've tried loads of other things, refresh, recalc etc., but nothing updates the open form.
The only way I have managed to get it to work is to close the form and reopen it, then it shows the data from the newly linked backend database.
While it works, it doesn't look good but also there seems to be some problem with it because eventually it reports an error saying "cannot open any more databases" and when clicking OK comes back with "An error occurred while sending data to the OLE server (the application used to create the object" and a whole bunch of other messages.
I think it might have something to do with the fact that the form has a number of MS graphs open on it, but I'm not sure. Also, I can't track down a particular line of VBA code which causes this error.
how to update a form after changing the backend database.
Access database 2007: I have a database with some forms init but when i type my username and password to open the main menu to insert data the form shows 1 second and closes the whole database. I don't know whether the problem is the VB code or the microsoft.
View 14 Replies View RelatedI have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies View RelatedI have a database that has a main form, and from that main form there are buttons that open their respected forms. I am curious as to how I control the size of all of my forms. They are all pop-ups at the moment. It all works fine on my monitor, but when opened on a smaller monitor it is too big and I can't even see the bottom of the screen. The main form is set to open automatically after the user logs into the database and it opens to fit the screen. also, all of my forms are modals.
View 4 Replies View Relatedi have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedWhat is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application?
If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
Thanks very much.
Hi,
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.
I'm very lost. Thanks for any help.
I have one database and I want the ability to click on a button and open up another database. Can I do that?
View 1 Replies View RelatedI can't open my database...
It was open yesterday and after a power failure computer turned off...
2day I can't open it...
Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...
I tried to import the objects in other database but can't do that as well...
Is there any way to repair the database???
Thanx and regards,,
MPB
I have problem once each day when I open Access for the first time. I get an error message "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.". It asks for a file name and insists on compacting (I think) and saving the database. I go through this several times saving it under a diferent name each time until I get the warning "Security warning Some active content has been disabled. Click for details." with a button to disable it.
View 13 Replies View Relatedwhen i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.
View 2 Replies View RelatedHello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...
I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.
Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?
Thank you! :D
We've got a client that runs two access 97 based databases on their network. up until recently both databases worked
fine on all workstations (all XP Pro).
About 3 weeks ago they called me to report that one of the databases would not load on 3 workstations. It opened
fine on all the others. I checked out the permissions on the database (which is stored centrally on the server) and
everyone had full control.
Within the last week they have added two new xp pro workstations to the domain - neither of which can access the
database in question. they can access the other database no problem - as can all the other workstations.
The occurs as follows:
1. Double click on the icon for the database
2. access 97 loads but does not load the database's interface - instead it opens an empty version of access (with
file menu etc at the top)
3. no specific error messages at all.
4. close access and the standard xp program crash message appears (see screenshots below)
As mentioned above, other workstations can open the database fine.
the only thing that has changed on the network is the installation of some server and workstation based production
software - we have not yet consulted with the company that installed this - we felt that if it was this software
causing the problem then all workstations would be suffering. we wil have to consult with them once we've exhausted
all the possibilities.
Thanks in advance for any advice
http://www.techresource.co.uk/error1.jpg
http://www.techresource.co.uk/error2.jpg
Hello all,
Please help with this:
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Thanks for your help!
I am getting the following Error:
"This database is in an unexpected state; Microsoft access cannot open it.
"This database has been converted from a prior version of Microsoft access by using the DAO CompactDatabase method instead of the Convert Database command on the tools menu. This has left the database in a partially converted state.
"If you have a copy of the database in its original format, use the convert database command on the tools menu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."
The database is on the server. Nothing was changed. Someone in our IT department says they simply opened it and then closed it. I think that they had their access program set to compact and repair on close.
I have tried to import the tables but am gettting the same errors.
I have the original database but it is an old backup that is missing data.
Can someone HELP
I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
Hi,
I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another application program (the database file is still opened), user2 can open the database, then both users can access the same database file.
Why do we have this problem? How can I fix it?