Search results

or use a module level VBA to do sums via a recordset based on the query?

in query design tbl1 link 1-many to tbl2 add tbl2's linked id to design then criteria where = is null then y should have only in tbl1 those that are not in tbl2

I know what you mean - But this happens weather you copy any contol on a form - the button is a new object and seen as having unique set of events on form. To use same procudure on similiar buttons, without duplication of procedure in module of form, - create a procedure and call it from each...

there is a property in yr tables = "Allow zero length" which if set to Yes may result in problem being solved?? let me know

the code for this is: Form![mainform]![subformname].[Form]![controlname].Refresh (or requery or whatever) To refresh whole subform Form![mainform]![subformname].[Form].Refresh (or requery or whatever) [This message has been edited by Ron Bell (edited 05-08-2001).]

done by recordsets pse email for details or see help in access

hese start dates and end dates are being entered into the SQL of your query, so cannot be picked up by the textbox on report Try using on a new form for users to enter dates: two new text boxes - named eg "Date1" and "Date2" and then add to your macro: Between [Forms]![newform]![Date1] And...

Hi: Hope this helps using queries: create query;1 add Table1 and Table2, with unique ID; + [ Discharge_Time] and [Time_used] from the two tables create query2; add query1, and use unique ID, + this as other field:- Diff...

You must be a VB user? As far as I know textboxes in Access cannot be arrays: To run same proc. from same box Use VBA editor and add a named procedure. This will appear under 'General' for a module then you can call that procedure from any object (textbox) event

Hi MK Your FIND button has a Name property eg "x" On this form 'On open' event type:- "x"_Click eg:- buttonname_Click Thats it- However if you wish this to run even if the form has previously been opened, do same above, but using 'On_Activate' event So: Use 'On Open' event if ONLY if...

Hi jlkrk1 The problem you have may be related to the value of your combo being a number, not text Try #1 Delete that On_Close event from report then: - using On_Activate event of your FORM: enter: -- [Combo10] = 0 #2 Or use the On_Close event But your On_Close event should read:-...

This version uses late binding but I think the priciples are the same Public appAccess As Access.Application Set appAccess = CreateObject("Access.Application") With appAccess.Application .OpenCurrentDatabase ("root and filename of db") .Run "runreports"...

Hi To count tables in Access Create a VBA recordset named ie X for a table then X.Movelast variable = X.RecordCount Note : Should you wish to count both of yr tables together: create a Union Query in Access with both tables included, then Create a VBA recordset on that query = X...

Had this problem today!! Use x = Format("x","mm/dd/yy") then use x in yr SQL

Text boxes in Reports have property 'Running Sum' 'No' means you have no groups etc. Try in a group footer, 'Over Group' Try in a report footer 'Over All' [This message has been edited by Ron Bell (edited 09-12-2000).]

Reports text boxes have property 'Running Sum' No,Over Group, Over All Try Over Group if yr Sum is in Group footer Try Over All if on Report Footer

first question is why all pop-up? This may be yr problem - try normal view maximize Popups are to remain on top of all. Modal or not.

Have you tried Dlookup()??

Notes fm me if not solved: GC_Store is not the same as GC Store. Yr Name property has to be precise to use in VBA - pse check which your using? yr field 'Name' property is the ONLY one recognised by VBA - NOT the Controlsource property. This gives flexiblility if more than one control, with...

Hi : just to add some more - I've had this one: - found only way to resolve is to set via another control ie: In yr Title_Exit() Me![secondcontrol].setfocus ' anything on form Then in secondcontrols 'On Got Focus' event Me![firstcontrol].SetFocus 'off it goes, back to first control...