Reports :: Preventing Fields From Being Displayed?

Jun 23, 2015

im working on a report at the moment that will generate a standard NIP (nutritional information panel, similar to whats on the back of pretty much all packaged food products, see link below for an example)

[URL]

this in itself is pretty easy, however depending on which market we're selling to, different countries have different requirements for which data is to be shown, ie some markets might require we show how much sodium but not how much fiber, others might require us to show how much carbs and sugars but not how much vitamin C and so on (all up there are 16 different variables for nutritional info, due to size requirements on our packaging we cant simply display all 16 all the time)

at the moment im designing a form which has a drop down box (for the user to select a product) and checkboxes for each of the 16 variables (kilojules, carbs, iron, trans fats, sat fats, etc) following this ive got a report that has all 16 variables on it

i can make the variables that arent ticked on the form invisible (by adding a bunch of IF or Case statements, on print of the report, that determine whether the corresponding checkbox for each variable has been ticked and setting the "visible" attribute to true or false accordingly), however when they are invisible there is still a blank space where the field is meant to be ive got all the fields grouped together, is there any way of making fields invisible and then pushing all the visible fields together so there are no blank spaces?

View Replies


ADVERTISEMENT

Reports :: Preventing Negative Numbers In Report

Mar 7, 2014

I have a report where I have equipment tested every 90 days. I have a field called TEST DATE formatted using the medium date format

(07-Mar-14). I have another field called RETEST DATE where my query adds 90 days and displays the Retest date as (07-Jun-14).

I have a unbound box with a heading called "Day(s) passed retest date.

In the Control Source I am using =Datediff("d"[Retest Date],Now()). In this scenario the result is -90.

Is there a way for this -90 to stay at 0 until the 91st day where it will count up from there?

View 11 Replies View Related

Preventing Duplicate Data From Multiple Fields

Mar 4, 2008

Hello All,

I'm trying to limit the data entered into a specifc field, but also the data must be unique with respect to other fields.

i.e.
Two fields: System A & System B.
Data entered into System A, can not be entered into System B.

Anyway to prevent this from recurring?
Would I use a validation rule?

Thanks in advance

View 4 Replies View Related

Tables :: Preventing Duplicates Values In Fields

Oct 12, 2012

I am trying to modify an inventory management database. I want to prevent duplicate entries to specific fields in centralized table. The table is called Work Stations. Its function will be to track various computer equipment by a specific work station name. Each of the items will have a unique asset tag.

The primary Key for Work Stations is WS-ID. The fields I am trying to prevent duplicate entries in are WS-Computer, WS-Docking Station, WS-Monitor_1, WS-Monitor_2, and WS-Switch. Each of those fields are primary keys in 4 different tables that conation more detailed information about item. The exception is WS-monitor_1 and WS-Monitor_2 have a one-to-many relationship with Mon-Asset Tag in the monitors table.

The goal I am trying to accomplish is when a work station ID is created or modified duplicate entries are prevented to those fields listed above. The computer, monitors, docking station, and switch fields in the work station table may contain data or may be null.

I have tried to set the Indexed Option to Indexed (No duplicates) for each of the fields and I have also tried setting Yes to Ignore Nulls in the index option on the table design tab for the individual fields. Both options have returned the same error stating the changes would create duplicate values, in the index, primary key, or relationship.I have not created form for this table yet as I was trying to get no duplicates option to work first. I have verified the data and the only duplicating fields are the Null fields

View 6 Replies View Related

Reports :: Having Month Displayed In Report From Query

Jul 17, 2014

I have a query that pulls the records by month and year this worked great

Query is set up as
Field: Month: Format([ErD],"mm/yyyy")
Criteria: [Enter Month and Year (mm/yyyy)]

But I need the Month that is pulled to display in the report header along side the report header text without the user needing to enter the Month again.
Example report header: January Things you need to know.

View 12 Replies View Related

#deleted Displayed In Fields On Form

Aug 12, 2005

Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.

These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"

This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?

Thanks in advance
Matt Collins

View 2 Replies View Related

Modules & VBA :: Preventing Duplicates On Multiple Fields (Numeric And Text)

Oct 15, 2013

How to prevent duplicates on the combination of two fields - text & numeric?

I'm currently using the code below that warns users when the combination of two fields have already been used. (Combination of the TWO fields has to always be unique so if used again will warn the user)

Works well when both fields are numeric but fails when the JobDetails field is changed to text in the main table (tblPPMPLanner)

Code:
Option Compare Database
Option Explicit
Private Function IsDuplicateRecord() As Boolean
On Error Resume Next
Dim PreviousRecordID As Long
IsDuplicateRecord = False

[Code] ....

The field that should be a text field is called "JobDetails"

View 5 Replies View Related

Queries :: MIN Function With Additional Fields Displayed

Feb 5, 2015

I am trying to return the MIN in a numeric field (single result) from my database and I have no issues doing this BUT the problem is that I also need to display additional fields in order to make the result useful. The additional field can't be grouped by b/c that changes the result of the MIN function.

View 3 Replies View Related

General :: Modify Displayed Fields Of Combo Box On A Form

Mar 1, 2013

Where in Access 2010 I can modify the displayed fields of a Combo Box on a form. I need to format the display window and add criteria to one of the fields. Can't remember where I set this up and recently upgrading from Access 2007 isn't working.

View 5 Replies View Related

Modules & VBA :: Controlling Fields In A SubForm Displayed In DataSheet Mode

Dec 2, 2013

I have a Form to Display Projects that has a SubForm displaying Sub-Projects related to them. The main Project Form has a Combo Box which allows a user to select a ProjectID to display. The SubForm has a ProjectID Field as well. When the Project ID is selected in the Main Form, only the appropriate Sub-Projects are displayed in the Sub-Form.

On the SubForm, there is a Field named ActionID, which uses the following VB Code to limit the availability of the Fields in the SubForm that apply to Dates. If the selected Action is Install, only Install related Dates should be available. Likewise, if the selected Action is Remove only Remove related Dates should be available.

Code:

If Me.ActionID.Column(1) = "Install" Then
Me.AssetInstallMonth.Enabled = True
Me.AssetInstallYear.Enabled = True
Me.AssetRemovalYear.Enabled = False
Me.AssetInstallMonth.Locked = False

[Code] ....

Everything seems to work as expected until there is more than one Sub-Project is the SubForm and they do not contain the same Action. In these cases, it appears as if the Sub-Projects in the SubForm are not being treated as individual records. If Sub-Project is Added or Modified to have an action of "Install", all records are treated as Install Records (only Install related Dates are available), regardless of their content.

Is there a way to update the properties for only the row that has been selected?

View 5 Replies View Related

Reports :: Summing Calculated Fields On Reports And Tables To Include Cents?

Feb 18, 2014

In my tables i have used calculated fields. one of the fields is to "total expenses." In a report, i need to show the sum of all the "total expenses", the filed populates in the report but the cents are missing. for example if the amount is 6080.40 it shows as 6080. how can i get around this? I have tried changing the decimal point value to 2 at which point the value turns to 6080.00 when it should be 6080.40 (i am a beginner at this i am assuming the answer will probably involve c++ or visual basic's, two concepts i am not familiar with.)

View 2 Replies View Related

Reports :: Zero Values And Calculated Fields In Reports?

Nov 13, 2013

I am trying to get calculated fields in my report to work but zero values in the data are throwing up #Div/0! and #Error! and #Num!

The main data fields I am trying to work with are:

VehicleReading
PreviousReading
VehicleLitres

My aim is to track mileage and consumption for a fleet of vehicles and show daily and weekly averages in mileage and consumption and then to flag 20% increase in consumption.

I have a calculated field in my report named Kilometers,

= [VehicleReading]-[PreviousReading]

and also a calculated field named Consumption,

=[Kilometers]/[VehicleLitres]

My sum and average calculation fields in the group footers are only working where there are values above zero in the Kilometer and VehicleLitres and Consumption fields.

In reality there are some days where there has been no travel, so some records will have a zero for the Kilometers field and there are also days when there has been no refueling so there is a zero for the VehicleLitres field.

I have tried using the expression builder to create an IIf function but to no avail.

I have tried copying the syntax suggested by the Expression builder:

«Expr» IIf («expr». «truepart». «falsepart»)

I know I need to get those zero's to fail in the calculation but as I said before all of the suggested expressions I have tried fail due to syntax!

View 11 Replies View Related

Reports :: Use 1st Query To Populate Fields Then Use 2nd Query To Filter Fields

Apr 30, 2013

Any way in report that I have 2 reference queries just 1 is to populate all details and 2nd query to filter details and will be the final reporting information???

View 5 Replies View Related

Preventing Duplicates

Jun 27, 2005

Hi,

I have a form and within that form there is two combo boxes and one text box. When one choses a value from one combo box, and then chooses a value for the other combo box and then enters the value into the textbox I don't want the user to be able to enter the same arrangement. That is I want to prevent duplicates on that combination. Also if they do this I want a Message Box to appear saying that that this combination already exists

I was thinking of using a multiple field index to prevent the duplicates, but I don't know if this is a wise thing to do. Can someone give me some help to see how I can prevent duplicates or offer another solution to prevent duplicates on the combination of the values.

Thanks
Greg

View 2 Replies View Related

Preventing Duplicates

Jun 13, 2007

Hi, How do you normally prevent duplicates being inputted into you forms.My Idea is thisThe input text box doubles up as a dropdownlist of current values held in the database for that field.So when you access the organisation form and go to the first text box as you enter the 'I' for IBM All the orgs with 'I' appear. When you see that the organisation your inputting already exists you will stop and move on to the next form.I dont know how to do this, so currently I have set the field OrgName as Indexed: Yes (No duplicates) but this isnt really any good as the user enters all the other details and clicks submit before the error message comes up.I have attached my file for you to understand this better.

View 2 Replies View Related

Is It Possible To Get Fields As Headers In Reports?

Apr 28, 2006

Hi,

I have a report that has category, subcateogry and districts.

I can get the first part of the report to work as I want it like so:

Category
FruitSub Cateogry
Apples
OrangesMeatSub Cateogry
Pork
Chicken
Now is where the fun starts. I want next to each of the subcateogries a count of districts, but I want to name of the districts to be at the top, and the counts to go underneath - here is 2 lines to show what I would like.

Category District Name
FruitSub Cateogry 2Apples 3Oranges0
The red text "District Name" would be 4 different districts, going across with the counts under the related districts.

I can not get the districts to show up at the top of the report next to cateogories, and go across with all of the districts, it keeps on wanting to list them underneath each other.

All reports that I have seen have a "set" header, not one created on the fly according to a database.

Is this possible to do, and if so, can someone point me in the right direction?

thank you for your time

View 1 Replies View Related

Combine Fields In Reports

Mar 26, 2007

I have two reports, "Quick Glance Report" and "Note Report". The Quick Glance Report comes from a query called (ACE/ARB Table Query) and the Note Report comes from a query called (notequery).

I want to be able to have a calculated field from the "Note Report" in the "Quick Glance Report". Am I able to show a calculated field from one report into another report and how would I do this (If I can that is)?

View 1 Replies View Related

Reports :: Running Sum Fields

Jul 4, 2013

I have a report about bowlers & series. I am attempting to do a running sum on each bowler's series & games bowled each week, so I can get a new composite average each week.The data looks good until the 2nd to last row of data. The running sum on series & games bowled for every bowler is blank even though I have a series that week for all bowlers. And the averages for that week show a 0. The very last row of data for all bowlers is fine and correct.

View 3 Replies View Related

Preventing Certain Rows From Being Deleted

Sep 7, 2005

Hi
I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?

View 3 Replies View Related

Preventing Form From Resizing

Sep 7, 2005

Hi
I have a Switch Board and when I click to view a report on it the report automatically opens in maximize view, this is what I want. What I dont want is when I close the report for the Switch Board form to be maximized as well

How would I be able to prevent this??
Cheers
bikeboardsurf :rolleyes:

View 2 Replies View Related

Preventing Data Deletion

Dec 5, 2007

I have developed a database in Access which has user permissions implemented. These are set so that only Full Data Users have permission to delete information.

However, it has come to my attention that users can get around this by creating a query and then deleting records displayed in its results. I can't understand why this is possible, because the permissions should prevent this.

Can anyone help?

Thanks,

Gary

View 1 Replies View Related

Preventing A Record From Being Deleted

Jan 31, 2005

I have a table with a blank record at the begining and populated records thereafter. I used the cmd button wizard to create a delete button for that table. Is there a way to prevent the blank record (record 1) from being deleted by the command button but still allow all other records to be deleted?

View 9 Replies View Related

Preventing Duplicate Entries.

Nov 26, 2006

Hi again, thanks to all for the help given so far.

Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record?

E.g.

If under 'Name' Radion has already been written, I want an error message coming up saying there is already a record with radion.

View 3 Replies View Related

Preventing Duplicate Entries

Aug 2, 2006

Hi all,
I am currently using this code in the before Update event of the Surname Textbox on a form. The first Textbox is FirstName.
The second one is Surname.

************************************************** **

If (Not IsNull(DLookup("[FirstName]", _
"Employee", "[FirstName] ='" _
& Me!FirstName & "'"))) And (Not IsNull(DLookup("[Surname]", _
"Employee", "[Surname] ='" _
& Me!Surname & "'"))) Then
MsgBox "Someone already exists with the same name! Please check for duplicates", vbCritical, "IPDMS"
Me.Undo
End If

************************************************** **

However once the user has entered the surname and tries to save the record the MsgBox is coming up.
Basically what is happening is the first name is coming up as the duplicate entry only.
I need to prevent the whole name (first name and surname together) from being duplicated.

Thanks if you can help me.

View 3 Replies View Related

Preventing Duplicates In A Form

May 28, 2007

Hi all,
I've got a database with a members table and an events table and a participation table which is like an 'intermediary table' which just has fields for MemberID_fk and EventID_fk.

The form at the moment has a combo box for Members and a combo box for events. This works well but the problem with it is that there is no safeguards to prevent a member from joining the same event many time.

Ideally i'd like for the combo box of events to be updated once the member's been selected to only include events the member has not signed up for.

If anyone's got any suggestions i'd love to hear them. The only constraint i have is that this has to be prevented when it is entered in the form.

Cheers,
Joe

View 3 Replies View Related

Preventing Record Over-writes

Jun 22, 2007

I have a form with fields being input to a table to create records in a query. The query is dispalyed in a ListBox.

People are forgetting to create a New Record, selecting an existing record in the List Box and overwriting it.

How can I prevent this?

Please, no code solutions - I don't understand those. Events and macros I can just about grasp.

Thanks

View 2 Replies View Related







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