Search results

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!

I was under the impression that i joined a new workgroup but now i cant find the default workgroup - obviously i'm in trouble - guess i'll have to delete everything the wizard created and start all over - great! :mad:

i used the user level security wizard with an access project but i want it to be solely for this project - however it seems that any access project requires the password from the workgroup i created - how do i get rid of this?

Cheers!

Using the user level security wizard, is it possible to send the name of the user to the main switchboard? or is it possible to manipulate the information entered in the log-on screen?