Recent content by plonker

I have the button to run the queries but what i was asking was help with changing the subform - i dont know how to link the command button to the subform

thanks neileg, Now is it possible to run both queries (current + past rentals) using the same subform? if i put the queries behind 2 buttons? Also i've used the code generated by the add new record wizard to create a new transaction yet i can only edit some of the fields? why is this? it's as...

i got the query working but now i have another problem - i have a rental form where i can view previous transactions and make new transactions - i've used a subform which contains the transaction details which is inside a form displaying member details - the problem now is that it is displaying...

the sub procedure should have been called Private Sub LastName_Exit(Cancel As Integer) I also tried it in the click event but that didnt work - please help

forgot to mention that i had that - i have a member rental table which stores the product id, member id, date out and date due - i then ran a query to see if the date due was null i.e the person had not returned it but the problem is with rental history - i have rentals which have been booked...

i have a specific problem and i'm wondering does anyone have any ideas on how i would approach this - i have tables for rentals, members and products - i want to implement a rental system from a rental form where i can check if a certain item is available to rent or not - the problem is then...

i have the user id as a separate field and it contains a number - the dlookup seemed to be returning the employee id rather than the name, which i was looking for - it turned out to be a syntax error...

:) that's one for the future anyway i got your message working but it returns the value not found when i made the change to my code i got an error in string in query expression '[First_Name] ='ST101' which is the employee id for the employee whose name i've selected in the combo? Got it -...

mile - it cant find the form main screen...i've checked the name in the vba property window and it refers to it as Form_Main Screen. Now i've referenced that and that doesnt work either - it throws a syntax error

strPassword = DLookup("[Password]", "tblEmployee", "[First_Name] = '" & Me.cboUserName & "'") still get an invalid use of null strPassword = DLookup("[Password]", "tblEmployee", "[First_Name] = " & Forms!Main_Screen!cboUserName) how do you reference the formname? my form's name is main...

i have a problem with DLookup: strPassword = DLookup("[Password]", "tblEmployee", "[First_Name] = cboUserName") i am trying to match the password entered in a textbox with that of the password in the database (First_Name) i get an error: invalid use of null

i have a query that looks to see if an item is available or not - my criteria is the date - if a product has an associated date due then it is not available - my problem is that the query returns all items, both those with a due date and those without one? i only want the available ones to...

i want to run a search for members (stored in the db) from a member form based on the member's surname. i found some vba code on this but it doesnt work - it says i have a label undefined and points to: GoTo LastName_Exit Private Sub cmdSearch_Click() GoTo LastName_Exit 'call sub...

Thanks for all your help - i think i'm messing with something a bit over my head - i'm having a look at the text file+will have a go anyway - the project i'm trying to use the security on is referenced on a separate drive to that of the systems workgroup - that makes a bit more complex....and i...

Yep, did that...claims i've modified it in the last hour!