Search results

Making James Bond a woman is about as stupid and sexist as it gets. They may as well make Barbie a man.

One of the gotchas is that Access Forms are different from Form objects used in other Office products.

Access doesn't touch pass through queries. They go as they are written. ODBC does have to translate standard Access queries. Only VBA functions that have SQL equivalents can be passed to the server. All others must be processed locally and that presents a problem unless the functions are in...

SMB has nothing to do with it. If a browser can have a usable remote connection, so can Access. The ODBC technology was developed for LAN use. Someone needs to develop a version for WAN use. But it goes a little beyond that since the parts of Access that use the ODBC connection have to be...

The table that Colin posted explains the coding used in the MSysQueries table so you know what each field/row represents.

The MS SQL Server people are always saying that "Access" is a toy and eventually that permeates an environment so no programmer wants to learn a "toy" and be laughed at. I've never technically worked for IT in a large corporation. I am always hired by some department that needs something done...

Only a poorly designed query would require Access to request entire tables from the server. Access does its best to make every query a pass-through query. The fact that Access has to touch the query at all makes even good queries slightly slower than true pass-through queries but not enough so...

I'm in 100% agreement with you there. There are things that MUST run in a browser, there are things that can run in a browser, and there are things that CANNOT run in a browser and you need to understand the difference. Most clients don't have 10's or 100's of thousands of dollars to rewrite a...

But it is not hard-coding a value. It is specifying where to obtain the value. Your other alternatives are: 1. TempVars. These work fine but are essentially no different in concept except that before you run a query, you need code to place the actual value into the TempVar 2. Use embedded...

The problem with MS is that it tends to concentrate on its corporate clients. It gets some opinions from the MVP group also. My "Access" clients have ranged from huge companies like United Technologies (Pratt & Whitney, Sikorsky, Hamilton Sundstrand, etc), medium large companies like Readers'...

If you look at one of the links @isladogs posted, he included a chart that explains the Attribute and Flag codes. If you make this into a parent and child table, you can replace the code that Dave suggested with a query with a left join and use that query as the RecordSource for a report so you...

If you look at Access for what it is - a Rapid Application Development tool and keep an open mind, you will be amazed by how productive you can be with this smart tool and how capable it truly is. The trick is to accept the "Access way" and stop trying to control the things Access feels that it...

What is this obsession with running in a browser? You don't need Access to run in a browser. You only need Access to be able to effectively connect to data sources across a WAN the same way that web apps do. Access is perfectly capable of doing this NOW. The issue is the connection is so...

Best to check that you can do that in all cases especially if you are intending to use the Runtime engine to run the app or to distribute an .accde.

No one has actually identified a specific problem associated with using form field references in queries so "avoid" is a muddy suggestion based on no facts. The issue is almost certainly as already pointed out. ALL parameters must be defined when used directly in a crosstab or even in a query...

It is easy to create a loop to add "10" records. The problem is that each record needs to have a serial number associated with it. If the items come to you with sequential serial numbers, you can ask for a starting value and increment that. I'm very confused. Which will be the official...

"mimic" doesn't cut it. If your existing Access app cannot be directly converted, the pretend Access AWA is useless and that was what the public ruled. That's because of their pricing model. It is not geared for small businesses. It is too expensive. Therefore, it is not a replacement for...

I just explained this to a new Access hater who is learning how to use Access from a badly designed database and an AI tool. It is no wonder he is fighting Access tooth and nail. What is "vibe" coding?

The developer knows when they change which in my world would be exceptionally rare. Who just randomly changes the names of controls or forms? The developer also knows which controls are used in queries. For any given form, it will be the RecordSource and any cascading combos. Same for...

Before you start to convert your applications, make sure that they each compile cleanly under 2003. Then you can start using A365 to run the .mdb's and convert them one at a time. You don't need to convert them all at once.