Access :: Show The Item Rating With Stars....help

How Do I Show A Selected Item?

Dec 29, 2006

I have a main form with several continuous subforms on it. These subforms are based on a selection of fields of a complete and editable form, so these subforms are overview forms so to speak. Whenever a field of a certain record is clicked, the other subforms show the linked data for that record, whenever a field of a certain record is double clicked, the corresponding form opens so data can be edited.

I would like to show which record is selected (record selectors are not enabled) in the way you select text in any application in windows. So when record A (holding fields A1, A2, A3 and A4) is selected in any way, the text should be lit up as if struck with a text-marker pen.

How do I go about that?

It would really be nice, since there is a cascading effect of records going on in the main form, which can get a bit confusing if you have to or want to glimpse at which record is selected. So for ease of use, this feature would really be nice.

View 4 Replies View Related

Have Combo Box Show First Item On List

Oct 20, 2004

I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:

A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).

Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.

Any Ideas?

View 7 Replies View Related

Show Item With Last Updated Price By Date

Aug 14, 2005

I need a (group by?) query that shows my items only by the last updated price by date.

Basically i need to show the last date. (MaxDate?)

I keep a database for my restaurant of my food items and change their price everyday. i now have a table that archives individual items by date, price and company in a subform.

Item_id, Item, date, cost , unit, Company

1 asparagus, medium8/12/2005$1.45poundEuro Gourmet
1 asparagus, medium8/13/2005$2.00 poundEuro Gourmet
55 oil, blended 8/12/2005 $4.99 gallon accardi
116 polenta 8/12/2005 $1.58 box accardi

I am trying to kick out an item or inventory sheet by creating this query but i cant seem to group by last date. i have all my items showing up multiple times (as many as i entered)
i have been easily able to create an inventory report off a query i used with only one date that i would change. but now i want to archive prices for charts.

i have tried max dates on item_id fields and date fields and nothing seems to work.

Thank you

View 3 Replies View Related

Queries :: Query To Show As A Single Line Item

Apr 8, 2013

Access Database in which i download the table from an Excel file.I am looking to create a query with certain criteria but did not have any luck recently.

1) I will need the query to show <Short code> that are only unquie to Korea.That means shortcode with a count of 1 belonging to Korea only.

2) I will need the query to show as a single line item <Shortcode> that appears two times under the country Korea. For example short code CB01406 is shown as two rows, i will like it to only show as a single row.

3) For all other shortcodes which exist in China as well as in Korea or China only. I will like them to be hidden in the query. That means not shown at all.

View 7 Replies View Related

Fill 'empy' Part Of Text Control With Stars*****

Jan 25, 2005

I would like the remaining part of my text control to show stars
e.g control value is 12
it shows *************12
control value is 3567890
it shows *********3567890

My text control does not have a fixed width, this is set in code depending on various factors
Thanks

View 1 Replies View Related

General :: Create New Table By Item ID To Show Balance Of Stock

Feb 17, 2014

I have created 3 tables for simple inventory.

a) Item details
b) stock in
c) stock out

All I simply want to do is create a new table by item id to show balance of stock.

View 2 Replies View Related

Wine Rating Database

Dec 21, 2005

Hi all,

Does anyone have a database lying around for registering and rating wines?

If not, I will just start from scratch and maybe if it goes well, post it here in the Sample Database section.

Cheers!

View 1 Replies View Related

Modules & VBA :: How To Compare Two Records (Rating)

Jan 5, 2014

So I have a table:

table1: company_name, year_month, company_rating, rating_change

For each company, I would like to compare the rating from 201201 and 201202 (and keep going for each month) and if there's a change in the rating, update rating_change to the difference in rating values.

The company_rating is a value from 1 to 20.

How should I go about doing that?

View 6 Replies View Related

Queries :: Building Rating Scheme Query?

Jul 8, 2014

I currently have 2 tables in a database that I'm trying to build a query off of. The first table lists personnel & their position #s, and the second table has a column for "rated person", "rater", "senior rater" and "reviewer" which are all part of our annual evaluations. I'm trying to program the query to display the names of the person attached to a position #, but can only get the query to return the actual position #s.

I'm using the table to assign each position # appropriately, i.e. position # 10202 is rated by 10103 and senior rated by 10101; I do this with the lookup data type. Once each position # is assigned, I'd like the query to display the name of the personnel instead of the position #, i.e. when queried, it would return under the rater column JOHN SMITH instead of 10202, and in the senior rater column JOHN JONES instead of 10103, etc.

View 1 Replies View Related

Query For Calculating A Rating Depending On Multiple Criteria

Dec 4, 2007

Hi All,

I have fought hard to try and figure this out and I have gotten 50% there.

I have a query that generates the following calculated fields through numerous calculations etc....:

[De-Merit Marks]
[No Del with Major Faults]

Now the way it should work is that a supplier gets a rating (A-D) depending on both their De-Merit Marks score and the amount of deliveries with major faults. I used the following function in the query and it does the de-merit mark grading.

Rating: IIf([qry_vend_rating2]![De-Merit Marks]<=10,"A",IIf([qry_vend_rating2]![De-Merit Marks]<=30,"B",IIf([qry_vend_rating2]![De-Merit Marks]<=50,"C",IIf([qry_vend_rating2]![De-Merit Marks]>=51,"D",""))))

However I have no idea how to integrate the Major Faults part.

Basically:

0-10 = A
11-30 = B
31-50 = C
51-100+=D

If the supplier has one major fault, the rating should drop one from that reported using just the de-merit score. Two means it drops two ratings (so if an "A" on just the demerit, they would drop to a "C" and so on. Obviously a supplier cannot drop below a "D".

Can anyone suggest how these maybe acheived? I fear it requring VB code, but I am not that good with VB hence why I have relied on queries for this.

TIA

View 2 Replies View Related

Setfocus On Repeating Item/accessing A Specific Item

Aug 18, 2006

I have a form that simply lists the items:
DEPARTMENT_NBR and DEPARTMENT_NAME

In the table: DEPARTMENT_TBL

When I edit the field DEPARTMENT_NBR and it is in error (must be between 01 and 99) I want to put out a message in a MSGBOX and SetFocus back on the DEPARTMENT_NBR.

I coded the MSGBOX with vbokonly and then DEPARTMENT_NBR.SetFocus, but after the message displays and enter is hit for the ok the cursor jumps to the DEPARTMENT_NAME on the current line. Is there a way to get the SetFocus to work properly on repeating items like this? I can never seem to get them to perform the same as they do on non-repeating items.

Thanks for your help.

HERE'S THE EXACT CODE:
If IsNumeric(DEPARTMENT_NBR) = False Then
If DEPARTMENT_NBR <> "00" Then
MsgBox "DEPARTMENT NUMBER must between 01 and 99.", vbOKOnly
DEPARTMENT_NBR.SetFocus
GoTo DEPARTMENT_NBR_EXIT (exits the paragraph skipping other checks)
End If
End If

Also, is there a way to look at a specific item in a list like that? IE. I want to reference the 3rd row's DEPARTMENT_NBR. Thanks.

View 4 Replies View Related

Populating A Subform Item To Another Subform Item.

Dec 21, 2006

Hey all.

I'm trying to get a combo box to populate the box next to it.

Basically pick a project number in the 1st box and have the project name show up in the second box.

I have it working, but the problem is that when it puts in the name of the project, it fills the whole column with that name, and not just the one box.

Here is what it's doing:
http://img156.imageshack.us/img156/2659/dbhm4.jpg

Here is the code im using.

Private Sub ProjectNumber_AfterUpdate()
On Error Resume Next

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String

ProjectNumber.SetFocus
If ProjectNumber.Value > 0 Then
strSQL = "SELECT * FROM ProjectList WHERE ID = " & ProjectNumber.Value

Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
If Not rs.BOF Then
Me.ProjectName = rs("ProjectName")
End If
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
End If

End Sub

Let me know what I can do.

Thanks!!

View 5 Replies View Related

User Defined Show/No Show Query Results

Jul 5, 2005

I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.

i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..

View 10 Replies View Related

How Do I Show Convert Vertical Entries To Show Horizontally

Jun 7, 2007

Is it possible to convert fields listed down to show across.

IDNo Code Position
AAA B01 1
AAA C01 2
AAA D01 3
AAA E01 4

I want to show it as
IDNo Code Code Code Code
AAA B01 C01 D01 E01

Is this possible using Access 2003?

View 7 Replies View Related

Query To Show Show Different Results From Same Group

Jun 11, 2006

I wondered if someone could help.

I have 3 columns of data within a table and from a select query am trying to seperate certain groups.

Table 1

yr period valuehome

2006 0 100
2006 0 10
2006 1 1000
2006 1 800
2006 2 60
2006 2 50
2006 3 40
2006 3 10
2006 3 5
2006 3 70
2006 4 50
2006 4 5

I wish to show both results for period 0 and an accumulative total for periods 1-4

so results would be

year period Total sum

2006 0 110
2006 1-4 2090

Can anyone help?

thanks

Paul

View 5 Replies View Related

Reports :: Show Detail - Using Section Header As Hyperlink To Show / Hide Detail

Aug 13, 2013

I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:

Code:
ABC Co.
ZYX Co.
123 Co.

If I click on ZYX Co., I want it to show the contracts for ONLY that customer:

Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.

Right now, my code looks like this for On_Click:

Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If

But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?

View 1 Replies View Related

New Item In The Field

Feb 22, 2005

Hi

I have a field that contains some kinds of the student status, such as "Current", "Alumni" and "Expire". The table has already got a lot of records. How can I make a new item available to the field, for example, "Other", without entering a new status?

Like, "Student A" is "Current" but he is now "Other" status. When the user see his record, he/she needs to change the student status from "Current" to "Other". I don't want the user to enter "Other" manually. I want it to be available from a comb box at the first place. How can I add a new item into a field without entering a new student record?

Sorry, I am unsure that I explain enough ..

Thank you.
Gaufres

View 3 Replies View Related

Item Numbers

Feb 2, 2005

OK heres the deal:
I have an asset inventory database that i've made where item numbers 1000-1999 is one category 2000-2999 is one category, 3000-3999 is one category etc.

I've made a drop down menu with the choices, 1000, 2000, 3000, etc.

What I want to be able to do is, I want the computer to generate the item number from that drop down menu's selected choice. For example if the category 1000 is chosen i want the computer to be able to generate the next possible item number (without duplicating any item numbers).

Is this possible?
Thanks much for any help :)

View 4 Replies View Related

Item Searches

Jul 6, 2005

Hi everyone i was just wondering if anyone new how to do the following;

Data is entered into a text box named txtItemNo on exit a search is performed and the next textbox txtDescription displays the results.

There is a table with itemnumber and item description in it the results would be the description.

Any ideas? This is on a subform, dont think this amkes any difference though
Thanks in advance :)

View 2 Replies View Related

Listbox Item

Jul 28, 2005

My query is executing on everything in the listbox. I only want it to be executed on the value that i select. What codes can i use? I really need some help on this one.

View 1 Replies View Related

Add Item To Combo Box

Sep 9, 2005

When a user enters an item manually into a Combo Box MS Access Help shows how to add it to the 'Value' list. I need the code to add it as a record to the underlying table.
Note: The table has only one column.

Thanks

View 2 Replies View Related

Selecting Item From Combo Box

Jun 5, 2005

Not sure what to search for so I thought Id write a new post:

I have a combo box which selects 3 items-

Primary key, Surname, Firstname

After an item is selected, the fields are populated according to the item.

Since there will be many records, it would be nice if the user can begin typing the surname and have predictive text, so the three items should then be-

Surname, Firstname, Primary key

So my question is, how do I get at the primary key if it is not selected?

myText = dlookup("myValue", "myTable", "primarykey = '" & ???? & "'")

If this does not make sense, what I am trying to say is:

The surname is selected, but I want to do a calculation based on the primary key so I get all the data associated with that user. I cant use the surname because there are duplicates.

Thank you

View 2 Replies View Related

Calculating Totals Per Item

Jun 29, 2006

For some reason I can't write the proper query to get a simple total from a single table. Here is the basic table design:

Transaction ID___Product ID___ Transaction Date____Transaction Quantity
1______________Product A____6/12/2006__________200
2______________Product B____6/12/2006__________500
3______________Product C____6/14/2006__________100
4______________Product B____6/15/2006__________200
5______________Product C____6/16/2006__________300
6______________Product A____6/17/2006__________500

I'm trying to get the total transactions quantity for each product so that I could end up with a form or a report that would show:

Product ID_____ Transaction Quantity Total
Product A______700
Product B______700
Product C______400

... and so on for each item.

What would actually be entered in the query? I'm assuming I would have four columns in the query:

transaction id____product number____transaction qty____expression

Then I would use the SUM feature so the "group by" row appears.

Then I would build the expression above in an expression column. If that's correct, could you give me the expression typed "exactly" as you think it would appear? I'm getting syntax errors when I'm trying it.

And then, once I have the expression built, what should be the "group by" selection under each of the columns?

Sorry for being so ignorant. The rest of my data base works great... but I'm just not getting this one thing!

Thanks anyone who can help me!

View 4 Replies View Related

Summing A Subform Item

Apr 14, 2005

I'm having trouble with a text box, which is trying to sum some date in a subform. All I get is #Error, yet I'm sure I'm referencing the item in the subform OK. I've attached the database as it's self explanatory (I stuck a label on it).

The form I'm having trouble with is frmPurchaseOrdersDataEntry and you'll see what I'm getting at from there.

Any help most appreciated.

Ste

View 2 Replies View Related

I Just Want To Select An Item In A Listbox!!

May 9, 2005

Hi Everyone!

I'm having problems and am frustrated as usual ;)

I'm trying to select a specific row in a listbox in the OnKeyDown event on my form. Basically, while in a subform, I want the enter key to move the focus to the list box, specifically to row After the last selected.

Here's an example of the code I thought would work:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Dim ItemNumber As Integer

ItemNumber = Forms![Product Inventory System]![InvList3] + 1

If KeyCode = vbKeyReturn Then
Forms![Product Inventory System]![InvList3].ItemData(ItemNumber).SetFocus

Else

End If
End Sub

I just started the Atkins diet today, so my sugar and caffiene levels are non-existant. (Seems like an easy excuse, right?)

Can anyone offer any insight into what I'm doing wrong?

Thank you so much!
Ben Bolduc

View 2 Replies View Related