thank you for your help TheSmileyCoder
you are great
it works as expected
thank you again and again
User Profile
Collapse
-
filter between two dates or null
hi,
I have a form for filtering data in report
the report opens on the date criteria as in the code below
what I want to do is to view the records where the date is null and the records returned by the date criteria
...Code:Private Sub PCOD_Click() On Error Resume Next Dim scriteria As String sCriteria = " 1 = 1 " If Len(Me.DF & vbNullString) <= 0 Or _ Len(Me.DT -
-
Add delivered quantities and assign to an order (inventory issue)
hi,
I have a Form for add delivery Receipts and assign each product quantity for specific OrderdetailID
:
1- Form Add receipt: when I select the customer from Customer_ID combobox, I get Form1 opened with no orders
2- when I select product in the subform, Form1's Listbox will be filtered by unlocked/unfilled orders for that product
I have two problems with this Form:
1- if I select a product and entered... -
-
hi, Mary
when I tried to use the sql statement i have met a problem with left join
here's the structure of the tables in the Database
1- tbl_order
2- tbl_OrderDetailCode:OrderID; AutoNumber; PK OrderNo; String CustomerID; Number; FK OrderDate; Date Locked; boolean
...Code:OrderDetailID; AutoNumber;PK OrderID; Number; PK( to allow duplication in products) ProductID;
Leave a comment:
-
hi, Mary
thank you very much
I have a form for adding delivery receipts, if the allocating of the delivery receipt against orders may has multiple rows for one product, I need one more help I need to check the quantity of the record in table orderdetails because may be the quantity in the record of table deliverydetails exceeds the quantity in table ordersdetails
thank you very muchLeave a comment:
-
Orders lock/unlock
hi,
I have Follow-Up report for orders and deliveries to calculate the Build Quantities (the quantity I have to produce to fill the order) after subtracting the quantities delivered to the customer
attached to this post a snapshot of the old report
the trick that I couldn't get it solved in the report I added lock/unlock field to orders table to flag locked orders
so, I need to assign the delivery receipt to specific... -
Ok, Ali
I am trying to implement your approach
I need one more thing, please provide me with more explanation and details about how I can implement it, because I am not fully grasped it, and that would result in design changes
thank you again and over again
I really appreciate your help
MSEOLeave a comment:
-
hi,
thank again
I mean by number of customer (I can use iif function statically) which means I need to handle this programatically (something like Dcount or Dlookup)
here's the metadata of tbl_products
I have before update trigger to prevent duplicating records (something like compound index on...Code:productID;autonumber;PK Productname;String Customer_ID;Number;FK UnitPrice;Number
Leave a comment:
-
thank you very much Ali
I really appreciate your reply
you analysed the problem correctly
but, because we have numerous customers and products and thus we will have more than one price for the same product depending on the number of customers, so I can't use iif function to implement your approach
we need more dynamic solution for this problem
thanks and over again
MSEOLeave a comment:
-
dlookup unitprice based on customer and product
hi,
I have a form/subform for adding orders, the problem that the prices are different from one customer to another, what I need to do is: dlookup the unitprice when I select a product and a customer from the comboboxes
thank you very much
Any help would be appreciated -
hi,
I have a ProductID (AutoNumeber)fi eld and it seems meaningless for the user so I added one more field and I need to fill this field as the following:
each product has category so I need to codify the products using first four characters from the category name and concate it with a number
the problem I need this number to be generated automatically, and grouped by categoryID
let's assume I have two Categories :
...Leave a comment:
-
-
codify products
hi,
I need to know if i can give each product unique code depending on the category and sequence number other than PK field
in other words, the sequence of products in each category
for example
dairy-001
cheese-001
milk-002
Vcheese-002
thank you very much -
-
thank you beacon for your reply
In addition to you posted
I need to compare the last inserted record into table customerhistory for specific customerID if it is the same not to insert new record if the inactive control changed insert new record with new values
thank you very much...Leave a comment:
-
history table
hi,
I have two tables:
1- customers that contains field named
2- customerhistory :Code:customerid; autonumber; PK Companyname;string dateentered; date/time inactive; yes/no datemodified ;date/time
I have form for edit customers and its controls bound to table customers...Code:customer_ID; number Inactive; yes/no datefrom; date/time dateto; date/time
-
that's true Neopa, We have learned a lot of things from here
thank you...Leave a comment:
-
So, It would be like this:
...Code:Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me!Text1) Then Me.Text2 = "text 1 is blank, it is required" Cancel = True: Me.Text1.SetFocus ElseIf Not IsNull(Me.Text1) Then Me.Text2 = "" End If If IsNull(Me!T5) Then Me.T6 = "text 5 is blank, it is required" Cancel = True: Me.T5.SetFocus ElseIf Not IsNull(Me.T5)
Leave a comment:
No activity results to display
Show More
Leave a comment: