Search results

ok got It to work.. :D The relations where Set up Wrong Ha Lol.. But I Have hit The Second Problem.. :S When adding a 2nd record and clicking the command button to open Form2.. it doesnt work.. it only works for the 1st record that i entered on Form1 How can i Make It Work So I Can Change...

Hmm.. in form2 i got onLoad() function Private Sub Form_Load() stID.Value = Form_Main.stID End Sub works fine and how i want it but.. it displays an error after closing the popup.. lol :S it says something about the relations.. so i took all relations off and it worked fine.. but...

and where you said why have i got the 2 tables for what well basiclly the records i will be adding.. oh my lord lol there around 1000 and i thought it will be easier to just update all the tables instead of going to each one seperatly.. and adding in the different (staff ID's) to the different...

oh i have around 50 odd tables lol.. :| not my idea but as im on work placement i had to update their database.. lol and i couldnt it was messy.. :S so i started again and just added the same tables just without the data.. and what i want is when i update table 1 it will update all the tables...

One To Many Relationship... and no the tables are not set up like this i had to use an example because of the classified work that i am doing lol so basicly i just want table1 too add a nw record from the form i have created so say i type staff Id as 1 it will update table1.. what i want is it...

Ok i have found out a way to do this and i am kinda hitting a problem.. lol sounds stupid but it is ha lol umm well i have gotten the vars to work so for example when the button to open a form is clicked i set it to opena form blah blah lol and i have aded the code dim sID as string sID =...

i have taken on your idea about VBA got abit confused what that ment then i realised lol yea hmm i have programmed in VB before so i am kind of fermiliar with the code as of such but im am just wondering how would i make it so on command click it would store Staff ID as a varable? im kinda...

Hmm Bit confused with what your getting at but what i am trying to do is say for example i got : --Table1-- Staff ID - Number Name - Text Surname - Text --Table2-- Staff ID - Number Availabile - yes/no and i have a form with say the table1 details and then a command button that opens a form...

I dont think it is possible but maybe if you get the form feild names for example in username the form feild name why be for example 'name' then you can make a table with all the appropraite feilds with the form names on paypal and umm.. dont know where to go from there maybe soem how making an...

I have Created A Thread Already In General But I Think I Might Have Posted It In The Wrong Area So Here Is The Link =] My Thread That I Need Help With... =]

I have encountered a problem... what it is i have a few tables with data and i have created a form and other forms that open in pop up which interact with the main form.. what i would like is that when i make a new record in table1 it makes a new record in say table 2, table 3, ect.. i am...