How To Build Sliding Bar Displays?

Jan 8, 2007

Hello All

Does anyone know how you might build sliding bar displays as an input device for scores into an Access database? I am building an application that could really use something like this.

Here is an example. First go to the 'Chelsea tab', slide the bars, submit the results, and see the results on the "Results" tab

http://news.bbc.co.uk/sport1/hi/football/teams/c/chelsea/6173703.stm

Very impressive

NoVoice

View Replies


ADVERTISEMENT

Reports :: Build Report That Only Displays Specific Data?

May 17, 2013

I have an excel spread sheet that is linked into access 2003 via a table. This spread sheet is updated by personnel in another location and I have to run a weekly report on engines stored in that table that are below a certain performance level. The column heading is MGT Margin and I have to list all of the engines that are below 20 degrees. Can I run a query that looks at this table and produces a report of all the engines that are only below 20 degrees? I currently have to cut and paste each engine from the updated spread sheet every week onto a separate spread sheet and import that into access to run the report. Can a query be used to run the required report? I have attached a screen shot of the query that I am putting together to try and run this report.

View 5 Replies View Related

Record Displays In Row When There Is No Data?

Mar 18, 2005

I have a form that contains 4 sub-forms. In two of the Sub-Forms "Users" and "Computers" the form displays the PK on the second row when there is NO Data? (See attached).

Does anybody know how I can stop this from displaying?

Many Thanks,
Phil.

View 5 Replies View Related

Lable Displays Result

Jan 11, 2005

How can I Program a LABLE to appear (.visible = True)
when a result is present!

Example: If RecivedDate.text >1 Then LABLE.visible = True

I have it as Not Visable on start up! I cant seem to get this to work =(
Where can I place this CODE, so that it is executed every time the record is changed

Please help me put the finishing touches on a good Access DB Thank YOu

View 4 Replies View Related

Tables :: Combo Box Displays ID Only?

Dec 10, 2012

I have been designing a database and finally was making good headway. I have a junction table that references 2 tables (1-m) and the junction table creates an autonumber primary key that many tables will reference. I realized that the junction table could have duplicates. I did not want to use a composite primary key, but found that I could create an index that contained the unique combination of my foreign keys. No more duplicates. I thought things were looking up. I found out that it is a bad idea to use a combo box in dataset view to have look-ups to other tables. If it is a bad idea why have the option? It does make data entry easier. Anyway not my question. The other tables that refer to my junction table no longer show the values of the foreign keys, but displays an id number for my 2 columns.

Using MS Access 2010 32 bit Win XP.

View 5 Replies View Related

Query Displays Blank Fields

May 19, 2006

I have a query that gets data from a table now not all fields are filled in, in this table, and the query only shows data that has all fields filled and i need it to show them all

View 3 Replies View Related

Parameter From Form Displays Garbage

Nov 28, 2006

Hi there!

I'm trying to use an Invoice number from an Invoice form to populate a table of Invoice Lines with relevant records (linking by Invoice number). I realise the following SQL code isn't an append query, but I've simplified it to make it easier to explain

SELECT [Forms]![fInvoices]![SPInvNumber] AS MTInvNumber, tInvoices.SPInvNumber
FROM tInvoices
WHERE (((tInvoices.SPInvNumber)=[Forms]![fInvoices]![SPInvNumber]));

The output I get for this query is something along the lines of:

MTINvNumber | SPInvNumber
쉠 | 49760

THe MTInvNumber should read the same as the SPInvNumber, but it doesn't. If you can't see the above, its some sort of weird chinese/japanese character I think!

I thought maybe it was a display error, but I tried using it in my append query, and it inserted it as garbage too. The weirdest bit is it actually regards the form information as equalling the SPINvNumber from the tInvoices table! :S

Any clues on how I get it to format correctly??? I'm very tired now so it's bound to be something simple!

View 2 Replies View Related

Publisher Displaying Name.. Now Just Displays Numbers?

Apr 4, 2005

I have a list of publishers for software titles in a table.

1=Adobe
2=Macromedia

and so on and so forth.
I have a form that pulls the publisher name and displays it, and it used to display correctly with the NAME but now all of a sudden it's displaying the publisher number "1" instead of "Adobe"

what's going on?

View 1 Replies View Related

Combo Box In Form That Displays Last 7 Days

Feb 15, 2006

Hello, please could anyone tell me if is it possible to have a combo box in a form that displays just the last 7 days? (from whatever today’s current day is) I need to be able to store this date that the user selects in a query/table(Currently I have a field named SHIFT_DATE that the user enters a date into this field, this field is bound/linked to a query)Ie a drop down list showing the dates like this:15/02/200614/02/200613/02/200612/02/2006& so on……ive used the following code in a query before to display records from just the last 7 days >=DateAdd("d",-7,Date())I thought maybe I could do something similar in a combo box but I’ve had no luck so far :-( any suggestions would be excellent. Thanks.

View 14 Replies View Related

Combo Box Displays Data ... Database Does Not

Jun 20, 2006

Friends,

I have created a combo box on a form using the combo box wizard. The combo box is linked to a table, and the combo box user's selection is supposed to be entered into a table so I can use it in reports, etc. The form works great. However, when I go to the table field that is supposed to have the newly entered combo-box selection, it contains only the record number, not the field contents chosen (by-the-way ... the record number and the record ID are the same ... maybe it is showing the ID??) Either way, why won't the table show the correct user choice from the form?

Thanks,
Mike

View 1 Replies View Related

Button That Displays A Form In Unbound Box

Sep 7, 2006

Hi

I've checked out some nice solutions on this forums but i'ts not really what I want and I've tried to modify them but without success.

Can anyone create a sample or let me know how to do this the easiest way preferably with no scripts (or small ones)

//Mikael

View 1 Replies View Related

Sub Form Displays Master Record

Sep 26, 2006

Hello I have a small problem that seems weird. I have a form which displays a subform with all correspondending jobs for one individual. The problem is the sub form displays the main form information with the other jobs. Im trying to stop the subform from displaying the current mainform's job information. So it won't look like there are more then 1 of the same jobs to other individuals. Can someone help me with the correct method to stopping this. Thanking you in advance,

View 1 Replies View Related

Forms :: Calculation Only Displays When Clicked

Jan 8, 2014

I have a form which has a few calculations on which are:

TotalPrice - =Nz([Quantity])*([UnitPrice])

Then at the bottom to calculate it all:

=IIf(Sum([Quantity]*[UnitPrice])=0,0,Sum([Quantity]*[UnitPrice]))

This has been working perfectly fine however the TotalPrice is no longer calculating the UnitPrice x Quantity and the TotalCost isnt calculating as nothing appears in the TotalPrice. However when we click the fields the data is diplayed but only on clicking, if we leave the record and go back its back to blank again.

View 2 Replies View Related

Forms :: Form Screws Up And Only Displays One Row

Jul 3, 2013

I have a form, with a sub-form, which worked fine. but now, after I added and changed around the options in a combo box in the sub-form my main form only shows one result.

View 7 Replies View Related

How Do I Build This?

Aug 8, 2006

How do I build a form which will pull only certain work orders from my table [Work Orders], filter it through a query, [Payroll] which gives me only those work orders which match a certain repID#, for only certain Invoice Dates, and and then display a talley of the total number of times a certain product appears in the field [ProductSold] on the query [Payroll]?

View 1 Replies View Related

Total Time Query Displays Incorrect Value

Feb 16, 2007

Hi,
I am using

Total_Time: Format([totaltime_mins]/60,"00") & ":" & Format([Totaltime_mins] Mod 60,"00")

To display the time as hours and minutes but this formula doesn't always work correctly.

for instance if the totaltime_mins = 90 then total_time is displayed as 2:30

also if totaltime_mins = 40 then thotal_time is displayed as 1:40

does anybody know why this is not working correctly ?


kind regards,
jamie

View 2 Replies View Related

A Query That Only Displays Each Item And The Cheapest Price

May 2, 2007

ok i have a table containg two columns. One column has a list of items and the second column has their respective prices. I wanna make a query that only displays each item and the cheapest price. Does anyone know how to do that?

View 5 Replies View Related

Combo Box Selection Displays Results In Listbox

Jun 6, 2005

How do I get my combo box selection to display related results in a list box?
I have a many to many table structure for a contact list that relates many contacts to many costcenters. What I want is when the user selects a costcenter from the combobox the related contacts show in a list box.

Thanks,

View 4 Replies View Related

Imputing Data Displays Info In Another Text Box?

Oct 4, 2005

Haya all, I’m new to access and I’m trying to create a database for my boss, but am a bit stuck, it’s a Bundy clock system in access, I have the tables set up (I think), and what I’m stuck on is building a form where, when I put in the employs ID and press enter there name appears underneath, can anyone point me in the right direction of a tute that would show me how to do this?

Thanks so much

The way I have the table set up is 3 fields, staff ID, first name, last name. All within one table

I think I’m in over my head… but you have to learn somehow :confused:

View 2 Replies View Related

Listbox Displays Data Associated With Parent Form?

Dec 23, 2006

Hey guys,
I was wondering... is there a way to have a listbox display values associated with a parent form ID? in other words... say I have a customer with invoices associated with their name, I want to display a form for that customer with a listbox (or maybe even subform) containing the invoice IDs associated with their name.
Right now, I've got:
SELECT qryClientData.InvoiceID, qryClientData.InvoiceDate FROM qryClientData ORDER BY [InvoiceDate]; to display information in the listbox. How do I modify this to display ONLY Invoices associated with the Clientname on the parent form?

I hope this makes sense. I can clarify if need be, I am just completely stumped. thanks and happy holidays!

View 7 Replies View Related

General :: Field Displays Wrong Info

Sep 12, 2012

I use this to record piece counts and weight of items of freight that I pick up in Boston ( all seafood by the way) Anyhow here is the problem I'm having. Anytime I create a report one of my field names (RECIVER) keeps displaying as a unique number. Example, "New Enland Fish Market" display's as "14" which is its auto number assigned to it when I created the Table of recievers.

View 3 Replies View Related

General :: Look Up Wizard Displays Numerical Value Instead Of Text

Mar 19, 2015

I am having some problem regarding the way the options in a lookup field is displayed. Currently the options are displayed numerically instead of displaying the actual text.

I have three tables which are ContactPersonnelT, OrganizationT and TrainingDonorT.

One of the fields in the ContactPersonnelT table is, Affiliation. This field is a lookup value (look up wizard) which comes from the OrganizationT table field, OrganizationName.

In the TrainingDonorT table I have a field called, ContactPersonnel. This field is a lookup value which comes from the ContactPersonnelT table field, ContactPersonName. In the drop down list of the ContactPersonnel, besides the ContactPersonName. I also want to display the Affiliation field. However, instead of displaying the text in the OrganizationName field, a numerical value is showing.

How to change the display to text instead of the numerical value.

View 5 Replies View Related

General :: Report That Displays Results Of A Query

Mar 16, 2013

I have a report that displays the results of a query. The query and the report are both run from a submit button on a form. I use DoCmd.OpenQuery "name", followed by DoCmd.OpenReport "name". Due to slow network connection the query shows up before the form is displayed. I would like the query to be hidden or minimised. In other words, I do not want the user to see the results of the query, only the report.

View 3 Replies View Related

Reports :: Report That Displays 3 Different Columns Of Numbers

Aug 22, 2013

I have a report that displays 3 different columns of numbers.. and when I try to do a total for any one of the columns the sum option is greyed out and I cannot total any of the columns at the bottom of the report. Everything I have read says I should be able to do that.

View 5 Replies View Related

Build Function

Feb 23, 2007

I can't find anything in the archive relating to this...

Can someone tell me how to enable the "Build" feature in the Visual Basic screen in 2003, please?

I recently upgraded from 97 and can only find the "Build" feature in Query Design.

In 97 it was available by right clicking the screen and selecting "Build". I have no such option when right clicking in 2003.

Thanks

View 5 Replies View Related

Help With Table Build

Dec 4, 2006

Can anybody help me build the last table in my database? I have taught myself Access – and can usually get by with a little help from this forum. I have been trying for days to try and solve this !!!

The database is designed to manage feedback questionnaires from attendees of training courses.

I have attached the relationship diagram.

- A course may run for several days. The details of the course are held in the table ‘Courses’. During a course, attendees may be asked to fill in several Questionnaires
- An Attendee is a Person that attends a Course. Attendees are held in the table ‘Attendees’ and their details are held in the table ‘Person’.
- There is a ‘Library’ of questions that sit in the table ‘Questions’
- The questions can be assembled into “Standard Questionnaires”. These sit in the table called “Questdesign” which is a junction table. Assembling a Standard Questionnaire involves using a form to pick questions and give them an order (Qnumber). I HAVE DONE THIS.
- A specific “Questionnaire” is a “Standard Questionnaire” that is used on a specific course. The list of Questionnaires is held in the table “Questionnaire”
- Scoresheet is the junction table between Attendee and Questionnaire (an Attendee on a course may fill in several Questionnaires and a Questionnaire may be filled in by lots of Attendees.)

I now need a table (Scores) in which to put all the scores to the questions (in other words, the scores of the questions on the Questionnaires that are completed by the Attendees on a Course.)

At the end of the day I am aiming to have a form in which:

The Attendee number is entered and all the person’s details are filled in automatically) – I HAVE DONE THIS
The Questionnaire number is entered and all the course details are filled in automatically – I HAVE DONE THIS
A Scoresheet ID is filled in (Autonumber) - I HAVE DONE THIS
A subform appears which shows the right set of questions and question numbers for the appropriate Questionnaire – with a blank column so that the user can fill in the scores which get stored in the Scores Table. - I CAN'T DO THIS !!!

I cannot work out where to link my Scores table and how to build a query that drives the correct behaviour of the subform

I hope I have explained this clearly. I would be so grateful for any help. This Forum is fabulous.

Many thanks

NoVoiceLeft

View 6 Replies View Related







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