初学者问题 [英] Beginner question

问题描述

嗨！我是一个相当新的访问并且不太熟悉vba

编程。我正试图在

公司建立一个股东数据库。到目前为止，我已经设法构建包含所有者数据的表格，

股票数据以及我在哪里注册每个

所有者拥有的股票的表格。


现在遇到困难（？）问题。我需要为股票设定一个数字

所以我可以制作一份所有权报告，显示人们拥有的sharenumbers

拥有。我打算制作一个新表，其中我为每个新发行的股票包含一个已排序的

列，以及每个新发行的每个所有者的列数

股票问题。然后我计划有一个

单独的列，总结所有权栏中的股票数量，

，最后是一个给我一个从 - 到值的列，象征着<每个新发行股票中每个所有者的独特sharenumbers ..


看起来非常简单，但我感到卡住了。有谁可以请

帮我上车？


提前致谢！

解决方案

" StenKoll" <再**** @ asly.net>在留言中写道

新闻：6d ************************** @ posting.google.c om ...

嗨！我是一个相当新的访问，并不是很熟悉vba
编程。我正在努力建立一个
公司的股东数据库。到目前为止，我已经设法构建包含所有者数据的表格，以及用于共享每个
所有者拥有多少份额的表格。

现在到了困难（ ？） 问题。我需要为股票设置一个数字
所以我可以制作一份所有权报告，显示人们拥有的sharenumbers。我想知道如何制作一个新表，其中我为每个新发行的新发行的股票和每个所有者的库存列数列出了一个已排序的
列。然后我计划有一个
单独的专栏，总结所有权栏目中的股票数量，
最后一个栏目给我一个从 - 到值，象征着每个所有者的独特sharenumbers在每一期新发行的股票中......

看起来非常直接，但我感到困惑。任何人都可以帮助我继续吗？

提前致谢！

如果你有更好的帮助你展示你的桌子的设计，包括（特别是

）每张桌子的主键。


这是一个示例格式：


tblShareholder

SharholderID（主键）

姓名，地址等


我''我不挑剔！关于

表设计问题，很难做出任何明智的评论，除非我们知道> what<你想要使用的桌子;

，特别是你说的是每张桌子的主键。


HTH，

TC

" StenKoll" <再**** @ asly.net>在留言中写道

新闻：6d ************************** @ posting.google.c om ...

嗨！我是一个相当新的访问，并不是很熟悉vba
编程。我正在努力建立一个
公司的股东数据库。到目前为止，我已经设法构建包含所有者数据的表格，以及用于共享每个
所有者拥有多少份额的表格。

现在到了困难（ ？） 问题。我需要为股票设置一个数字
所以我可以制作一份所有权报告，显示人们拥有的sharenumbers。我想知道如何制作一个新表，其中我为每个新发行的新发行的股票和每个所有者的库存列数列出了一个已排序的
列。然后我计划有一个
单独的专栏，总结所有权栏目中的股票数量，
最后一个栏目给我一个从 - 到值，象征着每个所有者的独特sharenumbers在每一期新发行的股票中......

看起来非常直接，但我感到困惑。有人可以帮我帮忙吗？

提前致谢！

你是对的！你不挑剔我会深吸一口气吗？

改写自己？... :-)


我们走了：

tbl姓名：

Name_ID（主键）

名字

姓氏


tbl New_Issues_Shares

Issue_ID（主键）

日期

Number_of_shares（每期新发行）


tbl Number_of_shares

Transaction_Counter

Name_ID

Issue_ID

Number_of_Shares


通过查询我已经能够通过使用事务计数器按顺序列出所有股票的运行金额

。我现在的问题是如何为个人股票编号

，以便交易1显示股票

从1-500，交易2从500到600，交易3从600到

800等等。

我之所以这么想，就是能够发行单独的

证书，显示每个人拥有哪些股票。


重新阅读上一篇文章之后，我意识到给出的信息难以获得帮助，但我已经让人们更容易了to

现在帮帮我吧？


谢谢，

StenKoll


" TC" < a@b.c.d>在消息新闻中写道：< 1070078342.982907@teuthos> ...

如果您显示表格的设计，包括（特别是
）每个主键，您将得到更好的帮助表格。

这是一个示例格式：

tblShareholder
SharholderID（主键）
名称，地址等。

>我不挑剔！很难对表格设计问题做出任何合理的评论，除非我们知道> what<你试图使用的表格;
，特别是你说的是每张桌子的主键。

HTH，
TC

" ; StenKoll" <再**** @ nospamasly.net>在消息中写道
新闻：6d ************************** @ posting.google.c om ...

嗨！我是一个相当新的访问，并不是很熟悉vba
编程。我正在努力建立一个
公司的股东数据库。到目前为止，我已经设法构建包含所有者数据的表格，以及用于共享每个
所有者拥有多少份额的表格。

现在到了困难（ ？） 问题。我需要为股票设置一个数字
所以我可以制作一份所有权报告，显示人们拥有的sharenumbers。我想知道如何制作一个新表，其中我为每个新发行的新发行的股票和每个所有者的库存列数列出了一个已排序的
列。然后我计划有一个
单独的专栏，总结所有权栏目中的股票数量，
最后一个栏目给我一个从 - 到值，象征着每个所有者的独特sharenumbers在每一期新发行的股票中......

看起来非常直接，但我感到困惑。任何人都可以帮助我继续吗？

提前致谢！

Hi! I am fairly new to access and not very familiar with vba
programming. I am trying to setting up a database of shareholders in a
company. So far I have managed to build tables containing owner data,
data for the shares and a form where I register how many shares each
owner owns.

Now to the difficult(?) issue. I need to set a number for the shares
so I can make an ownership report showing wich sharenumbers people
owns. I have thougt about making a new table where I include a sorted
column for the Id for new issues of shares and a column number of
stocks for each owner in each new issue. Then I plan to have a
seperate column summing up the number of stocks in ownership column,
and finally a column which gives me a from - to value, symbolising the
unique sharenumbers for each owner in each new issue of shares..

It seems pretty straight forward, but I feel stuck. Can anyone please
help me to get on?

Thanks in advance!

解决方案

"StenKoll" <re****@asly.net> wrote in message
news:6d**************************@posting.google.c om...

Hi! I am fairly new to access and not very familiar with vba
programming. I am trying to setting up a database of shareholders in a
company. So far I have managed to build tables containing owner data,
data for the shares and a form where I register how many shares each
owner owns.

Now to the difficult(?) issue. I need to set a number for the shares
so I can make an ownership report showing wich sharenumbers people
owns. I have thougt about making a new table where I include a sorted
column for the Id for new issues of shares and a column number of
stocks for each owner in each new issue. Then I plan to have a
seperate column summing up the number of stocks in ownership column,
and finally a column which gives me a from - to value, symbolising the
unique sharenumbers for each owner in each new issue of shares..

It seems pretty straight forward, but I feel stuck. Can anyone please
help me to get on?

Thanks in advance!

You will get better help if you show the desgn of your tables, including (in
particular) the primary key of each table.

Here is an example format:

tblShareholder
SharholderID (primary key)
Name, address etc.

I''m not being picky! It is difficult to make any sensible comments about a
table design problem, unless we know >what< tables you are trying to use;
and in particular, what you say is the primary key of each table.

HTH,
TC
"StenKoll" <re****@asly.net> wrote in message
news:6d**************************@posting.google.c om...

Hi! I am fairly new to access and not very familiar with vba
programming. I am trying to setting up a database of shareholders in a
company. So far I have managed to build tables containing owner data,
data for the shares and a form where I register how many shares each
owner owns.

Now to the difficult(?) issue. I need to set a number for the shares
so I can make an ownership report showing wich sharenumbers people
owns. I have thougt about making a new table where I include a sorted
column for the Id for new issues of shares and a column number of
stocks for each owner in each new issue. Then I plan to have a
seperate column summing up the number of stocks in ownership column,
and finally a column which gives me a from - to value, symbolising the
unique sharenumbers for each owner in each new issue of shares..

It seems pretty straight forward, but I feel stuck. Can anyone please
help me to get on?

Thanks in advance!

You''re right! You''re not being picky and I will take a deep breath and
rephrase myself?.. :-)

Here we go:
tbl Name:
Name_ID (Primary key)
Firstname
Lastname

tbl New_Issues_Shares
Issue_ID (Primary key)
Date
Number_of_shares (for each new issue)

tbl Number_of_shares
Transaction_Counter
Name_ID
Issue_ID
Number_of_Shares

Through a query I have been able to have a running sum of all shares
listed in order by using a transactioncounter. My problem now is how
to number the individual shares so that transaction 1 shows shares
from 1-500, transaction 2 from 500 to 600, transaction 3 from 600 to
800 and so on.
The reason why I want it this way is to be able to issue individual
certificates showing which shares each individual owns.

After having re-read my previous post I realize that it was hard to
help by the information given, but I have made it easier for people to
help me now?

Thanks,
StenKoll

"TC" <a@b.c.d> wrote in message news:<1070078342.982907@teuthos>...

You will get better help if you show the desgn of your tables, including (in
particular) the primary key of each table.

Here is an example format:

tblShareholder
SharholderID (primary key)
Name, address etc.

I''m not being picky! It is difficult to make any sensible comments about a
table design problem, unless we know >what< tables you are trying to use;
and in particular, what you say is the primary key of each table.

HTH,
TC
"StenKoll" <re****@nospamasly.net> wrote in message
news:6d**************************@posting.google.c om...

Hi! I am fairly new to access and not very familiar with vba
programming. I am trying to setting up a database of shareholders in a
company. So far I have managed to build tables containing owner data,
data for the shares and a form where I register how many shares each
owner owns.

Now to the difficult(?) issue. I need to set a number for the shares
so I can make an ownership report showing wich sharenumbers people
owns. I have thougt about making a new table where I include a sorted
column for the Id for new issues of shares and a column number of
stocks for each owner in each new issue. Then I plan to have a
seperate column summing up the number of stocks in ownership column,
and finally a column which gives me a from - to value, symbolising the
unique sharenumbers for each owner in each new issue of shares..

It seems pretty straight forward, but I feel stuck. Can anyone please
help me to get on?

Thanks in advance!

这篇关于初学者问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！