Search results

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...

I assume you are trying to show customer and order details on one form. That's not going to work. You must show a customer's details on a main form and the orders on a subform.

My attempt: SELECT Surname, FirstName, Client FROM tblFirstAid WHERE Client IN (SELECT Client FROM tblFirstAid WHERE Course="FirstAid 2" OR Course="FirstAidOS2") AND Client NOT IN (SELECT Client FROM tblFirstAid WHERE Course="FirstAid 3")

Why do you want to save the same data twice? An invoice is nothing more than a message to a customer that he must pay. You can compose that message based on the sales order and its details.

It looks like the error occurs when you try to insert duplicate records. Why are you doing this work? :cool:

Before you start thinking about forms, you first need to consider how you will store the data. That's the most important thing when setting up a database. An important question here is how and whether the data in the spreadsheets are related to each other. We have no insight into that.

Before you open the form, you can check whether there are any records that meet the condition. Something like If DCount("*", "YourTable", "[CheckDate]=#" & Me.ShiftDate & "#) > 0 Then DoCmd.OpenForm "frmDayShiftPrintcheck", , , "[CheckDate]=#" & Me.ShiftDate & "#" Else MsgBox "no records"...

I don't think it is possible to keep track of stock in the sales lines. If you have received stock of that item after the last sale of an item, the stock in the sales line is no longer correct. You can calculate the stock at any time by adding all incoming and outgoing changes.

Look at post #1 to see the (a) table.

Because the table is not normalized :confused:

As soon as you enter a value in a field other than the autonumber, a value will be automatically assigned to the autonumber.

I have lost track of this topic, but I assume performance is still the problem and that the cause is the number of DCounts. I think you can use cross tab queries to speed up things. For the "Action Statistics" (sub form) use as recordsource: TRANSFORM Count(ActionID) AS ActionCount SELECT Site...

Consider using Excel.

It is a bad idea to record the same information twice in a table. Why would you want to record the customer type both in the code and as a separate field? The code must always remain the same, but it will probably happen from time to time that a customer changes type. What then? Moreover, it is...

You should have just one table for whatever you store with a date field from which you can deduce the quarter.

The best method is not to duplicate your database. One database for all years is the best. Year (date) should be a field in your tables and should not be in the name of a database or a table.

I guess it starts with me.parent..........

As said in post #3 there is no use in looping through all the records. The real action (print the report) is outside the loop. This will do: Public Sub KnopBriefAfdruk_Click() DoCmd.OpenReport "ledenbriefRap" End Sub

Welkom. Zoals je merkt, is de voertaal hier Engels. Maar daarvoor is Google Translate je beste vriend. Welcome. As you can see, the main language here is English. But for that, Google Translate is your best friend.