Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop mac malware memory monitor motherboard network operating system printer problem ram registry router security slow software sound svchost.exe trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: how to query a blank table or list

Reply  
Thread Tools
thewebbmasterone's Avatar
Computer Specs
Junior Member with 20 posts.
 
Join Date: Aug 2008
Location: New Hampshire
Experience: Intermediate
03-Aug-2008, 05:59 PM #1
Question Solved: how to query a blank table or list
I'm using ms access 2003 and i created a table that tracks safety violations at work. I have a column that allows me to select from a couple different statuses. I have 3, Corrected, not corrected, and void. I am trying to query the table so that i can see the complaints that are either marked not corrected, or have not been looked at yet and so the status is blank. So i need a query for "not corrected" and "blank". I'm new to visual basic and the coding that goes with it. Can someone please help me. Thanks.
Jimmy the Hand's Avatar
Senior Member with 1,134 posts.
 
Join Date: Jul 2006
Location: Hungary
Experience: Level 15 Paladin
04-Aug-2008, 05:23 AM #2
Hi

I'm not sure you need VBA code for this. You can create this query with the built in query builder. The condition will be something like Status <> "corrected".

Naturally, you can do this through VBA, too. One possible way is to define the query in SQL language, and open a recordset based on this SQL string. E.g.

Code:
Dim Rst As DAO.Recordset, mySQL As String
mySQL = "SELECT * FROM [tbl_Violations] WHERE [Status] <> 'corrected'"
Set Rst = CurrentDb.OpenRecordset(mySQL)
The first method is more convenient, and easier to use. The second method is good for something, too, but it all depends on what do you need it for.

Jimmy
__________________
'
It is advised to provide a clear, detailed description of the task, so that others can understand it, and offer the best possible help. Otherwise, you risk experts ignoring your request.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
04-Aug-2008, 11:12 AM #3
Webmaster, you have made several posts all dealing with different aspects of the same database.
(everyone - the other two are
http://forums.techguy.org/business-a...ble-based.html
http://forums.techguy.org/business-a...sn-t-fill.html)
It would be far more efficient if you only posted once - we will help you, but this scattershot process is going to have some people helping with some things and others with others, sometimes at cross purposes.

I have suggested that we use this as the thread to use at both the other threads.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
thewebbmasterone's Avatar
Computer Specs
Junior Member with 20 posts.
 
Join Date: Aug 2008
Location: New Hampshire
Experience: Intermediate
04-Aug-2008, 10:40 PM #4
reply
sorry, i'm new to all of this. usually i don't post anything on forums i just read them and fiddle until i figure it out. I'll post any further questions here in this thread.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
05-Aug-2008, 01:04 AM #5
That's ok - a lot of newcomers make that mistake. Welcome to the Forum!
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
05-Aug-2008, 10:14 AM #6
Agh...Jimmy, webmaster, since OBP is doing quite a bit of work on this in this thread
http://forums.techguy.org/business-a...ml#post6039245
I am going to just forget it all.
Reply

Tags
2003, access, blank, list, table

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:09 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.