Search results

Sorry to keep posting... but I have just put in the operator 'AND' so the code now reads... DoCmd.OpenForm "Frm_Company", , , "CompanyRef = " & Me!ListCompany And "Forms!Frm_Company!SubFrm_Contacts", , , "ContactRef = " & Me.ListCompany.Column(1) However I am now getting an error for a 'Type...

:confused: I have now put in the following code: DoCmd.OpenForm "Frm_Company", , , "CompanyRef = " & Me!ListCompany & "Forms!Frm_Company!SubFrm_Contacts", , , "ContactRef = " & Me.ListCompany.Column(1) But am getting the following error: Run-time error '3075' Syntax error (missing operator)...

Thanks for the suggestion Larry; I understand the concept of putting the Contact Ref on the subform and have done so - I can tell the link is working as it does show the reference numbers for each contact as I scroll through the records... I am having problems with the line of code though...

Hello everyone :D Hoping someone can help... I currently have a filter in place so that when the user selects a prospect / client from the search box it opens up that prospect / client's details... I am wanting to take this one step further but keep getting stuck... It is posisble to have many...

Hello Thanks for your response; I like the idea and am just trying the first approach however it appears to be skipping straight over the error message and going straight to the 'else' statement... please could you clarify for me what exactly the '- 1 <=0' means so I can work out whats going on...

Hello All... wondered if anyone could give me some advice on the best way to do the following... (see attached db) Ref: Frm_Search I am trying to put an error message in place so that a user cannot click the OK button without first having either typed a company name in the text box...

Hello Everyone... Can anyone help me to understand why I have got an error in my Total Hours Box?? It is meant to be a total of the decimilsed daily totals (in the smaller boxes).... I have attached the db, if anyone can stop me from banging my head against the wall I will be more than...

I think I've got that bit sussed... I needed to change the control source of the tick box to the field 'completed' in the query. Seems to be letting me tick them individually now... just need to work on the query / filter side of things now. Keeps me busy :) Anyway, thank you so much for your...

Ok., so If you first open the Frm_Log In and choose 'Natalie' - it should take you to 'my diary actions', there are currently two or three set I think - this form runs from a query (Qry_Diary). If I were to use the check box on the left side (linked the the archive field in the table, which I...

This is fantastic advice, thank you so much, and I actually understand what you are advising which is also good, thank you for explaining it simply for me. I think I will be OK with the query side of things (she says.....) The only thing that now confuses me now is if I want to put a 'tick box'...

Yes, I can see the logic behind that... I have added an 'archive' field to my table - I have set this to a Yes/No field - would I be correct in assuming that it what you meant?? My only other question is how to set the query going - i.e. how do I set an actions 'status' to 1 / 0 from the form in...

Hello. I am hoping someone can give me some insight... I am still very new to all this. Quick Background... I am designing a Sales Contact Management System, the general idea being we can store information about any prospects / clients and set actions or reminders for things such as call backs...

Hello everyone! Quick background... I have been introduced to Access and VBA for the first time in January... have just been teaching myself via text books and internet. I have found this site to be very helpful and thought I would join. I appologise in advance for any newbie questions that...