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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rows in table...is there a way to hide them
I am really a seriously novice Access user. My company uses Access to keep
track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#2
|
|||
|
|||
Rows in table...is there a way to hide them
Hi Leah,
Since you are a novice, I think I would suggest that by default the form opens with the destroyed information filtered out. Then if someone wants to see the destroyed stuff they simply remove the filter. So create an On Open event procedure for your form. In it add two lines; one to set the filter and the other to make sure the filter is on. It will look something like this: Private Sub Form_Open(Cancel As Integer) Filter = "[Stored At] ""Destroyed""" FilterOn = True End Sub Now, when it opens they will not display. To display them toggle the filter. In Access 2007: Home ribbon, Sort & Filter section, Toggle Filter item. Repeat to hide them again. In earlier versions: Records menu, Remove Filter/Sort item or Apply Filter/Sort item. Hope this helps, Clifford Bass "LeahT" wrote: I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#3
|
|||
|
|||
Rows in table...is there a way to hide them
Leah
An alternate approach to what Clifford offers is to use a query to only see the non-Destroyed rows. Then use that query to feed your form. You ARE using forms to display the data, and not working directly in the table, right?! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#4
|
|||
|
|||
Rows in table...is there a way to hide them
Hmmm...this is where my novice REALLY shows. No...we work directly in the
tables...no forms to speak on in this one. OH if only I knew how to use Access! I like the idea that Clifford suggested, but clearly that won't work cuz we don't use forms...so until I can figure out how to use the forms...is there a simple way to just hide the rows in the table? "Jeff Boyce" wrote: Leah An alternate approach to what Clifford offers is to use a query to only see the non-Destroyed rows. Then use that query to feed your form. You ARE using forms to display the data, and not working directly in the table, right?! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#5
|
|||
|
|||
Rows in table...is there a way to hide them
Hi Leah,
It is really simple. Just use the Form Wizard to create a form based on your table. Access 2007: Create ribbon, Forms section, More Forms item, Form Wizard. Or choose one of the other form options. Previous version: Click on the Forms item under Objects in the left side of the database window. Then click on the New button in the middle top of the database window. Choose Forms Wizard or one of the other options that shows. Do a search in your online help for "create a form", with the quotes, for more information. Clifford Bass "LeahT" wrote: Hmmm...this is where my novice REALLY shows. No...we work directly in the tables...no forms to speak on in this one. OH if only I knew how to use Access! I like the idea that Clifford suggested, but clearly that won't work cuz we don't use forms...so until I can figure out how to use the forms...is there a simple way to just hide the rows in the table? |
#6
|
|||
|
|||
Rows in table...is there a way to hide them
Leah
One of the problems with working directly in the tables in Access is that folks get into a mindset that Access is just a "spreadsheet on steroids". Access tables store data. Access forms (and reports) display it, and offer a VERY rich event environment. As long as folks are working in the tables, they're likely to expect Access to work like a spreadsheet ... and it won't! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... Hmmm...this is where my novice REALLY shows. No...we work directly in the tables...no forms to speak on in this one. OH if only I knew how to use Access! I like the idea that Clifford suggested, but clearly that won't work cuz we don't use forms...so until I can figure out how to use the forms...is there a simple way to just hide the rows in the table? "Jeff Boyce" wrote: Leah An alternate approach to what Clifford offers is to use a query to only see the non-Destroyed rows. Then use that query to feed your form. You ARE using forms to display the data, and not working directly in the table, right?! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#7
|
|||
|
|||
Rows in table...is there a way to hide them
I agree entirely with the thoughts and teachings of both Clifford and Jeff, a
user should never, repeat never be allowed to use the table direct. It is possible to generate a datasheet form base direct on a table or prefereably on a query which for intents and purposes looks identical to a table. Using wizards are easy for both the form and the query. The filter in the query should be placed in the criteria row, Not "Destroyed" However, right clicking a record in the table which contains the word "Destroyed" and selecting "Filter Excluding Selection" will filter out the destroyed records. I only include the above statement for completness of factual information. You should take time to complete the easy steps of making a query and a form based on your table. Kindest Regards Mike B -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "Jeff Boyce" wrote: Leah One of the problems with working directly in the tables in Access is that folks get into a mindset that Access is just a "spreadsheet on steroids". Access tables store data. Access forms (and reports) display it, and offer a VERY rich event environment. As long as folks are working in the tables, they're likely to expect Access to work like a spreadsheet ... and it won't! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... Hmmm...this is where my novice REALLY shows. No...we work directly in the tables...no forms to speak on in this one. OH if only I knew how to use Access! I like the idea that Clifford suggested, but clearly that won't work cuz we don't use forms...so until I can figure out how to use the forms...is there a simple way to just hide the rows in the table? "Jeff Boyce" wrote: Leah An alternate approach to what Clifford offers is to use a query to only see the non-Destroyed rows. Then use that query to feed your form. You ARE using forms to display the data, and not working directly in the table, right?! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#8
|
|||
|
|||
Rows in table...is there a way to hide them
Easiest way is just to create a query and in the criteria for 'Stored
At' enter "Destroyed" Then run the query Also save it so that you can load it at any time For FREE Access ebook and videos click here http://access-databases.com/ebook On 23 Jan, 22:25, LeahT wrote: I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#9
|
|||
|
|||
Rows in table...is there a way to hide them
Thank you everyone!! I see now that I need to really get a better handle on
Access and its capabilities. I have purchased a few (7) books on how to use Access...and I plan on really getting a better understanding. You al have started me in the right direction though...VERY VERY much appreciated. "LeahT" wrote: Hmmm...this is where my novice REALLY shows. No...we work directly in the tables...no forms to speak on in this one. OH if only I knew how to use Access! I like the idea that Clifford suggested, but clearly that won't work cuz we don't use forms...so until I can figure out how to use the forms...is there a simple way to just hide the rows in the table? "Jeff Boyce" wrote: Leah An alternate approach to what Clifford offers is to use a query to only see the non-Destroyed rows. Then use that query to feed your form. You ARE using forms to display the data, and not working directly in the table, right?! Regards Jeff Boyce Microsoft Office/Access MVP "LeahT" wrote in message ... I am really a seriously novice Access user. My company uses Access to keep track of files and what box they are in and on what rack in what bldg (stored at). So, the problem is...we frequently destroy boxes. In the Box Table there is an option in the "Stored At" column for "Destroyed" to show that we have gotten rid of that box. Unfortunately, now our (very large) box table is riddled with destroyed boxes. We don't want to delete the record (in case we need to know what happened to a file)...but I would like to hide them somehow if that is possible. Any thoughts? |
#10
|
|||
|
|||
Rows in table...is there a way to hide them
Hi Leah,
You are welcome! And good luck. The time and effort you take in learning Access will be well worth it. It will open up a lot of possibilities to you and your company. Clifford Bass "LeahT" wrote: Thank you everyone!! I see now that I need to really get a better handle on Access and its capabilities. I have purchased a few (7) books on how to use Access...and I plan on really getting a better understanding. You al have started me in the right direction though...VERY VERY much appreciated. |
|
Thread Tools | |
Display Modes | |
|
|