Search results

Now, we have a sharing issue. When the FE (currently located in a network folder) is opened by one user, a second user cannot open it, either from a shortcut or by navigating to the app on the network. They double-click and nothing happens. The FE mdb is set to shared, as is the BE mdb and...

Folder permissions was indeed the problem. The network permissions on the 2 folders being used by the app have been changed to full permission for everyone on the network and read-only is gone for everyone. The confusing thing for me was that when I opened the app, it was not read-only. This...

I'm running an mdb in 2007 and it is running in read-only mode. The read-only mdb has attached tables in several external mdbs on the network. I think I have determined that the read-only issue is being caused by the network folders that contain the external mdbs. I am not a network guru, nor...

I'm not at a computer that has Access installed. Copy and paste your code into your reply, and I will see if I can help. Are you using a value list or a table as the source of your listbox? The example that I sent deletes the record from the source table. It will not work with a value list. Sup

kvang, Because my listbox had multiple columns, I found it easier to use a table rather than a value list as the source of my listbox. I've attached a simple example of deleting an item from a listbox based on a table. I hope this helps you, Sup

Wow! What a difference. From 5 minutes to about 40 seconds. Thank you VERY much! Sup

I am comparing records in two dao recordsets using FindFirst. rstOne is based on an attached table with about 90,000 records. rstTwo is based on a table in the currentdb and has about 1,600. It is taking about 5 minutes to compare all 1,600 records against the 90,000. Here is my code: Dim...

I am printing several reports at one time from a command button. I would like to set the printer (same for all reports) for these reports before I open them. I cannot find a way to do this in access 2000. Currently, I use this code, but it opens the print dialog for each report...

PBaldy, I was thanking ChrisO while you sent your last reply. Your solution is much appreciated as well! Thanks, Sup

ChrisO, Your example does exactly what I want. I really appreciate it! I almost had it working on the listbox_afterupdate event. I didn't think to use the listbox_mousedown event. Thanks, Sup P.S. the sample is A2K, not 2003

I am using a listbox to filter reports. I need to have it act as multi-select in some instances, but have it limited to single selection in others. My research suggests that the multi-select property can only be changed in design view, and therefore can't be changed using vba on the fly. Does...

Bob, Sorry, I did assume you were responding to PBaldy. I'm surprised that there isn't something out there that will check if recordsets are properly closed. Thanks, Sup

Hi Bob, I just tried Allen Browne's issue checker. It looks like a great tool, but it seems to only review tables and queries. Am I missing something, I can't find where it reviews vba code? Thanks, Sup

Does anyone know of an automated tool to check my vba code to make sure that all recordsets that have been opened are also closed and set to nothing? Thanks, Sup

What about an odbc connection from the mdb to the accdb, like connecting to SQL Server?

I am building an a2K3 application, that will require comparison of data located in another database. That data is currently being stored in a 2007 accdb. How can I link to or import a table located in an accdb from an mdb? Thanks, Sup

I am importing data from csv, txt or xls files. I allow the user to view the file in Excel before import using Application.FollowHyperlink. If the text in cell A1 begins with "ID" the file won't open because Excel mistakes it for a SYLK file. I can work around that issue by changing the text...

Banana, Thank you very much for your very informative reply! I appreciate it, Sup

I am working on an Access application that is currently using a large number of (Foxpro created) dbf files as the data source. These dbf files are updated and reported on using the Access application. My questions are: 1) If I import these dbf files into Access, should I expect them to be...

jdraw, Your code was extremely helpful. I have altered it slightly to write the results to a table. Here is my altered code: Private Sub CompareStatus() Dim db As DAO.Database Dim rs As DAO.Recordset Dim rsLoc As DAO.Recordset, rstComp As DAO.Recordset Dim tbl As String On Error GoTo...