Search results

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

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

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

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

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

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

I hoped the following code, would select and then edit/update, a particular record in my recordset. Maybe I have the theory/syntax wrong. Set rst = Me.RecordsetClone strCriteria = "[Referral_ID] = '" & Me.Recordset!Referral_ID & "'" rst.FindFirst strCriteria Me.Bookmark = rst.Bookmark If Not...

The following code is in the Load event of a form. It doesn't even execute the code, and the form doesn't open. If [Forms]![FrmNavigationLeft].[Form]![NavigationSubform].[Form]![NavigationSubform].[Form].[Name] = "frmClosures" Then rfnum =...

This is the closest I've come, to being able to check whether a particular 'Tab' ( or Navigation Button ) is selected on these types of Form - ( I say this because, it doesn't cause an error, but it also doesn't work ! ) If...

I am getting the following error 'Procedure declaration does not match description of event or procedure having same name', every time an event ( _Change ) fires, for a Tab control. It was working peerefctly weel and consistently, and I have not changed any code in it. There is also a Text Box...

Hello. I have a text box, linked to an Integer field in a table. I have set the output text box, to a Format of Percent. However, it multiplies up all the field values by 100, and adds decimal places after - before outputting them i.e. 42 becomes 4200.00% ! Any ideas as to why, thanks.

Hi. I'm dynamically populating a table I create, at a report Load event. ( The field values will be based on values taken/calculated from fields in 2 other existing tables ). The following code just places some test data into the 2 fields for now, to check the logic and functionality of my...

Does anyone know if I can create a temporary table, 'on the fly' on the Report_Load event, ( based on fields from two other tables ) and set this as the recordsource for a report. I'm toying with the idea of 'INSERT INTO'. Would this be appropriate, and would it work ? Thanks.

The following code is now not working ( whereas it was before ) It throws up no errors, and seems to run without a hitch. If Not (rst1.BOF And rst1.EOF) Then With rst1 .MoveLast .MoveFirst If .RecordCount = 1 Then...

I have a combo box which forms part of a subform. I can select and enter data, and update the underlying record fine. However, it is also bound to that field, and should show the value ( if one exists ) as would a text box. It doesn't. Any ideas ?

I have 3 combo boxes each of which work perfectly well ( showing data from 3 different tables ), on my form. However, when I split my DB into front-end and back-end, these boxes no longer show output, and although I can enter data into them, which updates the underlying tables, they do not show...

The following code throws up no errors, and should copy a file in location ( strpath ) to a different location ( strDest ) With wdApp .Documents.Open strPath .Documents(strPath).Activate strDest = "E:\New folder" & filnam .ActiveDocument.SaveAs Filename:=strDest...