User Profile

Collapse

Profile Sidebar

Collapse
mseo
mseo
Last Activity: Mar 12 '11, 06:17 PM
Joined: Oct 26 '09
Location: Egypt
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • mseo
    replied to filter between two dates or null
    thank you for your help TheSmileyCoder
    you are great
    it works as expected
    thank you again and again
    See more | Go to post

    Leave a comment:


  • mseo
    started a topic filter between two dates or null

    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
    ...
    See more | Go to post

  • hi,

    I need help with this, please
    See more | Go to post

    Leave a comment:


  • 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...
    See more | Go to post

  • mseo
    replied to Orders lock/unlock
    thank you Mary

    it works great

    I really appreciate your help
    See more | Go to post

    Leave a comment:


  • mseo
    replied to Orders lock/unlock
    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
    Code:
    OrderID; AutoNumber; PK
    OrderNo; String
    CustomerID; Number; FK
    OrderDate; Date
    Locked; boolean
    2- tbl_OrderDetail
    Code:
    OrderDetailID; AutoNumber;PK
    OrderID; Number; PK( to allow duplication in products)
    ProductID;
    ...
    See more | Go to post

    Leave a comment:


  • mseo
    replied to Orders lock/unlock
    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 much
    See more | Go to post

    Leave a comment:


  • mseo
    started a topic Orders lock/unlock

    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...
    See more | Go to post

  • 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
    MSEO
    See more | Go to post

    Leave 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
    Code:
    productID;autonumber;PK
    Productname;String
    Customer_ID;Number;FK
    UnitPrice;Number
    I have before update trigger to prevent duplicating records (something like compound index on...
    See more | Go to post

    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
    MSEO
    See more | Go to post

    Leave a comment:


  • mseo
    started a topic dlookup unitprice based on customer and product

    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
    See more | Go to post

  • mseo
    replied to codify products
    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 :
    ...
    See more | Go to post

    Leave a comment:


  • mseo
    replied to codify products
    can I codify products?
    See more | Go to post

    Leave a comment:


  • mseo
    started a topic codify products

    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
    See more | Go to post

  • mseo
    replied to history table
    thank you very much...
    See more | Go to post

    Leave a comment:


  • mseo
    replied to history table
    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...
    See more | Go to post

    Leave a comment:


  • mseo
    started a topic history table

    history table

    hi,
    I have two tables:
    1- customers that contains field named
    Code:
    customerid; autonumber; PK
    Companyname;string
    dateentered; date/time
    inactive; yes/no
    datemodified ;date/time
    2- customerhistory :
    Code:
    customer_ID; number
    Inactive; yes/no
    datefrom; date/time
    dateto; date/time
    I have form for edit customers and its controls bound to table customers...
    See more | Go to post

  • mseo
    replied to Clear Error Message from TextBox
    that's true Neopa, We have learned a lot of things from here
    thank you...
    See more | Go to post

    Leave a comment:


  • mseo
    replied to Clear Error Message from TextBox
    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)
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...