473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Auto Assign number from values selected from a combo box

15
Hi guys. i have a little problem here.
I have a combo box with values like Japan, China, Philippines and i want ms access to assign auto number in every values that i choose. Any help out there?

for example :

i choose Japan from the combo box then the text box will give an auto number.

help please!
Dec 3 '13 #1
1 974
zmbd
5,501 Expert Mod 4TB
How is this substantially different than what you have already asked for in: http://bytes.com/topic/access/answer...-choose-combox

Is this not the same issue as the compound lot/serial/sequence number that you asked therein?

If not, then you have alot of missing information whithout which we simply can not answer your question.
Dec 3 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: amywolfie | last post by:
Hi all: I have a subform called sfrmFootnotes linked to main Form frmFeeInput (the latter based on tblFees). tlkpFootnotes contains the PK for Footnotes. tjnCode_Footnotes is a join table...
2
by: mumbaimacro | last post by:
hi i have two combo boxes in a form with values from a table. i need a report to be opened by a button from the form ,The Report should show the values selected in the combo boxes in the form...
1
by: harsh2006 | last post by:
Hello friends, i have a situation where i have to take the values of combo box from the program. how can i do that. Let me explain in detail... i have a form which imports value from a excel...
4
by: hhak | last post by:
Hi all, Im pretty new to C#, im trying to assign a combobox selected value to a int variable. int number; combobox has items added (1,2,3,4,...9) when i select a number from the combobox i...
0
by: riyap | last post by:
i understood the oracle procedure but only question is after executing the access db query, how do i assign those values(each field values) to the parameters iam passing into oracle procedure i.e...
2
by: mygirl22 | last post by:
Hi, I used this code to created 2 combo boxes General and Specific...and Only show Specific (Combo B) when Combo A is chosen..... What i need now is to know how to assign specific values to the...
2
ddtpmyra
by: ddtpmyra | last post by:
How can I assgined value to each row of my query result? Example Book=1; Fruits=2; Animals=3 OR is there other way to do it? thanks for your help! echo "<tr><td><b>Categories:</b></td>"; ...
1
by: Karan Singh Goyal | last post by:
I have an access table which have fields like Customer Id, First Name, Last Name etc. i know how to generate auto number but when i delete last record it generates next number instead of previous one...
2
by: Will James | last post by:
Hi there, I have a vba query that inserts the data from a form into a table. I have 4 combo boxes that users can select values 0 to 10 from another table, how can I get either the combo box to...
3
by: natyboi | last post by:
Can anyone help me/..i have a problem in auto numbering. this is the case i have a combo box named municipality then with values like Dapa, Gen. Luna and Pilar. with another combo box named...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.