A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dates in a listbox connected to a form...



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old November 16th, 2004, 05:04 PM
RusCat
external usenet poster
 
Posts: n/a
Default Dates in a listbox connected to a form...

Good morning,

Here is something I'm tryng to do, but can't seem to get a handle on. I am
hoping for some direction.

I have the following things listed in a listbox: today, this week, this
month, last week, last month, custom

I want to be able to click on THISWEEK and have all the records for this
week to show up on my form.

It is a projects table where our employees log in the hours they have spent
on a project. I need them to be able to see the data by the choices above.

ALSO: how would I create a CUSTOM set of data? Click on CUSTOM, some sort
of boxes appear where I could type in the 2 dates and everything between
those dates would show up on the form.

I've tried queries, but I'm just not getting it. I understand the logic
behind it, but just not how to get it done. I'm a novice Access user, so
please be gentle in your help and explainations !!

Thank you so much.
LisaB.
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cursor Positioning Colin Hammond General Discussion 3 November 2nd, 2004 08:42 PM
Can you move highlighted data from one listbox to another listbox on the same form? Col. Forbin General Discussion 2 September 24th, 2004 07:51 PM
Searching Records Melissa Lambino New Users 6 July 20th, 2004 04:51 AM
Passing value to modal child form in MS Access using VBA? Grahammer Using Forms 6 July 4th, 2004 11:53 PM


All times are GMT +1. The time now is 06:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.