| Home | Reviews | Forums | Downloads | $ EXTREME Deals $ | RealTime Pricing | Free Magazines | Gear | Folding Stats | Newsletter | Contact Us |
|
|
|||
|
||||
|
|||||||
| Register | Forum Rules | FAQ | Search | Today's Posts | Mark Forums Read |
| Welcome Guest Visitor! Please Register, It's Free and Fun To Participate! | |
|
The EXTREME Overclocking Forums are a place for people to learn how to overclock and tweak their PC's components like the CPU, memory (RAM), or video card in order to gain the maximum performance out of their system. There are lots of discussions about new processors, graphics cards, cooling products, power supplies, cases, and so much more!
You are currently viewing our boards as a "guest" which gives you limited access to view most discussions. You need to register before you can post: click the register link to proceed. Before you register, please read the forum rules. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own pictures, and access many other special features. Registration is fast, simple, and absolutely free! To start viewing messages, select the forum that you want to visit from the selection below. After you have registered and read the forum rules, you can check out the FAQ for more information on using the forum. We hope you enjoy your stay here! Note To Spammers: We do not allow unsolicited advertising! Spam is usually reported & deleted within minutes of it being posted, so don't waste your time (or ours)! |
|
| Please Register to Post a Reply |
|
|
Thread Tools |
03-01-2007, 05:50 PM
|
#1 | ||||
|
I Use Email ^_^
Senior Member
|
Database Problems (Access)
- I need to be able to make a query somehow that will allow me to have a GUI of some sort (other than SQL and the query "design view" itself) to allow me to set two dates to check all date fields that I have. It would be great if I could set it in a Form section. If you need more of what I need just ask and I will give more details. I don't have them, but I'll try and explain deeper if needed. This one shows you all of the tables I have.  This one shows you all of the forms I have.  This is the basic structure of ALL the tables.  This is the basic structure of ALL the sub forums.  This is the actual structure of the forum that will be used as data entry.  Now again what I want is when data is entered I have it sitting in them tables that are above. When there in there I need a query to find the data between certain dates, so that it's within a month period. Thats when my dad's monthly reports are due, but he wants to keep all data so that he has records. If you can't help me by just telling me or explaining it then I uploaded the .mdb file. [CLICK HERE] to obtain it. |
||||
|
|
|
03-02-2007, 02:09 PM
|
#2 | ||||
|
J.D. Freeman
Senior Member
|
Have you linked the tables?
|
||||
|
|
|
03-02-2007, 02:15 PM
|
#3 | ||||
|
I Use Email ^_^
Senior Member
|
Theres no reason to. I am going to have a master table that has all data in there so when anything gets entered it will also go to the master table so that I can search it. I'm just havening a problem with making that table and the queries in GUI format.
|
||||
|
|
|
03-03-2007, 10:27 AM
|
#4 | ||||
|
The Mad Beaker
Administrator
|
Geeze, it's been at least 5+ years since I've fooled with access, but I used to be pretty good at it. I'll take a look at your DB and let you know if I figure something out.
I need to reinstall office on my PC first (just did a clean XP install) |
||||
|
|
|
03-04-2007, 11:25 AM
|
#5 | ||||
|
I Use Email ^_^
Senior Member
|
Quote:
 That doesn't mean anyone else can't jump in and help out. |
||||
|
|
|
03-05-2007, 09:41 AM
|
#6 | ||||
|
The Mad Beaker
Administrator
|
Didn't forget about you... I was installing office on my PC Saturday then got side-tracked.
Thankfully my replacement video card came for my notebook so now I'm back up and running on my main machine (yes I use a notebook as my main pc) |
||||
|
|
|
03-05-2007, 10:05 AM
|
#7 | ||||
|
I Use Email ^_^
Senior Member
|
Quote:
|
||||
|
|
|
03-07-2007, 05:11 PM
|
#8 | ||||
|
The Mad Beaker
Administrator
|
Oh boy... so long since I've done any vbscript...
Without spending hours on end trying to re-teach myself, I think it basically would boil down to having two date fields, then a button to run the query and return the results in a window. I know, sounds simple in theory but coding it is another story. It's just been too long since I have touched a MS product requring coding (and with good reason). |
||||
|
|
Sponsored Links:
|
| Please Register to Post a Reply |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Confusing server access problems... | Verbitan | Programming, DBMS, HTML, Web Related | 23 | 10-31-2006 01:16 AM |
| Yum database problems | SteveR | Linux, BSD, Alternative OS's | 1 | 03-24-2006 02:16 PM |
| Problems to access Fórum-Community | Fernando_Celio | Official EOC Folding @ Home Team | 6 | 12-31-2004 06:19 AM |
| Easy Access/How To Easy Access fan filter/w pics | MISTA TING | Cases, Case Accessories, Case Modding | 2 | 09-11-2004 08:58 PM |
| Access Problems.. | AMD_newbie | General Windows Troubleshooting | 2 | 05-03-2004 07:52 PM |
| Thread Tools | |
|
|
