访问自动编号定义我自己的............， [英] Access Autonumber define my own ..................,

问题描述

iam对于此表单几乎没有失望，没有人有任何答案，反而可以帮助我传递评论并给我链接，谷歌上的链接也可用，但是我很累，如果我必须阅读链接，为什么我要在此表单上发布此表单，为什么?我在这里浪费我的时间，这些人不明白，这不是链接共享.这是为了帮助指出正确的解决方案，使那里的傻瓜变得资深，所谓的程序员态度太糟糕了，我首先在我的问题中说那些不友好的人不要给我发送链接或传递评论.提供洗手液，感觉不好，

这是我昨天发布的问题

我有桌子日记凭证

V_No主键定义并设置自动编号

我必须定义自己的自动编号，例如

例如
DateShowToday
JV-30Aprl2011-00001
JV-30Aprl2011-00002
JV-30Aprl2011-00003
JV-30Aprl2011-00004
JV-30Aprl2011-00005

请不要将链接发送给我.

解决方案

您的字段似乎包含三个子字段-一个两个字符的代码(在您的示例中为JV)，一个日期(在30aprl2011年)您的示例)和一个自动编号字段-因此您可以使用访问自动编号字段以及其他两个字段(代码和日期)来构建您需要的字段-如果需要显示该字段，请使用视图" .

如果您真的想让每个日期或代码更改的编号重新从1开始，那么您就必须自己编程-通过找到现有代码和日期的字段最大值，然后在计数器"上加一末尾部分

您可以使用类似的

select max(field) from table where field like ''JV-30Aprl2011-*''

我不记得Access语法了，但您应该明白这个想法.

我本打算发送到几乎完全符合您想要的功能的Access程序的链接-但您没有请求任何链接，所以就去了.像这样帮助您.尝试以礼貌的方式问一个合理的问题，而不是要求一个答案并告诉人们做什么和不做什么.毕竟，您无需为此服务付费.

iam Hardly disappointed for this form no body have any answer rather helping me passing Comment and give me the links , links are available on google also but i tired that why i post this on this form if i have to read the links why iam wasting my time here these people don''t understand this is not the link sharing Form this is to help right to point solution making fool people there senior so called programmer attitude of the people here is so bad , i firstly said in my qustion that those who don''t know kindly don;t send me the links or passing comments. provideing salution they feel bad,

This is my Question that i was posted yesterday

i have Table Journal Voucher

V_No Primary Key Define And Set AutoNumber

i have to define my own Autonumber Like

For Example
DateShowToday
JV-30Aprl2011-00001
JV-30Aprl2011-00002
JV-30Aprl2011-00003
JV-30Aprl2011-00004
JV-30Aprl2011-00005

Kindly not Send Me the Links Solution Required

解决方案

Your field appears to comprise three sub-fields - a two character code (JV in your example) a date (30aprl2011 in your example) and an autonumber field - so ou could use access autonumber field, together with two other fields (the code and the date) to build the field you require - use a ''view'' if you need to to present that field.

If you really want the numbering to restart at 1 for every date or code change then you will have to program it yourself - by finding the maximum value of the field for the existing code and date, then adding one two the ''counter'' portion at the end

you could use something like

select max(field) from table where field like ''JV-30Aprl2011-*''

I don''t recall the Access syntax off the top of my head - but you should get the idea.

I was going to send a link to an Access program that did almost exactly what you wanted - but you asked for no links, so there you go.

Well, you are really encouraging people to help you with comments like this. Try asking a reasonable question in polite terms rather than demanding an answer and telling people what to do and what not to do. After all, you are not paying for this service.

这篇关于访问自动编号定义我自己的............，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！