Search results

Thanks Pat. I would create the queries in SQL Server and link them to Access. I will give it a try.

A quick fix is to run the alter query once for each field you want to add. After this all the fields should be in the table.

You may have to actually assemble the query in code based on the form fields used. You would need a string variable like strSelect containing the basic query and another string variable like strWhere. Put the range info info into this variable and append it to strSelect. Make the resulting...

Hi, Pat has said that with JET, if any of the queries in a chain uses aggregation, you can not update a table using it. Does anyone know if this is also true with SQL Server? Thanks, Mike

Thanks Pat. I think I will use a make table query and destroy the new table after using it. I agree with you on the storing of aggregated data. But I am modifying an existing program that has a reorder point field in the inventory table and all I have to do is update that field once a month...

Yes. It does.

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

Thanks for all the intelligent ideas. Now I know why Null is the programmer's worst enemy.

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

Thanks Bert.

Using DAO.

What does the first line have to do with the rest of your question?

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

I believe that you do not have a reference to the MS Windows Scripting Host.

You may want to try to reinstall Access on the boss's machine. However, a better solution is to get another server and set it up with Windows 2003 and use it as a terminal server. Set up a desktop for all the users on the terminal server. Install Access on the terminal server and copy both...

Thanks ChrisO, I have downloaded your database and plan to take a look at it. But I wanted to show folks the solution I came up with. The first part of the solution is to create a table, called tblMyLInkedTables, in a common backend. Give it CompanyCode, Name, SourceTableName, and...

If not MS, how about a world consortium? Could this be an instance of the computer programming community forgetting that their products are used by human beings? What should we say to the O'Haras of the world? Having to use a quote santitizing function every time we access a string is a waste...

Perhaps we could convince MS to use a character that is never used when writing like "~" to designate strings. Maybe they could make up a new character for this.

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

You could just let the error happen and then trap it. Find out what the error number is and, if that is what causes an error in the future, inform the user with a very user-friendly message. ExitSub: Exit Sub HandleError: If err = 1234 then msgbox "Blah blah blah"...