Search results

  1. L

    Combo Box won't show/list in report header

    I have done ( several times now ). Oddly, the small 'box' normally found at the right-hand side of the control, ( grey background with black arrow pointing down ), for displaying the list items is missing, and only 'flashes' temporarily into existence, when that part of the control is clicked...
  2. L

    Combo Box won't show/list in report header

    I have a combo box in the header area. The record source, Bound Column are set correctly ( I know because I tested it on a form ). In this instance, the user would select from the dropdown list, the name of a member of staff, based on the click-event, and passing the Staff_ID to a variable, this...
  3. L

    Before_Update event ( sub-form ) ?

    That works perfectly Beetle. Thank you very much.
  4. L

    Before_Update event ( sub-form ) ?

    I have a Cancel = True which triggers correctly, on a condition in the Before_Update event of a data field/control on a sub-form. However, the data which would have changed ( but won't now ) remains in the text box/control, and Focus stays on it. Only by closing and re-opening the form, can you...
  5. L

    Type Mismatch ?

    It's now working - Thanks ( it seemed it was only failing on a public computer, although I did check that I referenced the correct dll - which I had ?? ) Different version.
  6. L

    Type Mismatch ?

    I will check now ( I believe I have ). Thanks.
  7. L

    Type Mismatch ?

    Here is the full code. You should be able to follow the logic from this. Dim fso As Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") Dim flds As Folders Dim strText As String Dim i, pos As Integer Set flds =...
  8. L

    Type Mismatch ?

    The following command line, should return the sub-folders in the folder - path ( string ) 'folderstr'. The syntax and declarations for the variables seem fine. No errors, but I get 'Type Mismatch' on this line ... Set flds = fso.GetFolder(folderstr).SubFolders this should load the folder names...
  9. L

    Relative sizing of controls ( to screen size ) ?

    I'd like to set the width & height properties of my controls, in ( Pixels or twips ), rather than cms, so that they adjust proportionally according to the size/dimension of the screen, my form loads in. I know in the property sheet, you can only set the measurement in cms. However in vba, at...
  10. L

    Forms slow to open

    I don't have 'NAME AUTOCORRECT' under General in Tools/Options ?
  11. L

    Checking ( adjusting ) screen resolutions ?

    I have done ( and will check ). On a smaller screen though, it appears the controls are 'off centre' - maybe I mean I'd like all the controls to be positioned 'centrally and proportionally' to the form being centred ? Thanks for advice.
  12. L

    Checking ( adjusting ) screen resolutions ?

    I have an API, which returns the values for the Screen resolution in use ( let's say 1360, 768 ) I hoped to use this in formulae, to ensure my forms were 'centred'. I wanted to use the width and height properties of the form in question to do so, but it appears ( in Access 2010 ) there is NO...
  13. L

    Slow Form load event

    I've got a DB, which has 3 forms ( all 'under' 3 navigation buttons/tabs ). The main form ( Client's form ) is set to show first, and currently has a recordsource of about 1350 records. I think the size of the recordsource, and the fact it 'loads' the other two forms all 'in one go', is slowing...
  14. L

    Using VBA to create new folder & transfer files ?

    Problem solved. Just changed code a bit - works a treat. Thanks.
  15. L

    Using VBA to create new folder & transfer files ?

    The following code , SHOULD create a new folder, and then transfer ALL files in the old folder to the new one ... Do While fdr <> "" tempStr = fdr If tempStr <> "" Then OldPathName = strRootFolder & rst!Forename & "_" & rst!Surname & "_" & theDOB &...
  16. L

    Update CURRENT ( most recent ) record

    Thanks to all contributors. Using the If Me.Dirty = True Then Me.Dirty = False, in the relevant Control's ( Referral_Date ) Dirty event, it works a treat. Thanks.
  17. L

    Memo field issue ( overwriting ) ?

    I have a memo field, which I write to with a string ( this is a list of files and their pathways/locations ). The idea is that if the 'target' folder's contents change, this/these change(s) are reflected in my memo field. So I 'read' the contents of the relevant folder every time the form loads...
  18. L

    Update CURRENT ( most recent ) record

    Error 'This action was cancelled by an associated object' ( putting the code in the BeforeUpdate event )
  19. L

    Update CURRENT ( most recent ) record

    The following code SHOULD update, the most recently created record in a recordset ( of a subfrom ) It doesn't, it 'skips' to the wrong record and changes that .. Set frm = Forms!FrmNavigationLeft!NavigationSubform.Form!NavigationSubform!sfrmReferrals.Form frm.Requery With...
  20. L

    'Bookmarking' recordsets ?

    I see it's not entirely clear beetle. Apologies. I am using Client details from Parent FORM, to create a concatenated string value ( Referral_ID ). The issue is when I create a new record in the subform, it 'skips' to another 'existing record in the subform/recordset and changes THAT data (...
Top Bottom