Recent content by nrjhano

I am attempting to use "DoCmd.DeleteObject acForm, "Form1"" to erase a temporary form that I partially design from VBA code based on a template. I get the message that this cannot be done while the database is open. How can I get arround this problem? I use "copy&quot...

I have defined an object that calls and generates a form. On the form I have save button that should save all information entered into the form and then close the form. The save button is preloaded onclick from my object: btnCmdButton.OnClick = "=RemoveCondFormOnclickV(""" &...

I use QueryDefs to retreive an address table from backend. To avoid time delays I reconstruct a table with the same contents in frontend and then change the content of a linked table when there is a need to refresh addresses in my frontend. This works fine. However, I would like to change the...

Tanks lameid. Eval is a terrific function. Only one thing, it doesn´t seem to like Recordset and TableDef. Also, one string variable that contained "C:\nnnn" was misinterpreted. Well, I suppose eval is an overloaded function that works on string contents in some mysterious fashion so...

Your answer is a straightforward solution and gave me a reason to formulate myself more precisely. Your suggestion means that I have to edit the called function each time I call it with a new function. I would like to avoid that complication. In one exellent document from the microsoft site I...

I have spent some time to search for techtips for this problem and on microsoft´s site but in vain. I would like to pass a function() or procedure() call as an argument to another function() or procedure(). The most obvious thing is to send it as a string, however, when I assign this string to...

There is an ongoing discussion where I was suggested to run queries like a stored procedure in the back-end. Search on my handle and you can take part. It can be done and as you will see the remaining question is to organise update of queries in a multi-user back-end environment, (:I. The...

Thanks Quehay and MichaelRed for very enlightening contributions. I sense that you both are covering a lot of ground related to performance. Yes Quehay, after some thinking and initial work I realized that you are right. After a second thought I realised that 3 query-tables I use to drive...

I sorry for the delay of my response to MichaelRed. After some search of msdn online library I found following code written in DAO that seems to do the job, :-): Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim fld As DAO.Field ' Open the database...

Thanks Quehay and Omega36 for your responses. Maybe I begin to understand some aspects of the situation. Basically, in order for the Query to run on a remote machine a demon of a sort is required (as in unix). I understand this is the background for: "How do you run them from the front...

I am reviewing posts in order to improve performance. A question to MichaelRed (Programmer) Oct 13, 2000: I moved my query to the BackEnd/server as you suggested but linking seems to be allowed on tables only. Am I missing the point :-I ? Another question to Sera, Oct 13, 2000: Can you...

Solved the problem by converting makro into visual basic which allows inclusion of addresses. Hakan

While tuning my database with Tool-Analyze-Performance I got a good search string: "Convert macros to Visual Basic", sic! Response time over the network went down from 30-90 seconds to below 15sec after converting the worst macro's into compiled visual basic. So, a little bit more...

My database describes a flow from different perspectives of time. By changing Recordsource I can address a corresponding query using only one form. However, update can only be done for a set of records owned by each perspecrive. Longer perspectives must be generated with record source set to...

Due to early bad choice of mostly bounded design I have been forced to top-off my design by setting RecordSources and controlsources. An effect of recursive use of a form (works fine by the way). Next time I will do the complete recursion in program. Is there a way to perform these operations...