Search results

Hi, Other problems with using transactions in Access are: 1. The DoCmd statements like RunSQL or OpenQuery are not affected by Rollback. This means that you should not use them in transactions. The simplest way around this problem is to use QueryDef.Execute statements instead. These...

Hi, I used Keith's approach. It was more comapatible with the data format. But it works quite well. My job is to customize an Access based Accounting program. Let's say it's called "Actg.mde". When I complete some new functionality, I make a copy called Actg_NEXT.mde and send it to the...

My choice would be Access. That way you don't have to care what Word document you are dealing with. You could set up an Access app that would be able to analyze other Word docs in many different ways. This is just a feel. I have not done any VBA in Word. But from a design point of view, it...

Hi, Does anyone know how to disable the Clipboard window that appears when you're doing copy-and-paste work? It is a pain in the butt. Thanks, Mike

Thanks to both Keith and DCX693, I think I will find uses for both approaches. I will give them a try and let you know how it goes. Thanks again, Mike

Hi, Now that I am able to capture the file's name - thanks to you folks - I suddenly realized I don't know how to go the rest of the way. I created a table with a list of control names that would be disabled if the filename were let's say "progInventory.mde" but, when I started to write the...

Thanks to all of you. Its amazing how much of the details behind MS's creations are difficult to find. Thanks to forums like this one, we can find out what we need to know. Thanks again.

Thanks Ian! I'll try that.

Hi, Is there a way with code to determine the filename of the Access application that a user is in or at least what folder it's in? The reason is that I want to enable/disable functional modules based on it. For instance, if the file name were "Acctg_Warehouse.mdb," then enable only the...

Hi Snicker, I just saw your question. I hope it is not too late. Here is some code. Sub SampleTran() On Error GoTo HandleError Dim ws As Workspace ws.BeginTrans 'Code to copy some rows from Table A to Table B. 'Code to delete same rows in Table A...

Try a multi-select list box for the uset to select counties to exclude. Then iterate through the list using the "For Each" or "For Next" statement. This may be a good start.

Hi llkhoutx and Mile-O-Phile, Thanks for your suggestions. The situation I am working with is this: We have folks using the regular Accounting System, which is an Access frontend linked to an Access backend. Some of the users are filling in sales orders from people who are calling in. They...

Tom, Thanks for the suggestion. However, the users of my application do not do any importing. They fill out sales orders and, as they are doing so, they are depleting the inventory in the inventory tables. Because we also receive orders via EDI, I am creaing a program that automates the...

Hi, Is there a way to lock a few tables with code so that when a user starts an important operation, nobody else changes any data in the tables until that operation has completed? Thanks, Mike

I had thought about it some more and that's what I figured. At some point even if the table is in memory the changes to it have to be committed to the disk. The result is that someone else gets bumped. Your excellent suggestion is what I had decided to do. We'll see how it works. Thanks.

Hi, I have about 8 people using an Access frontend on a terminal server. It looks like they are interfering with one another in the use a temp table that is resident in the frontent. I did not expect this because I thought that each user of the terminal server has his/her own instance of the...

One more thing about transactions: After you commit or rollback a transaction, do NOT close the workspace it was within. Doing so disables the form's RecordsetClone functionality. Thanks, Mike

Hi, I found the answer to this on another forum but I think that the users of this forum would be interested in it. If you make any changes to data on a form within a transaction, do NOT close the workspace. This causes problems later. I was closing the workspace. As soon as I removed the...

Hi, I have a form with a few subforms. The form also has a quick find combo box that uses the RecordsetClone method and the bookmark properties to get to a specific record in the form's record source. It works well when I open the form and as long as I don't change any of the underlying data...

Hi, I learned a few things about transactions in Access. Always set a record set object to nothing after closing it. If you use a recordset object name, then close it, then begin a transaction, and then use the same recordset object name, the data in the second recordset object will not be...