|
 |
access thread: Need some help
Message #1 by Dr P Singh <psinghp@e...> on Sat, 28 Dec 2002 13:47:30 +0400
|
|
Hi Every one
Happy new year
I have this simple problem but cant solve it.
I have two tables "tblMain". The table "Main" has three fields, ID, Month and Name. ID is the
autonumber while Month and Name are text fields.
I have built a query qName which has all the three fiels from table "tblMain". I have created
a form with a subform. The main form has a listbox is populated with "Jan-->Dec", while the
subform is based on the qName.
The criteria for the field Month in the query "qMain" set to [Forms]![frmDodo]![List0] and the
default for the list box is set to "Jan".
When I run the form, the form is populated correctly according to the default value "Jan",
however when I select a different value in the list box, the subform is not populated again?.
How could I getthe subform populated as per my selection in the list box.
Access digest wrote:
> -----------------------------------------------
> When replying to the digest, please quote only
> relevant material, and edit the subject line to
> reflect the message you are replying to.
> -----------------------------------------------
>
> The URL for this list is:
> http://p2p.wrox.com/list.asp?list=access
> ACCESS Digest for Saturday, December 21, 2002.
>
> 1. RE: Transferring data with lookup tables
> 2. RE: Realy need Help
> 3. RE: Ghosts
> 4. RE: Ghosts
> 5. RE: Exporting to excel template
> 6. RE: Ghosts
>
> ----------------------------------------------------------------------
>
> Subject: RE: Transferring data with lookup tables
> From: "Enzo Zaragoza" <enzaux@g...>
> Date: Sat, 21 Dec 2002 09:52:44 +0800
> X-Message-Number: 1
>
> Great idea! Thanks! I guess that's the way I'll do it. :D
>
> Thanks,
>
> enzo c",)?
>
> -----Original Message-----
> From: Carnley, Dave [mailto:dcarnley@a...]
> Sent: Friday, December 20, 2002 11:28 PM
> To: Access
> Subject: [access] RE: Transferring data with lookup tables
>
> You would have to store a "modified date" for the lookup table records. Are
> they very large tables? Most lookups are relatively smaller than the
> entities that refer to them...
>
> Oh I just had an idea...you could write a query that only extracted the
> lookup values actually used by the data you were exporting. Any value int
> he lookup table not used by the new/changed master records would be ignored.
> That owuld be pretty easy to do I think.
>
> -----Original Message-----
> From: Enzo Zaragoza [mailto:enzaux@g...]
> Sent: Thursday, December 19, 2002 8:10 PM
> To: Access
> Subject: [access] RE: Transferring data with lookup tables
>
> Yup actually that is the way it's gonna be. But the issue here is
> what data in the look up tables that I will include in the export? Are
> there
> any way that I can include only those data that were only updated or
> recently added?
>
> Thanks,
>
> enzo c",)(tm)
> http://www.tropangwatakwatak.tk
>
> -----Original Message-----
> From: Carnley, Dave [mailto:dcarnley@a...]
> Sent: Thursday, December 19, 2002 11:22 PM
> To: Access
> Subject: [access] RE: Transferring data with lookup tables
>
> send multiple files in multiple emails
>
> -----Original Message-----
> From: Enzo Zaragoza [mailto:enzaux@g...]
> Sent: Thursday, December 19, 2002 12:34 AM
> To: Access
> Subject: [access] Transferring data with lookup tables
>
> Hi! On my previous post regarding on how would I setup my tables
> (Transaction & Sender),
> you've suggested that I must hve Transaction table's SenderID linked only to
> the Senders table to
> avoid redundancy on the Transction table. Followin your suggestions, it is
> working
> out fine, but my problem is exporting the Transactions to a text file to be
> imported in the
> Central Station, I don't know how would I include the Sender Information
> since all I
> have in the Transaction table is SenderID. What I have in mind is to have
> also a
> Sender table in the Central Station, but my problem is how will the Branch
> transfer
> the Sender Info for new Senders and Updates for those existing senders.
>
> Branches export transactions once a week. Transactions are exported
> to a text file
> and then emailed to the Central Station. The Central Station will import
> the text file
> into the database. Exporting is done programatically and is not using
> Import/Export provided
> by Access.
>
> Suggestion please. Actually it's not the Sender ID only that is
> linked to Transaction
> table, there are other look up tables that are linked on Transaction table
> which also increments
> and updated occasionally.
>
> Thanks,
>
> enzo c",)(tm)
>
>
>
>
>
> ----------------------------------------------------------------------
>
> Subject: RE: Realy need Help
> From: "Basheer, Khyamuddin" <Khyamuddin_Basheer@a...>
> Date: Fri, 20 Dec 2002 23:13:58 -0700
> X-Message-Number: 2
>
> Nicola,
>
> I have been following you problem for quit some time. This is what I
> have cooked up for you.
>
> 1. create a field in you order master table as Last_invoice (Boolean).
> 2. Put a check box in you order main for and bound it to the above
> field.
> 3. In report underling query. put the criteria as last_invoice=3Dfalse.
>
> Inform your users that once they receive the last invoice for an order.
> click the check box last_invoice.
>
> Hope this solves your problem
>
> rgds
> Khyamuddin Basheer
> APL-Jeddah
> Saudi Arabia
> Tel 00966-2-6697397 Ext 32
> Fax 00966-2-6673212
>
> -----Original Message-----
> From: Nikola [mailto:Nikola@b...]
> Sent: Thursday, December 19, 2002 5:04 PM
> To: Access
> Subject: [access] Realy need Help
>
> Hi all,
>
> I was post this problem more then one time but without any luck. I'm
> desperate. So if you guys can help me with this.
>
> I have main form where user create Order. Each order have only one
> Estimated
> cost Received from Suppliers. But Suppliers can send more invoice amount
> for
> that Order. So I create Continues Subform (Invoice Order)In Subform I
> have 5
> field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> Now in Main form I create Order (OrderID =3D 14) and Estimated Cost for
> this
> Order is 5000 $.
> In Subform :
> InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> 1 14 2500$ 0% 12/11/2002
> 2 14 1000$ 0% 18/12/2002
> So total of invoice Cost for OrderID 14 is 3500 $.
> And I have Accrual Report. Accrual report show list of open Orders(
> orders
> with difference between Estemeted cost - TotalInvoice Cost).So in report
> by
> above example:
> OrderID OpenCost
> 14 1500$ (5000$ - 3500$)
>
> Now my problem. Because Estimated cost is not guarantied cost from
> supplier,
> difference between
> Estimated cost and TotalInvoice cots in 95% of orders will never be
> 0.00$.So
> I was thinking to create Check box (Last Invoice of Order).So when user
> receive last invoice for order hi gonna select check box and this order
> will
> not show anymore in Report.
> Enzo suggest to create List Box instead Subform but this is out of my
> leage(I dont know to make setup with list box and how is posible to add
> or
> edit record in list box)
>
> So guys please help me with any solution, idea advice!!!
>
> Thanks
>
>
> ----------------------------------------------------------------------
>
> Subject: RE: Ghosts
> From: "Charlie Goodwin" <cgoodwin@c...>
> Date: Sat, 21 Dec 2002 01:17:27 -0500
> X-Message-Number: 3
>
> MyControlName.Requery ........ didn't work, but I may have dug up an
> answer:
>
> If [LstCostItem]![ItemsSelected]![Count] =3D 0 Then
> MsgBox "Warning BlahBlah"
> Else
> DoCmd.OpenForm "MyFormName"
> End If
>
> It stops the process so forms don't come up to edit a non existant record.
>
> Charlie
>
> > Try this,
> >
> > Add the following line of code to your Edit/Delete buttons
> >
> > ' Requeries the ListCostItem listbox to the new values
> > ListCostItem.Requery
> >
> > John V. Ruff - The Eternal Optimist :-)
> > Always Looking For Contract Opportunities
> >
> > www.noclassroom.com
> > Live software training
> > Right over the Internet
> >
> > Home: xxx.xxx.xxxx
> > Cell: 253.307/2947
> > 9306 Farwest Dr SW
> > Lakewood, WA 98498
> >
> > "Commit to the Lord whatever you do,
> > and your plans will succeed." Proverbs 16:3
> >
> >
> >
> > -----Original Message-----
> > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> net.com]]
> > Sent: Friday, December 20, 2002 8:47 AM
> > To: Access
> > Subject: [access] RE: Ghosts
> >
> >
> > The plot thickens.
> >
> > My listbox seems to be retaining the last selected value, even if that va
> lue
> > is "impossible".
> >
> > To diagnose, I created a text box with the control source: =3D[LstCostIt
> em]
> > LstCostItem is a misbehaving listbox.
> >
> > If I select a detail, say detail 500 from, transaction 100. the box
> > dutifully displays 500.
> >
> > And then I move to main transaction record 101, without selecting a new
> > detail item at all, the display in the listbox changes, but the textbox
> > keeps showing 500 till I actually select a new detail. Once I make a new
> > selection, then everything works untill I move to a new record or remove
> the
> > previously selected item without selecting something further.
> >
> > I have tried refreshing the form... adding other code to look for "" I
> > suspect that is'nt the problem. I seem to have to make a new selection
> or
> > close the form to exorcise the ghost of the previous selection....
> >
> > Is my textbox telling me the truth about my errant listbox? Does this n
> ew
> > view of the problem help anyone help me?
> >
> > Charlie
> >
> >
> >
> >
> >
> >
> >
> > > if a field has enver had a value it is null, but if it had a value and
> > > then you deleted that value, the field value is "". Which is a heck
> > > of a lot like NULL but it isn't exactly NULL.
> > >
> > > (I hope this is correct and not a VB/VBA difference...)
> > >
> > > -----Original Message-----
> > > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > > Sent: Friday, December 20, 2002 3:09 AM
> > > To: Access
> > > Subject: [access] RE: Ghosts
> > >
> > >
> > > I've had this same problem. It seems to 'remember' that an item was
> > > previously selected.
> > >
> > > I'll go back and check the code, but I don't recall finding an answer.
> > > Let me know if you do!!
> > >
> > > Cheers,
> > > A
> > >
> > > -----Original Message-----
> > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> nknet.com]]
> > > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > Sent: Friday, 20 December 2002 5:05 PM
> > > To: Access
> > > Subject: [access] Ghosts
> > >
> > >
> > > I have been converting continuous subforms in a DB into unbound
> > > listboxes with adjacent buttons to summon up forms that will add a new
> > > transaction detail item, edit the item or remove the item.
> > >
> > > If no item has been selected in the listbox and the edit or delete is
> > > clicked, then a messagebox warns the user to make a selection. All is
> > fine
> > > so far.
> > >
> > > If I do select and delete the item, which really just sets it's value
> > > to $0, the item disappears from the listbox just as it should, since
> > > queries / SQL in the listbox, (and pretty much everything else in the
> > > DB) are set to eliminate $0 values.
> > >
> > > The oddity is that if I then click on edit or delete buttons, when the
> > > list has nothing currently selected, but did since the form was
> > > opened, I do not get warning messageboxes, but instead the edit or
> > > delete forms are summoned up.
> > >
> > > Somehow, the listboxes are appearing to retain the "ghost" of the value
> > they
> > > last had, which would be the detail item selected previously. Since
> > > nothing is selected, I would guess the listbox should be null. On the
> > edit
> > > and delete buttons I have code like this:
> > >
> > > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > > "Warning text " Else
> > > DoCmd.OpenForm "EditOrDeleteFormName"
> > > End If
> > >
> > > Other than this odd behaviour, they're working fine.
> > >
> > > Any ideas?
> > >
> > > Charlie
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> > >
> > > IMPORTANT - PLEASE READ ********************
> > > This email and any files transmitted with it are confidential and may
> > > contain information protected by law from disclosure. If you have
> > > received this message in error, please notify the sender immediately
> > > and delete this email from your system. No warranty is given that this
> > > email or files, if attached to this email, are free from computer
> > > viruses or other defects. They are provided on the basis the user
> > > assumes all responsibility for loss, damage or consequence resulting
> > > directly or indirectly from their use, whether caused by the
> > > negligence of the sender or not.
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> >
> >
> >
> >
>
> ----------------------------------------------------------------------
>
> Subject: RE: Ghosts
> From: "Charlie Goodwin" <cgoodwin@c...>
> Date: Sat, 21 Dec 2002 01:22:34 -0500
> X-Message-Number: 4
>
> Sorry, I forgot to append older portions of this thread...
>
> MyControlName.Requery ........ didn't work, but I may have dug up an
> answer:
>
> If [LstCostItem]![ItemsSelected]![Count] =3D 0 Then
> MsgBox "Warning BlahBlah"
> Else
> DoCmd.OpenForm "MyFormName"
> End If
>
> It stops the process so forms don't come up to edit a non existant record.
>
> Charlie
>
> Try this,
>
> Add the following line of code to your Edit/Delete buttons
>
> ' Requeries the ListCostItem listbox to the new values
> ListCostItem.Requery
>
> John V. Ruff - The Eternal Optimist :-)
> Always Looking For Contract Opportunities
>
> www.noclassroom.com
> Live software training
> Right over the Internet
>
> Home: xxx.xxx.xxxx
> Cell: 253.307/2947
> 9306 Farwest Dr SW
> Lakewood, WA 98498
>
> "Commit to the Lord whatever you do,
> and your plans will succeed." Proverbs 16:3
>
> -----Original Message-----
> From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> t.com]]
> Sent: Friday, December 20, 2002 8:47 AM
> To: Access
> Subject: [access] RE: Ghosts
>
> The plot thickens.
>
> My listbox seems to be retaining the last selected value, even if that value
> is "impossible".
>
> To diagnose, I created a text box with the control source: =3D[LstCostItem]
> LstCostItem is a misbehaving listbox.
>
> If I select a detail, say detail 500 from, transaction 100. the box
> dutifully displays 500.
>
> And then I move to main transaction record 101, without selecting a new
> detail item at all, the display in the listbox changes, but the textbox
> keeps showing 500 till I actually select a new detail. Once I make a new
> selection, then everything works untill I move to a new record or remove the
> previously selected item without selecting something further.
>
> I have tried refreshing the form... adding other code to look for "" I
> suspect that is'nt the problem. I seem to have to make a new selection or
> close the form to exorcise the ghost of the previous selection....
>
> Is my textbox telling me the truth about my errant listbox? Does this new
> view of the problem help anyone help me?
>
> Charlie
>
> > if a field has enver had a value it is null, but if it had a value and
> > then you deleted that value, the field value is "". Which is a heck
> > of a lot like NULL but it isn't exactly NULL.
> >
> > (I hope this is correct and not a VB/VBA difference...)
> >
> > -----Original Message-----
> > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > Sent: Friday, December 20, 2002 3:09 AM
> > To: Access
> > Subject: [access] RE: Ghosts
> >
> >
> > I've had this same problem. It seems to 'remember' that an item was
> > previously selected.
> >
> > I'll go back and check the code, but I don't recall finding an answer.
> > Let me know if you do!!
> >
> > Cheers,
> > A
> >
> > -----Original Message-----
> > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> net.com]]
> > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > Sent: Friday, 20 December 2002 5:05 PM
> > To: Access
> > Subject: [access] Ghosts
> >
> >
> > I have been converting continuous subforms in a DB into unbound
> > listboxes with adjacent buttons to summon up forms that will add a new
> > transaction detail item, edit the item or remove the item.
> >
> > If no item has been selected in the listbox and the edit or delete is
> > clicked, then a messagebox warns the user to make a selection. All is
> fine
> > so far.
> >
> > If I do select and delete the item, which really just sets it's value
> > to $0, the item disappears from the listbox just as it should, since
> > queries / SQL in the listbox, (and pretty much everything else in the
> > DB) are set to eliminate $0 values.
> >
> > The oddity is that if I then click on edit or delete buttons, when the
> > list has nothing currently selected, but did since the form was
> > opened, I do not get warning messageboxes, but instead the edit or
> > delete forms are summoned up.
> >
> > Somehow, the listboxes are appearing to retain the "ghost" of the value
> they
> > last had, which would be the detail item selected previously. Since
> > nothing is selected, I would guess the listbox should be null. On the
> edit
> > and delete buttons I have code like this:
> >
> > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > "Warning text " Else
> > DoCmd.OpenForm "EditOrDeleteFormName"
> > End If
> >
> > Other than this odd behaviour, they're working fine.
> >
> > Any ideas?
> >
> > Charlie
>
> > Try this,
> >
> > Add the following line of code to your Edit/Delete buttons
> >
> > ' Requeries the ListCostItem listbox to the new values
> > ListCostItem.Requery
> >
> > John V. Ruff - The Eternal Optimist :-)
> > Always Looking For Contract Opportunities
> >
> > www.noclassroom.com
> > Live software training
> > Right over the Internet
> >
> > Home: xxx.xxx.xxxx
> > Cell: 253.307/2947
> > 9306 Farwest Dr SW
> > Lakewood, WA 98498
> >
> > "Commit to the Lord whatever you do,
> > and your plans will succeed." Proverbs 16:3
> >
> >
> >
> > -----Original Message-----
> > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> net.com]] [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > Sent: Friday, December 20, 2002 8:47 AM
> > To: Access
> > Subject: [access] RE: Ghosts
> >
> >
> > The plot thickens.
> >
> > My listbox seems to be retaining the last selected value, even if that va
> lue
> > is "impossible".
> >
> > To diagnose, I created a text box with the control source: =3D[LstCostIt
> em]
> > LstCostItem is a misbehaving listbox.
> >
> > If I select a detail, say detail 500 from, transaction 100. the box
> > dutifully displays 500.
> >
> > And then I move to main transaction record 101, without selecting a new
> > detail item at all, the display in the listbox changes, but the textbox
> > keeps showing 500 till I actually select a new detail. Once I make a new
> > selection, then everything works untill I move to a new record or remove
> the
> > previously selected item without selecting something further.
> >
> > I have tried refreshing the form... adding other code to look for "" I
> > suspect that is'nt the problem. I seem to have to make a new selection
> or
> > close the form to exorcise the ghost of the previous selection....
> >
> > Is my textbox telling me the truth about my errant listbox? Does this n
> ew
> > view of the problem help anyone help me?
> >
> > Charlie
> >
> >
> >
> >
> >
> >
> >
> > > if a field has enver had a value it is null, but if it had a value and
> > > then you deleted that value, the field value is "". Which is a heck
> > > of a lot like NULL but it isn't exactly NULL.
> > >
> > > (I hope this is correct and not a VB/VBA difference...)
> > >
> > > -----Original Message-----
> > > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > > Sent: Friday, December 20, 2002 3:09 AM
> > > To: Access
> > > Subject: [access] RE: Ghosts
> > >
> > >
> > > I've had this same problem. It seems to 'remember' that an item was
> > > previously selected.
> > >
> > > I'll go back and check the code, but I don't recall finding an answer.
> > > Let me know if you do!!
> > >
> > > Cheers,
> > > A
> > >
> > > -----Original Message-----
> > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> nknet.com]] [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]] [mailto:
> cgoodwin@c...]]] [mailto:cgoodwin@c...]]]]
> > > Sent: Friday, 20 December 2002 5:05 PM
> > > To: Access
> > > Subject: [access] Ghosts
> > >
> > >
> > > I have been converting continuous subforms in a DB into unbound
> > > listboxes with adjacent buttons to summon up forms that will add a new
> > > transaction detail item, edit the item or remove the item.
> > >
> > > If no item has been selected in the listbox and the edit or delete is
> > > clicked, then a messagebox warns the user to make a selection. All is
> > fine
> > > so far.
> > >
> > > If I do select and delete the item, which really just sets it's value
> > > to $0, the item disappears from the listbox just as it should, since
> > > queries / SQL in the listbox, (and pretty much everything else in the
> > > DB) are set to eliminate $0 values.
> > >
> > > The oddity is that if I then click on edit or delete buttons, when the
> > > list has nothing currently selected, but did since the form was
> > > opened, I do not get warning messageboxes, but instead the edit or
> > > delete forms are summoned up.
> > >
> > > Somehow, the listboxes are appearing to retain the "ghost" of the value
> > they
> > > last had, which would be the detail item selected previously. Since
> > > nothing is selected, I would guess the listbox should be null. On the
> > edit
> > > and delete buttons I have code like this:
> > >
> > > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > > "Warning text " Else
> > > DoCmd.OpenForm "EditOrDeleteFormName"
> > > End If
> > >
> > > Other than this odd behaviour, they're working fine.
> > >
> > > Any ideas?
> > >
> > > Charlie
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> > >
> > > IMPORTANT - PLEASE READ ********************
> > > This email and any files transmitted with it are confidential and may
> > > contain information protected by law from disclosure. If you have
> > > received this message in error, please notify the sender immediately
> > > and delete this email from your system. No warranty is given that this
> > > email or files, if attached to this email, are free from computer
> > > viruses or other defects. They are provided on the basis the user
> > > assumes all responsibility for loss, damage or consequence resulting
> > > directly or indirectly from their use, whether caused by the
> > > negligence of the sender or not.
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> > >
> > > ---
> > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > unsubscribe send a blank email to
> >
> >
> >
> >
>
>
> ----------------------------------------------------------------------
>
> Subject: RE: Exporting to excel template
> From: "Steve Klein" <Stephen@K...>
> Date: Sat, 21 Dec 2002 06:27:39 -0000
> X-Message-Number: 5
>
> Bob is right. but his is also a disadvantage. If your group header is
> formated to Arial 16, which might work well on paper, it will be farmatted
> to Arial 16 on your spreadsheet. Which is why I recommended using the
> underlying query.
>
> Steve K
>
> -----Original Message-----
> From: Bob Bedell [mailto:bobbedell15@m...]
> Sent: 20 December 2002 21:49
> To: Access
> Subject: [access] RE: Exporting to excel template
>
> strReportName = "rptAlphabeticalListofCustomers"
> Docmd.OutputTo acOutputReport, strReportName, acFormatXLS,, True
>
> will also work and preserve minimal formatting like stepped groups
>
> >From: "Steve Klein" <Stephen@K...>
> >Reply-To: "Access" <access@p...>
> >To: "Access" <access@p...>
> >Subject: [access] RE: Exporting to excel template
> >Date: Fri, 20 Dec 2002 21:16:56 -0000
> >
> > DoCmd.OutputTo acOutputQuery,"QueryName", acFormatXLS, , True
> >
> >
> >Steve K
> >
> >
> >-----Original Message-----
> >From: Gerald, Rand [mailto:RGerald@u...]
> >Sent: 20 December 2002 19:22
> >To: Access
> >Subject: [access] RE: Exporting to excel template
> >Importance: High
> >
> >
> >One problem with the DoCmd.TransferSpreadsheet command is that it only
> >accepts TABLES as data sources. It will not work with QUERIES. The only
> >way around it is to use the query to create a temporary table and then use
> >DoCmd.TransferSpreadsheet with the temporary table.
> >
> >Rand E Gerald
> >Database Specialist
> >Information Services / Operations
> >Bahá'í National Office
> >1233 Central St.
> >Evanston IL 60201
> >(847) 733-3436
> >
> >-----Original Message-----
> >From: Steve Klein [mailto:Stephen@K...]
> >Sent: Friday, December 20, 2002 12:37
> >To: Access
> >Subject: [access] RE: Exporting to excel template
> >
> >Are you tryng to output to an excel spreadsheet or to a specific template?
> >
> >It is usually easier to work with the underlying query than outputting the
> >report
> >
> >Steve K
> >
> >
> >-----Original Message-----
> >From: Lesley Schulz [mailto:lesley.schulz@h...]
> >Sent: 20 December 2002 16:53
> >To: Access
> >Subject: [access] Exporting to excel template
> >
> >
> >I have a report in Access 97 that I want to export to an excel template.
> >On a form the user can press a button to export the document. How would I
> >program it to export that report to an excel template?
> >
> >Can anyone help?
> >
> >Thanks
> >Lesley Schulz
> >
> >
> >
> >
> >
> >
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 3 months FREE*.
> http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=747
> 4&SU
> http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspampr
> otection_3mf
>
>
> ----------------------------------------------------------------------
>
> Subject: RE: Ghosts
> From: "Bob Bedell" <bobbedell15@m...>
> Date: Sat, 21 Dec 2002 18:47:03 +0000
> X-Message-Number: 6
>
> Hi Charlie,
>
> The Requery method seemed like the way to go to me too. When I'm using
> a listbox as a subform, I often requery the listbox in two events
> associated with the parent form:
>
> Private Sub Form_Current()
> Me!lstMyListBox.Requery
> End Sub
>
> This keeps the 'child' list box synchronized with the parent form as I'm
> navigating through the records on the parent form. The 'link field'
> between the parent form and the listbox would be something like a
> ClientID field on the parent form that appears as a parameter field in
> the query underlying the list box's row source: [Forms]![frmClient]!
> [ClientID].
>
> The second place is:
>
> Private Sub Form_Activate()
> Me!lstMyListBox.Requery
> End Sub
>
> Here, if I open a form from the parent form to edit the content of the
> list box, the list box is requeried when the second form is closed and
> the listbox's parent form again becomes the active form.
>
> A couple more options to try.
>
> Bob
>
> >From: "Charlie Goodwin" <cgoodwin@c...>
> >Reply-To: "Access" <access@p...>
> >To: "Access" <access@p...>
> >CC: "andrew.haslett@i..." <andrew.haslett@i...>
> >Subject: [access] RE: Ghosts
> >Date: Sat, 21 Dec 2002 01:17:27 -0500
> >
> >MyControlName.Requery ........ didn't work, but I may have dug up an
> >answer:
> >
> >
> >If [LstCostItem]![ItemsSelected]![Count] = 0 Then
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 3 months FREE*.
> http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU
> http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspamprotection_3mf
>
> ---
>
> END OF DIGEST
>
Message #2 by "George Oro" <george@c...> on Sat, 28 Dec 2002 16:05:24 +0400
|
|
On Click of your ListBox try to put:
me.YourSubForm.Requery
HTH
George
> -----Original Message-----
> From: Dr P Singh [mailto:psinghp@e...]
> Sent: Saturday, December 28, 2002 1:48 PM
> To: Access
> Subject: [access] Need some help
>
>
> Hi Every one
>
> Happy new year
>
>
> I have this simple problem but cant solve it.
>
> I have two tables "tblMain". The table "Main" has three fields, ID, Month and Name. ID is the
> autonumber while Month and Name are text fields.
>
> I have built a query qName which has all the three fiels from table "tblMain". I have created
> a form with a subform. The main form has a listbox is populated with "Jan-->Dec", while the
> subform is based on the qName.
>
> The criteria for the field Month in the query "qMain" set to [Forms]![frmDodo]![List0] and the
> default for the list box is set to "Jan".
>
> When I run the form, the form is populated correctly according to the default value "Jan",
> however when I select a different value in the list box, the subform is not populated again?.
> How could I getthe subform populated as per my selection in the list box.
>
> Access digest wrote:
>
> > -----------------------------------------------
> > When replying to the digest, please quote only
> > relevant material, and edit the subject line to
> > reflect the message you are replying to.
> > -----------------------------------------------
> >
> > The URL for this list is:
> > http://p2p.wrox.com/list.asp?list=access
> > ACCESS Digest for Saturday, December 21, 2002.
> >
> > 1. RE: Transferring data with lookup tables
> > 2. RE: Realy need Help
> > 3. RE: Ghosts
> > 4. RE: Ghosts
> > 5. RE: Exporting to excel template
> > 6. RE: Ghosts
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Transferring data with lookup tables
> > From: "Enzo Zaragoza" <enzaux@g...>
> > Date: Sat, 21 Dec 2002 09:52:44 +0800
> > X-Message-Number: 1
> >
> > Great idea! Thanks! I guess that's the way I'll do it. :D
> >
> > Thanks,
> >
> > enzo c",)?
> >
> > -----Original Message-----
> > From: Carnley, Dave [mailto:dcarnley@a...]
> > Sent: Friday, December 20, 2002 11:28 PM
> > To: Access
> > Subject: [access] RE: Transferring data with lookup tables
> >
> > You would have to store a "modified date" for the lookup table records. Are
> > they very large tables? Most lookups are relatively smaller than the
> > entities that refer to them...
> >
> > Oh I just had an idea...you could write a query that only extracted the
> > lookup values actually used by the data you were exporting. Any value int
> > he lookup table not used by the new/changed master records would be ignored.
> > That owuld be pretty easy to do I think.
> >
> > -----Original Message-----
> > From: Enzo Zaragoza [mailto:enzaux@g...]
> > Sent: Thursday, December 19, 2002 8:10 PM
> > To: Access
> > Subject: [access] RE: Transferring data with lookup tables
> >
> > Yup actually that is the way it's gonna be. But the issue here is
> > what data in the look up tables that I will include in the export? Are
> > there
> > any way that I can include only those data that were only updated or
> > recently added?
> >
> > Thanks,
> >
> > enzo c",)(tm)
> > http://www.tropangwatakwatak.tk
> >
> > -----Original Message-----
> > From: Carnley, Dave [mailto:dcarnley@a...]
> > Sent: Thursday, December 19, 2002 11:22 PM
> > To: Access
> > Subject: [access] RE: Transferring data with lookup tables
> >
> > send multiple files in multiple emails
> >
> > -----Original Message-----
> > From: Enzo Zaragoza [mailto:enzaux@g...]
> > Sent: Thursday, December 19, 2002 12:34 AM
> > To: Access
> > Subject: [access] Transferring data with lookup tables
> >
> > Hi! On my previous post regarding on how would I setup my tables
> > (Transaction & Sender),
> > you've suggested that I must hve Transaction table's SenderID linked only to
> > the Senders table to
> > avoid redundancy on the Transction table. Followin your suggestions, it is
> > working
> > out fine, but my problem is exporting the Transactions to a text file to be
> > imported in the
> > Central Station, I don't know how would I include the Sender Information
> > since all I
> > have in the Transaction table is SenderID. What I have in mind is to have
> > also a
> > Sender table in the Central Station, but my problem is how will the Branch
> > transfer
> > the Sender Info for new Senders and Updates for those existing senders.
> >
> > Branches export transactions once a week. Transactions are exported
> > to a text file
> > and then emailed to the Central Station. The Central Station will import
> > the text file
> > into the database. Exporting is done programatically and is not using
> > Import/Export provided
> > by Access.
> >
> > Suggestion please. Actually it's not the Sender ID only that is
> > linked to Transaction
> > table, there are other look up tables that are linked on Transaction table
> > which also increments
> > and updated occasionally.
> >
> > Thanks,
> >
> > enzo c",)(tm)
> >
> >
> >
> >
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Realy need Help
> > From: "Basheer, Khyamuddin" <Khyamuddin_Basheer@a...>
> > Date: Fri, 20 Dec 2002 23:13:58 -0700
> > X-Message-Number: 2
> >
> > Nicola,
> >
> > I have been following you problem for quit some time. This is what I
> > have cooked up for you.
> >
> > 1. create a field in you order master table as Last_invoice (Boolean).
> > 2. Put a check box in you order main for and bound it to the above
> > field.
> > 3. In report underling query. put the criteria as last_invoice=3Dfalse.
> >
> > Inform your users that once they receive the last invoice for an order.
> > click the check box last_invoice.
> >
> > Hope this solves your problem
> >
> > rgds
> > Khyamuddin Basheer
> > APL-Jeddah
> > Saudi Arabia
> > Tel 00966-2-6697397 Ext 32
> > Fax 00966-2-6673212
> >
> > -----Original Message-----
> > From: Nikola [mailto:Nikola@b...]
> > Sent: Thursday, December 19, 2002 5:04 PM
> > To: Access
> > Subject: [access] Realy need Help
> >
> > Hi all,
> >
> > I was post this problem more then one time but without any luck. I'm
> > desperate. So if you guys can help me with this.
> >
> > I have main form where user create Order. Each order have only one
> > Estimated
> > cost Received from Suppliers. But Suppliers can send more invoice amount
> > for
> > that Order. So I create Continues Subform (Invoice Order)In Subform I
> > have 5
> > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > Now in Main form I create Order (OrderID =3D 14) and Estimated Cost for
> > this
> > Order is 5000 $.
> > In Subform :
> > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > 1 14 2500$ 0% 12/11/2002
> > 2 14 1000$ 0% 18/12/2002
> > So total of invoice Cost for OrderID 14 is 3500 $.
> > And I have Accrual Report. Accrual report show list of open Orders(
> > orders
> > with difference between Estemeted cost - TotalInvoice Cost).So in report
> > by
> > above example:
> > OrderID OpenCost
> > 14 1500$ (5000$ - 3500$)
> >
> > Now my problem. Because Estimated cost is not guarantied cost from
> > supplier,
> > difference between
> > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > 0.00$.So
> > I was thinking to create Check box (Last Invoice of Order).So when user
> > receive last invoice for order hi gonna select check box and this order
> > will
> > not show anymore in Report.
> > Enzo suggest to create List Box instead Subform but this is out of my
> > leage(I dont know to make setup with list box and how is posible to add
> > or
> > edit record in list box)
> >
> > So guys please help me with any solution, idea advice!!!
> >
> > Thanks
> >
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Ghosts
> > From: "Charlie Goodwin" <cgoodwin@c...>
> > Date: Sat, 21 Dec 2002 01:17:27 -0500
> > X-Message-Number: 3
> >
> > MyControlName.Requery ........ didn't work, but I may have dug up an
> > answer:
> >
> > If [LstCostItem]![ItemsSelected]![Count] =3D 0 Then
> > MsgBox "Warning BlahBlah"
> > Else
> > DoCmd.OpenForm "MyFormName"
> > End If
> >
> > It stops the process so forms don't come up to edit a non existant record.
> >
> > Charlie
> >
> > > Try this,
> > >
> > > Add the following line of code to your Edit/Delete buttons
> > >
> > > ' Requeries the ListCostItem listbox to the new values
> > > ListCostItem.Requery
> > >
> > > John V. Ruff - The Eternal Optimist :-)
> > > Always Looking For Contract Opportunities
> > >
> > > www.noclassroom.com
> > > Live software training
> > > Right over the Internet
> > >
> > > Home: xxx.xxx.xxxx
> > > Cell: 253.307/2947
> > > 9306 Farwest Dr SW
> > > Lakewood, WA 98498
> > >
> > > "Commit to the Lord whatever you do,
> > > and your plans will succeed." Proverbs 16:3
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > net.com]]
> > > Sent: Friday, December 20, 2002 8:47 AM
> > > To: Access
> > > Subject: [access] RE: Ghosts
> > >
> > >
> > > The plot thickens.
> > >
> > > My listbox seems to be retaining the last selected value, even if that va
> > lue
> > > is "impossible".
> > >
> > > To diagnose, I created a text box with the control source: =3D[LstCostIt
> > em]
> > > LstCostItem is a misbehaving listbox.
> > >
> > > If I select a detail, say detail 500 from, transaction 100. the box
> > > dutifully displays 500.
> > >
> > > And then I move to main transaction record 101, without selecting a new
> > > detail item at all, the display in the listbox changes, but the textbox
> > > keeps showing 500 till I actually select a new detail. Once I make a new
> > > selection, then everything works untill I move to a new record or remove
> > the
> > > previously selected item without selecting something further.
> > >
> > > I have tried refreshing the form... adding other code to look for "" I
> > > suspect that is'nt the problem. I seem to have to make a new selection
> > or
> > > close the form to exorcise the ghost of the previous selection....
> > >
> > > Is my textbox telling me the truth about my errant listbox? Does this n
> > ew
> > > view of the problem help anyone help me?
> > >
> > > Charlie
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > > if a field has enver had a value it is null, but if it had a value and
> > > > then you deleted that value, the field value is "". Which is a heck
> > > > of a lot like NULL but it isn't exactly NULL.
> > > >
> > > > (I hope this is correct and not a VB/VBA difference...)
> > > >
> > > > -----Original Message-----
> > > > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > > > Sent: Friday, December 20, 2002 3:09 AM
> > > > To: Access
> > > > Subject: [access] RE: Ghosts
> > > >
> > > >
> > > > I've had this same problem. It seems to 'remember' that an item was
> > > > previously selected.
> > > >
> > > > I'll go back and check the code, but I don't recall finding an answer.
> > > > Let me know if you do!!
> > > >
> > > > Cheers,
> > > > A
> > > >
> > > > -----Original Message-----
> > > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > nknet.com]]
> > > > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > > Sent: Friday, 20 December 2002 5:05 PM
> > > > To: Access
> > > > Subject: [access] Ghosts
> > > >
> > > >
> > > > I have been converting continuous subforms in a DB into unbound
> > > > listboxes with adjacent buttons to summon up forms that will add a new
> > > > transaction detail item, edit the item or remove the item.
> > > >
> > > > If no item has been selected in the listbox and the edit or delete is
> > > > clicked, then a messagebox warns the user to make a selection. All is
> > > fine
> > > > so far.
> > > >
> > > > If I do select and delete the item, which really just sets it's value
> > > > to $0, the item disappears from the listbox just as it should, since
> > > > queries / SQL in the listbox, (and pretty much everything else in the
> > > > DB) are set to eliminate $0 values.
> > > >
> > > > The oddity is that if I then click on edit or delete buttons, when the
> > > > list has nothing currently selected, but did since the form was
> > > > opened, I do not get warning messageboxes, but instead the edit or
> > > > delete forms are summoned up.
> > > >
> > > > Somehow, the listboxes are appearing to retain the "ghost" of the value
> > > they
> > > > last had, which would be the detail item selected previously. Since
> > > > nothing is selected, I would guess the listbox should be null. On the
> > > edit
> > > > and delete buttons I have code like this:
> > > >
> > > > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > > > "Warning text " Else
> > > > DoCmd.OpenForm "EditOrDeleteFormName"
> > > > End If
> > > >
> > > > Other than this odd behaviour, they're working fine.
> > > >
> > > > Any ideas?
> > > >
> > > > Charlie
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > > >
> > > > IMPORTANT - PLEASE READ ********************
> > > > This email and any files transmitted with it are confidential and may
> > > > contain information protected by law from disclosure. If you have
> > > > received this message in error, please notify the sender immediately
> > > > and delete this email from your system. No warranty is given that this
> > > > email or files, if attached to this email, are free from computer
> > > > viruses or other defects. They are provided on the basis the user
> > > > assumes all responsibility for loss, damage or consequence resulting
> > > > directly or indirectly from their use, whether caused by the
> > > > negligence of the sender or not.
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > >
> > >
> > >
> > >
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Ghosts
> > From: "Charlie Goodwin" <cgoodwin@c...>
> > Date: Sat, 21 Dec 2002 01:22:34 -0500
> > X-Message-Number: 4
> >
> > Sorry, I forgot to append older portions of this thread...
> >
> > MyControlName.Requery ........ didn't work, but I may have dug up an
> > answer:
> >
> > If [LstCostItem]![ItemsSelected]![Count] =3D 0 Then
> > MsgBox "Warning BlahBlah"
> > Else
> > DoCmd.OpenForm "MyFormName"
> > End If
> >
> > It stops the process so forms don't come up to edit a non existant record.
> >
> > Charlie
> >
> > Try this,
> >
> > Add the following line of code to your Edit/Delete buttons
> >
> > ' Requeries the ListCostItem listbox to the new values
> > ListCostItem.Requery
> >
> > John V. Ruff - The Eternal Optimist :-)
> > Always Looking For Contract Opportunities
> >
> > www.noclassroom.com
> > Live software training
> > Right over the Internet
> >
> > Home: xxx.xxx.xxxx
> > Cell: 253.307/2947
> > 9306 Farwest Dr SW
> > Lakewood, WA 98498
> >
> > "Commit to the Lord whatever you do,
> > and your plans will succeed." Proverbs 16:3
> >
> > -----Original Message-----
> > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > t.com]]
> > Sent: Friday, December 20, 2002 8:47 AM
> > To: Access
> > Subject: [access] RE: Ghosts
> >
> > The plot thickens.
> >
> > My listbox seems to be retaining the last selected value, even if that value
> > is "impossible".
> >
> > To diagnose, I created a text box with the control source: =3D[LstCostItem]
> > LstCostItem is a misbehaving listbox.
> >
> > If I select a detail, say detail 500 from, transaction 100. the box
> > dutifully displays 500.
> >
> > And then I move to main transaction record 101, without selecting a new
> > detail item at all, the display in the listbox changes, but the textbox
> > keeps showing 500 till I actually select a new detail. Once I make a new
> > selection, then everything works untill I move to a new record or remove the
> > previously selected item without selecting something further.
> >
> > I have tried refreshing the form... adding other code to look for "" I
> > suspect that is'nt the problem. I seem to have to make a new selection or
> > close the form to exorcise the ghost of the previous selection....
> >
> > Is my textbox telling me the truth about my errant listbox? Does this new
> > view of the problem help anyone help me?
> >
> > Charlie
> >
> > > if a field has enver had a value it is null, but if it had a value and
> > > then you deleted that value, the field value is "". Which is a heck
> > > of a lot like NULL but it isn't exactly NULL.
> > >
> > > (I hope this is correct and not a VB/VBA difference...)
> > >
> > > -----Original Message-----
> > > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > > Sent: Friday, December 20, 2002 3:09 AM
> > > To: Access
> > > Subject: [access] RE: Ghosts
> > >
> > >
> > > I've had this same problem. It seems to 'remember' that an item was
> > > previously selected.
> > >
> > > I'll go back and check the code, but I don't recall finding an answer.
> > > Let me know if you do!!
> > >
> > > Cheers,
> > > A
> > >
> > > -----Original Message-----
> > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > net.com]]
> > > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > Sent: Friday, 20 December 2002 5:05 PM
> > > To: Access
> > > Subject: [access] Ghosts
> > >
> > >
> > > I have been converting continuous subforms in a DB into unbound
> > > listboxes with adjacent buttons to summon up forms that will add a new
> > > transaction detail item, edit the item or remove the item.
> > >
> > > If no item has been selected in the listbox and the edit or delete is
> > > clicked, then a messagebox warns the user to make a selection. All is
> > fine
> > > so far.
> > >
> > > If I do select and delete the item, which really just sets it's value
> > > to $0, the item disappears from the listbox just as it should, since
> > > queries / SQL in the listbox, (and pretty much everything else in the
> > > DB) are set to eliminate $0 values.
> > >
> > > The oddity is that if I then click on edit or delete buttons, when the
> > > list has nothing currently selected, but did since the form was
> > > opened, I do not get warning messageboxes, but instead the edit or
> > > delete forms are summoned up.
> > >
> > > Somehow, the listboxes are appearing to retain the "ghost" of the value
> > they
> > > last had, which would be the detail item selected previously. Since
> > > nothing is selected, I would guess the listbox should be null. On the
> > edit
> > > and delete buttons I have code like this:
> > >
> > > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > > "Warning text " Else
> > > DoCmd.OpenForm "EditOrDeleteFormName"
> > > End If
> > >
> > > Other than this odd behaviour, they're working fine.
> > >
> > > Any ideas?
> > >
> > > Charlie
> >
> > > Try this,
> > >
> > > Add the following line of code to your Edit/Delete buttons
> > >
> > > ' Requeries the ListCostItem listbox to the new values
> > > ListCostItem.Requery
> > >
> > > John V. Ruff - The Eternal Optimist :-)
> > > Always Looking For Contract Opportunities
> > >
> > > www.noclassroom.com
> > > Live software training
> > > Right over the Internet
> > >
> > > Home: xxx.xxx.xxxx
> > > Cell: 253.307/2947
> > > 9306 Farwest Dr SW
> > > Lakewood, WA 98498
> > >
> > > "Commit to the Lord whatever you do,
> > > and your plans will succeed." Proverbs 16:3
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > net.com]] [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > Sent: Friday, December 20, 2002 8:47 AM
> > > To: Access
> > > Subject: [access] RE: Ghosts
> > >
> > >
> > > The plot thickens.
> > >
> > > My listbox seems to be retaining the last selected value, even if that va
> > lue
> > > is "impossible".
> > >
> > > To diagnose, I created a text box with the control source: =3D[LstCostIt
> > em]
> > > LstCostItem is a misbehaving listbox.
> > >
> > > If I select a detail, say detail 500 from, transaction 100. the box
> > > dutifully displays 500.
> > >
> > > And then I move to main transaction record 101, without selecting a new
> > > detail item at all, the display in the listbox changes, but the textbox
> > > keeps showing 500 till I actually select a new detail. Once I make a new
> > > selection, then everything works untill I move to a new record or remove
> > the
> > > previously selected item without selecting something further.
> > >
> > > I have tried refreshing the form... adding other code to look for "" I
> > > suspect that is'nt the problem. I seem to have to make a new selection
> > or
> > > close the form to exorcise the ghost of the previous selection....
> > >
> > > Is my textbox telling me the truth about my errant listbox? Does this n
> > ew
> > > view of the problem help anyone help me?
> > >
> > > Charlie
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > > if a field has enver had a value it is null, but if it had a value and
> > > > then you deleted that value, the field value is "". Which is a heck
> > > > of a lot like NULL but it isn't exactly NULL.
> > > >
> > > > (I hope this is correct and not a VB/VBA difference...)
> > > >
> > > > -----Original Message-----
> > > > From: Haslett, Andrew [mailto:andrew.haslett@i...]
> > > > Sent: Friday, December 20, 2002 3:09 AM
> > > > To: Access
> > > > Subject: [access] RE: Ghosts
> > > >
> > > >
> > > > I've had this same problem. It seems to 'remember' that an item was
> > > > previously selected.
> > > >
> > > > I'll go back and check the code, but I don't recall finding an answer.
> > > > Let me know if you do!!
> > > >
> > > > Cheers,
> > > > A
> > > >
> > > > -----Original Message-----
> > > > From: Charlie Goodwin [mailto:cgoodwin@c...] [mailto:cgoodwin@c...
> > nknet.com]] [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]]
> > > > [mailto:cgoodwin@c...]] [mailto:cgoodwin@c...]]] [mailto:
> > cgoodwin@c...]]] [mailto:cgoodwin@c...]]]]
> > > > Sent: Friday, 20 December 2002 5:05 PM
> > > > To: Access
> > > > Subject: [access] Ghosts
> > > >
> > > >
> > > > I have been converting continuous subforms in a DB into unbound
> > > > listboxes with adjacent buttons to summon up forms that will add a new
> > > > transaction detail item, edit the item or remove the item.
> > > >
> > > > If no item has been selected in the listbox and the edit or delete is
> > > > clicked, then a messagebox warns the user to make a selection. All is
> > > fine
> > > > so far.
> > > >
> > > > If I do select and delete the item, which really just sets it's value
> > > > to $0, the item disappears from the listbox just as it should, since
> > > > queries / SQL in the listbox, (and pretty much everything else in the
> > > > DB) are set to eliminate $0 values.
> > > >
> > > > The oddity is that if I then click on edit or delete buttons, when the
> > > > list has nothing currently selected, but did since the form was
> > > > opened, I do not get warning messageboxes, but instead the edit or
> > > > delete forms are summoned up.
> > > >
> > > > Somehow, the listboxes are appearing to retain the "ghost" of the value
> > > they
> > > > last had, which would be the detail item selected previously. Since
> > > > nothing is selected, I would guess the listbox should be null. On the
> > > edit
> > > > and delete buttons I have code like this:
> > > >
> > > > If IsNull([Form]![TransactionFormName]![ListName]) Then MsgBox
> > > > "Warning text " Else
> > > > DoCmd.OpenForm "EditOrDeleteFormName"
> > > > End If
> > > >
> > > > Other than this odd behaviour, they're working fine.
> > > >
> > > > Any ideas?
> > > >
> > > > Charlie
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > > >
> > > > IMPORTANT - PLEASE READ ********************
> > > > This email and any files transmitted with it are confidential and may
> > > > contain information protected by law from disclosure. If you have
> > > > received this message in error, please notify the sender immediately
> > > > and delete this email from your system. No warranty is given that this
> > > > email or files, if attached to this email, are free from computer
> > > > viruses or other defects. They are provided on the basis the user
> > > > assumes all responsibility for loss, damage or consequence resulting
> > > > directly or indirectly from their use, whether caused by the
> > > > negligence of the sender or not.
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > > >
> > > > ---
> > > > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > > > unsubscribe send a blank email to
> > >
> > >
> > >
> > >
> >
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Exporting to excel template
> > From: "Steve Klein" <Stephen@K...>
> > Date: Sat, 21 Dec 2002 06:27:39 -0000
> > X-Message-Number: 5
> >
> > Bob is right. but his is also a disadvantage. If your group header is
> > formated to Arial 16, which might work well on paper, it will be farmatted
> > to Arial 16 on your spreadsheet. Which is why I recommended using the
> > underlying query.
> >
> > Steve K
> >
> > -----Original Message-----
> > From: Bob Bedell [mailto:bobbedell15@m...]
> > Sent: 20 December 2002 21:49
> > To: Access
> > Subject: [access] RE: Exporting to excel template
> >
> > strReportName = "rptAlphabeticalListofCustomers"
> > Docmd.OutputTo acOutputReport, strReportName, acFormatXLS,, True
> >
> > will also work and preserve minimal formatting like stepped groups
> >
> > >From: "Steve Klein" <Stephen@K...>
> > >Reply-To: "Access" <access@p...>
> > >To: "Access" <access@p...>
> > >Subject: [access] RE: Exporting to excel template
> > >Date: Fri, 20 Dec 2002 21:16:56 -0000
> > >
> > > DoCmd.OutputTo acOutputQuery,"QueryName", acFormatXLS, , True
> > >
> > >
> > >Steve K
> > >
> > >
> > >-----Original Message-----
> > >From: Gerald, Rand [mailto:RGerald@u...]
> > >Sent: 20 December 2002 19:22
> > >To: Access
> > >Subject: [access] RE: Exporting to excel template
> > >Importance: High
> > >
> > >
> > >One problem with the DoCmd.TransferSpreadsheet command is that it only
> > >accepts TABLES as data sources. It will not work with QUERIES. The only
> > >way around it is to use the query to create a temporary table and then use
> > >DoCmd.TransferSpreadsheet with the temporary table.
> > >
> > >Rand E Gerald
> > >Database Specialist
> > >Information Services / Operations
> > >Bahá'í National Office
> > >1233 Central St.
> > >Evanston IL 60201
> > >(847) 733-3436
> > >
> > >-----Original Message-----
> > >From: Steve Klein [mailto:Stephen@K...]
> > >Sent: Friday, December 20, 2002 12:37
> > >To: Access
> > >Subject: [access] RE: Exporting to excel template
> > >
> > >Are you tryng to output to an excel spreadsheet or to a specific template?
> > >
> > >It is usually easier to work with the underlying query than outputting the
> > >report
> > >
> > >Steve K
> > >
> > >
> > >-----Original Message-----
> > >From: Lesley Schulz [mailto:lesley.schulz@h...]
> > >Sent: 20 December 2002 16:53
> > >To: Access
> > >Subject: [access] Exporting to excel template
> > >
> > >
> > >I have a report in Access 97 that I want to export to an excel template.
> > >On a form the user can press a button to export the document. How would I
> > >program it to export that report to an excel template?
> > >
> > >Can anyone help?
> > >
> > >Thanks
> > >Lesley Schulz
> > >
> > >
> > >
> > >
> > >
> > >
> >
> > _________________________________________________________________
> > The new MSN 8: smart spam protection and 3 months FREE*.
> > http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=747
> > 4&SU
> > http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspampr
> > otection_3mf
> >
> >
> > ----------------------------------------------------------------------
> >
> > Subject: RE: Ghosts
> > From: "Bob Bedell" <bobbedell15@m...>
> > Date: Sat, 21 Dec 2002 18:47:03 +0000
> > X-Message-Number: 6
> >
> > Hi Charlie,
> >
> > The Requery method seemed like the way to go to me too. When I'm using
> > a listbox as a subform, I often requery the listbox in two events
> > associated with the parent form:
> >
> > Private Sub Form_Current()
> > Me!lstMyListBox.Requery
> > End Sub
> >
> > This keeps the 'child' list box synchronized with the parent form as I'm
> > navigating through the records on the parent form. The 'link field'
> > between the parent form and the listbox would be something like a
> > ClientID field on the parent form that appears as a parameter field in
> > the query underlying the list box's row source: [Forms]![frmClient]!
> > [ClientID].
> >
> > The second place is:
> >
> > Private Sub Form_Activate()
> > Me!lstMyListBox.Requery
> > End Sub
> >
> > Here, if I open a form from the parent form to edit the content of the
> > list box, the list box is requeried when the second form is closed and
> > the listbox's parent form again becomes the active form.
> >
> > A couple more options to try.
> >
> > Bob
> >
> > >From: "Charlie Goodwin" <cgoodwin@c...>
> > >Reply-To: "Access" <access@p...>
> > >To: "Access" <access@p...>
> > >CC: "andrew.haslett@i..." <andrew.haslett@i...>
> > >Subject: [access] RE: Ghosts
> > >Date: Sat, 21 Dec 2002 01:17:27 -0500
> > >
> > >MyControlName.Requery ........ didn't work, but I may have dug up an
> > >answer:
> > >
> > >
> > >If [LstCostItem]![ItemsSelected]![Count] = 0 Then
> >
> > _________________________________________________________________
> > The new MSN 8: smart spam protection and 3 months FREE*.
> > http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU
> > http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspamprotection_3mf
> >
> > ---
> >
> > END OF DIGEST
> >
>
>
>
Message #3 by Dr P Singh <psinghp@e...> on Sun, 29 Dec 2002 09:25:01 +0400
|
|
Sorry for the last posting. It happened by mistake. Hope it is Ok this time.
Prabhu
Hi Every one
Happy new year
I have this simple problem but cant solve it.
I have two tables "tblMain". The table "Main" has three fields, ID, Month and Name. ID is the
autonumber while Month and Name are text fields.
I have built a query qName which has all the three fiels from table "tblMain". I have created
a form with a subform. The main form has a listbox is populated with "Jan-->Dec", while the
subform is based on the qName.
The criteria for the field Month in the query "qMain" set to [Forms]![frmDodo]![List0] and the
default for the list box is set to "Jan".
When I run the form, the form is populated correctly according to the default value "Jan",
however when I select a different value in the list box, the subform is not populated again?.
How could I getthe subform populated as per my selection in the list box.
Prabhu
Message #4 by "George Oro" <george@c...> on Sun, 29 Dec 2002 09:54:36 +0400
|
|
Yah you're right "It happened by mistake". Anyhow can you try this:
On Click Events of your ListBox try to put:
me.YourSubForm.Requery
HTH
George
> -----Original Message-----
> From: Dr P Singh [mailto:psinghp@e...]
> Sent: Sunday, December 29, 2002 9:25 AM
> To: Access
> Subject: [access] Need some Help
>
>
> Sorry for the last posting. It happened by mistake. Hope it is Ok this time.
>
> Prabhu
>
>
> Hi Every one
>
> Happy new year
>
>
> I have this simple problem but cant solve it.
>
> I have two tables "tblMain". The table "Main" has three fields, ID, Month and Name. ID is the
> autonumber while Month and Name are text fields.
>
> I have built a query qName which has all the three fiels from table "tblMain". I have created
> a form with a subform. The main form has a listbox is populated with "Jan-->Dec", while the
> subform is based on the qName.
>
> The criteria for the field Month in the query "qMain" set to [Forms]![frmDodo]![List0] and the
> default for the list box is set to "Jan".
>
> When I run the form, the form is populated correctly according to the default value "Jan",
> however when I select a different value in the list box, the subform is not populated again?.
> How could I getthe subform populated as per my selection in the list box.
>
> Prabhu
>
>
>
>
>
|
|
|
View Cart
