Search results

What's the problem with using a query? As it would be based on a single table, it's result table will be updatable and can be used wherever you'd use a base table. You can then include a computed column using whatever expression you wish. No need to compromise with a less than satisfactory...

If you have occasion to repeat orders by a customer regularly you might find the following function of interest. It firstly inserts a new row into the Orders table with the same data as an existing order, identified by passing its OrderID primary key value into the function. It then inserts...

The way I have handled clocking in or out is to firstly have a login form in which the user enters their login details , and then presses a Clock In/Out button. The code in this button's Click event procedure is: Private Sub cmdClockInOut_Click() Dim strArgs As String Dim strCriteria...

Unless I'm going blind, I don't see any link in the OP's post.

Storing stock in hand values in a table runs the risk of update anomalies, as the values can easily be amended so that they do not reflect the movements in and out of stock. Commonly the stock in hand for a product is computed by subtracting the total quantity of stock disposals from the total...

The attached zip archive includes both .accdb and .mdb versions, which illustrate how to browse to a file and return its path as text. The .accdb version stores the path in a column in a table, from which the file can be opened in its associated application. It would not be difficult to amend...

So it has. Better late than never. I'm surprised nobody mentioned restricting the Cartesian product before.

The following query uses the attached little demo file as its example to return all employees and the courses which they have not taken. The outer query returns the Cartesian product of employees and course titles, i.e. for each employee all possible courses are returned. This is then...

I gave him a link to such a file, with the means to browse to a file and store its path in a text column, along with a way to format the path and/or just the file name, so that it appeared and behaved as a hyperlink by means of which the file could be opened in its associated app, but he...

Nevertheless, I would still advise that, as a beginner now is the time for you to get out of bad habits, and eschew the use of multi valued fields for the reasons given by myself and other respondents in this thread. In relational database terms what you are doing is an example of Relational...

It would be helpful if you could post an image of the database's relationships window, set out clearly so that the tables and all of their columns are readily visible, and the relationships between the tables are readily apparent. This would enable us to judge whether the tables are correctly...

You might find the attached file of interest. It illustrates how to undertake a search on the basis of multiple values in table in a many-t-many relationship. In this case the relationship is modelled by a table which resolves in into two one to many relationship, rather than by a multi-valued...

For that I'd use a column of Integer data type constrained with a ValidationRule of (>=-1 And <=0) Or Is Null. For the bound control a check box with a TripleState property of True could be used.

Codd supported 3-way logic, TRUE, FALSE and MAYBE, though Date did not, asserting that this was an inferred support for NULL, which Date strongly opposed, maintaining that the database relational model disallowed NULL as it required each column position in each row to contain a value of type a...

Not so straightforward these days.

Codd would be right behind you on that. The Information Principle (Codd's Rule #1) requires that all data be stored as single values at column positions in rows in tables, and in no other way. A value list RowSource encodes data as part of the object definition. The only time I'd consider...

You might like to take a look at BrowseDemo.zip in my Dropbox public databases folder at: https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0 This little demo file illustrates how one or more files can be associated with each record...

Did you mean 1.325lb? 3.125lb = 1.41747616kg.

Not to mention the mirror on the Hubble telescope.

If you intend to process the imported data in Access you might want to think about decomposing the imported data into correctly normalized related tables. This can be done with a set of 'append' queries executed in a specific order. In your case you'd probably need different sets of queries for...