Forms Count Of Other Database Without Opening That Database Physically
Oct 7, 2005
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
I'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.
I need to know the procedure or event code for user login form at opening.
I am working on database which is almost done and i defined tables for users with passwords.
I need to know how i can assign Login Form to be appear on opening of database no other person than listed users should be able to enter or open database without password, to enforce this i made a login form.
I have a split DB that is in its (hopefully) finally stages of development. Using Access 2010. It is being developed both at work and at home on a 64 bit machine. The remainder of the machines are 32 bit.
All of a sudden one of my most basic sets of code doesn't want to work, but only on my machine at work. It works fine on my home computer and on other computers at work. It is the simplest of codes, run from frmNameA:
The desired sequence of events is to open frmNameA, find the active clients and then click on the [SequenceNumber] to bring up the related record on frmNameB.
When I do this on my computer at work, it asks for the query criteria for the [SequenceNumber] and the criteria for another field. On the home computer and others at work, it works just fine.
In a related problem, I have the following code on the OnLoad event for frmNameB. It opens all the related records for active clients that are in frmNameB. But if there are no related records, it is supposed to cancel the event. Again, it works fine on my home computer and others at work, but not my work computer.
Private Sub Form_Open(Cancel As Integer) 'code when opened from frmNameA and no record exists in frmNameB Dim MyReply If ClientID = "" Or IsNull(ClientID) Then MyReply = MsgBox("No record exits in frmNameB, Do You Want to Exit?", vbOKOnly) If MyReply = vbOK Then DoCmd.RunCommand acCmdUndo DoCmd.Close acForm, "frmNameB", acSaveNo End If End If End Sub
What I can't figure out is why this may be happening, where I might look for errors, and what I might do to correct this.
I have a form that contains a subform. The subform is a datasheet which calls the results of a query of 4 tables (tbl_companies, tbl_deals, tbl_products, tbl_vl).
In the main form there is a button which opens a report with a historical record of dates of value changes of each product up to a chosen date. This chosen date is determined by inputting a date into a text box.
This report also sources (tbl_companies, tbl_deals, tbl_products, tbl_vl).
When I try to open the report, I get the run-time error "3211".
'The database engine could not lock the table "Tbl_companies" because its already in use by another person or process.'
I'm guessing that because the query for the subform is already calling the table, the query for the report can't call the table at the same time?
There are 3 drop down button that should filter category of items in a database:
Category 1 Category 2 Category 3
Whatever users choose in category 1, it will filter the items in Category 2. whatever users choose in category 2, it will filter the items in category 3. users can choose 1 to 2 categories or sometimes the 3 categories. the items will show in a subform. the subform are getting the items from a query. the dropdown button gets its value from a Table.
My challenge is that, i want to get the number of items in Category 1 once users chose it. if they choose something in Category 2 the number of items will change also. there will be 3 textbox for Category 1 COUNT, Category 2 COUNT, and Category 3 COUNT.
as of now, what im getting is only the filtering of Category 1 and Category 1 COUNT.
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?
The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob
I have a question. I have a button on a form. When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database Dim rsMyRS As Recordset Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb") Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.
I tried that database on 3 different PC's with the same effect.
Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.
I am creating an order processing system and am using 2 tables
OrderHeader OrderLines
The OrderHeader table includes the number of orderlines on the order.
I want to ensure that when a user completes the order lines they don't up in a line number greater than the number of lines and want to programatically get the number of lines from the order header table.
The form links to the ID of the order header table by using a combo box, which works fine and I can even display the number of order lines in the combo box.
I don't know how to use an ADODB recordset to query the current database.
I can't use something like : objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:filesdatabase.mdb"
which i see all over the place, because I don't know where on the PC this will be running on it will be stored.
There must be a simple way to find out a value from a field within a recordset of the current application database?
My database is opening much slower than normal just over the past few days. When I run a performance analyzer it is telling me that my database is only being compiled in a partial state. How did this happen and what do I do to fix it??
I am hoping someone out there will be able to help me figure this one out! I have a database I just created which houses approximately data on about 500 physicians/practitioners - from their personal info to information regarding their licensures, liability coverage, and DEA. In order for us to be compliant with administration and government criteria we have to monitor expirations of their license, liability, DEA, and other things. We do this by sending letters/e-mails out 30 days in advance of expiration dates (which is a field in my database). What would really be great if when I bring up my database it would automatically give me a pop-up saying these licensures are expiring in 30 days and send out reminders. I am a rather new user to Access but I do recall a few years ago hearing something about databases that have crystal reports??? I am not sure if that is the same thing or not. I do have parameter queries set up from date to date but it sure would be impressive if I could get it to do the above. Or maybe another way to do this. Any suggestions????????? CMElady in :confused: distress!!! Thanks.
ive just upgraded our sales database from access 97 to access 2002. everything is fine apart from when i try to open the database twice on one machine - it wont allow this. In access 97 this was allowed and i normally had atleast 3 databases (all the same database) open at once.
I tried to search the forums for an answer but I still can't seem to solve the problem. I receive the "Not a valid bookmark" error message when attempting to open my database. I have tried the compact tool through access and also jetcomp but it just brings up the same error message on access and says "error compacting database" on jetcomp. Can anyone provide a solution to my problem in order that i can either open the database or else retrieve data from it? Many thanks, any help appreciated Jon.
I have attached the database in case you have any software which might be of use.
I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
I'm trying to create a log in form for my database using a tutorial I found here. [URL] ..... I got it working fine, but when I split my database into a front end and back end file I could no longer retrieve the record set for this code. I receive the error "Item not found in this collection" on the highlighted line of code below. I'm at a loss as to how I would retrieve the record set with a split end database. The code used in the log on button is below:
Private Sub submitButton_Click() Dim dbs As Database Dim rstUserPwd As Recordset Dim bFoundMatch As Boolean Set dbs = CurrentDb
I was wondering if anybody knew a way to disable the security warning in Access that pops up saying "This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"
If possible, I'd like to disable the message for just my database, but we currently don't use any other database anyway, so I'm not too concerned with turning it off completely if that's all I can do. I'm sure there has to be an option somewhere to not check for macros or something, but I can't find it.
If anyone knows how to do this or if you know that it is not possible, please let me know.
We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have no idea how it was set up. I think it may have something to do with being opened up exclusively. Is there anyway around this by creating a short cut or changing any kind of propertties?
Got something which has been bugging me like mad for weeks now;
We have a MS Access Database on a Citrix server and a local copy is downloaded to the clients directory when they log on.
When they actually double click and load the database(frontend) it loads for approx 4/5mins before it eventually opens. After that it is fine, unless they log off and back on again, then the same thing happens when they double click to open the database.
The Backend is stored on a seperate server with over 5million records on it.
Before we attempted Citrix we had a normal network and the frontend has always loaded fine on this.
