473,569 Members | 2,617 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Customized Table

42 New Member
I’m trying to create a customized table for Purchase Order, where Purchase Order will be the Primary Key, 5 characters number, increments and autonumber and starts with 10000.
How do I do that?
Thanks
John
Vista
Access 2000
Mar 3 '08 #1
2 1077
MindBender77
234 New Member
I’m trying to create a customized table for Purchase Order, where Purchase Order will be the Primary Key, 5 characters number, increments and autonumber and starts with 10000.
How do I do that?
Thanks
John
Vista
Access 2000
First, create a new table in design view. On the first line type, Purchase Order. with a data type of auto number and hit enter. On the bottom of the screen, look for Format and type 10000. This should start your first purchase order as 10000 and will increment 1 for each entry.


Bender
Mar 3 '08 #2
John Torres
42 New Member
THANKS! Wow- that simple! I appreciate your quick response!

First, create a new table in design view. On the first line type, Purchase Order. with a data type of auto number and hit enter. On the bottom of the screen, look for Format and type 10000. This should start your first purchase order as 10000 and will increment 1 for each entry.


Bender
Mar 3 '08 #3

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

Similar topics

4
4241
by: Prakash Wadhwani | last post by:
Is there any easy way to color the header of a combo box (where the field headings are displayed on dropdown) ? There's only a horizontal line separating the headings from the data .... I'd prefer it if the headings could be colored ? Also can the headings be specified per field ? Currently I get something like I_F_Name for First Name,...
1
4144
by: Jean Bredeche | last post by:
Hi: I am trying to create customized confirmation/error/etc dialogs in my application. Up to now we've been using MessageBox.Show and passing it the various necessary flags (buttons, icons, etc). By "customized", I mean I want complete control over the color of the messagebox, the position/color/size of the buttons, etc. Do I need to...
0
1103
by: TIBM | last post by:
Hi. I'm trying to come up with a customized RadioButtonList and I don't know where to start. My requirements are: I'll be given a dataset that contains one table with product data (eg price, product_name, product_description, product_id) and I have to build a control that displays the products dataset on a page, allowing the user to make only one...
2
13494
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to execute a MailMerge to create mailing labels or customized letters. A label name known to MS Word MailMerge mailing label wizard may be used or a...
0
1184
by: segal.aviad | last post by:
Hi, I'm trying to create a customized setup project for my application. I want to write a setup project which will install several merge modules (- this I know how to do). Before running the setup, I want the admin to have the ability to create a customized setup, containing which ever merge modules he choses to include from the merge...
5
7270
by: RedHair | last post by:
I have a ASP.NET 2.0 web page which inherits a customized base page class and have a master page, their relation is as below Customized base page class --> web page --> master page How to access the property and control of master page from the customized base page class? Btw, I can access the server control of master page from base...
0
1134
by: tcv | last post by:
Hi folks, I have a need to draw customized table dynamically in my asp.net page. For example, i have a template table of 2 rows and 6 colums. Depending on the data from the backend I need to re draw this template to become a new table where: a) 1st colum will has 1 cell that spans over 2 rows b) 2nd column has 2 cells , one on each row c)...
2
1625
by: AccessHelp32 | last post by:
Hi All!, I've searched the fourms but I can't find anything specific to this. I'm trying to create customized letters using a data table containing names, addresses, order numbers etc. I want a standard letter, but I want the name, address and order number to change for each letter (e.g. Dear Mr. Jones, Dear Mr.Smith, etc). I also want to...
0
1452
by: vandalous | last post by:
Hello.I need to know how to create a customized table in wmls or wml; eg: a user enters the size of a table say: 4 and a 4X4 table is displayed. please help;) thanks
0
7701
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7615
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7677
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3643
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2115
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
940
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.