Search results

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

Problem solved, thanks for your interest pr2-eugin. I used the Form.Name property/value, to test which of the NavigationSubForms is currently loaded/open. From this, dependent on the 'result', I can then determine the source of the field value, which is available, to utilise in my code. Happy...

Yes, I have tried setting a breakpoint, but as the Form_Load event now doesn't 'happen' AT ALL, it's not much use. I'm going to try loading the Form.Name value into a variable and check this is an available variable, which can then potentially be used for checking purposes. :confused:

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

I see your logic Beetle - good thinking. I'm looking into the 'best' solution now. Many thanks for your helpful suggestion.:)

That's most kind of you sir. Thank you.

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

Here's a good example. I am storing a value from a control (Referral_ID) on a 'sub-form' called sfrmReferrals, in a variable named 'r'. The sub-form ( sfrmReferrals ), is in turn a sub-form of a main form, which is 'on' a navigation form ( frmNavigationLeft). From this, you should be able to...

Thanks to all RESPONDENTS.

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.

Problem solved, thanks. I created a couple of recordsets, selecting the fields I want from the 2 tables in question. I then 'Recordset.Addnew' to the newly created table/recordset in a controlled loop, for each new record. Works perfectly.

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

Thank you pbaldy. I was just thinking that i.e. putting the table creation code in the load event ( especially as the values are likely to change often ), and then set the recordsource in the open event.

It might be a complex query, and I'd be better off creating a table. I want two columns of data, but one 'column' on the report would be made up of several fields. I want the count of each of those fields ( with a WHERE clause ) to be listed as if they are several values from one field. As you...

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

Aplogies it's working now ( I had left a back-slash off the destination path string .... ) the wonders of breakpoints in debugging, solved it. Thanks.