Search results

Hi, I'm trying to run the following query: "UPDATE Inventory INNER JOIN qryItemReorderPoints ON Inventory.[Item Number] = qryItemReorderPoints.[Item Number] SET Inventory.[Reorder Point] = qryItemReorderPoints.ReorderQuantity;" But I keep getting the message "Must be an updatable query."...

I have read that it is better to use Len() than IsNull() because it is faster. However, it seems that there are times when the variable being evaluated is actually Null, Len() = Null and not zero. In fact, I believe I got this advice from the famous VBA Handbook. But the Access help says that...

Hi, Does anyone know the VBA code to remove all queries, forms, reports, etc from a given Access database? Removong them manually takes too long. Thanks, Mike

Hi, I'm maintaining a frontend access db that can be attached to different backends depending on what company it is for. Each company frontend has tables that are linked to the same backend because they are common to all companies and other tables that are linked to their own backend. The...

Hi, We were using Terminal Services on a Windows 2000 Server machine to run an Access-based accounting system which I am customizing on a daily basis. After each change I made, I would compact and repair the MDB and then create an MDE. I would copy the MDE over to the server and there it...

Hi, Every once in a while, Access refuses to let me change the size of a form. I looked at the form properties and didn't see anything that looks like it will block changes to form sizes. Does anyone know why this happens and what could be done about it? Thanks, Mike

I did a search within the forum for this but didn't find a posting that dealt with this issue. I have a few back-end databases that, all though the data will be different among them, the structures should be the same. Because I am constantly customizing the program, I occasionally have to...

Hi, I had problems refreshing a subform after updating its underlying table using a popup form. I did a search within this forum and found nothing to shed light on my problem. I was doing already what was recommended, but it wasn't working. So I thought about it a little more and happended...

Hi, When I had a two-tier setup for our Access app, I was able to find out who was still on with the appropriate code. It was quite useful. However, as soon as we changed to running the app through Terminal Services, all the users had the same machine name; so we need another way to do the...

Does anyone know how I can change the color of the form's title bar using Access VBA?

Hi, Does anyone have a sample app for using the Rich Text Box control? Even though it has a control source, the control seems to ignore it. I don't have a clue where to start with it. I downloaded the RTF2 ActiveX control from Lebans Holdings but I don't understand their their sample app at...

Hi, I have noticed that the DoCmd.Hourglass method works under certain circumstances but doesn't work under others. A situation in which it did not work is when I was resorting a tabular form after clicking on the label above a field. Because it was taking longer than I wanted to resort the...

Hi, I am creating an email app in Access 2002. Everything seems to work fine except that when I try to display the body of the of the message. If happens to be in HTML, all of the HTML code is displayed as well. I would like to display the message as a web browser does. What control would I...

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

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, 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

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...

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'm using Access 2002 and I want to wrap a few things in a transaction. But things are not happening as I am expecting. For instance, within a transaction I append one record to a table. Although the table may have 100,000 records, five of them may be related to the same item and one of...

Hi, I am customizing an Accounting application using my machine (OS = Windows XP) for use under Terminal Services on the server (OS = Windows 2000). I made a recent change that works on my machine but fails on the server. We are using Access 2002. What is odd about this is that, when the...