Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rating: Thread Rating: 12 votes, 5.00 average. Display Modes
Old 01-25-2013, 10:42 AM   #16
Kelly@AllenEnt
Newly Registered User
 
Join Date: Oct 2012
Location: Orlando, Florida, USA
Posts: 51
Thanks: 16
Thanked 2 Times in 1 Post
Kelly@AllenEnt is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

This was great. Thank you for the useful information.

Kelly@AllenEnt is offline   Reply With Quote
Old 02-04-2013, 07:32 AM   #17
MichalB
Newly Registered User
 
Join Date: Oct 2012
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
MichalB is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

That is brilliant, just what I need! Thanks!
MichalB is offline   Reply With Quote
Old 02-28-2013, 02:16 AM   #18
IAmNotABot
Newly Registered User
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 2 Times in 1 Post
IAmNotABot is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

Awesome tutorials! Site bookmarked

__________________
Humans are the only race that is known to build a $1500 computer just to see lolcats on their $600 HDTV.
IAmNotABot is offline   Reply With Quote
Old 07-01-2013, 01:45 AM   #19
trkl
Newly Registered User
 
Join Date: Jun 2013
Posts: 31
Thanks: 7
Thanked 0 Times in 0 Posts
trkl is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

plz punish me bob.i posted wrong.just to increase my post count to 10.i wont tell you why did u punish me?
trkl is offline   Reply With Quote
Old 08-16-2013, 10:01 PM   #20
Sarabjit
Newly Registered User
 
Join Date: Aug 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Sarabjit is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

Hello Boblarson,I am new to access. I am creating a student database. I have crated a single table for this database and a form. I need help with two combo boxes. I have created these two combo boxes named (Documents Submitted and Documents pending). Thease two boxes I created using "Lookup coloumn". I selected "I will type in the values that I want" for both the boxes. After I filled the values in both as (CV, Ielts, Passport Copy, Certificates, photo id). After this I gave the name and selected "Allow multiple values". Now in my form it shows both the combo boxes and in both the boxes it shows CV, Ielts etc. I can select multiple Items in both the boxes. I hope I am clear up to here.
Now at this point these two boxes (Document Submitted and Documents pending) are showing items (documents names) separately. What I want is to combine the values of both. I want to do is, if I select "CV, IELTS, passport copy" in document submitted box, rest of the pending names (Photo ID, Certificates) should automatically be filled in Document pending box. What ever I didnt select in Document submitted box should appear in Document pending box.
Can you help me in accomplish this. Please guide me through the process how I can do that. I shall be very thankful to you.

For better understanding i am attaching my file with it. Please check it and let me know.


cheers
Sarab
Attached Files
File Type: accdb Student Database.accdb (1.73 MB, 225 views)
Sarabjit is offline   Reply With Quote
Old 09-17-2013, 09:58 AM   #21
Nicesoni_ash
Newly Registered User
 
Join Date: Sep 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Nicesoni_ash is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

Couldn't understand your example. Where it is explained we need to exclud these particular records?
Nicesoni_ash is offline   Reply With Quote
Old 09-17-2013, 01:34 PM   #22
Sarabjit
Newly Registered User
 
Join Date: Aug 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Sarabjit is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

Hello Sir,

I have attached the file (one I am working on) with the previous post. If you can download and can have a look on document submitted and document pending field. you will understand. what I want is, when I select documents from document submitted filed, the pending document should automatically appear in document pending filed. If I selected 2 documents out of 6 in document submitted then rest 4 should automatically appear in doucments pending field, which will show that these documents are still pending to request from students.

Thanks

Sarabjit is offline   Reply With Quote
Old 10-14-2014, 07:31 AM   #23
themurph2000
Fat, drunk, and stupid
 
themurph2000's Avatar
 
Join Date: Sep 2007
Location: Chicago, IL USA
Posts: 181
Thanks: 8
Thanked 11 Times in 11 Posts
themurph2000 is on a distinguished road
Re: New Quick Tutorial - Exclude Data using a table

Hey, Bob. I don't know if you still monitor this site, but btabdevelopment.com appears to not exist at this point. Do you have an alternative website where you've posted this example? I could really use it to study for a problem I'm having with one of my databases.

Thanks

__________________
Patrick J. Murphy
Chicago, IL

"The only thing I hate more than hippie neo-liberal fascists and anarchists are the hypocrite fat cat suits they eventually grow up to become."---John Casey, Chuck
themurph2000 is offline   Reply With Quote
The Following User Says Thank You to themurph2000 For This Useful Post:
hassanogaibi (06-28-2016)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to mix two tables data to prepare report? captgnvr General 38 06-25-2010 08:57 AM
Splitting one table in to multiple tables- how to move the data afterwards fuddy Tables 4 05-29-2009 05:34 PM
record ids auto number problem. jason2885 Forms 4 07-03-2007 10:16 PM
[SOLVED] Show % values with one decimal place in CHART DATA TABLE jjafer Reports 2 04-13-2005 12:29 AM
Help Saving form data to a different table bessej43 Tables 2 08-27-2002 04:41 AM




All times are GMT -8. The time now is 01:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World