Scanning Barcode Into Search Box Works But Causes Multiple - Cannot Open Any More Databases - Errors
Aug 5, 2014
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.
I need to be able to run my database in the background but i still need to be able to input data from a barcode scanner is this possible. I have worked out how scan bar codes but when the application is minmised it no longer accepts the barcode data.
I am wanting to use a barcode scanner to input data into a field and bring up details based on the barcode. This is simple enough as long as the field you want to scan into has focus. Is there a method which will automatically populate the correct field with the scanned data no matter where I am on the form.
My client is a baseball league who started a Kids Club which has membership cards that have a barcode and their own specific number to monitor the number of times that the KidsClub members come to the games. They don’t have any software to go with the cards though. They asked me if I could help. I created a simple table in Access to capture the name, address, telephone, email, number of games attended. The cards have a barcode on them, and they would like to be able to scan the card with a USB handheld scanner and have the number of games attended field to be updated by the scan. Each card has its own number that is programmed into the barcode, which could be the primary key for Access. Can you offer any assistance in how to get the scan of the card to update the "number of games attended" field I created based upon the barcode number?
I designed an inventory control software and we are managing our stock through barcode scanning, it is working well although i have a problem to solve that i have put a combo box for scanning code 39 barcode, upon scan the barcode a code is entered into combo box and then we need to press the "ENTER" key to go for new record, we would like to ms access form to automatically go to new record when a code input from scanner.
I've got a number of different append and delete queries running on command on one of my forms, in which it makes a copy of all of the data on that form and included subforms, copies them into another table, and then deletes all of the data from that record. When this runs, I get an error saying "record deleted" and then another error message. Now it is deleting the records and it is moving them, however when i go onto one of the subforms, all the fields in the subform show "Deleted#" until i go back to the previous record or forward to the next, then they clear, but everytime it brings up the other error message it says "end or Debug" which I don't want it doing.
I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this? The form basically holds a subform of textboxes that have barcodes. I want the user to be able to scan a barcode which will then find that barcode in the subform and assign it with a DateOut = Date() ...
I have a simple bit of code that searches for a [User Name] field the basic idea is I place a field called "search" on a form and set its on change to
Private Sub Search_Change() Search.SetFocus strtarget = Search.Text If strtarget < "a" Then strtarget = "a" [User Name].SetFocus DoCmd.FindRecord strtarget, acStart, False, acSearchAll, False, acCurrent, True Search.SetFocus Search.SelStart = 100 End Sub
it takes the text entered in the search field and calls it Strtarget then resets focus on the field I want eg [user name] once the search has done it resets the focus on the search field so you can carry on typing this works very well unless the search string starts with a letter I.
I have been asked to create a database very quickly for a small group that needs to scan multiple pages into an Access 2007 form. They they would like all scanned documents to be converted to PDF and stored on a shared network folder which can be accessed by their group. I have tried several ideas posted but, I have been unable to get any to work correctly. Any sample of working database that the scanning portion is working? I am so involved with other projects right now that I just don't have the time to create a scanning process on the database.
I'm trying to modify an existing database to make it easier and faster to search for homeowners. Currently, there is a search window that has two radio buttons, and a list box. one radio button is to search by address and another by last name. When you click one of these, it shows all the records in the list box. The problem is that 1. this is time consuming scrolling through over 300 records, and 2. more search options are needed, to include tag numbers of vehicles, and also phone numbers of residents. What Im trying to do is replace the radio buttons with a text box that will search all of the wanted fields, and produce a list of results in the list box. I'd rather not use a search button and just have the list box filter out as you type, but if a button must be used then thats fine. I've tried different ways, and searched all over the new for weeks, but cannot find the solution to my problem. Here is the current and original code. Thanks in advance for your help....Mike
Type of Search = Radio Buttons By Search Type = List Box HOMEOWNERS = table where all the info is located GET = cmd button to open form with results selected in list box
--------- Private Sub Option35_GotFocus()
End Sub
Private Sub Option37_GotFocus()
End Sub
Private Sub Type_of_Search_AfterUpdate() With CodeContextObject If .[Type of Search] = 1 Then .[By Search Type].RowSource = "" .[Search Text].Caption = "Select the Last Name to Search for" .[By Search Type].ColumnCount = 3 .[By Search Type].ColumnWidths = "1.5 in;1 in;0 in" .[By Search Type].BoundColumn = 3 .[By Search Type].RowSource = "SELECT DISTINCTROW HOMEOWNERS.LastName, HOMEOWNERS.FirstName, HOMEOWNERS.Address FROM HOMEOWNERS WHERE ((Not (HOMEOWNERS.LastName) Is Null)) ORDER BY HOMEOWNERS.LastName, HOMEOWNERS.Address;" ElseIf .[Type of Search] = 2 Then .[By Search Type].RowSource = "" .[Search Text].Caption = "Select the Address to Search for" .[By Search Type].ColumnCount = 2 .[By Search Type].ColumnWidths = "1.5 in;1 in" .[By Search Type].BoundColumn = 1 .[By Search Type].RowSource = "SELECT HOMEOWNERS.Address, HOMEOWNERS.LastName FROM HOMEOWNERS WHERE ((Not (HOMEOWNERS.Address) Is Null)) ORDER BY HOMEOWNERS.Address;" End If End With End Sub Private Sub Get_Click() On Error GoTo Get_Click_Err Dim Criteria As String Dim MyRS As DAO.Recordset
Set MyRS = Forms![BASIC DATA].RecordsetClone Criteria = "[Address] = """ & Me![By Search Type] & """" MyRS.FindFirst Criteria If Not MyRS.NoMatch Then Forms![BASIC DATA].Bookmark = MyRS.Bookmark End If MyRS.close Set MyRS = Nothing
I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.
I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.
So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .
Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?
this is the code that im using to help me with a listbox and a search text box that is embedded on my main form. it works ok. The problem is, i was trying to link an already filled out Table with data to this interface.
When i key in information from the form it works, but when i just enter stuff through the table (which was already completed and handed to me) When I click in the listbox on the main form the code window just pops up showing this section of my code. Help./
Drag and Drop works great but how do I open a reports based on what I selected? I have two list boxes the first is "items not selected" and the second is "Items selected" now I want to create a button that open a report showing the result from "Items selected"?? Hope someone can help I've been to ms access web site but our firewall does not allow any down loads. Thanks in advance.
I will have a PC and a number of scanners in a production line. I will need at least 15-20 scanners and would like to plan for more if needed. When an operator clicks on a button I would like to have each of the scanners triggered and return the value. They can be done in turn or all at once (preferred for speed). I need to know which value came from each scanner. I would then compare the barcode read at each station versus what is supposed to be at that station and either pass or fail.
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.
Resolved the date range issue, thanks, now I have a problem with the query results. I have a query based upon several other queries that have the StaffID and the linking factor. When I combine some of the queries it works fine, but with others, seemingly those that have no valves or data in the tables, the query brings back no results what so ever.
The queries are running a simple count of records so they have, StaffID input, date range and it counts the records for that staff member within the date range. The second query gives a sum of the count of the first query. But when I try to combine the queries so that I can produce a report for multiple work areas for audit, I hit problems, is there another, easy way for me to do this, maybe creating a report from invididual query results and only combining them for the report itself.
HELP! Can not attach actual db because of sensitive nature of the information contained, but would be willing to create a like db as sample.
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've developed a ASP.NET website which connects to a secured access database (user/pwd combos with an .mdw file) and allows users to enter data into the database. After the "due date" the system is locked and the database is transferred to a local computer via FTP for processing. Using a VB program and MS Access Reports, the data is printed out in a convenient format and distributed.
Recently, the more users that use my system the more frequently I've encountered problems with connecting to the database. I've been told that access databases are not designed to be used in a multiuser environment and that I should use MS SQL or mySQL instead.
My users report occasional errors and the debug information on the error page shows an 'unspecified error' prompted by a OLEDBConnection object's open method. Secondly, occasionally in the FTP site I see .ldb locking files with 10-20 locks on the database and the .mdw file held by the web application. I'm using a utility class that connects to the db in the constructor and closes the connection in its finalize method.
Code:Protected oConnection as OleDbConnectionProtected Sub Initialize() sConnString as String sConnString = "Provider=Microsoft.Jet.OLEDB.4.0....the rest of the connection string with data source and passwords oConnection = New OleDbConnection(sConnString) oConnection.Open()End SubProtected Overrides Sub Finalize()oConnection.Dispose()End Sub
First, is there something wrong with this code? Is it not being run at the initialization and finalization of each page load? Secondly, is there any way to avoid db connection errors without moving to ms sql?
I have a simple access database that 26 clerks in my office use to enter their weekly tasks. The database is split into a front end and back end, with the back end stored on a shared drive that we all have access to. We have been testing the database for 3 weeks with 5 clerks and no issues. This week is the first week that all 26 have used it, and immediately we encountered a problem.
I think the problem is happening because one of the tables in the database is linked to an excel spreadsheet. When multiple users try to use a dropbox that is linked to this table simultaneously they get an error message. I saved the excel file as a shared file, but this did not correct the problem.
I made a copy of the database before I split it. I know I can fix this if I import the excel spreadsheet into a copy of the database, link this table to the dropboxes, split it again, and redistribute it.
would like to leave the front ends linked to this spreadsheet, because we update it regularly. If not, we will have to have somebody update that particular table in the database intermittently.
I'm having trouble opening up the tools I am developing in Access for multiple users. I split all my databases so the users will only interface with the "Front End" and I just tried saving one as an ACCDE file. I had the ACCDE file open on my machine and asked another person in the office to try opening it (all our files are stored on a network drive, which is already identified as a trusted source).
She got the following error message:
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms, and reports. You should back up your database before attempting to open the database and delete the VBA project"
How do I fix this? I don't want to publish several Front End Access files since each person in my office will ask me to customize their file and my supervisor wants everyone working off the same file. I thought the point of Access was that multiple users could open the same file and make data modifications. How do I achieve this while retaining all the fun, creative VBA solutions I have developed?
