Search results

A "proper" table in a database should not be a collection of duplicates, as far as I understand. Therefore. I don't think I'm reporting anything new. But at least the topic has been taken up again after many months and seems to have some significance besides eliminating boredom.

If this statement is not correct, then it is. CurrentDb has nothing to do with SQL Server. Since it is about inserting a single record (?), do not use a bound form here and use an unbound form instead, use an ADODB connection (or a DAO reference) to the backend and carry out the append query...

In Form_BeforeUpdate, an automatically generated primary key should already be available and readable. At this point, you also have access to the correct record and its key. The measure in Form_AfterUpdate is too late and not recommended. In addition, the bound form and CurrentDb have nothing to...

To put it more precisely, as desired, one would replace "one unique attribute field" with a combination of fields, which then provides the natural key for the uniqueness of the record. However, this example natural key shows very clearly how advantageous a surrogate key made up of a single long...

How exactly should the update be done, manually in the list or via procedure/query? In the second case at least, you can remove PP.ProcessFK from the field list and thus also change the query. In general, I only update tables where this one table and its fields are in the SELECT part of the...

If you ask me: I once perceived that DAO is optimized for Jet/ACE, while ADODB is better for other external databases.

The connection technology is secondary. So yes.

That's enough to do the same thing. ... WHERE O.OrderPK Between 5 AND 10 Without the brackets in the JOINs, you should have valid T-SQL syntax here. With an ADODB connection to the BE, you could run the query directly in the SQL Server.

I have two suggestions: 1) Parameter passing and processing is much easier if you combine the three queries into one. This can be achieved by simply copy&paste. It is easier to pass parameters to a single query, even to lower query levels. 2) The parameter passing as you use it inevitably...

Note: I didn't notice the example database, so I wrote the SQL statement by hand. Therefore, two table names are not entirely correct.

SELECT O.OrderPK, PP.ProcessFK FROM (tblOrder AS O INNER JOIN tblProducts AS P ON O.OrderProductFK = P.ProductPK ) INNER JOIN tblProduct_Processes AS PP ON P.ProductPK = PP.ProductFK You can certainly add the INSERT INTO line yourself. This is what your...

What custom methods can a CSV file have? A plaintext file with only data is the most innocent thing you can imagine.

If you use VBA in such a targeted manner, you can also call the desired function. You don't need an extra event for this. However, you would have to check separately before calling the function whether the content of the control really changes when it is overwritten using VBA. This raises the...

However, these rallies are not about listening to music, but about highlighting individuals and political views. Musicians and other artists have their own views and attitudes and do not necessarily want to be taken over by others with the assumption that they are marching in lockstep. Who...

In which SQL dialect do your attempts work? ? accesserror(3134) Syntax error in the INSERT INTO statement. To the point: In the record to be created, at least one value must be written correctly and thus assigned so that the default values are adopted as field contents. However, this basic...

Processing all the steps obviously takes a long time, beyond a single user session. Therefore, you should also consider whether another user can continue the work of a previous user who is temporarily unavailable due to illness or vacation. I have various thoughts on this process. 1) You don't...

I can handle that. I find the Christmas season much worse. There are relatively few Christmas songs played on the radio, and it feels like they are played every hour, for weeks. While Christmas is supposed to be a celebration of peace and joy, such constant noise tends to make me more frustrated...

Even many developers who ask here have problems creating sensible queries themselves. Now users are supposed to do this as well? Are users more industrious or smarter than you as a developer? That would be a great disgrace. Normally, you offer forms that show data. A form recordset can also be...

That can only be a personal and very individual opinion. Music has existed for a very long time in human history, the directions you mentioned are just a few short-term snapshots. Wait and see whether people will still talk about rock & blues in 300 years in the same way as they do today about...

If you want to program in the classic way and understand what is happening, there is always a way open: - Export the Access objects of interest using SaveAsText. This creates text files with the complete definitions of the objects. Anyone can read and evaluate plain text. - With simple text...