[SOLVED] MSAcess

James Tembo · 05-20-2009, 08:28 AM

am creating this Database application and am stuck on these:
1)Auto number
2)Combo Boxes and Tex boxes

Autonumber
i hav got tables in my project eg Demand note table,Purchase requisition,stores Issue voucher tables
on these tables i want my auto number to appear on the forms like this
for the purchase requisition for example pr1000
how do i go about it
in other words how do customise my autonumber bcoz its also my primary key.
combo boxes
how do i syncronise them so they can coordinate
eg adding to values in two textboxes two get the sum in the other one.

**Dragoen** · 05-20-2009, 10:33 AM

Hi James,

The AutoNumber data type is a Long Integer so in order to display it as an Alpha-Numeric you will need to concatenate your form type prefix i.e. PR, DE, SI whenever you display it. The field that you make the autonumber can still be the key field for the table without the alpha prefix.

As for the combo box question, I'm not really sure what you are asking. Could you explain it in more detail?

Hope that helps,

**jamiemac2005** · 05-20-2009, 03:32 PM

I get the combo boxes question, basically how can you make a text box display the sum of two combo boxes. And the only way i've done this before is programmatically because it requires using the onchange events of the combo boxes.

Cheers,
Jamey

James Tembo · 05-21-2009, 01:02 AM

Hi guys,

so how do i go about concatenating my form type prefix?

For the combo box question i meant for example if u choose an item in a combo box,the other combo boxes will show other details
eg
i choose maybe Item Code 1000,then the second combo box shud desplay the Item description automatically,then the textboxes,how do i go about it programmatically say in VBA code.
hope i v not confused u with my explaination

thanx in advance
cheers

**Dragoen** · 05-22-2009, 11:45 AM

Hi James,

to concatenate a form prefix to a serial number (the autonumber value for that type of form) you would just create a text box on your form or report to display the number and in the control source property for the text box enter:

= "PR" & [Purchase_Req_ID]

and that would display PR1234. Essentially the ampersand is the concatenation control in Access. Of course you need to use your desired prefixes and field names for the form ID numbers.

James Tembo · 05-23-2009, 12:44 AM

Thanx Dragoen u v been so helpful.its working now!

05-20-2009, 08:28 AM	#1 (permalink)
James Tembo Registered User Join Date: May 2009 Location: Kitwe, Zambia Posts: 53 OS: windows xp sp2,Professional Edition,Version2002	[SOLVED] MSAcess am creating this Database application and am stuck on these: 1)Auto number 2)Combo Boxes and Tex boxes Autonumber i hav got tables in my project eg Demand note table,Purchase requisition,stores Issue voucher tables on these tables i want my auto number to appear on the forms like this for the purchase requisition for example pr1000 how do i go about it in other words how do customise my autonumber bcoz its also my primary key. combo boxes how do i syncronise them so they can coordinate eg adding to values in two textboxes two get the sum in the other one.

05-20-2009, 10:33 AM	#2 (permalink)
Dragoen TSF Enthusiast Join Date: Apr 2009 Location: Harrisburg, PA Posts: 1,024 OS: Windows Vista Home Premium (6.0, Build 6001) My System	Re: MSAcess Hi James, The AutoNumber data type is a Long Integer so in order to display it as an Alpha-Numeric you will need to concatenate your form type prefix i.e. PR, DE, SI whenever you display it. The field that you make the autonumber can still be the key field for the table without the alpha prefix. As for the combo box question, I'm not really sure what you are asking. Could you explain it in more detail? Hope that helps, __________________ Dragoen ========================================================= Just because we can, doesn't mean we should...

05-20-2009, 03:32 PM	#3 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,878 OS: Vista, various linux distros	Re: MSAcess I get the combo boxes question, basically how can you make a text box display the sum of two combo boxes. And the only way i've done this before is programmatically because it requires using the onchange events of the combo boxes. Cheers, Jamey __________________ Myspace

05-21-2009, 01:02 AM	#4 (permalink)
James Tembo Registered User Join Date: May 2009 Location: Kitwe, Zambia Posts: 53 OS: windows xp sp2,Professional Edition,Version2002	Re: MSAcess Hi guys, so how do i go about concatenating my form type prefix? For the combo box question i meant for example if u choose an item in a combo box,the other combo boxes will show other details eg i choose maybe Item Code 1000,then the second combo box shud desplay the Item description automatically,then the textboxes,how do i go about it programmatically say in VBA code. hope i v not confused u with my explaination thanx in advance cheers Last edited by James Tembo; 05-21-2009 at 01:26 AM.

05-22-2009, 11:45 AM	#5 (permalink)
Dragoen TSF Enthusiast Join Date: Apr 2009 Location: Harrisburg, PA Posts: 1,024 OS: Windows Vista Home Premium (6.0, Build 6001) My System	Re: MSAcess Hi James, to concatenate a form prefix to a serial number (the autonumber value for that type of form) you would just create a text box on your form or report to display the number and in the control source property for the text box enter: = "PR" & [Purchase_Req_ID] and that would display PR1234. Essentially the ampersand is the concatenation control in Access. Of course you need to use your desired prefixes and field names for the form ID numbers. __________________ Dragoen ========================================================= Just because we can, doesn't mean we should...

05-23-2009, 12:44 AM	#6 (permalink)
James Tembo Registered User Join Date: May 2009 Location: Kitwe, Zambia Posts: 53 OS: windows xp sp2,Professional Edition,Version2002	Re: MSAcess Thanx Dragoen u v been so helpful.its working now! Last edited by James Tembo; 05-23-2009 at 12:46 AM.