Recent content by mcsheff

When I go to look at any of the even procedures for the form. eg on click it asks me for a password :( Dont see how theres much I can do there. The guy who wrote it obviously didnt want anyone else changing it I guess. Right I just managed to get in the form. I can move stuff around etc...

I am trying to edit a database application. The forms need updating with new layout/info etc. The database is password protected. I have managed to get hold of the password for admin so I can log on. I then say yes to enable startup keys, close the dbase and reopen with shift held down...

finally sorted it out :D Thanks mile and others for your help. I think I might have actually learnt something this week :p Cheers

err nope :p Im stuck here trying to do about 10 things at once and people keep giving me more work to do :eek: Could u post the ammended version pls :p Dont worry if not I could prob figure it out (If I actually get 2 mins to think :p ) Hmmm getting end with without with error. But I can see...

Thanks mate you been a great help :)

Thanks for your help people :) After a fair bit of head scratching and trial and error I finally got it work. I now have a form where books can be returned. On the click of the return button I want the database to using the key bookID remove the related record from the loan table. I was...

Thanks for your help people :) After a fair bit of head scratching and trial and error I finally got it work. I now have a form where books can be returned. On the click of the return button I want the database to using the key bookID remove the related record from the loan table. I was...

yeah I noticed on the confusion front :p ill try and sort it :) Also the only relationships I have are: "BookID" in the "books" table is related to the BookID in "Loan" table. "UserID" in the "loan" table is related to the "userID" in the "users" table. So I dont see what can be...

so the me.BookID is the name of the text box from where I want to get the data yeah? But Im still getting funny error about the "users" table, even though thats not been used anywhere :confused:

heres my edited version of the code: Private Sub Borrow_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = CurrentProject.Connection Set rs = New ADODB.Recordset rs.Open "Loan",table I want to enter data in cn, adOpenDynamic, adLockOptimistic...

eeep :p Ok mate ill have a look at that and try and figure it out :) Sorry about my lack of access knowledge :p I havent touched it since uni and now suddenly Im expected to remember what I did! Cheers again for your help. (im sure ill be back posting in a mo :p )

Ahhh now I see what u mean ;) ill stick with my text boxes atm as I dont want to cause myself more problems :p Im using Access 2000 (on a darn 486 with a tiny monitor :p)

errr I dont have a combo box? Do you mean I need to put one on?? All I have atm is text boxes and labels and a search function. once the user has found the details they want. I want them to click a submit button which will send the current UserID ID to the loans table. This process I...

The loans table will contain: BookID (primary key) UserID as bookID is unique. (UserID may be repeated as a user can borrow many books) Cheers

Ive spoken to someone who says that I need to define some variables, and that I cant just pass the value on click to the other table. I think you can but as you can tell Im no expert :p Any help would be greatly appreciated as Im sat at work trying to look busy, although Im totally stuck...