Search results

Thank you for suggestion. I'll try until tomorrow to simplify my database and attach a sample so maybe someone could point me where could be the problem.

Hi arnelgp, Thank you for your message. I need that special query with fields from parent and child tables because the client need a "special view", even some of the fields that came from parent table will have repeating values like this: O.OrderNo, O.ClientName, OD.PartNo, OD.QtyOrdered...

Hi jdraw, Thank you for your suggestion, but I think that would be more difficult to understand, firstly because all the field names are not in english, and is a "split" configuration with Front End/Back End and the FE is also "not in english". Anyway I could not reproduce the problem nor on...

Hello! I am having some problems with a simple 2 related tables: 1. Order (parent) 2. Order-Details (child) In Order table I have an OrderNo Autonumber field that is also the primary key. The tables are in "1 to many" relation with "Enforce Referential Integrity" checked. I have one form in...

Well, the problem was solved. It seems that the record must be saved, this was done "by default" when leaving the record using DOWN ARROW. So the exit event now look like this: Private Sub Received_Exit(Cancel As Integer) Dim nOrdered As Double, nReceived As Double DoCmd.RunCommand...

Hello, I need some help regarding conditional formatting into an DataSheet Form. I have attached a small/basic sample database. The setup is as follows: - 3 tables: Orders and Order-Details (stripped so will remain only the required sample fields) and Order-Status - One query - qryOrders - that...

Thank you CJ_London for the answer and also for the hint - putting the function to set one colum of the query should be more reliable. But in this case how can I could create a function that will have to return only 2 values, let's say 0 & 1 but making sure that on the first record in query...

Hello Everyone, I have a problem formatting a form displayed as DataSheet. I am using a code provided by WayneRyan in another thread (Conditional Format Based on Previous and Current Record)(unfortunately I am not allowed to post with links yet) that toggle color based on an ID, in my case...