Recent content by AncientOne

if you refer to a previous answer I gave, you will see that I mention a join table. In this answer, I am stating that Patients and drugs need to be in separate tables, nothing else.

Yes, it would enable you to run the query in one hit. The reasons I rejected the solution of using two queries was because one of the aims in normalizing a database is to prevent repetition of data entry. With your table containing both the patient's name and the patient's drug in the same...

Tip: you don't need any code. just compose two queries. Access creates the code from the entries you make in the grid. The first is a straightforward select query as explained by your first respondent. The second query uses the first query's fields. If you go to the VIEW menu whilst in query...

That's a method which I considered and rejected in favour of establishing a politically-correct database structure. Ah well, sometimes you just can't win...

Unfortunately, the previous solution will return any records containing either Drug B or Drug C. You need to create a many to many relationship between patients and drugs. This is because many patients can have a particular drug , and many drugs may be taken by a particular patient. You need a...

The first (though I don't claim it's necessarily the best) method that springs to mind is to divide the day into 1440 minutes. Let us say that your peak hours are between 10am and 5 pm. This would divide your day into three sectors. Minute 1 to Minute 599 is off peak. Minute 600 to Minute 1020...

It sounds as though your query is not updateable. Please post the SQL for your query.

I seem to recall discussing this with you previously? You set the column width of the key field to zero. Then the key is used to retrieve the record, but the text field is displayed in the combo.

Like "*" & [forms].[fmVSSelection].[VendorService ID] & "*"

What do you want to do with the row when it's processed? Store it or use it in a report or form? Is it always the instructor field that contains the varying data?

1) are the files all in one location? 2) Is this a one off operation or is it carried out at regular intervals? 3) What are you doing with the files after importing them?

Du bist ein Berliner,vielleicht?

Yes, you can automate the import of files. I do it by creating an array of file names in a module, stepping through the array to append the imported data to existing files. The specific method used would depend on the type of files you're importing. In my app. they're DBF files. What are yours?

I'll try and put something together for you by tomorrow.

Yes, but you are just repeating what we have already established. The most efficient way of setting up your tables is to have a table to cover all errors that commonly occur and to join that table in a many-to-many relationship with your main table via a link table. Then you won't have hundreds...