I have an inventory access program that a sales outlet uses.
Since the barcodes of the same group of items are always changing, I want to figure out how I can scan all related items into one textfield, where at selling point, any item code can serve for that group without recording each one differently.
I have a table in wich I have stored numbers and i want to subtract them using vba.
example
Table1
ID number
1 20
2 40
textbox(ID):2 texbox(value):5 button(subtract)
So when i click button i want to subtract record with id 2 (40-5=35) and i want the new value to rewrite the previous one in the table.
result:
Table1
ID number
1 20
2 35
I want to know if it's possible to do this in vba.
I have a form that is button launched from a main form. The main form and this form are linked via their id#. The problem I am at is there are two different types of information that a user would need to fill in depending on what the group code is next to the id#. So if someone has a LSE code then it would need to have 17 fields added to the datasheet (they are in their own table) and if it is MLS then their 23 values added to the datasheet but not all of the information when someone launches the form.
I am adding a pic so you can see what is linked to what.
I'm putting together some databases, and there are some minor differences between each, but its fine now.
Now all thats bothering me, is that 1 of the fields in a table is a text field containging ONLY " y " or nothing. (thats the letter 'y' by itself or nothing.)
I just want to know if theres a way to convert it to checkbox (yes/no).
obviously, with large numbers of data entries, i wouldnt want to check each box manually correspondingly to the 'y' or lack thereof.
any help would be greatly appreciated.
Is there a attribute for setting the max amount of characters in a textfield, I have thought about adding some code in the on keypress event, to lock the textfield once the required amount of characters has been reached, but I was hoping there would be a more simple way.
View 5 Replies View RelatedI have a database that has a field [country] that stores the numerical id of the country from a table of countries. The student table also has a field called [mother tongue] and it seems to me that this is duplication.
I created a simple query based on a link table that tells me the country and its associated mother tongue.
SELECT [-LOOKUP-ALL-Country-LinkToMotherTongue].Country, [-LOOKUP-ALL-Country-LinkToMotherTongue].MotherTongueLinkNo, [-----LMotherTongue].Language
FROM [-----LMotherTongue] RIGHT JOIN [-LOOKUP-ALL-Country-LinkToMotherTongue] ON [-----LMotherTongue].[Reference no] = [-LOOKUP-ALL-Country-LinkToMotherTongue].MotherTongueLinkNo;
It seems to me to be an overhead to store in the student table the mother tongue id.
How can I create a text lable that dynamically shows the mothertongue as i move over records?
that way the user can see the students mother tongue but I only store the country table and link table to mother tongue. as opposed to a mother tongue entry against all students.
regards in advance
Peter
Hi
I have just been having a look at some of the past threads and I am hoping that what i want to do is possible however I am just wanting to check that it is possible and how hard it is?
I already have a database which controlls all of our stock however the quantaties have to be manually updated so I would like to give each item a barcode and use a handheld scanner so that the users can just scan what they have taken and then at the end of the day upload it to the database and all the quantaties will change.
My questions are is this possible and how hard would it be for a beginer?
Thank you
I have created form with multiple tables field in some of these fields I have assigned the combo box selection the total combo boxes in form is four and all are unique numbers but this form is incomplete.
1.When I select or update any of four combo box then remaining combo boxes and fields on form should be updated automatically with related records.
2.I need to bring calculated fields from multiple queries on to my current form .how I can insert query fields in to form...
I have a combo box that brings up records for an individual. I have people with the same last names and have their first names showing on the combo box list, but when i choose one of them, it will always go to the name of the person who was entered first, so matter who i pick(that has the same last name).
View 1 Replies View RelatedI want to add a bar code feature to my database for the following reason,
I want to use it as a search facility when looking up a member, each member will have a unique ID which I would assume would be turned into a barcode font.
When I scan the members ID card I would like the details for this person to be displayed.
Are there any idiot guides or useful reference points for me to get started with this, I have never used this method before so therefore know nothing about where to get started.
Have located a hand held scanner to use, it is a datalogic Dragon Scanner
Any help would be great
Cheers
Andy
Hey everyone,
I am trying to make a custom Access database, and I would like to have the ability to integrate barcodes into the database.
Basically, what I want to do is have the database open and when I scan a particular barcode, it will bring up a record associated with that barcode in a Form. I am wanting it to bring up the record pertaining to that specific barcode to allow for quicker retrieval of records ... Is that possible? Anyone know of how to do that?
Thanks!
Jason
I want to add a bar code feature to my database for the following reason,
I want to use it as a search facility when looking up a member, each member will have a unique ID which I would assume would be turned into a barcode font.
When I scan the members ID card I would like the details for this person to be displayed.
Are there any idiot guides or useful reference points for me to get started with this, I have never used this method before so therefore know nothing about where to get started.
Have located a hand held scanner to use, it is a datalogic Dragon Scanner
Any help would be great
Cheers
Andy
I'm having some issues using the cascading combo box technique on my form.
I have a form, which contains a subform in continuous view, which contains a few combo boxes.
One of those combo boxes (available resources) should be filtered depending on the value of 3 other combo boxes (task types, source languages, target languages).
What I would like to be able to do is run the filtering routine on this resources cbo (currently VBA code that changes the row source value) when the user clicks on it.
It's kind of working right now: when I click on the arrow to open up the drop down list, the values are indeed filtered. The problem I'm having though is that, if I then click on that same cbo for another record (or any other cbo in another record for that matter), the resource cbo of the record I previously set gets deleted.
I'm building a test registration form, and I want to populate 2 additional fields based on the TestID ComboBox selection. This same TestID table has a Requirement and Expected result field, that I want to display for the end user, to make sense of the test in question. Multiple fields in the ComboBox does not work since you cannot select a single testID; you can click on the relevant testID, but the table remains in view, rather than displaying only the relevant testID.
View 7 Replies View RelatedI would like to have 5 combo boxes from which users can choose fields to search, e.g.
cbo1 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo2 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo3 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo4 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
cbo5 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE
criteria are stored in txtbox1, txtbox 2 etc. so the search string could be
WHERE cbo1 = txtbox1 AND cbo2 = txtbox2 etc.
If the user doesn't choose anything for a combo, the search should ignore that field.
I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly.
1 - Can I display the values from both columns after the selection has been made?
2 - If not, can I choose to display the second column (not the first) after the user has made a selection?
We're trying to print a barcode (characterset "3 of 9 barcode"). If we print the data starting from an Excel-document on a Dymo-printer there is no problem to "read" the barcode with a scanner. However, if we print the same data starting from an Access-database, the barcode cannot be scanned. Does anybody have a clue how to solve this ?
View 9 Replies View RelatedNow I have a combo box "cbo_items" and a text box "txt_selectedItems", I want to populate text field with items selected from the combo box, every time i select an item it appears in text box and to be separated with comma, so text box appears like this ( item1, item2, item3), and after finishing the whole thing the result appears in lable "lbl_result" as "total items selected: 3 items".
View 1 Replies View RelatedAccess 2010
I have a form bound to a table which has 20 (name)fields and 1 date per record. A user fills in this form first to indicate which people are present this day. I know it would be better to use 1 name per record but that would in this case not work since the form must show all names for that day before saving and closing.
I have a different form where I use 4 combo boxes and a date field. The values that can be selected in the combo boxes should come from the 20 names on the first form and with the same date as the other form. So only 4 people of the 20 indicated as present on that day can be selected to have performed some task.
I know how to select with a combo box from different records, but how would I do it from different fields in the same record? And then also for a particular date?
I am newbie to barcode but I need to generate barcode for my invoice with the invoice something likes W12675679. Just want to know how to generate barcodes based on that type of invoice number, and how to store barcodes in ACCESS 2003!
View 14 Replies View RelatedI'm looking to create a database in order to scan a barcode on a packing slip to be automatically entered into database and update an inventory file.
View 4 Replies View RelatedI want to result as dlookup function in access 2007, when I use dlookup like this
=DLookUp("GPFDed","[SalaryAll]","[EMPID]='" & ![Cmb_EMPID] & "' And [SalMonth]='" & "Jan" & "' And [Salyear]='" & [me]![Label17].[Caption] & "'")
it gives #Name?
What is the problem and how can i change the label caption to Combo box column 2 value...
I have a form for user to select multiple items from a combo box, and 18 unbound text boxes , each time user selects an item in combo and hits "add" the value appears in txt box by order, I mean select1 then "add" filling txtbox1, select2 then "add" filling txtbox2 ... and so on till we reach txtbox18, then msg box appears that he filled the whole 18 boxe. I have already done this before for one txtbox which is a very simple operation, but i cannot figure out how to do it with multiple txtboxes.
View 2 Replies View RelatedI'm trying to create a form using a combo box to populate multiple fields and tables.
I've created a text field to display the added information using this format:
=Comboboxname.Column(x)
in the text box control source field, and this works for display purposes.However, I need it to populate this data into a field on a table.
For example:
My combo box looks up data that has 2 columns, Part Number and Description.
The control source for the combo box is "Part Number". And that populates the part number in the "Main" table no problem.
The text box I created using the above format in the control source populates the field in the form, but not the "Main" table.
Is there a way for the other (description) field to also populate the "Main" table as well?
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?
Let's assume we have 3 tables:
Order_Category (Order_Category_ID, Order_Type_Name) with 2 records:
1, Minor
2, Major
Order_Type (Order_Category_ID, Order_Type) with 4 records:
1, Book
1, Pencil
2, Car
2, House
Orders (Order_Category_ID, Order_Type, value) with 2 records:
1, NULL, NULL
1, NULL, NULL
2, NULL, NULL
I want to create a Multiple Items form presenting Orders table with two Combo Boxes:
1. A combo box to select Order_Category_ID.
2. A combo box to select Order_Type. When 1 (Minor) is chosen in the first combo box it should show Book and Pencil, when 2 (Major) is chosen it should show Car and House.
Examples in the Internet show how to do it on a 'single row' forms using the RowSource property. I tried to use a query like:
SELECT Order_Type
FROM Order_Type
INNER JOIN Orders ON Order_Type.Order_Category_ID = Orders.Order_Category_ID
WHERE Order_Category_ID = [comboBoxOrderCategoryID]
But it sets same values for all records in the Multiple Items form and it should return different values in each rows based on value in the first combo box (Order_Category_ID).