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! 10 2093
"StenKoll" <re****@asly.ne t> wrote in message
news:6d******** *************** ***@posting.goo gle.com... 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.ne t> wrote in message
news:6d******** *************** ***@posting.goo gle.com... 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_Shar es
Issue_ID (Primary key)
Date
Number_of_share s (for each new issue)
tbl Number_of_share s
Transaction_Cou nter
Name_ID
Issue_ID
Number_of_Share s
Through a query I have been able to have a running sum of all shares
listed in order by using a transactioncoun ter. 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:<107007834 2.982907@teutho s>... 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****@nospama sly.net> wrote in message news:6d******** *************** ***@posting.goo gle.com... 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!
Ok. let's take an example.
- There is a person Fred Smith with Name_ID 111.
- There is a new issue of 10,000 shares on 1/1/2004 with Issue_ID 222.
- Fred Smith takes 3,000 of those shares in transaction number 444.
So in tblNumber_of_sh ares you have the following. (I've abbreviated the
names to ensure that they stay on one line):
Transaction Name_ID Issue_ID no_shares
444 111 222 3,000
And of course, that person might have taken other shares in different
transactions:
Transaction Name_ID Issue_ID no_shares
444 111 222 3,000
447 111 228 4,000
451 111 250 1,500
Correct?
Now I am not quite sure what you mean by: "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." Your table structure does
not allow for numbering of individual shares (as far as I can see). And I
don't see what you mean by "shares 1-500". In the above example, each
transaction (say 444) shows a >total number< of shares (3,000). There is no
sense in which those shares are individually numbered, is there?
perhaps explain your problem using the actual example above.
Cheers,
TC
"StenKoll" <re****@asly.ne t> wrote in message
news:6d******** *************** ***@posting.goo gle.com... 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_Shar es Issue_ID (Primary key) Date Number_of_share s (for each new issue)
tbl Number_of_share s Transaction_Cou nter Name_ID Issue_ID Number_of_Share s
Through a query I have been able to have a running sum of all shares listed in order by using a transactioncoun ter. 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:<107007834 2.982907@teutho s>... 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****@nospama sly.net> wrote in message news:6d******** *************** ***@posting.goo gle.com... 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!
Thank you for trying to understand TC, but actually there is a reason
why I want to find the shares' individual numbers. According to local
(Swedish-) law, a company is to issue certifictes for the shares
purchased in a company such as the one I am managing. The certificate
shall include the totalnumber of shares as well as their individual
numbers.
Therefore, Fred Smiths 3,000 shares in transaction number 444 might be
the shares with numbers from 100,001 to 103,000.
So when transaction 443 shows a total of shares being 100,000 and
transaction 445 shows total of shares being 103,001, I want a table
saying that Fred Smith owns stocks in the interval 100,001 to 103,000.
Is there a way this can be done, or is manual input of sharenumbers
the only alternative?
Is there a way I can get my results in two columns giving From_Share
To_share?
Thanks again TC!
StenKoll "TC" <a@b.c.d> wrote in message news:<107025509 1.386049@teutho s>... Now I am not quite sure what you mean by: "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." Your table structure does not allow for numbering of individual shares (as far as I can see). And I don't see what you mean by "shares 1-500". In the above example, each transaction (say 444) shows a >total number< of shares (3,000). There is no sense in which those shares are individually numbered, is there?
perhaps explain your problem using the actual example above.
Cheers, TC
Sten, let's keep all the example details in each post. Otherwise I have to
search back for them on my newsserver. I have re-inserted them, so I can
refer to them here. Just add your reply to the top of this text (but retain
all the existing text).
If the shares must be individually numbered, you need to answer the
following question: Are all the shares in an issue (say issue 222), >always<
numbered in >strict sequence< (whatever, whatever + 1, whatever + 2, & so
on)? Or is there any case where the shares in an issue might not be numbered
in strict sequence?
If they are always numbered in strict sequence (and you can rely on that
being true, and remaining true, forever), I would do this:
tbl New_Issues_Shar es
Issue_ID (Primary key)
Date
Number_of_share s << DELETE
Start_Number << ADD
End_Number << ADD
Now you know the start & end share number for each issue. You need not save
the number of shares in the issue, because you can calculate that from
End_Number - Start_Number, whenever you need to.
Now you need to know >which< shares are allocated to each person. Again,
even if the shares >in the issue< were sequentially numbered, we need to
know whether the shares >from that issue< that are allocated in a
transaction, >are also sequential<. I'll assume they >are< sequential. (For
example, if an issue had shares 500, 501, 502, 503 ... 1000, and a person
was issued just 3 shares, he might be given 505, 506 & 507, but he would
never be given non-sequential numbers like 505, 507 & 508). On that
assumption:
tbl Number_of_share s
Transaction_Cou nter
Name_ID
Issue_ID
Number_of_Share s << DELETE
Start_Number << ADD
End_Number << ADD
Now you know which shares were allocated in each transaction.
Then, the following query weould list >all< shares that are currently held
by each person:
SELECT n.*,
s.Start_Number,
s.End_Number,
s.Transaction_C ounter,
s.Issue_ID
FROM tblName AS n,
tblNumber_of_sh ares AS s
WHERE s.Name_ID = n.Name_ID
ORDER BY n.Name_ID,
s.Start_Number
Does that help?
TC
"StenKoll" <re****@asly.ne t> wrote in message
news:6d******** *************** ***@posting.goo gle.com... Thank you for trying to understand TC, but actually there is a reason why I want to find the shares' individual numbers. According to local (Swedish-) law, a company is to issue certifictes for the shares purchased in a company such as the one I am managing. The certificate shall include the totalnumber of shares as well as their individual numbers.
Therefore, Fred Smiths 3,000 shares in transaction number 444 might be the shares with numbers from 100,001 to 103,000.
So when transaction 443 shows a total of shares being 100,000 and transaction 445 shows total of shares being 103,001, I want a table saying that Fred Smith owns stocks in the interval 100,001 to 103,000. Is there a way this can be done, or is manual input of sharenumbers the only alternative? Is there a way I can get my results in two columns giving From_Share To_share?
Thanks again TC!
StenKoll
"TC" <a@b.c.d> wrote in message news:<107025509 1.386049@teutho s>...
== added excised example details == Ok. let's take an example.
- There is a person Fred Smith with Name_ID 111. - There is a new issue of 10,000 shares on 1/1/2004 with Issue_ID 222. - Fred Smith takes 3,000 of those shares in transaction number 444.
So in tblNumber_of_sh ares you have the following. (I've abbreviated the names to ensure that they stay on one line): Transaction Name_ID Issue_ID no_shares 444 111 222 3,000
And of course, that person might have taken other shares in different transactions:
Transaction Name_ID Issue_ID no_shares 444 111 222 3,000 447 111 228 4,000 451 111 250 1,500
Correct?
======
Now I am not quite sure what you mean by: "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." Your table structure
does not allow for numbering of individual shares (as far as I can see). And
I don't see what you mean by "shares 1-500". In the above example, each transaction (say 444) shows a >total number< of shares (3,000). There is
no sense in which those shares are individually numbered, is there?
perhaps explain your problem using the actual example above.
Cheers, TC
== added more excised stuff ===
"StenKoll" <re****@asly.ne t> wrote in message
news:6d******** *************** ***@posting.goo gle.com... 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_Shar es Issue_ID (Primary key) Date Number_of_share s (for each new issue)
tbl Number_of_share s Transaction_Cou nter Name_ID Issue_ID Number_of_Share s
Through a query I have been able to have a running sum of all shares listed in order by using a transactioncoun ter. 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:<107007834 2.982907@teutho s>... 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****@nospama sly.net> wrote in message news:6d******** *************** ***@posting.goo gle.com... 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 is starting to look like the sollution I had a vague picture of in
the back of my head! ;-)
Since I am really a novice, would you care to explain in detail about
the << ADD and << DELETE you have mentioned in your latest response?
you are right in assuming that the shares are issued in strict order. as
for now, there are no one trading the shares, so I just have to keep
track of who has which shares.
Thanks again for helping me on track.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Hmmm- strange... I cannot see my own reply.
Well I'll try again. It looks like it is starting to make sense. You are
right in your assumption about the shares being in sequence, both in the
tblNew_Issue_Sh ares as well as tblNumber_of_sh ares.
What I don't understand now is what you mean by << ADD and << DELETE...
I'm a complete novice remember, so please be patient and take it s l o w
l y ;-)
Thanks for your time TC
Sten Koll
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I was suggesting to modify your table structures by adding the fields marked
<< ADD, and deleting the fields marked << DELETE :-)
Sten, I won't be able to help you any more, unless you start retaining the
text of the previous posts. Just hit the Reply To button on your newsreader,
and >add< your reply to the existing text of the previous posts. >Do not
delete< the text of the previous posts. That makes it just too hard to
follow the thread of conversation.
Cheers,
TC
"Sten Koll" <re****@asly.ne t> wrote in message
news:3f******** *************** @news.frii.net. .. It is starting to look like the sollution I had a vague picture of in the back of my head! ;-)
Since I am really a novice, would you care to explain in detail about the << ADD and << DELETE you have mentioned in your latest response?
you are right in assuming that the shares are issued in strict order. as for now, there are no one trading the shares, so I just have to keep track of who has which shares.
Thanks again for helping me on track. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Svens |
last post by:
Hey everyone! I'm a math student working on a short script involving
logs. I have a function on my scientific calculator, and was wondering
if there was a similar funtion in python.
For example:
(log65536)/(log4)= 8
I've searched around a bit and haven't been able to find anything.
|
by: jvax |
last post by:
Hi all,
I hope I'm posting in the right NG...
I have a data text file I want to read from a c++ program.
the data file goes like this:
90 # number of balls
33
42
13
|
by: Mike Malter |
last post by:
I am just starting to work with reflection and I want to create a log that saves relevant information if a method call fails so I
can call that method again later using reflection.
I am experimenting a bit with what I need to do this and have the following code snippet. But first if I pass the assembly name and
type to Activator.CreateInstance() it always fails. However if I walk my assembly and get a type value, the call to...
|
by: z_learning_tester |
last post by:
But I can't seem to find the answer.
The question is how do you reverse the words in a string?
Or how do you reverse the numbers listed in a string?
The example is usually something like:
Turn this string "1,2,3,4,..."
Into "...4,3,2,1"
This one seems hard enough let alone trying to turn a string of
space-seperated words around(is that even possible? a trick question
|
by: Blaze |
last post by:
I am doing the first walk through on the Visual Studio .Net walkthrough book
to learn a little about programming. I am having issues with the first
tutorial not running correctly. It seems that the build fails with what the
book tells me to do.
Specifically, I am doing this:
public authors1 GetAuthors()
{
authors1 authors = new Authors1();
| |
by: optimistx |
last post by:
As a beginner in javascript I had a question. I was reading FAQ and posts
here.
I became very unhappy: Obviously this group is mainly for wise, pedantic,
unkind etc people, who already know everything about javascript, and want
to prove that to everyone in a very harsh way?
Therefore, I skip the question, and we can go directly to the following
posts:
|
by: Roman Zeilinger |
last post by:
Hi
I have a beginner question concerning fscanf.
First I had a text file which just contained some
hex numbers:
0C100012
0C100012
....
|
by: a |
last post by:
Dear all vb.net developer
I want to know the time I need to master vb.net?
I'm beginner
|
by: Ben Keshet |
last post by:
I have a probably simple beginner's question -
I have a script that I am currently able to print its output. instead,
i want to write it into a file - I tried different versions of write()
but might have gotten the syntax wrong. the variable I want to write is
a line from a file I am reading:
"...
f = open('receptor.mol2', 'r')
line = f.readline()
|
by: roanhn |
last post by:
Hello.
I've to to write a master's thesis. Currently I deal with php, mysql, ajax.
Fate decreed that I've to choose one of this subjects:
1.gdi+ library in .net technology
2.ado.net technology in VS 2008.
I didn't have contact with Visual Studio, .NET. I only know some basics of c++.
My question is what subject of your point of view will be easier for absolute beginner in .net domain. From writing which subject I gain more knowledge...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |