Recent content by liamfitz

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...

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...

That works perfectly Beetle. Thank you very much.

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...

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.

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

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 =...

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...

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...

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

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.

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...

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...

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

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