Recent content by XPS35

It seems the original poster has left the forum and is trying his luck elsewhere. See HERE. I wouldn't waste any more time on this question.

It is an error. Clockings are related to a member and a member can have one or more clockings. So there is a one to many relationship between members and clocking. The field that connects them is barcode. All clockings with the same barecode belong to one member. Connecting on amounts is wrong...

I suggest you alter the relationship between the tables:

We need much more information to answer this question. What exactly do you mean by exporting DB files? What is being exported (queries, tables, reports) and in what format (xls, pdf)? Does she use program code to export? If so, show the code. What are the symptoms? Is she getting error...

This clearly shows what is wrong with this design. You can store multiple medicines but can only store one frequency, dosage, start date and other data. So to which medicine apply those data? The only right solution here is to have a related table with prescribed medications.

Get used to it :p OP used to post on UtterAcces and seems to have moved to AW after UA disappeared. He is "famous" for this.

Try: [NewLineDesc]<>"#1" AND [NewLineDesc]<>"#2"

Nothing is updated bacause of the If rs!DogID = "" Change that to If IsNull(rs!DogID)

Like this? Dim companyF As String companyF = Left([Company_Name], 2) Me.Assigned_To = DLookup("[Analyst]", "[tbl_company_analysts]", "[first2_char] = '" & companyF & "'")

You need to remove the =.

If a field can be automatically update, you do not need to store it. Use a query to show the related value.

Create a group by query. Group on the four fields and add the MIN s_id.

Google is your best friend. You will find sites like THIS.

Use & instead of +.

1. It looks like the yymmdd is not always on the same position. This makes it almost impossible to make a procedure that will extract the right value. 2. I do not understand this at all.