Track Order In Which User Selects Items From A List

May 11, 2012

I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:

I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.

View Replies


ADVERTISEMENT

Keep Track Of Stock Items By Query

Aug 14, 2006

Hy, I have this db where a user can purchase and item and total stock number needs to be updated.

I can calculate how many items are left but how to update the warehause table?

I can live without table updating, but if the same item is purchased multiple times my query return incorrect values as the number from which the formula subtracts is never changed.

See attached database.

View 1 Replies View Related

Track Price Changes On Items - Entries With Autodate

Oct 21, 2013

Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.

I have been doing this on Excel for a while now, and its time to do it properly.

The only issue I would have is when I enter data.

I want to be able to track the price changes on items. I have my own.

So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic)...

View 6 Replies View Related

General :: Entries With Dates - Track Price Changes On Items

Oct 21, 2013

Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.

I have been doing this on Excel for a while now, and its time to do it properly.

The only issue I would have is when I enter data.

I want to be able to track the price changes on items. I have my own.

So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic).

View 4 Replies View Related

Modules & VBA :: If User Selects Wrong Value / Display Message

Feb 23, 2015

I have a field that is pre filled in with a value. The name is "Business".Then there is a combo box with various values. If the user would select a value that does not match with values that can be selected if in "business" a value is selected, it should show a message that the selection is wrong and user needs to select the correct one.

Example:If in the field "Business" the value "Food" is selected, then the possible values to be selected in the combobox would be: Fruit or Meet or Fast Food. If the value in "Business" would be "Wood" only selections could be made: Talble or Chair or Cabinet.So, if a user select "Food' in "Business" and in the combo box "Chair", it should show a message that the wrong selection was made and don't let them use the wrong one.

View 11 Replies View Related

General :: Scanning Barcodes To Track Items While Using Other Database Functions

Feb 5, 2013

I can use barcode scanning to track items through the process, on the condition that the relevant field on a form is highlighted.

The issue is I want the scanning/tracking with wireless scanners to be going on in the background while an operator can use the other functions of the database.

I'm thinking the solution is two computers, one to run the barcode scanning & tracking the other for the rest of the database functions. The problem is we only have one work PC and getting money for a new PC will be like pulling teeth.

Is there a one PC solution?

View 2 Replies View Related

Forms :: Button That Opens Form And Pre-selects A Value In List Box

Aug 24, 2014

I open a form (EntryBasic) for users to enter data in, which is then saved to the only table in the database (MasterTable). The form (EntryBasic) has a list box with four choices: red, white, blue, orange. The button that opens the form is placed on another form (MainForm) The form (EntryBasic) record source is MasterTable.

A user is on the MainForm and needs to add a new record related to red. When user clicks on the button (NewRedEntry), I need the form to open and the list box pre-selected to red.

Is there a macro or VBA code that might simply execute this action, preferably something that can be attached to the NewRedEntry button?Even better, if there are two list boxes, code such code be applied to same NewRedEntry button, where both list box values are pre-selcted with the click of this button?

View 5 Replies View Related

Reports :: Generate A Report For Items In Previous Sentence Not Completed To Keep Track Of Workload

Jul 29, 2013

I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.

View 5 Replies View Related

Forms :: Second User Record Changes When First User Selects Record

Jul 31, 2014

I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.

But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.

View 1 Replies View Related

Track User Changes

May 17, 2007

Is it possible to identify the user and date of a change made to a record in an Access 2003 Database retroactively the built in securiy features were not turned on?

View 2 Replies View Related

How To Track User Logins

Oct 3, 2005

Hi,

I thought this was posted here in the past, but I can't find it. I need a way to track when users log into an access database (username and time).

Is there an easy way to do this?

Thanks,

Keith

View 1 Replies View Related

Modules & VBA :: Track User Log In And Out

Mar 27, 2014

I want to be able to track users log-ins on my DB, basically when a user enters their username and password I want the the time they log in and their username recorded in table. I tried doing it from the database found here: [URL] .... but I cant get it to work.

View 1 Replies View Related

Count Items In Order

Dec 27, 2007

I'm building an order entry database. It has two tables (amongst others) called tblOrders and tblOrderDetails, related together on the OrderID field. For every order, there is one record in tblOrder, and as many records in tblOrderDetails as there are individual lines in the order (so, if, for example, the order is for 10 pencils and 2 pens, then tblOrderDetails has 2 records).

Each entry in tblOrderDetails has a Status field, which indcates whether or not the items have are in manufacture, shipped, delivered, etc).

I need a way to get Access to show me only "Open" orders (i.e. ones in which not every item has been shipped). Can I set up a query to determine how many lines each order consists of, and then is there a way to get access to check if all of these are "Shipped"?

Many thanks in advance for any pointers,

Gary

View 1 Replies View Related

General :: Keep Track Of All Permits Per Year Per User In Same Table

Dec 3, 2012

We have a db to register permits that count for one calendar year. This since 2012. For next year, permits must be renewed. How can we keep track of all permits per year per user in the same table ? We would like to produce annual statistics as well ? Easy solution would have been to copy the existing table for the year 2012 and paste as a new table for year 2013 but we don't know yet who will renew his permit ...

View 3 Replies View Related

Video Items Order Question

Dec 8, 2005

Hi

First let me tell you about my system, these are some of my tables


tblMovie
MovieID,MovieTitle,MovieDate,MovieDescription,Movi eActors,CategoryID,MovieLength,MovieStatus,RatingID,MovieR entCount,MoviePoster

tblItem
ItemID,MovieID,FormatID,ItemCondition

tblSuppliers
SupplierID,SupplierName,SupplierCity,SupplierAddre ssSupplierPhone,SupplierMobile

tblPurchase
PurchaseID,SupplierID,PurchaseDate,PurchaseTimePurchaseCost

tblPurchaseDetails
PurchaseID,ItemID,Quantity,CostPerItem


my question is how can i make an order and then update the item table with the new copies that i ordered

View 5 Replies View Related

Preserve Order Of Items In Table Without ID Or Primary Key?

Nov 10, 2012

This is a CSV file that comes through an Access specification. I need to be able to copy the items from the table to other tables but somehow apply a unique and sequential ID to the rows first, this is essential to the job. The text import spec applies a unique ID but save the spec, and call it using VBA, it doesn't do that.

Also, there seems to be a bug where using a macro to run the text import specification, (and this is after an update from Microsoft), that it doesn't recognize the specs anymore... after I deleted several of them.

View 8 Replies View Related

Forms :: Bound Form - Items Not Appearing In Alphabetical Order

Aug 2, 2013

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

View 2 Replies View Related

User Security Access 2013 For Switchboard Items

Aug 3, 2015

I have user security level setup with username and password.I have set forms and tables etc to security levels.what i am having trouble with is setting user security levels to command buttons on the switchboard.Example if you sign in Mary Jones and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.

Code:
Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 2 Then
MsgBox "you cant open this form"

[code]...

it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.

View 5 Replies View Related

Tab Order - User Defined

Jun 16, 2005

Has anyone ever produced a function to let users, pick their own tab order for a form.

I am thinking along the lines of holding a tab order for each user for each form.

So when a form opens - if a user has saved a tab order the form will adopt it, if the user has never saved a tab order, the sytem default will be applied.

Would this work.

Paul

View 4 Replies View Related

Adding Items To List Boxes

Oct 4, 2006

This is a somewhat complicated question to explain, so please bare with me.

I have a form with a ‘list box.’ The box is populated using a Table/Query Row Source Type method. The table I am grabbing the list from is “Department,” where it contains a list of my company’s departments(ie. Accounting, HR, Payroll, etc.).

Now, the only thing this table does not have is the word “ALL.” I need this word in the “List Box” because I want users to have the option to select ALL.

Is there anything in VBScript code wise or in Row Source that I can do to include this word?

I know I can manually go into the Department table to simply add the word, but this is not the point, because there is more to that(I have different list boxes that are grabbing lists from different tables, AND I have to refresh these tables twice a week). Please help.

Thank you.

Joe

View 1 Replies View Related

List Of Tables And Items In A Database

Nov 7, 2004

Hi just started working for a Company and I found they have tons of
databases but no structure or standard, so I would like to build a tool that will go thrue a list of databases and get all the table names, the items and type. Is there functions in vba that can get me a list of the tables in the database and the get all the items in the database ?

Thanks on any input

View 2 Replies View Related

Forms :: Moving Items From One List Box To Another

Jul 16, 2015

I have a form where there are 2 list boxes: Part_List and acbPartList. acbPartList has multiselect enabled and what I want to do is be able to select multipler records in that list box and then press a button to add those selected records into the other list box. Here is my code for my button:

Private Sub addItemButton_Click()
Dim varItem As Variant
With Me.acbPartList_Existing
For Each varItem In .ItemsSelected
Me.Part_List.AddItem (varItem)
Next
End With
Me.Part_List.Requery
Me.Refresh
End Sub

I'm not sure if passing varItem is correct, but regardless, it isn't working because Part_List is based off of a query, its not a value list.

View 3 Replies View Related

Modules & VBA :: Sum Of Items Selected In A List Box

Sep 10, 2013

how to get the sum of column 2 of a list box total bags is in the second column, i only want the total of bags of the ones selected

I can get the sum of all the boxes but only want highlighted ones

Public Function SumListBox(sForm As String, _
sCtrl As String, iColumn As Integer) As Variant
Dim frm As Form

[Code]....

View 1 Replies View Related

Modules & VBA :: Looping Through All Items In List Box?

Apr 5, 2015

I have managed to amend records based on the user selecting multiple items in a list box by using the following code.

Set db = CurrentDb()
Set rs1 = db.OpenRecordset("Usage", dbOpenDynaset, dbAppendOnly)
Set ctl = [Forms]![frmsearch]![lstSelector]

[Code].....

what I need to do now, is to loop(I think) through and amend all the records in a populate listbox, with no selections, similar to above, but without selection.

View 3 Replies View Related

Select Multiple Items From Dropdown List

Mar 24, 2006

Hi,

I would like to be able to select multiple items from a dropdown list like we often see on web forms. The kind where you hold down the control key to select up to 5 items. Is this possible on an access form? If so, how would do we implement, and how is such data be stored?

Thanks!
~Bruce

View 12 Replies View Related

Forms :: Combo Box Allowing Not In List Items?

Sep 29, 2014

I am using the following code in a textbox (CountryID) to show a country name (CoName) from a table (tblCountry). If the comboBox (cmbCoName) in current form (frmCountry) has no entry then CountryID remains blank, great. If I use the form to add a new entry then CountryID flashes because it does not recognize the entry. Can I use "or" to add another condition in the IIF statement so that it allows the "not in the combobox list" entry?

Code:
=IIf(IsNull([txtCoName]),"",DLookUp("CoName","tblCountry","Country_ID = " & [Forms]![frmCountry]![txtCoName]))

View 2 Replies View Related







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