Search results

Apologies, I didn't copy in the function ... der, sorry.

This looks like, just what I'm after, but what I've tried ( adapted for my control name ) is not working. Here's my code. Any help appreciated. .Text = Left(strComments, l) & ")" pfPositionCursor Me.txtOutcomes, Len(Me.txtOutcomes & "")

Point taken. So far so good.

Thanks pat. I take your point. I probably didn't explain it properly. I only need teh combo to show/change a particular field ( of set values, entirely based on a single table ) which forms part of the recordset, which displays in my subform. It's now working as it should. Thank you.

The following line of code ( partial ) is producing an error asking for a 'valid' pathway frmNavigationLeft.NavigationSubForm>frmNavigationTop.NavigationSubForm It was working fine, and I 've not changed a single character ?? Any ideas ?:banghead:

Thank you. It appears to be working now. It did seem to be adding the selection to the next ( last record )simultaneously as well, but that's fine now.

Thanks again Pat. I'm working on it now.

I'd like to use a combo box on a datasheet view subform. it's not working as I hoped. I'd like to set the control source property, to a field in the subform's recordset ( displaying like a text box ), but also use it as a combo to change/add new records. Any tips ?:(

Thank you Pat, that's very informative. What is/are CRUD and BE ?

The following message appears, when more than one user tries to access my DB ( Access 2010 ), which is on a common drive to all users ( P:) The database has been placed in a state by user 'Admin' on machine 'VISTAJJ' that prevents it from being open or locked Thank you in advance. :confused:

I've worked it out. The trick is, in when to use literal names, and when to use generic i.e NavigationSubForm would be generic whereas frmClients is literal. Thank you for all help.

I must have tried every permutation, so it's probably something simple, but please .... how do I open programatically a tab in Nav. Form ? I have a Nav Form ( say, name = frmNav1 ) holding another ( say Nav2 ) on one of the tabs ( ON Nav2 ) a form called sfrmReferrals ( a user designed form -...

Sorry, but it still doesn't work. Should it be in the Load event of The 1st (top) level Navigation Form ( frmNavigationLeft ). The main/first Form is frmNavigationLeft. This has two tabs ( on the left ! ), one of which is selected by default, this tab contains a 'subform' Navigation Form with 3...

I'm trying to use the following to open to a particular NavButton ( on Navigation Form ) in VBA DoCmd.BrowseTo acBrowseToForm, "frmActiveReferrals", "NavigationForm.NavigationSubForm" The problem is in the last parameter i.e. Form 'path'. can anyone assist ? My form names are frmReferrals...

Most kind sir. I'm grateful.

I can't get mine to work, using the same logic/hieracrchy. I note you put your objects in square brackets []. Are you using these lines of 'code' in the control source of objects, or actually writing VBA code using this syntax ? Thanks.

I have a word document which I open using :- wdApp.Documents.Open strFileName Where 'strFilename' is the path to the file in question. It opens Word, and the correct file, BUT ONLY as a MINIMISED form i.e. in the bottm system tray/band. Does anyone know, how I get it to open as a maximised and...

It looks as though it may very well help. Many thanks. I'll try it at work tomorrow. I'm at least assured there is a way to do it ( as I thought there must be ). Having read it, it reads like a 'Control Source' for an object on 'another' form. I can write my VBA to cater for this, ( maybe put an...

I'm having the same trouble myself. Any advice much appreciated. Here is what my VBA reference would be, if I just went down through the 'hierachy' using full-stops to get to the form with the value/control I want... With...

With Access 2010's new 'Navigation Forms'- the usual hierarchical referencing of forms, does not work. For example, where one wishes to refer to a variable/control on a sub-form, NOT IN THESE FORMS, one might program as follows : With Forms!frmClients!sfrmReferrals.Form.NAMEOFVARIABLE/CONTROL...