Hide Unused Records
Oct 18, 2004hello
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.
ADVERTISEMENT
Identify Unused Tables
Jan 13, 2006Is 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
Show Only Unused Data In Combo Box
Jul 29, 2005Hi,
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!
General :: Searching Database For Unused IP Addresses From Populated Table / Fields
Feb 18, 2015I 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 RelatedHide Records
Jul 25, 2006HI,
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
Hide Subform If No Records
Jul 27, 2005Hi,
Is there a way to hide a subform on a main form if there is no records in the subform?
Thanks
Forms :: Hide Records That Have 1 In Combo Box
Jun 10, 2013I 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.
Reports :: Move Or Hide Duplicate Records?
May 8, 2013I'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.
Reports :: Hide Or Filter Out Empty Records
Apr 29, 2015I 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 RelatedModules & VBA :: Cycle Through Several Records And Hide Field If It Is Blank
Feb 10, 2014I 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.
Modules & VBA :: Hide Subform Footer Controls If No Records Present (AC2007)
Mar 14, 2014I 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.
Is There Any Way To Hide A Form...?
Oct 2, 2006Hi.
I was just wondering if you can hide a form in the windows status bar?
How To Hide All The Bars
Jul 28, 2007How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...
Hide Duplicates
Apr 4, 2006Goal - 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));
Hide 1 Record
Apr 10, 2007I 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
Hide Field Value
Mar 22, 2005I 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.
Hide Record
Jun 8, 2005Is 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 RelatedHide New Record Row
Jun 28, 2005I 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
Hide / Unhide
Aug 31, 2005I 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.
Hide Buttons
Nov 23, 2005Hi,
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
How Do I Hide Access
Apr 3, 2006Please 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
Hide A Combo Box
Aug 24, 2006hello,
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
Hide Form
Sep 15, 2006Hi, 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
Hide Forms
Nov 14, 2005hello,
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.
Hide Everything But The Form
Jun 10, 2005hello 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
Hide Toolbar
Jul 20, 2006I 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