Recent content by XPS35

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.

As far as I can see AuthorsType is not a control on the form, so Sub AuthorsType_LostFocus() will never be executed. It seems that you are not doing anything with the solutions offered. I tested my solution (obviously) before posting it. As I already wrote, you have to look at what you do with...

It depends on whether you want to remove an author even if there are related books. If you do want that, the books must also be removed. To achieve this, you must adjust a property of the relationship between authors and books (enable cascade delete). You can then delete an author and the...