Search results

Try; Me.Refresh or Me.Requery Or Me.Refresh Me.Requery [This message has been edited by Ron Bell (edited 08-13-2000).]

Hi "CheryIF" Thanks for your clear reply - much appreciated. I'm wondering if users may be able to set number of labels required. This may be achieved (I'm working on this one) via say:- Reset report to a single ID. create a new table just for 'numbers of' report/labels, with required fields...

Hi "Sydney" Providing I understand yr requirements - this should work You have to add a Combo or List box (both will work) to add the operator "+" or "-" between yr two text boxes. (I cant see a way round this because "+" or "-" cannot be converted to numbers) So: You end up with: a...

The solution to this problem: First - delete Controlsource of 1st combo, if it has one. You could then display any record relating to the ControlSource of this field via another added textbox. So yr 1st Combo then becomes only related to yr 2nd Combo, and does nothing else but, with code...

Hope your not confused by my "on the cuff" replies - so just to make things clearer Note a RecordsetClone is a vertual copy of your Forms recordsource - at that time Your code at start should read: _________________ Private Sub Form_Current() If Material <> "" Then 'You may get...

I'm interested in this!! But- CheryIF: Please explain further your last sentence of posted 07/28/200 08:28 Where are you entering this ID number for number of labels required? I can't find this option in the Access2000 Wizard, ie "number of labels per event"

Sorry Elise_L Made a mistake in above Line:variable = Forms![X].RecordsetClone.MoveLast.RecordCount , IS WRONG!! Replace with: these- Forms![X].RecordsetClone.MoveLast variable = Forms![X].RecordsetClone.RecordCount

The way I do it : In your table: use OLE datatype to insert your pic into relevant field, - this I presume you have done already?. Then with your report, just use following with ControlSource - =DLookUp("[OLE picfield name]","tablename","[ID of row in table]=Report![ID of row on report]")

Help required to minimize a report (myreportname) without minimizing Word at same time in OutputTo. I wish ideally: when Previewing a report ( this seems necessary because of Filter requirements) to then minimize that report (temp) then close it after Word has opened with result of OutputTo...

As a pointer to this problem: EOF is a function and requires an argument ie EOF(indexnumber) So if you use EOF without an argument you will get error = argument not optional Look in Access or VB help on EOF function .EOF (note the dot) is a property of of a recordset if nothing is defined...

Heres another idea I entered this into project two years ago - works but would appreciate reply if any errors found as it does'nt perform ideally all the time - maybe becouse of my tables set up Try in yr bound fields After_Update event: Forms![x].RecordsetClone.MoveFirst Do Until...

Try this if you've not already: Find your Forms 'After update', event procedure and enter: msgbox "your msg",48,"I've entered something" after new record entered and you go to next record this msg will appear this will also appear if you amend any record on form so maybe not as required you...

If you are sending the function X as a parameter, literally [X], then this is the problem try =getnumbersFromMemo([X]) and replace X with the name of the field you wish to search with the function. Usually #Name means access doesnt cannot find the field name entered as a control source. The...