• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by liamfitz

  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 &...
Top Bottom