I am using an Access 2007 front end linked to an Access 2007 back end. I have a Report that the user operates by selecting the information he/she wants to see on a pop-up form and clicking a button. The Report works perfectly unless another form, called Shows Form, in the database is opened. When Shows Form is open the Report/button on the pop up form generates Error 3048: Cannot Open Any More Databases. Also when Shows Form in open, the Query that the Report calls on also won't run. The Query gives gives the same error - Cannot Open Any More Databases.
I have been through my code with a fine tooth comb to make sure all DAO.Recordsets and DAO.Databases are closed after they are used. The troublemaker Shows Form is quite complex and has many sub-forms (11), on a tab control (9 tabs). The Shows Form is the work horse of the database and the User needs to have this form open all of the time. It is inconvenient to have to close the Shows Form in order to use the Report. I am suspecting, through my internet reading, that the multiple sub-forms in the Show Form are using up resources and causing Error 3048.
I thought maybe I could look at coding the sub-forms to open only when needed - when the user clicks on the tab containing the sub-form. Would that conserve resources?
I am using Access 2010...I am suddenly getting the error 3048: Cannot open any more databases...The error occurs on the line of code: Set db = CurrentDb()
Code:
Private Sub SetInUseFalse(TelesalesId As Long) Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("Select InUseBy from tblTelesales where Telesalesid = " & TelesalesId) Run Some Code
[code]....
Why should I suddenly get this error? The error appears to be in a loop. If I close the error message, it pops up again. I have to close the database using Windows Task Manager.Is there a maximum number of connections? But I religiously close connections as indicated above!.I am only connecting to the current database (backend form frontend)Am I opening / closing connections & recordsets correctly?
I have a db that runs call stats (Master) this exports to several Department (Slave) Databses. The Slave db's can be accessed by any of number of Managers.
My problems (Amongst others!) is that I run the master every 15 mins and the slaves are linked to the master tables. How can I set this up so that these slaves can be updated whilst they are logged into?
I'm having a problem on a workstation that I've always used to create databases in Access. When I open any of my saved .mdb's I get a the error "end query expression" with the table name. The message gives me the option to click OK or Help and Help refers to "<Message> in query expression <expression>. (Error 3075)".
I've copied the .mdb's to another PC with Access installed and they open with no problem and I've removed and reinstalled Access on the problematic PC but still the same problem.
Also, I have a UPS Worldship shipping application that uses an Access database and when it opens it gives me a Micrsoft Visual C++ runtime error then closes, which may or may not be related.
I get the sense that something is corrupted in either Access or Windows XP but I'm not sure where else to look.
This is the second database where this has happened to me. I have code to print a report (with several sub-reports) to PDF. When it prints, only the first couple reports appear. The rest of the pages on the PDF are blank. If I try manually saving to PDF (Save As > PDF or XPS), I get the error "Cannot open any more databases."
In the other case, my "solution" was to copy all the queries into temporary tables and use the temp tables as the datasources for the reports.
Any way to list all currently opened Access databases? It feels like this must be possible by referring to the databases collection, but I just don't know how.
Also, is it possible to refer to controls on a form in one open database from code in another database? (and obviously if so, how?)
I'm scanning bar codes into the record search box, most of the time it works as it should but occasionally I get multiple "cannot open any more databases" errors. It still finds the product record but the error messages are super annoying. I am sure to clear the memory on the scanner each time before I scan in a new barcode but it doesn't seem to matter. Also sure to only have one or 2 forms open at a time, that doesn't seem to matter either. Most of the time I don't get the errors but when I have to click through like 10+ error messages (all identical). I only have one database open so I'm not sure what it even means. Also I have tried this in 2 different forms and it's the same for both forms. Seems like I get the errors in my initial scan and then after clearing them it seems to work without errors.
Extreme novice small business trying to use Access, need some help.
I want to setup a simple payroll system in Access - we have a database of 13 employees already in Access as well as a form we created with fields to enter hours and calculate total due. This may end up being very easy or very hard, but I'd like to know how to, first, set up the form so that it performs the calculations (hourly rate x hours) and then enter this information into another database that will keep track of the weekly payroll...is this far more complicated than I think? Any help/suggestions/points in the right direction are much appreciated.
When I import a form with the Navigation control on it The following attributes of the navigation buttons are changed to #FFFFFF:
Hover Color, Pressed Color, Hover Fore Color, Pressed Fore Color
I was hoping to be able to automate the updating of customers databases by sending them a database which would export the required objects rather than the whole front end database. I can think a way around this by including code in the form so that it changes the attributes to the desired values, which are:
Accent 1, Accent 1, Background 1 and Background 1. But I would rather not have to do that.
It is interesting to note that the Border Color attribute is not changed on importing.
when 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.
I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.
I have a bit of a problem with a database in Access 2013. On 1 of the forms, I have a number of buttons which open other forms and filter the results using an embedded macro. All has been well until a few days ago when error 2950 pop up box started appearing. After fiddling around for a while it all works OK (without actually changing anything) until next time the database is opened. I checked to make sure the location is "trusted" and all seems OK.
In ContactIDForm it contain 1 textbox name 'TextBox' with Button Name 'Btn'
In ContactIDForm there is only 1 Text Box ContactIDTextBox and 1 Button. User Enters ID in TextBox and On Button Click Event it should check data from TextBox in Table name (ContactDetailTable) in field ContactID and if there is record matching, ContactInfoForm should Open else NewContactForm should open with ContactIDTextBox value in it.
I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens...
Private Sub Command12_Click() DoCmd.Close DoCmd.OpenForm "Frm2" End Sub
But I want it to open Frm2 using the ID from the previous form. The stumbling block for me is I close the first form before opening the next so I cant pass the ID across.
i am new in Access and i make one project with it. Now i need when i open the indexForm i want open only it and not the access with table,queries,reports and access menu.
I have a Access DB that has securtiy thanks to baxter, however everytime i open a form the windows bar on the bottom starts to get cramped. is there a way to elimante that? For example at least hide them ? I have a form that has 3 forms and next thing i noticed i have no more room... Thank for any advice..
I've created a database which works fine and i've tested it extensively on my machine. It is saved on a network drive which other users have access to. I've added a simple security log-in procedure (which I picked up from a sample posted on here) which only determines what buttons the different users can see on the switchboard which takes them to the different areas of the database. The problem I now have is some of the forms aren't opening.
Other Users who try and go into the forms that they have access to - even some of the generic ones cant open the actual forms as it crashes and comes up with the generic error message - "Microsoft Access has encountered a problem and needs to close".
I cant understand why this is happening. The security measures are only linked to the main switchboard and it works fine as it opens up all the other relevant switchboards as required. It's just certain forms on the other switchboards that refuse to open. I hope I have described my problem adequately and someone has encountered it somewhere or knows what I'm talking about and can help. Please let me know if you need further clarification.
I am working on a database to hold the data regarding our company vehicles. I have a table for the details of the vehicle (i.e Registration, VehicleType, Drivername etc) and a number of tables for different types of equipment (AccessEquipment, LiftingEquipment, StandardEquipment and others).
I have a form that runs on a query with the criteria to search for the registration number. I have also set up forms to show each type of equipment to use as sub-forms. I would like to have on this main form a number of command buttons that would open the specific sub-form on the main form.
How can I do this? Any ideas would be greatly appreciated?
When I open my form, it doesn't open at the top of the page. How do I get it to open up at the top, so that I do not have to use the scroll button to go up to top?
I have a main form with 2 check boxes. The title of the first box is Manufacturing and the title of the second check box is Purchased. I have 2 different forms based on the titles of the check boxes. After the user checks one of the boxes, I want the user to click a command button which opens the correct form based on the box checked.
Using the On Click for the command button, I created this code, with no success:
Dim stDocName As String
If Me.Check14 = 1 Then stDocName = "frmManufacture" DoCmd.OpenForm stDocName Else If Me.Check16 = 2 Then stDocName = "frmPurchase" DoCmd.OpenForm stDocName Else stDocName = "frmError" DoCmd.OpenForm stDocName End If
Hello- I’ve searched the forums and was not able to find the answer, so I was hoping someone would be able to help with this.
I would like to open multiple forms (cascade) in the same .mdb file when the first form is opened. There are a total of 4 forms. This is probably a very simple thing to do. I'm not much of an Access person to simple things like these throw me for a loop. Cheers to anyone who can help. -Tom
