Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

record Number and Customer Number

Discussion in 'Information Technology' started by Mohammed, Jul 28, 2006.

  1. Mohammed

    Mohammed
    Expand Collapse
    Guest

    I have a customer file and it has a recordid as primary key autogenerate
    and customer number is also generating by the DMax("[zfileno]","zfile")+1.
    at one time recordid and zfileno was same but after delete of some records,
    now the recordid and zfileno is different. when I am using lable print from a
    form selected record it was printing fine when the recordid and zfileno was
    same when it become diff then it is not printing the selected record as on
    selection I have strWhere=[Recordid]
    what is the best way to print the same record from the form.
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Mohammed wrote:
    > I have a customer file and it has a recordid as primary key
    > autogenerate
    > and customer number is also generating by the
    > DMax("[zfileno]","zfile")+1. at one time recordid and zfileno was
    > same but after delete of some records, now the recordid and zfileno
    > is different. when I am using lable print from a form selected record
    > it was printing fine when the recordid and zfileno was same when it
    > become diff then it is not printing the selected record as on
    > selection I have strWhere=[Recordid]
    > what is the best way to print the same record from the form.


    More information please. What are the relationships and table
    structures?

    What is the sql for the selection to print. How are you "selecting"
    records to print?

    --
    Joseph Meehan

    Dia duit
     
  4. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    Provided you include the RecordID field in the label report's RecordSource
    you can still use it to print the current record even though it differs from
    the customer number. The RecordID does not need to appear on the label. The
    code in the Click event procedure of a button on the form would be something
    like this:

    Dim strWhere As String

    strWhere = "RecordID = " & Me.RecordID

    ' first make sure record is saved
    RunCommand acCmdSaveRecord
    ' print the label
    DoCmd.OpenReport "YourLabelReport", WhereCondition:= strWhere

    You could also do it by using the customer number as this also uniquely
    identifies the record, in which case you'd use something like:

    strWhere = "[CustomerNumber] = " & Me.[CustomerNumber]

    Ken Sheridan
    Stafford, England

    "Mohammed" wrote:

    > I have a customer file and it has a recordid as primary key autogenerate
    > and customer number is also generating by the DMax("[zfileno]","zfile")+1.
    > at one time recordid and zfileno was same but after delete of some records,
    > now the recordid and zfileno is different. when I am using lable print from a
    > form selected record it was printing fine when the recordid and zfileno was
    > same when it become diff then it is not printing the selected record as on
    > selection I have strWhere=[Recordid]
    > what is the best way to print the same record from the form.
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page