Search results

Lol Yes!.. =] Im Well Chuffed First Database I Have Made LOL :rolleyes: Hope My Company Likes It Or They Can Just Get Somebody Experienced LOL Ha Im gonig to Go Back To College They Will Have Me Make A Presentation Of what I Did And I Am Going to Say.. I Cant Its Classified =] Ha Well Thanks...

Yep It Was In The Table.. :P didnt Have The Feild Called 'Title' How Silly =] Well Works Fine.. :D Now 40 Minutes Left Ill Start Um.. Adding In Records.. =] Yay :D Thanks For all your Lovely Help =] I Think i Will stay On This Forum Just Incase I Need Help With Access again =] 2 Weeks And I...

Hmm .. Its Just SQL9 for soem reason.. =P The Main One Too Be Percise lol Hmm Can You See Anything Wrong? Im gonig to check The Tables Just Incasr I Missed Something..

haha i lie.. :S Private Sub Form_AfterInsert() Dim SQL As String Dim SQL1 As String Dim SQL2 As String Dim SQL3 As String Dim SQL4 As String Dim SQL5 As String Dim SQL6 As String Dim SQL7 As String Dim SQL8 As String Dim SQL9 As String Dim SQL10 As...

Lol how stupid.. found out the problem.. :D SQL8 has been copied so it stops at that point so i dleeted SQL8 and works fine =] Woo lol :D

Hmm there must be a limit because i commented all of them off up too 9 and tested it didnt work.. then i commented off 9 and 10 and 1 2 3 4 5 6 7 and 8 and it worked.. so i thought it was 9 and 10.. so i un commented them all and commented 9 and 10 and it didnt work.. so i commented off 9, 10...

haha there must be something wrong.. Hmm cant find the error Grr thanks for the trouble shooting lol would have never thought of that.. =P Hmm Any Idea?? There Must Be A speeling Mistake somewhere Along The Lines hmm Lets Look And Find Out =] - Alan

Ahh good Idea =] commenting is // ?? yes i dont want to delete just incase =P

AHH 1 Hour And 30 Minutes.. Never Going To get This Done.. I Have Checked The Queiry's and Tables.. Capitals Spelling Everything.. Not Seeming To Work.. it Is As If The Pc Doesnt Want Me to Complete The Database.. :l =[ Poor Me 2 Weeks And Their Orginal Database Is Better Than Mine :| Grr Hmm...

ahh Ok Thanks I will check This Now =] Thanks For All The Help!! I Could Kiss You lol :D Next Part adding The 1000 Records.. :| Im Going to Waste Time and Just Add Like 10 =] :D Not My Fault If They Are Too Lazy.. =l - Alan

Ok Finally Got It too Work :D Half Past 1 Ha Oh Yes! Im Perfect Lol :D anyways still a little problem.. here is my coding.. Private Sub Form_AfterInsert() Dim SQL As String Dim SQL1 As String Dim SQL2 As String Dim SQL3 As String Dim SQL4 As String Dim SQL5 As String...

Ok figured It Out =] Dim SQL As String SQL = "INSERT INTO availability (ID, Title, Name, Surname) " & _ "VALUES ([ID].Value, [Title].Value, [Name].Value, [Surname].Value)" DoCmd.RunSQL SQL so there it is if you want to know what i was doing lol :D

Lol ha sorry i jsut read your post before i posted like 6.. hmm i can use quiery's but i dotn want to complicate what i have got and with only 3 hours left.. i dunno what im gunna do and to get the quiery's to work and input all the data will probablly take me longer than 3 hours.. so im...

im very sorry but as you can see i have till 4 too complete this task and im not startign from scratch.. yes it would have been more appropriate but i got 3hours and 45 minutes to finish the database... and do you really think i can do 2 weeks work in this time?? so im afraid i cant listen to...

Ok i have a database works fine just run into a little porblem.. In My VBA Coding i have made a SQL quiery the code is.. Private Sub Form_AfterInsert() DBEngine(0)(0).Execute "INSERT INTO availability (ID) " & _ " VALUES (" & Me.ID & ")", dbFailOnError '---------------------- Below Is The...

Ok So i have got Private Sub ID_AfterUpdate() DBEngine(0)(0).Execute "INSERT INTO availability (ID) " & _ " VALUES (" & Me.ID & ")", dbFailOnError End Sub i think this works because when i open form1 it does add the ID as 1 for that table.. but when adding more such as Private Sub...

I found some Help You Recently done And told somebody About Normalisation This would be a great idea ect.. but i have to much information and i have found this code CurrentDb.Execute "INSERT INTO tblAthens (ParticipantID) " & _ " VALUES (" & Me.ParticipantID & ")", dbFailOnError i and i have...

Ok ill give a breif discription.. im not saying its exact but post of it will be.. ok so i have a database that i need to have a form that enters data into table1 this data is all the details of people name address ect.. and i have ID's that tell the subform well pop up form who the person...

Hmm got another idea where i had Private Sub Form_Load() stID.Value = Form_Main.stID Title.Value = Form_Main.Title Surname.Value = Form_Main.Surname Name.Value = Form_Main.Name End Sub Well maybe i can make it so it doesnt get the code from teh form but the table for...

Oh My Lord.. Now i deleted record 1 from table 1 and 2 i cant get form2 to add the records.. lol.. GRRR messed this up completly =[ i hate databases lol anybody have another approtch? Really needa reply by tomorrow lol or i basicly fail what i ment to do for work experience lol.. oh joy =[