Microsoft Access

[The_Real_PlodeZ]

Anyone very familiar with Microsoft Access or basic SQL commands?

I need some help on a database build.

We can speak on msn or in pm's, let me know if you're out there.

[Baxxor]

i go a database course but i aint pro at it, tell me what ya need and ill try to help you

edit:
i know some sql code and i do everything in acsess ^^

[festo]

Write it in here what u need help with ^_^

[evilwevel]

if i paid attention in SQL classes i would've been able to help you :lol:

i know the basics, but nothing too detailed since thats when i played peggle on my laptop.

[Chemical]

Whatya need?

[Baxxor]

ill quote what he wrote to me in pm :

It's real basic bro - I'm trying to get an input box on a form to run totals in another text box in the same form based on the input.

For example, people can type the number 1, 2, 3, 4, 5, 6 in the box and I need a sum of each number typed in other boxes.

so if they type 1 then 1 then 1 then 2 then 2 then 3, there will be a box of sums that says:

box 1 sum = 3
box 2 sum = 2
box 3 sum = 1

I suck at access. :P[/b]

dont know it myself, aint that far yet so :mellow:

[CroNe]

i'm pro.. only if you could explain it in dutch to me :P

my english isnt that advanced lol



off: [X-Trap]The game security module update has failed.[00010001;80004004]
some1 help me out plx
pm me

[Amano]

i go a database course but i aint pro at it, tell me what ya need and ill try to help you

edit:
i know some sql code and i do everything in acsess ^^[/b]

<strike>
oooohhh yeahhhhh
</strike>

if i paid attention in SQL classes i would&#39;ve been able to help you :lol:

i know the basics, but nothing too detailed since thats when i played peggle on my laptop.[/b]

oooohhh yeahhhhh

[Rampage]

Could help you but my access class was 1 year ago and dont remember shit xD
(Access = worst database program imo)

[festo]

ill quote what he wrote to me in pm :
dont know it myself, aint that far yet so :mellow:[/b]

i dont get the jist? Does he want the total of all inputs in a text box? Or what?

[Baxxor]

exampel:
If you put in the number 1 three times in the box the box with label "Number one&#39;s:" should show 3
I think he means that he wants the program to count how many numbers of a certain number should be shown in the box

[The_Real_PlodeZ]

exampel:
If you put in the number 1 three times in the box the box with label "Number one&#39;s:" should show 3
I think he means that he wants the program to count how many numbers of a certain number should be shown in the box[/b]

Yep, thats it

[festo]

PlodeZ wats ur db consist of tables/fields wise;

SELECT COUNT(*) as <output field name>"
FROM "table name"
WHERE "fieldname" "what u want to filter";

[The_Real_PlodeZ]

PlodeZ wats ur db consist of tables/fields wise;

SELECT COUNT(*) as <output field name>"
FROM "table name"
WHERE "fieldname" "what u want to filter";[/b]

I can get the data into my tables just fine, I just can&#39;t get the boxes to sum correctly.

Every time a user types a number 1-6 then "Enter" in a text box, I need to run a sum of each number they type in another text box.

So I have: input box and sum1-6 boxes.

When the form is closed, the data populates the corresponding fields in the table per the totals in the sum boxes.

Right now, my event procedure occurs on change, and I&#39;m running an if/then statement, something like

Begin Sub

aa = me.textsum1
bb = me.textsum2
cc = me.textsum3

If me.textinput.value = 1
then aa = aa+1
or
if me.text5.value = 2
then bb = bb+1

me.textinput = null

End Sub

Sorry for the rough idea, the db is on my work pc.

[festo]

add me on msn much easier :P