Forms :: Displaying Conditional Info On A Form

Oct 15, 2013

I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests are scored out of 72 and numeracy out of 50.

what I would like to do is write something that shows the literacy numeracy levels of each student after each test. So for literacy, the score ranges are as follows:

0 - 13 Below Entry 1
14 - 32 Entry 1
33 - 52 Entry 2
53 - 65 Entry 3
66 - 7 Level 1

What I would like to be able to do is tick whether or not they sat a literacy or numeracy test, enter the score and the db to come up with their level and display it on the form.

View Replies


ADVERTISEMENT

Search Forms - Finding A Contact And Displaying All Related Info

Nov 22, 2005

Hi

I am pulling my hair out with what I am sure is a simple task, creating a search form that, when criteria are entered, finds a record and displays related data/results from 3 tables. I have tried every forum and web post I can find but I think there must be something fundamental I'm neglecting to grasp.

Quick background:
My database has 4 tables, Firm, Contacts, Mailout and FileNote
The database is contact-centric (ie, everything is linked to a contact record, multiple contacts are held against firms, mutiple file notes are held against a contact, contacts can be attached to multiple mailouts)
I need to search for a contact record based on multiple criteria (keeping it simple, lets say a combination of first_name & last_name OR first-name & firm_name OR their specific contact ID)
I need a 'results form' (not just a datasheet view) that displays all information related to that contact (i.e. all files notes + ability to create new ones, firm contact information, and mailout history)


I've created a Main form with Firm, Mailout, Contact & Filenote subforms embedded that enables me to scroll through every contact and view all related detail (as above) and add file notes & modify data very nicely. My problem is I can't search, I can only move through each record sequentially. Very handy when we have 4000 contacts!

I realise I'm probably a complete wally but could someone please explain to me the vital steps I'm missing? I've tried unbound fields, I've built SQL queries & command buttons (but results are dumped into a datasheet)....I'm lost.

Many many thanks.

View 2 Replies View Related

General :: Form With Text Boxes That Are For Displaying Info To Users

Jan 10, 2014

I have done this before and can't remember how I did it and I can't fogure out how to do it. I have a form with textboxes that are for displaying info to the users. I want to lock them so that users can not click on them or high light the fields. So basically the user can only click on fields I want them to.

View 4 Replies View Related

Displaying Aggregate Info About Query In Text Box

Feb 5, 2013

I working with Access 2010 and a form with criteria controls, a requery button and a subform that displays the query. I wanted to add a text box that would display some aggregate information about the query results. Like how many results were returned or what the average is in a column of numbers stuff like that.

If at all possible I was hoping to have the text box display aggregate information of the whole query but when a specific entry in the table is clicked I was hoping to have it show aggregate detailed information about that entry opposed to the whole table. So I am not sure if that changes the solution but I wanted to put it out there.In my searches it looks like Dlookup is the way to go but I have seen a lot of people use Dlookup in very different ways so I might be wrong.

View 14 Replies View Related

Reports :: Displaying All Info From Two Tables On Report Not Working?

Mar 11, 2014

I have 3 tables.

One is a list of fishermen with all their info. I used a Code as the primary key.

The 2nd is a fish ticket sheet with fish tickets entered and the code in there as a foreign key in the relationship between the two.

I create a report listing the fish tickets and prices perfectly for the 4 fishermen I have entered fish tickets for. (I have 140 fishermen in the main table)

I added a 3rd table for payments made to the fishermen. There are two payments for 2 of the fishermen.

then, I go into report design view and drag in two of the cells from that 3rd table into my report.

The problem is the report then prints JUST the fish tickets and payments for the two fishermen that have payments...not the info for all 4 fishermen. I need to print out settlements for all the fishermen whether they have payments or not?

View 1 Replies View Related

Forms :: No Info When Creating Form

Jan 24, 2014

I'm quite new to using Access 2007 and I'm trying to create a form from different tables which have relationships. I've used the form wizard and added all the fields I need from the different tables, however, when I click form view it only shows the title and nothing else. When I'm in design view everything is showing..

View 1 Replies View Related

Forms :: Copy Info Into New Form

Apr 9, 2013

I have a [New Job Number] form in my database. In this [New Job Number] form, I have a [Purchase Orders] subform showing all open Purchase Orders. I have a button in the [New Job Number] form to open another form called [New Purchase Order]. How can I transfer all of that information from [New Job Number] into the [New Purchase Order] form through a macro? I don't know how to use VBA. Also I do know how to use basic Macros, though.

The fields I would like to transfer from [New Job Number] into [New Purchase Order] are JobName, JobNumber, and CustomerAccountNumber.

View 7 Replies View Related

Forms :: Conditional Lamp In A Form

Aug 28, 2013

I want to make a toolbar on top of my form and put the input label and a lamp behind it, in that,so when the operator enter a specific input a lamp near the input label in toolbar become green and when the operator not enter a value this lamp show red color.

View 1 Replies View Related

Forms :: Displaying Variable On A Form?

Aug 28, 2013

I have been given a form that you pass a parameter into and on the basis of this it performs certain amendments to the particular data AND also runs 2 stored procedures on this data. I need to get the data to display on the form so that the user can visually verify if it is the correct data and then they will on click to execute the amendments and stored procedures.

I cannot get the data to display on the screen? I have tried to create a variable in the VBA code to store the data in and then used a message box to try to display it but to no avail?

View 3 Replies View Related

Forms :: Not All Records Displaying In Form

Aug 20, 2013

I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.

The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.

The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!

View 3 Replies View Related

Forms :: Displaying Pictures On Form

Oct 7, 2013

I'm trying to place a picture on my forms using a browse button code i found on the net. After picking a picture, the image won't display automatically during run time, i still need to select design view and finally form view just to display the image. Im using the events form current, and the text box afterupdate.

View 1 Replies View Related

Forms :: Conditional Formatting Of Control On Continuous Form

Feb 2, 2015

I have a continuous form on which where each record has many controls, including control (A). I wish to set the colour of this control based on the contents of another control (B). Control B is a memo format and is placed behind another control making it hidden. The idea being that the user can then click on control(A) and look at supporting information from Control B on another form.

Conditional formatting cannot be used since this only allows conditions based on the control (A), not (B). Event procedures cannot be used since they all depend on making a record the current record, and I want the user to immediately see when further information is available. When I apply VBA code using an 'on load' event it is action for all records on the form in a way that if only one record has extra information, all records are flagged in this way.

View 6 Replies View Related

Forms :: Full Info For All Property Options Of Any Form Control

Jun 26, 2015

How to set all controls in the form I would like to get complete information about all property options.

View 6 Replies View Related

Forms :: Duplicate Form Opens But Area With All Info Is Blank

Jul 2, 2013

I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.

View 3 Replies View Related

Forms :: Creating Pop-Up Form That Lists Persons Contact Info

Sep 18, 2014

I have a list of people in a list box. In the list box I only have the people names listed. (example below)

1. John
2. Frank
3. Tim
4. Jessica

I want to click on one of the names and have a form pop up on the same screen that lists the persons contact info. If I had a table like listed below, could the info auto populate on a separate form.

[ID] [Name] [Number] [Address]
1. John 456-4567 123 Elm Rd.
2.

I want the Form to pop up and show...

Name: John
Number: 456-4567
Address: 123 Elm Rd.

View 1 Replies View Related

Forms :: Displaying Result Of A Calculation In A Form

Jun 17, 2015

I am creating a driving school database and have four different tables. Student, Instructor, Lesson and Lesson Type.

In the footer of my subform which works out what lesson type the student has taken and from which instructor, I have created a calculation to multiply the number of hours a student does to what type of lesson they take.

=([LengthOfLesson]*[cost]) (This works ok)

I then want to add all of these options together. I have tried:

=sum([OverallTotal]) in the footer (This doesn't seem to work)

and then

=[Booking].[Form]![OverallTotal] to show it in the form

The name of the subform is correct (booking) and name OverallTotal is also correct but I keep getting #error message.

View 3 Replies View Related

Forms :: Displaying And Scaling Image From URL On A Form

Feb 20, 2015

I am using Access 2007.I have an application that keeps track of automotive parts and accessories.I have a table called "PARTS" that contains information about the various parts such as "part_name", "part_id", "price" etc.

I also have a website/shop that displays these various parts and also has an image of each part.I have managed to incorporate Microsoft Web Browser ActiveX functionality within the app so that when I scroll through the Parts table using the PartsForm, it automatically "reads" the URL from a field in the Parts table called "ImageURL" and displays it in the Microsoft Web Browser ActiveX browser window...this works great.

View 11 Replies View Related

Forms :: Conditional Formatting Of Currency Field In Entry Form

May 26, 2015

I have some Conditional Formatting of a Currency Field in an Entry Form. The cell is conditionally formatted with a yellow background when the value is zero.

I now wish to add an additional condition to the expression such that even if the value is zero it will not be formatted if a specific check box is TRUE.

I have tried modifying the expression such that it reads;

[currency field]=0 AND [check box]<>TRUE.

It correctly turns off the conditional formatting if the check box is ticked, but does not turn it on again when the check box is unticked.

View 14 Replies View Related

Forms :: Displaying Control From Database To Form Automatically

Jun 24, 2013

I have created and saved a form in access automatically from database table. But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.

View 1 Replies View Related

Forms :: Multiple Records From Query Not Displaying On Form

Nov 18, 2013

I have a form that a user will use to search records. Upon selecting a record, there are three buttons that allows the user to look at more detailed information. This information will be on the many side of the relationship. So I will have multiple values. The called form is just a popup form that I use for several other instances, like displaying memo fields from other tables.

The problem I am having is that only one record shows up at a time on the called form. I have read through the postings and have changed the properties for Default View, Filter on Load, Data Entry, etc. Nothing seems to change the outcome. I have run the query in SQL view and have no issues. It returns the correct records and multiple rows when expecting. Why they don't show up on the form. There are no errors, just the first record from the many side of the relationship shows up in the form. I would like all records to show up, just like when I run the query.

Code:

SELECT Capability
FROM Process_Meetings_Capabilities, Process_Meetings
WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID
AND Process_Meetings_Capabilities.Meeting_ID = 2;

Button Code

Code:
Private Sub Capabilities_btn_Click()
strSQL = "SELECT Capability AS Results"
strSQL = strSQL & " FROM Process_Meetings_Capabilities, Process_Meetings"
strSQL = strSQL & " WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID"
strSQL = strSQL & " AND Process_Meetings_Capabilities.Meeting_ID = " & Me!Meeting_cmbo.Column(0)

[Code] .....

View 6 Replies View Related

Forms :: Displaying Blank Form Instead Of Current Record

Jun 5, 2014

I have created a navigation form with quick access to the forms and reports I use most often. The Navigation Form (which I named Control Panel) automatically lands on the Tutor_Information Form on a current record. However, I would like for it to open to a blank form instead while retaining the ability to access the current records. Individually, when opening the Tutor_Information Form from the Navigation Panel, it opens to a blank record.

I used a 2 step macro

1. OpenForm
2. GoToRecord - New.

How can I make it do the same thing when landing on the Navigation Form (Control Panel)? I am using Access 2013.

View 9 Replies View Related

Forms :: Displaying Selected Fields In The Same Column In Same Form?

Jul 10, 2014

How you could display a few selected fields in different rows within the same table.

SO as an example

Machine_No Board_No Board_Mode Board_Data
1 1 xxx xxxx
1 2 yyy ssss
1 3 ttt wwww
2 1 323 dddd
2 2 eee qqqq
2 3 rrr pppp

Based on which Machine_No i pick, i would like to display it's Board_Mode and Board_Data for all Board_No values (1,2,3)

i will be able to display this on the same form. (say machine_no = 1)

Board_Mode Board_data
1 xxx xxxx
2 yyy ssss
3 ttt wwww

View 6 Replies View Related

Forms :: Combobox On Navigation Form Header - Query Table To Show Right Info

Mar 24, 2013

I created a navigation form on which I put a form call [frmAnimal Setup].

I then placed one combo box on the Navigation frm Header. I have bound it to its source and it actually queries the tbl and show the right info. However when I select one, it will not let me.

In addition, [frmanimal setup] will not allow me to select a breed although it does query the tbl and shows the right information.

View 1 Replies View Related

Forms :: Opening A Form And Displaying Records Based On Two Criterion

Feb 24, 2014

OK, I have two forms:

Form 1: Courses

Form 2: Mark Grid

The user select the class from [Combo28] for the unit already in [Textbox named Unit] from Form 1 and wants to list all the students for that particular class and unit in form 2.

I have tried god knows how many different codes. I've been playing with:

DoCmd.OpenForm "Mark Grid", , , "[Text43]=" & Me![Combo28] & " AND [Text17]= '" & Me![Unit] & "'"

But with no luck.

View 2 Replies View Related

Forms :: Form Wizard Not Displaying Table Field Names

Apr 25, 2013

Access 2007 Pro.Attempting to use a query and a table to populate a 1:N form/subform using the Form Wizard. The wizard will not display the field names of the query.

View 2 Replies View Related

Update Order Info Based On Quote Info

Nov 7, 2006

I need help on this, from what the best concept is, to what I need to look into using:

I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.

As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?

Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...

Thank you.

View 2 Replies View Related







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