ACCESS FEED: Re: [MS_AccessPros] RE: After preview of report one record is appended in table filling two fields

Dear Khalid,

Congrats on cracking the problem. Happy learning Access...

Ahmed

On Tue, Oct 22, 2013 at 11:24 PM, Khalid Tanweer <khalidtanweerburrah@yahoo.com> wrote:

John and all other Seniors and member,

The last BUT.... is also solved, on reports Data tab "Filter On" was set to "Yes" which i changed to "No", report for every consignment is now accessible.

Thank you every one who looked and helped in any way for this issue. I am closing this thread.

Khalid

On Tuesday, October 22, 2013 11:13 PM, Duane Hookom <duanehookom@hotmail.com> wrote:

Khalid,

I find it hard to understand how if you remove unneeded objects and records, performed a compact/repair on the remaining file, and then zipped it the would not be small enough to upload to the group.

I'm not confident you have ever responded to several request to remove the dialog form's record source.

Duane Hookom MVP
MS Access

________________________________
> From: khalidtanweerburrah@yahoo.com
>
> John,
>
> I could not find where are the public folders at Dropbox.
>
> In the mean while i have done some experiments.
>
> I made two queries:
> CollectionVoucher1Query (Append query)
>
> INSERT INTO CollectionVoucher1 ( ConsignmentNo, ClientCIN, ClientName,
> ConsigneeID, ConsigneeName, CollectionDate, CartonNo, ProductName,
> ProductQty, WeightOfCarton, Rate, Amount )
> SELECT CollectionVoucher.ConsignmentNo, CollectionVoucher.ClientCIN,
> CollectionVoucher.ClientName, CollectionVoucher.ConsigneeID,
> CollectionVoucher.ConsigneeName, CollectionVoucher.CollectionDate,
> CollectionVoucher.CartonNo, CollectionVoucher.ProductName,
> CollectionVoucher.ProductQty, CollectionVoucher.WeightOfCarton,
> CollectionVoucher.Rate, CollectionVoucher.Amount
> FROM CollectionVoucher;
>
> CollectionVoucher1DeleteQuery
>
> DELETE CollectionVoucher1.ConsignmentNo, CollectionVoucher1.ClientCIN,
> CollectionVoucher1.ClientName, CollectionVoucher1.ConsigneeID,
> CollectionVoucher1.ConsigneeName, CollectionVoucher1.CollectionDate,
> CollectionVoucher1.CartonNo, CollectionVoucher1.ProductQty,
> CollectionVoucher1.ProductName, CollectionVoucher1.WeightOfCarton
> FROM CollectionVoucher1;
>
> On the form "Detailed Packing List Selective Productwise Dialog" on
> Load event i put this code:
> Private Sub Form_Load()
> DoCmd.OpenQuery "CollectionVoucher1Query"
> DoCmd.Close , "CollectionVoucher1Query"
> End Sub
>
> On forms unload event:
> Private Sub Form_Unload(Cancel As Integer)
> DoCmd.OpenQuery "CollectionVoucher1DeleteQuery"
> End Sub
>
> Changed the table to "CollectionVoucher1" of "Consignment Summary All
> Clients Selective Productwise Query"
>
> Now no blank record is appended to table "CollectionVoucher".
>
> BUT.....
> i can preview report for only one "ConsignmentNo" if i do select other
> consignment No it shows blank report.
>
> Khalid
>
>
>
> On Tuesday, October 22, 2013 5:30 PM, John Viescas <JohnV@msn.com> wrote:
>
> Khalid-
>
> That link won't work. You need to put the file in your Public folder
> on Dropbox, then right click the file and select Copy Public Link.
> Paste the result in a reply.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Khalid
> Tanweer
> Sent: Tuesday, October 22, 2013 2:17 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] RE: After preview of report one record is
> appended in table filling two fields
>
>
>
>
> Hi All,
>
> Here is the link:
>
> PCTL.rar (file://KHALIDLAPTOP/Users/BNC/Dropbox/PCTL.rar<http://>)
>
> Ahmed this is what you wanted.
>
> Khalid
>
> On Tuesday, October 22, 2013 3:21 PM, Ahmed Hashim
> <ahmedhashim1@gmail.com<mailto:ahmedhashim1@gmail.com>> wrote:
>
> Dear Khalid,
> Can you upload the file to DropBox and share the link? so that other
> members can get the general idea about your problem in detail. As per
> my experience this forum senior members are more then willing to help
> any newbie/novice/experience Ms.Access programmer then anyone. But you
> have to do your part also to provide as much detail as possible.
> Best regards
>
> Ahmed
>
> On Tue, Oct 22, 2013 at 3:12 PM, Khalid Tanweer
> <khalidtanweerburrah@yahoo.com<mailto:khalidtanweerburrah@yahoo.com>>
> wrote:
>
> Duane,
>
> I told you the size of zip file.
>
> Khalid
>
> On Tuesday, October 22, 2013 2:27 PM, John Viescas
> <JohnV@msn.com<mailto:JohnV@msn.com>> wrote:
>
> Khalid-
>
> Try putting it in a Zip file.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> From:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of
> khalidtanweerburrah@yahoo.com<mailto:khalidtanweerburrah@yahoo.com>
> Sent: Tuesday, October 22, 2013 10:02 AM
> To:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
> Subject: [MS_AccessPros] RE: After preview of report one record is
> appended in table filling two fields
>
>
>
> Duane,
>
> I deleted all other tables, queries, forms & reports except related for
> this subject report and compressed my database, and comes to size of
> 34,686 KB which is exceeding the upload limit of 10 MB.
>
> Now what to do ?
>
> Khalid
>
>
> ---In
> ms_access_professionals@yahoogroups.com<mailto:ms_access_professionals@yahoogroups.com>,
> <duanehookom@...<mailto:duanehookom@...>> wrote:
> Khalid,
>
> You can also troubleshoot by determining the value of the combo boxes.
> While your dialog form is open, press Ctrl+G to open the
> immediate/debug window. Then type in:
>
> ? [Forms]![Detailed Packing List Selective Productwise
> Dialog]![ConsignmentNo]
>
> When you press enter, you will see the current value of the combo box
> so you can compare the value with your data. Do the same for your
> second combo box.
>
> Again, consider posting a sample database to the group so we can easily
> put an end to this thread and never reply back with a statement like
> "It did not work" unless you provide the results/symptoms.
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: JohnV@...<mailto:JohnV@...>
>>
>> Khalid-
>>
>> The form "Detailed Packing List Selective Productwise Dialog" MUST not
>> have a Record Source! And the two combo boxes must have no Control
>> Source. Did you do that?
>>
>> You say it did not work. Did you open the query Datasheet as instructed?
>>
>> John Viescas, Author
>>
>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>>
>> John,
>>
>> It did not worked.
>>
>> According to my settings all is OK, getting the required results as per
>> values entered in combo boxes, except for additional record inserted in
>> tblCollectionVoucher.
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Monday, October 21, 2013 1:31 PM, John Viescas
>> <JohnV@...<mailto:JohnV@...><mailto:JohnV@...<mailto:JohnV@...>>> wrote:
>>
>>
>>
>> Khalid-
>>
>>
>>
>> That should work. At first, I thought maybe you miscounted the
>> parameter commas, but it appears to be correct. I hate counting
>> commas, so prefer to use named parameters instead, like this:
>>
>>
>>
>> DoCmd.OpenForm "Detailed Packing List Selective Productwise Dialog", _
>>
>> WindowMode:=acDialog
>>
>>
>>
>> When you open the report, you should not see it at all - only the
>> form. After filling in the parameters and clicking the button to hide
>> the form, the report should appear with the filtered records.
>>
>>
>>
>> Try opening the report, filling in the parameters with ones you think
>> should work, then hiding the form so that the report shows. Leave the
>> report open. If it is blank, go to the Navigation Pane, find the query
>> on which the report is based, open it in Design view to make sure you
>> have the right one, then switch to Datasheet view. The form should
>> still be open hidden, so the parameters should resolve correctly. If
>> the Datasheet shows no records, you have chosen parameter values that
>> return no records.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Monday, October 21, 2013 1:04 AM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] RE: After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> John,
>>
>>
>>
>> Open event of this report is:
>>
>>
>>
>> Private Sub Report_Open(Cancel As Integer)
>>
>> 'Set public variable to true to indicate that the report is in the
> Open event
>>
>> bInReportOpenEvent = True
>>
>>
>>
>> 'Open Detailed Packing List Selective Productwise Dialog
>>
>> DoCmd.OpenForm "Detailed Packing List Selective Productwise
>> Dialog", , , , , acDialog
>>
>>
>>
>> 'Cancel Report if User clicked the Cancel Button
>>
>> If IsLoaded("Detailed Packing List Selective Productwise Dialog") =
>> False Then Cancel = True
>>
>>
>>
>> 'Set public variable to false to indicate that the Open event is completed
>>
>> bInReportOpenEvent = False
>>
>>
>>
>> End Sub
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Monday, October 21, 2013 1:56 AM, John Viescas
>> <JohnV@...<mailto:JohnV@...><mailto:JohnV@...<mailto:JohnV@...>>> wrote:
>>
>>
>>
>> Khalid-
>>
>>
>>
>> What is the code in the Open event of the Report? The trick to doing
>> it this way is to open the parameter form WindowMode:=acDialog. That
>> makes the report wait until the two parameters are set and the form
>> hides itself.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Sunday, October 20, 2013 7:31 PM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] RE: After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> John,
>>
>>
>>
>> Yes after setting the two combo boxes, on clicking "CmdOK" button On
>> Click event is:
>>
>> Private Sub CmdOK_Click()
>>
>> Me.Visible = False
>>
>> End Sub
>>
>>
>>
>> Reports Close event is:
>>
>>
>>
>> Private Sub Report_Close()
>>
>> DoCmd.Close acForm, "Detailed Packing List Selective Productwise Dialog"
>>
>> DoCmd.OpenForm "All Reports"
>>
>> DoCmd.Restore
>>
>> End Sub
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Sunday, October 20, 2013 10:03 PM, John Viescas
>> <JohnV@...<mailto:JohnV@...><mailto:JohnV@...<mailto:JohnV@...>>> wrote:
>>
>>
>>
>> Khalid-
>>
>>
>>
>> What is in the Open event of the Report? You must open the form as a
>> Dialog. Then what do you do on the form to let the report run? You
>> should be hiding the form after the two combos are set (Me.Visible =
>> False), and the Report Close event should be closing the form.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Sunday, October 20, 2013 6:37 PM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] RE: After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> John,
>>
>>
>>
>> I have tried this before also, and made the changes now again to check
>> the results. In this situation the report is blank gives no data.
>>
>>
>>
>> I may just add that forms open event is:
>>
>> Private Sub Form_Open(Cancel As Integer)
>>
>> If Not bInReportOpenEvent Then
>>
>> ' If we're not called from the report
>>
>> MsgBox "For use from the 'Detailed Packing List Selective
>> Productwise' Report only", _
>>
>> vbOKOnly
>>
>> Cancel = True
>>
>> End If
>>
>> Form_Open_Exit:
>>
>> Exit Sub
>>
>> End Sub
>>
>>
>>
>> Therefore, we double click on report then the form opens both combo
>> boxes work, but report is blank. This is in present situation which,
>> you suggested.
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Sunday, October 20, 2013 9:05 PM,
>> "zctek@...<mailto:zctek@...><mailto:zctek@...<mailto:zctek@...>>"
>> <zctek@...<mailto:zctek@...><mailto:zctek@...<mailto:zctek@...>>> wrote:
>>
>>
>>
>> Hi Khalid,
>>
>>
>>
>> I do not see why the extra record is created.
>> To pinpoint the problem just set a breakpoint or insert a trap by using
>>
>> a Msgbox in the BeforeUpdate Event of the form with the extra record.
>>
>>
>>
>> If vbYes = MsgBox("At FormBeforeUpdate. Stop Yes/No?, vbYesNo +
>> vbDefaultButton2) Then Stop
>> You can then click Yes if you want to stop or click No to continue.
>>
>>
>>
>> When you have stopped you can see where or why the extra record is creted.
>>
>>
>>
>> Hope that helps.
>>
>>
>>
>> Regards, Clive.
>>
>>
>> ---In
>>
> ms_access_professionals@yahoogroups.com<mailto:ms_access_professionals@yahoogroups.com><mailto:ms_access_professionals@yahoogroups.com<mailto:ms_access_professionals@yahoogroups.com>>,
>> <JohnV@...<mailto:JohnV@...<mailto:JohnV@...%3cmailto:JohnV@...>>> wrote:
>>
>> Khalid-
>>
>>
>>
>> The form with these combo boxes should have NO Record Source, and the
>> two combo boxes must have NO Control Source. I thought we had resolved
>> that.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Sunday, October 20, 2013 4:33 PM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> Duane,
>>
>>
>>
>> cmbConsignmentNo
>>
>>
>>
>> Row Source: SELECT DISTINCT CollectionVoucher.ConsignmentNo FROM
>> CollectionVoucher WHERE (((CollectionVoucher.ConsignmentNo) Is Not
>> Null)) ORDER BY CollectionVoucher.ConsignmentNo;
>>
>>
>>
>> Control Source: ConsignmentNo
>>
>>
>>
>> Bound Column: 1, Limit to List "Yes", Auto Expand "Yes", Enabled "Yes",
>> Locked "No", Column Count: 1
>>
>> -----------------------------------------
>>
>> cmbProductName
>>
>>
>>
>> Row Source: SELECT DISTINCT CollectionVoucher.ProductName FROM
>> CollectionVoucher WHERE (((CollectionVoucher.ProductName) Is Not Null)
>> AND ((CollectionVoucher.ConsignmentNo)=[cmbConsignmentNo])) ORDER BY
>> CollectionVoucher.ProductName;
>>
>>
>>
>> Control Source: ProductName
>>
>>
>>
>> Bound Column: 1, Limit to List "Yes", Auto Expand "Yes", Enabled "Yes",
>> Locked "No", Column Count: 1
>>
>>
>>
>> At present i am working with all these settings and it is still
>> inserting one new record in table "Collection Voucher" filling
>> "ConsignmentNo" and "ProductName", in query i have put in criteria "Is
>> Not Null" for rest of the fields so that in report blank rows may not
>> display. This is because the real data has been entered in application
>> and my boss is getting printouts of this particular report often. I
>> cannot make him annoy with showing blank rows in report.
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Sunday, October 20, 2013 2:23 PM, John Viescas
>> <JohnV@...<mailto:JohnV@...<mailto:JohnV@...%3cmailto:JohnV@...>>> wrote:
>>
>>
>>
>> Khalid-
>>
>>
>>
>> I did not ask you for the Record Source. I asked you for the ROW
>> SOURCE of the two combo boxes and the setting for the Bound Column
>> property for both.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Sunday, October 20, 2013 10:40 AM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> Duane,
>>
>>
>>
>> Record source for report is a Query:
>>
>>
>>
>> SELECT CollectionVoucher.ConsignmentNo, CollectionVoucher.ClientCIN,
>> CollectionVoucher.ClientName, CollectionVoucher.ConsigneeName,
>> CollectionVoucher.CollectionDate, CollectionVoucher.CartonNo,
>> CollectionVoucher.ProductName, CollectionVoucher.ProductQty,
>> CollectionVoucher.WeightOfCarton
>>
>> FROM CollectionVoucher
>>
>> WHERE (((CollectionVoucher.ConsignmentNo)=[Forms]![Detailed Packing
>> List Selective Productwise Dialog]![ConsignmentNo]) AND
>> ((CollectionVoucher.ClientCIN) Is Not Null) AND
>> ((CollectionVoucher.ClientName) Is Not Null) AND
>> ((CollectionVoucher.ConsigneeName) Is Not Null) AND
>> ((CollectionVoucher.CollectionDate) Is Not Null) AND
>> ((CollectionVoucher.CartonNo) Is Not Null) AND
>> ((CollectionVoucher.ProductName)=[Forms]![Detailed Packing List
>> Selective Productwise Dialog]![ProductName]) AND
>> ((CollectionVoucher.ProductQty) Is Not Null) AND
>> ((CollectionVoucher.WeightOfCarton) Is Not Null));
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Sunday, October 20, 2013 12:16 PM, John Viescas
>> <JohnV@...<mailto:JohnV@...<mailto:JohnV@...%3cmailto:JohnV@...>>> wrote:
>>
>>
>>
>> Khalid-
>>
>>
>>
>> That just proves that your form was bound before - selecting a value in
>> either combo created a new record!
>>
>>
>>
>> What is the Row Source and Bound Column of the two combo boxes? I
>> suspect you are missing a column.
>>
>>
>>
>> John Viescas, Author
>>
>> Microsoft Access 2010 Inside Out
>>
>> Microsoft Access 2007 Inside Out
>>
>> Microsoft Access 2003 Inside Out
>>
>> Building Microsoft Access Applications
>>
>> SQL Queries for Mere Mortals
>>
>> http://www.viescas.com/
>>
>> (Paris, France)
>>
>>
>>
>>
>>
>>
>>
>> From:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>]
> On Behalf Of Khalid
>> Tanweer
>> Sent: Sunday, October 20, 2013 12:05 AM
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> Subject: Re: [MS_AccessPros] After preview of report one record is
>> appended in table filling two fields
>>
>>
>>
>>
>>
>> Duane,
>>
>>
>>
>> I removed Record Source of Dialog Form, obviously i had to remove
>> Control Source of both combo boxes on the Dialog form (Correct ?) Row
>> Sources are still there. Both combo boxes show their drop down lists
>> also and selection of any item is available.
>>
>>
>>
>> But now the report preview is blank ?
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Sunday, October 20, 2013 2:09 AM, Duane Hookom
>>
> <duanehookom@...<mailto:duanehookom@...<mailto:duanehookom@...%3cmailto:duanehookom@...>>>
> wrote:
>>
>>
>>
>> Just remove the record source from your dialog form. No more, no less.
>>
>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>> From:
> khalidtanweerburrah@...<mailto:khalidtanweerburrah@<mailto:khalidtanweerburrah@...%3cmailto:khalidtanweerburrah@>...>
>> Date: Fri, 18 Oct 2013 10:29:39 -0700
>> Subject: Re: [MS_AccessPros] After preview of report one record is
>> appended in table filling two fields
>>
>> Duane,
>>
>>
>>
>> The purpose for making Dialog form was that i put two combo boxes on it:
>>
>> cmbConsignmentNo
>>
>> cmbProductName
>>
>>
>>
>> so that user may select "ConsignmentNo" and "ProductName" and main
>> reason is that ProductName is a combination of two languages, first
>> part is in English and second in other language like "abc / ......" so
>> it is difficult for user to type it in Parameter Value box: Enter
>> Product Name
>>
>>
>>
>> Is there any way if user just types English Part of ProductName and
>> gets the required result?
>>
>> OR give any suggestions for current Dialog form "Detailed Packing List
>> Selective Productwise Dialog"
>>
>>
>>
>> Khalid
>>
>>
>>
>> On Friday, October 18, 2013 9:58 PM, Duane Hookom
>>
> <duanehookom@...<mailto:duanehookom@...<mailto:duanehookom@...%3cmailto:duanehookom@...>>>
> wrote:
>>
>>
>>
>> Khalid,
>>
>> Ok, but why is the form bound to a record source? Table or query
>> doesn't make any difference in this instance. Does it need to be? It
>> sounds like you are moving to a new record, entering values into fields
>> of the new record and then wondering why you have a new record.
>>
>> Duane Hookom MVP
>> MS Access
>>
>> ________________________________
>>
>>> To:
>>
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
>>> From:
> khalidtanweerburrah@...<mailto:khalidtanweerburrah@<mailto:khalidtanweerburrah@...%3cmailto:khalidtanweerburrah@>...>
>>> Date: Fri, 18 Oct 2013 09:19:50 -0700
>>> Subject: Re: [MS_AccessPros] After preview of report one record is
>>> appended in table filling two fields
>>>
>>>
>>>
>>> Duane,
>>>
>>> Its not bound to table and its Record Source is :Consignment Summary
>>> All Clients Selective Productwise Query
>>>
>>> I have put SQL of this query earlier, you can see it on the top.
>>>
>>> Khalid
>>>
>>>
>>>
>>> On Friday, October 18, 2013 9:50 AM, Duane Hookom
>>>
> <duanehookom@...<mailto:duanehookom@...<mailto:duanehookom@...%3cmailto:duanehookom@...>>>
> wrote:
>>>
>>> Khalid,
>>>
>>> I expect [Forms]![Detailed Packing List Selective Productwise Dialog]
>>> is bound to your table. I expect it should not be bound to any table.
>>>
>>> Duane Hookom MVP
>>> MS Access
>>>
>>> ________________________________
>>>> From:
> khalidtanweerburrah@...<mailto:khalidtanweerburrah@<mailto:khalidtanweerburrah@...%3cmailto:khalidtanweerburrah@>...>
>>>>
>>>>
>>>> I have been checking for hours this report and its query and its Dialog
>>>> type form but unable to find the problem, at last came here for help.
>>>>
>>>> I have a report "Detailed Packing List Selective Productwise" (Report
>>>> is giving correct results) its Record Source is:
>>>>
>>>> SELECT CollectionVoucher.ConsignmentNo, CollectionVoucher.ClientCIN,
>>>> CollectionVoucher.ClientName, CollectionVoucher.ConsigneeName,
>>>> CollectionVoucher.CollectionDate, CollectionVoucher.CartonNo,
>>>> CollectionVoucher.ProductName, CollectionVoucher.ProductQty,
>>>> CollectionVoucher.WeightOfCarton
>>>> FROM CollectionVoucher
>>>> WHERE (((CollectionVoucher.ConsignmentNo)=[Forms]![Detailed Packing
>>>> List Selective Productwise Dialog]![ConsignmentNo]) AND
>>>> ((CollectionVoucher.ProductName)=[Forms]![Detailed Packing List
>>>> Selective Productwise Dialog]![ProductName]));
>>>>
>>>> Form "Detailed Packing List Selective Productwise Dialog" its Record
>>>> Source is as above. This form has two combo boxes:
>>>> "cmbConsignmentNo" Row Source:
>>>> SELECT DISTINCT CollectionVoucher.[ConsignmentNo] FROM
>>>> CollectionVoucher WHERE CollectionVoucher.[ConsignmentNo] Is Not Null
>>>> ORDER BY CollectionVoucher.[ConsignmentNo];
>>>>
>>>> "cmbProductName" Row Source:
>>>> SELECT DISTINCT CollectionVoucher.[ProductName] FROM CollectionVoucher
>>>> WHERE CollectionVoucher.[ConsignmentNo]=cmbConsignmentNo ORDER BY
>>>> CollectionVoucher.[ProductName];
>>>>
>>>> PROBLEM:
>>>> After previewing the report each time table "CollectionVoucher" gets
>>>> one more record with filling field "ConsignmentNo" and field
>>>> "ProductName" other fields remain blank.
>>>>
>>>> How to restrict this?
>>>>
>>>> Khalid
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
>
>
>
>
>
>
>