Search results

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.

I think you should first explain more about the purpose of the database. What you mention here doesn't mean much. Because I also see a quantity field, it could be a stock administration. This would mean that you record stock changes in one or more separate tables. Simply manually changing the...

I believe that we are once again dealing with a member who asks questions but never responds to the answers he receives. So don't waste your time.

Why do you store both numbers? If the begin number is equal to the previous end number by defenition, there is no need to store both. In your setup you may also encounter overlapping numbers. Like: 10, 69, 77 Any validation will only tell you there is something wrong. But not what is wrong. The...

First explain what you mean by a gap and provide example data.

In any case, the fact is that this user has asked 5 questions so far and has never responded to the answers given.