Search results

Hi, yes this came to me last night. I dont know why I thought to use the query....must have drunk too much!

This always works for me; =[Forms]![MyParentForm]![MySubForm]![MyField]

I have a subform on my main form which I can access properties etc without error, but when I try to set the sourceobject property I get an error saying it can find the object '~sq_cfrmAction~sq_csubPlanetItems' My form is called frmAction The subform is called subPlanetItems The code that...

Hi, thanks for this, but struggling to make sense of it as it is in French! me no speako da lingo!

I have a form with 5 fields on it. I want the user to enter as many or as few parameters as they require to pull up their results from a query that will run when they click 'start search' Problem is this... How do I create the query so that if a parameter is or is not supplied? Example...

little girl takin a bath with her mum and asks "mummy what is that between your legs?" Mummy says shyly "erm that is my erm hedgehog love". "Oh" says the girl. "Grandma has one too doesn't she?" "Yes" says mummmy. "Yes, but hers has been run over!" says the little girl. "Erm what do you...

I always use unbound text boxes and use code to populate them once the user makes a selection from the combo box.

OK I seem to be able to get this to work now...only taken me all morning but now I find another problem! No forms, linked tables queries etc replicate across?? I found this on this site dated june 2002, is this still the case? ----- In theory they can be replicated. However, in practice...

just found this code on this site; Dim repMaster As New JRO.Replica repMaster.ActiveConnection = currentproject.connection repMaster.Synchronize “C:\Path to replica”, jrSyncTypeImpExp, jrSyncModeDirect but does this not mean this runs from the master? I want the replica to check with the...

Hi, totally new to this concept? I intend to have a front end application on users desktops, the replica, and the master copy on our server. Do I understand it right that if a user opens their copy I could have it coded that it syncs with the master? I have looked at the help in Access2002...

Thanks for the code I will plumb this in and see how it works. The app in question is the ClickYes app to get rid of the security popups when accessing Outlook from Access. I want to open ClickYes when and email needs to be sent and then close it when finished with. Thnx

I know you can start an external application using the Shell command but is there a way to close this external application once you have finished with it?

Aha after searching through this forum I find that this is an annoying security MS thing! DOH! I have found a program called ClickYes but I am sure my employers don't want this on every users PC I guess I will have to ask the admin bods to see if they can set me up a template or something to...

Hi, I have created an app that accesses an Outlook object to create and send emails. The downside is the user keeps getting prompted saying an application is accessing their email. Is there a way from within the code to stop this message? I have been looking for ages with no luck! Thnx