Click here to Skip to main content
15,888,733 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
Eddy Vluggen20-Sep-11 7:58
professionalEddy Vluggen20-Sep-11 7:58 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
QuickBooksDev20-Sep-11 9:42
QuickBooksDev20-Sep-11 9:42 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
Eddy Vluggen20-Sep-11 10:40
professionalEddy Vluggen20-Sep-11 10:40 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
QuickBooksDev21-Sep-11 3:32
QuickBooksDev21-Sep-11 3:32 
AnswerRe: VB.NET 2008 The type initializer for ... threw an exception Pin
Eddy Vluggen21-Sep-11 7:14
professionalEddy Vluggen21-Sep-11 7:14 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
QuickBooksDev23-Sep-11 1:45
QuickBooksDev23-Sep-11 1:45 
GeneralRe: VB.NET 2008 The type initializer for ... threw an exception Pin
Eddy Vluggen23-Sep-11 8:48
professionalEddy Vluggen23-Sep-11 8:48 
QuestionDatabase Design Fields Pin
Eyo118-Sep-11 23:24
Eyo118-Sep-11 23:24 
Dearest VB GuRus,



thanks for all your contributions. this time, I have a problem and I need your magnanimous assistance and contributions.

I have developed a a VB Cash-expense application and I am designing a Database using MS-Access to be used as back-end.



I am confused on which fields should BE in the following tables below.

Table1: Department (This table has all the departments that are eligible to receive cash and make purchases.)

Table2: Items (this table has all items that are purchasable by all the departments.)

Table3: Purchases (This table SHOULD record all purchases made by individual departments.)

Table4: ReceiveableCash (This table SHOULD record all receivable cash that comes into the organisation (NOT THE DEPARTMENT).

Table5: PayableCash (This table SHOULD record all financial expenses made to a particular department.)

Table6: Accounts (This table records all the currentBalance, accountName and the AccountCode of different accounts. Every financial transaction is through a particular account.)

Kindly help me on the design of the above tables.

I do not know which fields should be included in the respective tables.

But my conception is:

Department:

DeptID

DeptName

Items:

ItemID

ItemName

Purchases:

PurchaseID

ItemID

PurchaseDate

Amount

PayableCash:

PayID

DeptID

Amount

Date

ReceiveableCash:

ReceiveID

Amount

Date

Accounts:

AcctID

AcctName

CurrBal



I do not know what SHOULD constitutes these table above and I really need your kindest assistance in the design.

Moreover, I also need to know the how to construct an SQL SELECT statement that will retrieve all expenses made.



Thank you.



Eyo Honesty
AnswerRe: Database Design Fields Pin
Eddy Vluggen19-Sep-11 12:09
professionalEddy Vluggen19-Sep-11 12:09 
QuestionHow do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid17-Sep-11 23:17
kamakazy_kid17-Sep-11 23:17 
AnswerRe: How do I open a url in a custom VB.net tab control brower Pin
DaveAuld17-Sep-11 23:41
professionalDaveAuld17-Sep-11 23:41 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid18-Sep-11 1:28
kamakazy_kid18-Sep-11 1:28 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
DaveAuld18-Sep-11 1:35
professionalDaveAuld18-Sep-11 1:35 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid18-Sep-11 2:18
kamakazy_kid18-Sep-11 2:18 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
DaveAuld18-Sep-11 2:24
professionalDaveAuld18-Sep-11 2:24 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid18-Sep-11 4:59
kamakazy_kid18-Sep-11 4:59 
GeneralRe: How do I open a url in a custom VB.net tab control brower [modified] Pin
DaveAuld18-Sep-11 5:17
professionalDaveAuld18-Sep-11 5:17 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid18-Sep-11 16:14
kamakazy_kid18-Sep-11 16:14 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
DaveAuld18-Sep-11 19:28
professionalDaveAuld18-Sep-11 19:28 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid20-Sep-11 3:57
kamakazy_kid20-Sep-11 3:57 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid20-Sep-11 5:55
kamakazy_kid20-Sep-11 5:55 
GeneralRe: How do I open a url in a custom VB.net tab control brower Pin
kamakazy_kid22-Sep-11 3:11
kamakazy_kid22-Sep-11 3:11 
QuestionHow can i make movable Buttons? Pin
Enver Hoxha16-Sep-11 3:46
Enver Hoxha16-Sep-11 3:46 
AnswerRe: How can i make movable Buttons? Pin
MicroVirus16-Sep-11 4:49
MicroVirus16-Sep-11 4:49 
GeneralRe: How can i make movable Buttons? Pin
Lek Plepi18-Sep-11 20:54
Lek Plepi18-Sep-11 20:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.