• 全部
  • 问答

access中vba的小问题

djwinter 2006-04-25 08:07:14
帮一个美女完成一个access数据库的作业时候,遇到了一个地方我认为要用vba的地方,但是完全不会,不知哪位大侠能够帮忙.
请联系djwinter2000@msn.com
在线等待,多谢了

在这里描述不清楚,而且也不能上载文件:(
...全文
76 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
djwinter 2006-04-25
http://access911.net/csdn/FileDescription.asp?mdb=2006-4-25&id=32

要求如下:
e) Write a query that will calculate the club’s profit or loss from when they started buying shares. You can implement this in SQL or in QBE. Explain how it works in your write up and include a print out of the results.
f) Write a query or VBA code that will reduce holdings in a certain company by a certain percentage which happens when the club decides to sell a number of shares. This query should NOT alter the bank balance (that happens when the club actually get the money from the broker). You may assume that the club always gets the current share price.
g) Write a query or VBA code that will allow the club to examine what will happen to their bank balance if they sell all or part of some of their shares. They will enter something like “BT” and 50% and the database will output how much money they will make from selling 50% of their shares in BT, and tell them their new bank balance. This query could be made more advanced by allowing the club to enter more than one share at a time such as: “BT”, 50%, “EasyJet”, 30%, etc. You may assume that the club always gets the current share price. You may or may not wish to take the brokers fees into account. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
h) Write a query or VBA code that will calculate how much each member would get if the club was dissolved i.e. the amount in the bank, plus the money that would be raised by selling all shares, divided by the number of members in the group. You may assume that the club always gets the current share price. You should produce a report formatted in a suitable way that details this information, along with how much the broker would be paid. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
i) Add additional queries/reports as you think useful.
j) Write a description and/or pseudo code of an algorithm that will give the club a buy / don’t buy / sell / hold decision for each of the shares that are have been identified as being of interest to the group. (This is historically a very tricky problem and there
回复
djwinter 2006-04-25
http://access911.net/csdn/FileDescription.asp?mdb=2006-4-25&id=32

要求如下:
e) Write a query that will calculate the club’s profit or loss from when they started buying shares. You can implement this in SQL or in QBE. Explain how it works in your write up and include a print out of the results.
f) Write a query or VBA code that will reduce holdings in a certain company by a certain percentage which happens when the club decides to sell a number of shares. This query should NOT alter the bank balance (that happens when the club actually get the money from the broker). You may assume that the club always gets the current share price.
g) Write a query or VBA code that will allow the club to examine what will happen to their bank balance if they sell all or part of some of their shares. They will enter something like “BT” and 50% and the database will output how much money they will make from selling 50% of their shares in BT, and tell them their new bank balance. This query could be made more advanced by allowing the club to enter more than one share at a time such as: “BT”, 50%, “EasyJet”, 30%, etc. You may assume that the club always gets the current share price. You may or may not wish to take the brokers fees into account. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
h) Write a query or VBA code that will calculate how much each member would get if the club was dissolved i.e. the amount in the bank, plus the money that would be raised by selling all shares, divided by the number of members in the group. You may assume that the club always gets the current share price. You should produce a report formatted in a suitable way that details this information, along with how much the broker would be paid. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
i) Add additional queries/reports as you think useful.
j) Write a description and/or pseudo code of an algorithm that will give the club a buy / don’t buy / sell / hold decision for each of the shares that are have been identified as being of interest to the group. (This is historically a very tricky problem and there
回复
OracleRoob 2006-04-25
上传到:
http://www.access911.net/csdn/
回复
相关推荐
access中VBA操作记录
怎样通过VBA代码来操作记录
access vba数据库开发
介绍详细,可以直接用于开发vbaaccess应用。
access 2007 VBA宝典
本书全面介绍了Access VBA的应用。首先介绍各种Office组件及其用途,然后详细介绍了这些组件,以及如何在组件之间共享各种数据;最后介绍了更为高级的主题...适合Office的高级用户以及希望学习Access VBA的人员参考。
例学VBA:EXCEL/ACCESS/POWERPOINTVBA高效应用2010.pdf
例学VBA:Excel·Access·PowerPointVBA高效应用》主要介绍基于Microsoft Office的VBA应用程序开发。全书分为4篇:第1篇包括第0章,主要介绍与Office VBA编程相关的基础知识;第2篇包括实例1~实例20,主要通过20...
access VBA-2
access VBA程序设计PPT
Access VBA数据库高效开发范例应用
Access VBA数据库高效开发范例应用,欢迎下载,11111111111111
access VBA-1
Access VBA 程序设计··
Access2000 VBA 一册通(高清中文PDF)
《中文版Access 2000 VBA一册通》主要介绍Microsoft Access 2000 VBA(Visual Basic for Applications)的使用方法和操作技巧。使用VBA可以方便地操作Access 2000,深入开发Access 2000的强大功能。《中文版Access ...
Access VBA活用范例大辞典源文件
Access VBA活用范例大辞典范例源文件,原光盘拷坝打包提供下载。
Access VBA活用范例手册/左荣欣主编 代码
本书侧重于Access的基础应用技巧, 共11章, 分为四大部分: 第一部分为第1-4章, 着重介绍Access VBA的基础操作技巧 ; 第二部分为第5-8章, 着重介绍对数据库数据的处理技巧 ; 第三部分为第9-10章, 着重介绍通过VBA...
Access VBA活用范例大辞典(文字版)
AccessVBA的代码集。文件为iso镜像,内含文字电子版和随书实例。
access VBA付费视频免费下载
本人花钱买的几百块。现在贡献出来,当然是有代价的,所以我设置了分值,文件虽,但那是下载地址,因为容量太大(几个G),根本不可能上传的。喜欢编程开发的朋友可以下载看看,非诚勿扰!
Access 2003 VBA Programmer’s Reference
Access 2003 VBA 开发必备
Access 2007 VBA 宝典
献给所有对技术抱有好奇心和热情的软件工程师们
Excel VBA与数据库Access整合笔记
Excel VBA与数据库Access整合笔记,Visual Basic 的应用程序版(VBA)是Microsoft 公司长期追求的目标,使可编程应用软件得到完美的实现,它作为一种通用的宏语言可被所有的Microsoft 可编程应用软件所共享。
VBA+Access事务与查询
VBA+Access事务与查询,实际代码
[V版]Access VBA活用范例大辞典
Access VBA活用范例大辞典,活学活用里面的范例,可以有效的学习Access
ACCESS_VBA
按特殊名在VBA中设置控件的可见性: 2 指定一个控件能否接受焦点 3 指定一个控件能否被编辑: 3 设置控件标题显示的文字 3 设置标签颜色: 3 获得焦点及失去焦点时字段变更颜色。 3 使标签闪烁以引人注意 4 设置标签...
VBA编程在ACCESS数据库存取图片文件.txt
刚才写得很详细,结果提交失败。现在简单写一下。 一、窗体建立 1、用向导从有“ID、图片、图片说明”字段的空数据表“图片资料”建立 2、窗体设立3个命令按钮、一个标签、2个Image...在ACCESS2003运行测试通过。
例学VBA:EXCEL ACCESS POWERPOINTVBA高效应用
扫描完整版 例学VBA:EXCEL ACCESS POWERPOINTVBA高效应用
Access2007 VBA宝典
Access2007 VBA宝典,主要介绍Access 2007 的VBA开发
VBA.Callback:Microsoft Access中的回调函数-源码
Microsoft Access VBA中的回调函数 版本1.2.0 (c)Gustav Brock,仙人掌数据ApS,CPH Microsoft Access鲜为人知的功能 回调函数是Microsoft Access中的隐藏元素。 有了这些,您就可以完全从代码中动态填充组合框或...
ACCESS VBA 活用 范例手册 6-11章
ACCESS VBA 活用范例手册 全范例学习 ACCESS VBA 零基础自学手册
access vba 手册.mdb
access vba 手册.mdb,将其整理到一个文件里,可以索引查询,是编写程序的好帮手,抓紧时间下载吧
access 使用 vba 遍历文件夹,批量导入目标表
文件夹导航图 (代码运行背景) Option Compare Database '------------------------------------------------------------------------------------------- ' 1、目的:批量导入表 ' 2、背景: ...
access VBA 数据库
access 开发经典教程,实例分析数据库开发步骤和主要注意点,ADO链接和操作
Office_Word_Excel_PPT_Access_VBA编程手册合集(CHM版)
手册包含VBA编程涉及的:对象、属性、方法、示例及相关的参考代码。 VbA_Office编程帮助手册(CHM版本).chm VBA_Excel编程帮助手册(CHM版本).chm VBA_Word编程帮助手册(CHM版本).chm VBA_PowerPoint编程帮助...
Access 2007 VBA宝典 2/4
Access是Microsoft公司Office办公套件的数据库应用程序,而Access VBAAccess的编程语言。利用VBA不仅能够设计常用的工具、软件,还能够编写代码,让很多程序共享数据。本书全面介绍了Access VBA的应用。首先...
EXCEL WORD ACCESS VBA帮助文件 CHM
EXCEL WORD ACCESS VBA帮助文件 CHM
access-VBA编程
access中vba编程指南,包含窗体、控件等,适合初学者参考
发帖
Access
创建于2007-09-28

7498

社区成员

Microsoft Office Access是由微软发布的关系数据库管理系统。它结合了 MicrosoftJet Database Engine 和 图形用户界面两项特点。
申请成为版主
帖子事件
创建了帖子
2006-04-25 08:07
社区公告
暂无公告