List Box and Temp Table question

I have a form with two list boxes, and add/remove buttons.  The user moves 
Account Numbers from the first box [Accounts] to the second [Current 
Accounts].

Once users have selected the accounts they want in a report, I need those 
account numbers to pass to a temporary table [Acct Temp].  The report queries 
are based on this temp table.  I have tested the report by manually entering 
and removing account numbers in [Acct Temp] and it works great.  Now I need 
to know how to pass those account numbers from the list box.  And, how to 
remove those account numbers from the temp table after a report has been run.

Thanks,

Jeff

0
Utf
1/23/2008 1:42:29 AM
access.forms 6864 articles. 2 followers. Follow

0 Replies
866 Views

Similar Articles

[PageSpeed] 46

Reply:

Similar Artilces:

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Pivot Table to Ignore N/As
Hi, Does anyone know if it is possible to get a pivot table summary to ignore N/As within a table when summing the data? Nelson I don't. Maybe you could clean them up in the original data (if those cells are a formula): =if(iserror(yourformula),0,yourformula) Or even use another column: =if(iserror(b2),0,b2) Then use that other column in the pivottable. Nelson wrote: > > Hi, Does anyone know if it is possible to get a pivot table summary to > ignore N/As within a table when summing the data? > > Nelson -- Dave Peterson Thanks Dave, that's what we figure...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Exchange Data Storage Question
I have an idea for my company on how to re-store our Exchange data to be more disk efficient (I/O wise) and would like your opinions. Right now Exchange 2000 is running on a PowerEdge 1750 (on Server 2000). The physical box has (and can only hold internally) 3 hard drives, and they’re running Raid 5. I’ve read reports that Exchange has been set up on PowerEdge 1750's but the exchange database and logs are stored on a NAS, and I think they use a PowerVault in the example I read. We have a Dell PowerVault 220S that is attached to a *different* server (not to our Exchange server)....

Table SY05000 is huge
Hi, Can we safely remove records from the activity tracking table SY05000? It is so huge it takes up half our database. Thanks Short answer Yes "jennyc" <jennyc@discussions.microsoft.com> wrote in message news:17A3A615-B959-4D65-AF41-49F7E47868F0@microsoft.com... > Hi, > Can we safely remove records from the activity tracking table SY05000? It > is so huge it takes up half our database. > > Thanks Jenny: You didn't say which version of GP you're on. To remove user activity tracking you bring up the Remove Activity Tracking screen - Tools &g...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

Report showing counts of two tables
I'm trying to create a query for a report that will show total counts of inspections and reinspections. I have two tables, Inspections and Reinspections. For every inspection there may be one or more reinspections. The tables are ofcourse linked one to many. Each inspection has a Inspection Date field. Each reinspection has a Reinspection Date field. What I want is a report showing only the total number of Inspections and the total number of Reinspections. This seems easy but I can't get it to work. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...

Tricky Macro Question
I created a worksheet that consists of multiple fields of data (the columns are ie. date, point of contact, completion date, etc) and based on the inputs into those columns I have a formula that calculates whether or not a particular row of data should be classified as "Red" "Green" or "yellow". I would like to be able to create a macro which in turn takes all rows that have a "Red" qualifier and input that data onto a new worksheet. Also, I would like that macro to take all rows that have a "Green" qualifier and input that data...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Check Box to display records with completed status only
Hi, I have a query whereby a record is lablelled complete if the "Completed date" field has a date in it, otherwise it is blank. I want to check box on a form when ticked, to display a report with completed records only. Can anyone help? Thanks, B/ On your form, you have a command button to open the report, and a check box named (say) chkCompleteOnly. If the check box is checked, you want to open the report to show only the records that have a date in the [Completed date] field. The event procedure for the command button's Click event would look like this: Priv...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Make table query with calculated date fields
I have a make table query that calculates requirement dates based on a [StartDate]. All of the fields (80 of them) are set as Short Date in properties. But when the table is created all of the fields are text. I would like to avoid using the FORMAT command in the query and change the field properties of the table manually. Does anyone have a suggestion? Thank you in advance for your help. Share the SQL view of you make table query. -- Duane Hookom Microsoft Access MVP "Harry" wrote: > I have a make table query that calculates requirement dates based on a > [StartDat...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

sum if questions
Hi, I am having a memory block ! I need to sum costs in colum C, if column A = x and column B = Y. n When using sumif i appear to count all costs in column C not just the ones required.. any suggestiong where i'm going wrong ?? You can only use one condition with SUMIF. Either use SUMPRODUCT or SUM(IF(...)) entered as an array formula. Hope this helps. Pete G wrote: > Hi, I am having a memory block ! > I need to sum costs in colum C, if column A = x and column B = Y. > n > When using sumif i appear to count all costs in column C not just the ones > required.. any sugge...

Create rule question please
Outlook 2003 How do I make a rule that any incoming email with a blank subject line gets deleted unless it is from someone in my address book? -- Thanks... Bob On Sat, 8 Mar 2008 15:35:38 -0500, "Bob Newman" <bobnewman@cox.net> wrote: >Outlook 2003 > >How do I make a rule that any incoming email with a blank subject line gets >deleted unless it is from someone in my address book? You want your next to last rule to move anything that has not been handled yet and is in your address book to go to a folder of your choice. You make a separate rule to send anythi...

Jpeg's appearing as black boxes...
Version: 2008 I am new to using Word for Mac - having recently transferred from a PC. I am finding that some (not all) some documents are displaying the jpeg's on them as black boxes. Instead of the image the entire are is just black and prints this way also. The image displays correctly in the finder, but once the document is full size, the image is a black box. <br> Help please! How do I get my images back? <br><br>Thanks <br><br>Amber Hi Britamy: Chances are they are CMYK JPEGs. Word (or any other Microsoft Office application) can't handle CM...