Recent content by ebs17

However, with the UNION query you subsequently lose all index usage. A real database regularly comes with a lot of data, and you need some resources to achieve satisfactory performance. What does that mean? If you have or can compile the full path in a file system in the database, you can open...

This is a problem of our own making. If necessary, you should move the attachments to additional backends, but not the actual data.

If you only want to delete parts of them, you need an attribute that allows you to distinguish between the records and can therefore be used to determine which records you want to delete or which records you want to keep. A typical field would be an ID with a continuous number (autoincrement)...

You could show these examples.

In the import specification, change the data type for this column to text. Text can initially record everything. Then, to link the text table, use a query like this: SELECT T.[FieldList] FROM...

I think you have to approach it completely differently. What dependencies are there between specialty and specialist? Show the database schema. I would expect a many-to-many relationship between specialty and specialist, and so the form would look completely different.

Passing parameters to a query - variants: https://www.access-programmers.co.uk/forums/threads/query-to-find-records-not-between-two-dates.328481/page-2#post-1886589

Expr1="Yes" What does this have to do with positive or negative numbers?

WHERE DateField > 0 In contrast to the suggestion with NOT, index use is possible here, and index use should always be kept as open as possible in the interest of good performance. 0 corresponds to 1899-12-30 and implies that dates used are greater than this date.

In order to present something as the "best solution", requirements from a development environment such as Access should be met. A key requirement would be code-controlled access via an accessible object model or via command lines. I have enough user interface in my access frontend, as changing...

You always have to react to unknown changes, regardless of whether you use an annual copy or an entire database. Where is there a significant difference? What characterizes fields that change? Samples? These are probably bullet fields from poor data modeling. Importing new data is always an...

It is better to display VBA codes as well as SQL statements from queries as code in the forum instead of packing them in a file that is not user-friendly. The text files mentioned, which contain the definition of Access objects, play a role more for developers themselves, for example in source...

Counter question: If you could upload these formats to the forum - who could and would want to read them directly? Should one put together his own database from 10 files instead of the questioner simply providing an example with data? My first encounter with a database usually takes place by...

Save your query under a name, e.g. qryXX. You can then set up another query. SELECT DCount("*", "qryXX", "ComplaintType = '" & Q.ComplaintType & "' AND AvgOfCost > " & Str(Q.AvgOfCost)) + 1 & "." & Q.ComplaintType AS ComplaintTypeX, Q.AvgOfCost FROM qryXX AS Q

WHERE YourDateTimeField >= Date() AND YourDateTimeField < Date() + 1