Access Database

This is a discussion on "Access Database" within the Databases section. This forum, and the thread "Access Database are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Mar 8th, 2007, 03:01
New Member
Join Date: Mar 2007
Location: United Kingdom Of Great Britain
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Access Database

Hi i wonder if anyone can help me:

I have a database, with one table. I have one Form, for this one table, so that i can add, edit, ammend the data etc.

On the form i have about 25 rows, with 5 columns, each time someone wants to in this time take holiday, they would fill out the date, and the other 4 columns, i then want to 'query' everyone in the data base who has taken holiday on a certain date, so basically what im after is a custom query, whereby the user would type in the date, for which they are trying to search.

I can just about produce a simple query, but its not what im really, after, have consulted a few books, but to no avail, if there is anyone out there who could point me in the right direction, i would apreciate it!

Many thanks

Benjamjon
Version: Microsoft Office 2007
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Mar 8th, 2007, 20:19
New Member
Join Date: Feb 2007
Location: Concord, MA
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Access Database

Quote:
Originally Posted by benjamjon View Post
Hi i wonder if anyone can help me:

I have a database, with one table. I have one Form, for this one table, so that i can add, edit, ammend the data etc.

On the form i have about 25 rows, with 5 columns, each time someone wants to in this time take holiday, they would fill out the date, and the other 4 columns, i then want to 'query' everyone in the data base who has taken holiday on a certain date, so basically what im after is a custom query, whereby the user would type in the date, for which they are trying to search.

I can just about produce a simple query, but its not what im really, after, have consulted a few books, but to no avail, if there is anyone out there who could point me in the right direction, i would apreciate it!

Many thanks

Benjamjon
Version: Microsoft Office 2007

Try this web database framework, Nenest (http://www.nenest.com), which makes your life easier.

You can import that database to your Nenest online database on-the-fly.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
access 2007, custom queries

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
using access database ? saadi babar Classic ASP 13 Mar 19th, 2008 09:45
Microsoft Access Database Help? crackafaza Databases 10 Dec 7th, 2007 04:04
ASp Access database error drappendix Classic ASP 2 Jan 30th, 2007 08:36
Access database on the Web redkyna Databases 7 Aug 2nd, 2004 20:25
Access Database Library vor Classic ASP 1 Aug 16th, 2003 08:16


All times are GMT. The time now is 16:00.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42