Search results

I have a very small form, which when it opens, I'd like to position precisely in relation to the main form. Is there some way of using properties, or VBA, to set screen coordinates or the like, to do so ? Thanks.

The following code, as you see, SHOULD store a Date field ( Referral_Date ) Data Type value in a variable 'dt'. However, I get the error message 'Invalid qualifier' on the last line ... Private Sub Referral_Date_AfterUpdate() Dim refid As String Dim dt As Date dt =...

Many thanks, vbaInet.

How do I open a form ( a msgbox style 'pop-up' would do - as long as it has the functionality of a form control ) on top of another form i.e without 'closing' the current form, an event associated with which, triggers the OpenForm command ? P.S. Can I change the size of a form so it only takes...

Many thanks again for your response ( clever - I take it you mean when it first creates the Form in 'Normal view', before setting Default view to datasheet ? ) I've worked out a 'better' way though - I created another Form in exactly the same way, but used my 'BASE' query instead of a TABLE (...

The new Subform is working as it should, BUT although I've set the default view to Datasheet it includes ALL the fields from the TABLE. I have to hide them in design view ( so it is clearly not 'adapting the Fields, to only those selected in my Query. In fact it ignores the query COMPLETELY. )...

Here's my code for sending e-mail (OUTLOOK) using ACCESS 2010. Public Function Email_Via_Outlook(varAddress, varSubject, varBody) DoCmd.SendObject , , , varAddress, , , varSubject, varBody, False End Function -------------------------------------- Call...

Thank you, that appears to have worked, up to and including, the 'drag & drop'. It didn't prompt me to link the fields ( I know there are properties which I'll try working on though... Parent/Child etc. ) Thanks again. Easy when you know how eh ?;)

Thank you very much, I'll try this on Monday, when I'm back at work.

When you say don't 'drag and drop', I woudn't know how to. Do you mean creat a new 'Main Form' based on a table ( query )

I'm running ACCESS 2010, and my subform does not look like the sub-form you use to illustrate your point ( if it did i.e. very much like the design view of a main form, I would have found these events/properties ) My sub form is a simple rectangle, with the name of the Query in the corner, that...

I take your point, but there are two things you should know (I'm wondering if the latter, is causing this difficulty ) Firstly, the actual control i.e the sub-form itself ( in my case it's named sfrmRefs, ONLY has two events assocaited with it in the properties sheet i.e 'On Enter' and 'On Exit'...

Thanks. I'll check it out ( on Main Form presumably ).

Here's the situation. I'd like to get soem derivative information from a field/cell, as soon as the user exits that cell, having entered ( in this case ) a date value. As this also automatically creates a new record ( i.e. generates an Auto_Number for the P.K. field ), I know it is the 'Current...

Will do. thanks.

I'm trying to formt a Date data type as follows Format(dt, ddmyy) This however returns, for example if dt = Today - 25/06/2012 I'd like to return just the numbers, without the '/' seperators, and two digits for year i.e (250612) ? Thanks if you can help.:confused:

The following code I was hoping, would write to another field in the newly created record, entered on sub-form, There are only 2 events listed, associated with the subform ( one being the 'Exit' used here ) The procedure doesn't run, as checked, by using 'Dim x' etc. to check. Private Sub...

Thank You. Do you mean by 'calculated', created at run-time in a variable ( and displayed ), but not actually written to the database, for a permanent record ?

Could I use this 'AfterUpdate' event to add/update records in my sub-form. Maybe I should explain... I have a subform, which shows related Client information. In this case, they are referral details ( i.e. Referral_ID, Referral_Date, Assessment_Date etc. ) of referrals relating to the current...

Is this right ? thanks.:o