Hide Unused Records

Oct 18, 2004

hello
could anyone tell me that is there any way to hide the unused records or the records that have a null value.
tx in advance.

View Replies


ADVERTISEMENT

Identify Unused Tables

Jan 13, 2006

Is there a way to query any system tables to list all tables that are being referenced in any queries, forms, reports, modules, etc.? We've inherited a rather large Access application containing some tables that we suspect aren't being used at all by the application, and we'd like to verify this suspicion before deleting these tables.

TIA

View 2 Replies View Related

Show Only Unused Data In Combo Box

Jul 29, 2005

Hi,

I'm wondering how to do the following:

I have two combo boxes that exist on a form record (i.e. two combo boxes for every record on the continuous form): mainCategory and subCategory.

Currently, I can choose a mainCategory and depending on the mainCategory, I have certain values available for the subCategory.

What I want to do is only show the values that have not been used for the subCategory (the mainCategory can always show its default value).

An example of what I mean is below...

The comboboxes and their row data:

mainCategory (combobox)
-------------
A (combobox rows)
B
C

subCategory (combobox)
-----------
for A: 1, 2, 3 (row for the selected mainCategory)
for B: I, II, III, IV
for C: red, blue

Sample scenario:
1. For the first record on the form, a user selects "A" from mainCategory and "1" from the subCategory for "A".
2. The user adds a new record to the form
3. For this new (2nd) record on the form, a user selects "A" from mainCategory and can only select "2" or "3" from the subCategory combobox. The "1" from the subCategory combobox is no longer available for choosing, unless the user changes the first record's "1" in subCategory to another value.

Any help would be much appreciated.

TIA!

View 4 Replies View Related

General :: Searching Database For Unused IP Addresses From Populated Table / Fields

Feb 18, 2015

I am looking to transfer a number of spreadsheets that I use to track IP Addresses to an Access Database, I have set up the tables and fields, what I would like to do is search for unused IP Addresses from populated table/fields.

View 2 Replies View Related

Hide Records

Jul 25, 2006

HI,
I have made form with a main form and a sub-form. The relationship between them are 1-t-many. The main forms key is security-number and based on this number the sub-form shows all the related accounts. One field on the sub-form is total arrears - and here comes my ?. Based on this calculated field - total arrears I would like to only show accounts if the total arrears are > X. Otherwise the main form - security-number should be the next in line.

I’m looking forward to hearing your suggestions. Thanks

BR

Henrik

View 1 Replies View Related

Hide Subform If No Records

Jul 27, 2005

Hi,
Is there a way to hide a subform on a main form if there is no records in the subform?
Thanks

View 14 Replies View Related

Forms :: Hide Records That Have 1 In Combo Box

Jun 10, 2013

I have a form with a checkbox and a combo box. When I click the checkbox, I would like it to only show the specified records that are in the combo box. The current code I have is this:

Code:

Private Sub chkHideComplete_AfterUpdate()
On Error Resume Next
If Me.chkHideComplete = True Then
Me.filter = "[ReservationStatus] = 3"
Me.FilterOn = False

[Code] ....

I basically want to hide all records that have "1" in the combo box.

View 2 Replies View Related

Reports :: Move Or Hide Duplicate Records?

May 8, 2013

I'm having trouble with one of my reports. attached is a screencap of my report. The second name which is highlighted i need to either nudge it to the right so it is not directly under the first name OR remove it completely but keep the times and a gap for the next record.

I am creating is a sign in database where staff sign in/out for each day of a week. the issue is when the staff member signs in/out in the morning and then does the same when they get back from lunch it is difficult to read. This report is only printed once a week and will not show after a time frame of 5 days.

So, i still need that name to show up for the next day.

View 1 Replies View Related

Reports :: Hide Or Filter Out Empty Records

Apr 29, 2015

I am looking for a way to hide or filter out the records in my reports if all of the values are 0. My problem is that all of my reports have their filters set on the event that opens the report. I use an If statement to decide which report to open, which means that different reports use different fields. This means I can't just add 'AND April_T <> 0' or something to the filter.

View 1 Replies View Related

Modules & VBA :: Cycle Through Several Records And Hide Field If It Is Blank

Feb 10, 2014

I have code that I want to cycle through several fields and check instead of coding for each individual field. I thought this might worked on an earlier project but Im lost. When I try to add my code in the "If MyControls Then", I want it to hide the field on a report if it is blank. It doesnt allow me to do MyControls.Visible.

Code:
If Len(Reports!RecallReport!QAW1 & vbnullsting) = 0 Then
Reports!RecallReport!QAW1.Visible = False
End If

but I want the below code to go through each field With QAW in it and hide it if it is blank.Or having it go through each field individual. There are 10 Fields With QAW THen there are another 10 fiels with ShipDist. I would prefer a simple solution to check all at once.

Code:
Dim MyControls As Control
For Each MyControls In Me.Controls ' Iterate through each element.
If InStr(1, MyControls.Name, "QAW") Then
If MyControls Then
End If
End If
Next

I don't even know if I am on the right track or what.

View 2 Replies View Related

Modules & VBA :: Hide Subform Footer Controls If No Records Present (AC2007)

Mar 14, 2014

I have a subform which lists a set of records. In the footer section of the subform, I have a number of controls which display calculations based on the records present.

The number of records in the subform will change (reduce). Basically, this is a review / approval function, the idea being that each record will be checked and approved, which will then remove it from the list.

So eventually, all of the records in the subform should disappear (the subform is requeried each time the user approves a record)

I want to be able to hide the controls in the footer section once the subform has been cleared of all records.

But not sure

a) how to determine when the subform's recordset reaches zero and

b) what event to use to fire the code to hide the footer controls.

This is my basic attempt :

Code:
Private Sub Form_Current()Dim ctl As Control
For Each ctl In Me.FormFooter.Controls
ctl.Visible = Not (Me.Recordset.EOF)
Next ctl
End Sub

But it doesn't work (it only seems to fire when the subform is loaded, not when it is requeried after each approval?)

I've tried Form_Query, Form_DataChange and Form_DataSetChange but no joy with those either.

View 6 Replies View Related

Is There Any Way To Hide A Form...?

Oct 2, 2006

Hi.

I was just wondering if you can hide a form in the windows status bar?

View 3 Replies View Related

How To Hide All The Bars

Jul 28, 2007

How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...

View 3 Replies View Related

Hide Duplicates

Apr 4, 2006

Goal - Show how many policies (dbo_Policy22.Policy.Number) were cancelled during a certain time period (Invoice Date).

Problem - a policy can be cancelled more than once and I don't want to count it after the initial cancel status (885).

Question - Below is my query. I'm thinking I type "Distinct" somewhere, but I have no idea where.

Please help :) Thank you.

SELECT dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
FROM dbo_Producer22 INNER JOIN ((dbo_Insured22 INNER JOIN dbo_Invoice22 ON dbo_Insured22.Insured_Key = dbo_Invoice22.Insured_Key) INNER JOIN dbo_Policy22 ON dbo_Insured22.Insured_Key = dbo_Policy22.Insured_Key) ON dbo_Producer22.Producer_Key = dbo_Policy22.Producer_Key
GROUP BY dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
HAVING (((dbo_Invoice22.Invoice_Date) Between [Forms]![PfrmYearToDate]![txtStartDate] And [Forms]![PfrmYearToDate]![txtEndDate]) AND ((dbo_Policy22.POLICY_STATUS)=885));

View 2 Replies View Related

Hide 1 Record

Apr 10, 2007

I was wondering if there is a way to hide 1 record from a query

say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed

View 2 Replies View Related

Hide Field Value

Mar 22, 2005

I have a form with various fields, two of these fields are "Date Purchased" and "Lease End Date". When there is no value entered originally, I have made a default value of 12/30/9999.

The problem is that when you open the form and these two fields are next to each other, the user says it confuses them seeing a date even though it is a dummy date.

Is there a way for me to create a expression that will be something like:

IIf(DateField = 12/30/9999, Me.Datefield.Visible = False, Me.Datefield.Visible = True)

or VBA

Private Sub Form_AfterUpdate()
If Me.DateField.Value = "12/30/9999" Then
Me.DateField.Visible = False
Else
Me.DateField.Visible = True
End If
End Sub

If have tried both ways and neither works.

View 1 Replies View Related

Hide Record

Jun 8, 2005

Is it possible to just hide a record? My form is based on a query so I know I could remove the record that way but I also have a box that calculates a average time, so the data that is produced by that record still needs to be taken into account. I want to hide some records pureley so the user dosent have to keep scrolling thriugh loads of records. Is it possible to do this?

View 9 Replies View Related

Hide New Record Row

Jun 28, 2005

I have a continuous form "components" where the data is added by a query. There is no need to manually add records to the form, I just want to edit certain fields.

Is it possible to hide/disable the blank "new record" row at the bottom of the form?

I tried setting the form's "Allow Additions" property to no, but the line still appears.

Thanks for your help!

Frank

View 3 Replies View Related

Hide / Unhide

Aug 31, 2005

I created an app., for tracking changes, where once the user is logged in , the login form is hidden.
When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When the program comes back to the form where the event procedure is, it closes the hidden form, which asked to continue or not. The problem is that it closes the login form as well.
To sum up:
-Login form is hidden
- Edit form calls Confirm form
- when user comfirm, teh comfirm form is hidden.
- Edit form, close Comfirm form and also login form. (i dont want to close login).

Here is the code to close comfirm form in edit form....

DoCmd.Close acForm, "comfirm"

thank you, max.

View 1 Replies View Related

Hide Buttons

Nov 23, 2005

Hi,
I can hide buttons on a form but what I want is to hide/ show it when one of the fields has a specific value.

Cheers

Gordon

View 4 Replies View Related

How Do I Hide Access

Apr 3, 2006

Please give all the info you can. I have my database and forms set up. what I want to do is just see my forms and not see access in the background. Please specify where I enter code if it's provided. thanks for all your help,
Derek

View 1 Replies View Related

Hide A Combo Box

Aug 24, 2006

hello,
i'm trying to make the combo box hide after i choose one out of combo
box, eg: i have in combo box 1,2,3,4,5,6 and when i choose 4 i want it to hide
i have tried

me.nameofcombobox.Visible = False

but does not work because it has the Focus so i tried

me.nameoftextbox.SetFocus
me.nameofcombobox.Visible= false

but it comes up saying

Run time error '2108':

You must save the field before you execute the GoToControl action,
the GoToControl method, or the SetFocus method.

i don't no what to do can someone help me plz
___________________
David

View 5 Replies View Related

Hide Form

Sep 15, 2006

Hi, I have a form with a cmd butto that unhides a text box, this text box is quite big on the form and I want it to display extra informations, the problem I have is when I unhide the textbox this will appear under fixed fields on the form, I need this text box to appear over everything over the form, Hox can I achieve it?
Thanks
Marco

View 3 Replies View Related

Hide Forms

Nov 14, 2005

hello,
i have a form that shows up when I start my database. It has a combo that users use to select their initials.

This form is run by the autoexec macro.

The forms stores users names that then are propagates to other forms without having users each time selecting their initials.

Is there a way I can hide the first form behind others so that it keeps the data active? I have tried to minimixe it but still can see in the gray toolbar.
Thanks.

View 2 Replies View Related

Hide Everything But The Form

Jun 10, 2005

hello everyone,
I have a database that has only two tables and one form. There is about 100 people that will be using this system(not all at the same time), and I want to hide everything from them except the form, including the microsoft access window behind the form. if i just make the access window small and put it behind the form, that looks alright, but i don't want to have to go to everyone's computers and do that! i've already hidden everything else, i just can't figure out how to make it seem like it's a stand-alone application. Any ideas???
Thanks very much in advance
*j

View 11 Replies View Related

Hide Toolbar

Jul 20, 2006

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved