Forms :: How Many Times A Particular Row Has Been Selected

Dec 11, 2013

Any way to have a column in a table that can generate how many times a particular row has been selected yes active (yes/no data type) .

Example.
*Row*
1. Yes
2. No
3. Yes
4. Yes
5. Yes
6. Yes
7. Yes
8. No

The column would report
1. 1
2. 0
3. 1
4. 1
5. 1
6. 1
7. 1
8. 0

The next week I come and change the data to
1. No
2. Yes
3. Yes
4. No
5. No
6. Yes
7. Yes
8. No

The column would update to report (original + new active status)
1. 1
2. 1
3. 2
4. 1
5. 1
6. 2
7. 1
8. 0

View Replies


ADVERTISEMENT

Queries :: Count Number Of Times Field Has Been Selected

Apr 2, 2013

I'm compiling a monthly report based on data from my table "JobSheet"

I want to count how many times last month a specific field was entered, it's a drop down list which is formed from it's own table "Problem"

Is there a simple way of doing this?

View 3 Replies View Related

Forms :: Warn User When Data Being Entered 3 Times

Oct 24, 2013

I am making a simple database for the computer laboratory in school (my place of work). Actually it is a Automated Logbook System. Here's the Problem. I want to make a form that will prompt me whenever I enter the data(ID number) of the user(student) 3 times already for the current week.

The message box will more likely prompt.

The Data already entered 3 times this week!!!

View 14 Replies View Related

Forms :: Repeat Image By Number Of Times In Access Report

Oct 27, 2013

I am creating a simple report. I would like to add an image (already done) but repeat the number of times it appears by a numerical value i.e. [Image1] x [Quantity] (field value) so that the image repeats the number of times I require per record is this possible?

(I have attached an image)....

View 10 Replies View Related

Forms :: Create A Counter To Log How Many Times A User Login To Database

May 22, 2013

I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.

Is there a way I can add a counter to see how many times a particular user has logged onto the database?

Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.

View 2 Replies View Related

Forms :: BeforeUpdate Event Of Linked Subform Firing Multiple Times

May 27, 2015

I have to maintain an Access form which contain a linked subform (using Master and Child fields).

Basically, in the main form (Form1), the user choose a value in a combobox and the subform (Form2) is automatically updated.

My issue is that I have a BeforeUpdate event on one field of my subform which is preventing to update the field (Cancel=true) when it does not meet the criteria. The alert msgbox should appear once if there is any error in the field but the BeforeUpdate event is always fired 3 times for unknown reason.

What I don't understand is that if I open the subform (Form2) as a main form or if i remove the child/master link fields in the subform property sheet, it is working as expected with the BeforeUpdate event being fired only once.

View 5 Replies View Related

Forms :: Error If Not Selected

Aug 14, 2015

List box named: lstEvents
and 2 forms
Main 1: frmEvents
2nd 1: frmEventsEdit1

I have the codeing from here URL....Now, the problem im having is, that for the shows I have this code:

Code:
ShowNames: ([ShowName] & " " & Format([StartDate],"mm-yyyy"))

That is so that each show has the month and year attached to the name, so its easier to find out when they were, from just looking at them in the list box.But, if I use the search that John (The OP of that link) then if I were to search for 2015, and try to open a show, it just opens to a blank frmEventsEdit1. Even though I currently just tell it:

Code:
DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows

I would like two things.Either, to figure out why that isn't working, or 2, to get this If sentence im working on that goes like this:

Code:
If "EventID" = " " Then MsgBox "Error, please try again" Else DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows

View 13 Replies View Related

Text Get Selected On Opening The Forms

Feb 12, 2006

Dear All

I have a form with memo field as [acLetter]. Now whenever I open the form the text in the memo forms are all selected/highlighted in all the records. Is there any settings required to disable this feature or have I missed out something, so that the text should not be selected at the time of opening the form.

Thanks

View 1 Replies View Related

Forms :: Combobox With Default Selected Value?

Nov 1, 2014

i have 2 tables (clients, frequencies) where in table "clients" i have a column to store ID of "frequencies" table (id, description).

in my form "FClient" i display data stored in table "clients" and i have a combobox that should display the "frequencies" descriptions, but with a frequency selected by default...in fact the one that has its ID stored in table "clients". i'm able to display all frequencies descriptions but i don't know how to easily select and then display, as default, the frequency stored in table "client"

View 3 Replies View Related

Forms :: Move Selected Between Two Listboxes?

Dec 16, 2013

Move Selected Items Between Listbox1 (listEmp) and listbox2 (listAllocated). the items moved from listEmp must be removed from listEmp when moved to list allocated and vice versa.

Overview:

listEmp is my first listbox and currently has the query in it's rowsource
SELECT e.* FROM qryEmp AS e;
it has 7 columns but only 6 are showing (Column 1 is hidden)
and it is currently bound to 1

listAllocated has only 4 columns (can be changed) i only need the first 4 columns from the first list.
currently it has no row source and the row source type is set to Value
it is also bound to 1

I did find some code that does not do what I need but is closer than anything that I have found so far. It seems like it is copying the Selected Items from Column 1 and pasting it in the second listbox. but it is pasting them all in a row and not in individual columns below is the code. I will post a screen shot in 2 posts time.

Code:
Private Sub cmdCopyItem_Click()
CopySelected Me
End Sub

[Code].....

View 7 Replies View Related

Forms :: Adding Date If Value Is Selected

Apr 22, 2014

I want make a date control compulsory if a value is selected from a combo list on the same form.

I have Combo List, status, which can be 25%, 50%, 75%, WON or Lost. If the value is WON or LOST I want the date control, Date Project Closed, to be compulsory. I cant set it to insert today's date as it may have been closed up to a week before.

If 25%, 50% or 75% are selected then the date should not be compulsory.

View 9 Replies View Related

Forms :: Splitform View - No Record Selected

Mar 7, 2013

Access 2010

I have a bound form (splitform view) with the code

"DoCmd.GoToRecord , , acLast"

on the Form_Open event. When I open the form it does go to the last record and shows all the data that are in (some of the) fields. I cannot however manipulate the record until I click on the navigation buttons in the bottom of the form. It also doesn't show which record ("34 of 34" for example) is selected.

How I can get it to open the last record and let me manipulate it directly on open?

View 4 Replies View Related

Forms :: Combo Box To Be Selected If Another Field Equals 0

Mar 11, 2014

I have a form (PostProductionForm) which is used to input data about finished goods which come off a production line. There are three possible outcomes which can occur after the production: Passed, Reprocessed, Failed and the numbers for these are entered in 3 text boxes on the form (QtyReprocessedTxt, QtyFailedTxt, QtyPassedTxt).

These text boxes are auto populated with a 0 from the table (PostProductionTbl) so there aren't blanks.

What I am trying to do is use an IF function (I think) which says that if Quantity Reprocessed is equal to zero when the submit button is pressed, the "Reason for reprocessing" combo (RPReasonCombo) must have something selected (i.e. can't be blank) or it won't go to a new record.

View 5 Replies View Related

Forms :: Drop Down Shows Both Columns When Selected

Jun 29, 2015

I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? First col is First Name, second col is Last Name.

View 3 Replies View Related

Forms :: Populate Combo2 While Combo1 Is Selected With Any Value

Apr 17, 2013

I have two comboboxes in access form. what i want is if i select "A" from combo1, I want to have one value to combo2 could it be "x" or "y" or "z" but of my choice.. After combo1 is selected "A", I want automatically pop, lets say, "y" or any value i want may be "z" at combo2 of the form. Combo2 also has list of values (x,y,z) fetched from table.

Please note that both combos are fetched from tables that contains two columns (ID, name) and combos are fetched by binding first column and assigned column count 2; so that it shows the values rather than numbers. Moreover, the combos are allowed to store multiple values (defined in master table).

View 10 Replies View Related

Forms :: Update And Export Selected Records

Dec 22, 2014

I would like to export selected records (from list box) to .xls file, also populate the same value to all selected records. The value will be entered on the form once.

I'm attaching a small sample DB, so you can see what I have so far.

The Export function, or the update record functions.

View 8 Replies View Related

Forms :: Navigate To New Form From Selected Subform

Feb 6, 2014

I'm new to access and am currently building a simple db customers table and jobs table, I have a setup a relationship between the 2 and have the jobs bt las a sub form of the customer, but only showing a small amount of the job data.

What I would like to do is be able to click on a specific job within the job subform and navigate to that record in the job form where I can see all the data about that job.

View 4 Replies View Related

Forms :: Remove Item After Being Selected From Combobox?

Mar 30, 2015

How can I remove an item after being selected from a combobox ?

View 2 Replies View Related

Forms :: Addressing Listbox Elements In Selected Row

Nov 11, 2014

I have an unbound listbox with 3 columns. Call it PeopleBx. How can I address the item in the first row and first column. How can I address the first column in the selected row and how can I address the item in row 3 and column 2. I tried with

Code:
Me.PeopleBx.Selected

and other possible variations but failed.

View 9 Replies View Related

Forms :: Move Selected Items To And From Listboxes?

Dec 11, 2013

I have 2 Listboxes the first list is based on a query I need to select items from this box or part of each item and move to another listbox. the items in the second listbox will be used in a report. I have previously posted on another forum with no real luck fyi. the query is put straight in the RowSource.

View 3 Replies View Related

Forms :: Automatic Population Of Field When Name Is Selected

Mar 20, 2014

I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select.

I have got the the point where I have building name and number in the building name combo box but i'm stuck with the after update code builer part.

I currently have:

Me.Building_NameControl = Me.Building_Number.Column(2)

But doesn't seem to work.I don't really understand syntax!

View 12 Replies View Related

Forms :: Load Textbox From Selected Value From Another Form?

Jan 16, 2014

i have employee form to insert employee information one of its text box on click another form open of schools name where i can select the school work how can i pass selected school name to the main form

View 2 Replies View Related

Forms :: Produce Data From A Selected File/ Query

Feb 16, 2015

I have over 100 queries of weather data, for each month, and would like to display certain or filtered information for a selected month.

I have been playing around with a combo box to select a month from a given year, and was hoping that maybe an 'After Update' would do what I want. The problem I have is that I don't know how to do this, as the month picked and displayed in the combo box is variable , and so a sort of wildcard might do the job, if I knew how.

View 14 Replies View Related

Forms :: Open New Form From Selected Group Of Records

Aug 8, 2013

I'm developing a database where people basically can fill in an order form and then the database can track if the order has been placed, when it came in etc.I have a form called frm_Suppliers to be Ordered that runs off a query. The tables that relate to the query are called tbl_Products, with a primary key called ID and tbl_Suppliers, with a primary key called Supplier ID.

The form called frm_Suppliers to be Ordered, shows a list of suppliers that have open orders. Each supplier may have several orders open. I want to be able to click a button after each supplier name and bring up a continuous form that relates to all the records from that supplier that have open orders.

I have tried using the code found in the thread called "open a form based on the record that is selected in current form" from 06-08-2011, however it will only work when my form lists each open order separately, not when they are grouped by supplier.

View 2 Replies View Related

Forms :: Remove Multiple Selected Items From Listbox

Jul 24, 2013

How do I remove multiple selected items from listbox.

Noticed it is a table/query listbox, not value list.

Remove selected.zip

View 1 Replies View Related

Forms :: Count The Number Of Items Selected In Listbox?

Nov 1, 2013

I'm creating an employee audit database, and, in the audit form, the user (ie. supervisor) can select a number of items from a listbox. Each item selected corresponds to an error that the employee has made, and, as such, the employee's Audit Score has two points deducted for each item that is selected.

Incidentally, there are other, solitary elements to the form, but this particular listbox houses a collection of items that are related under a single category.

The score is displayed at the bottom of the form, and it needs to update in real-time.

The problems that I am encountering are that I am unable to count the number of items selected and then I am unable to multiply that count by 2 (the point-value of each item on the list.)

View 2 Replies View Related







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