Search results

Hello, First of all, Merry Christmas to everybody! I've faced with a problem, what currently I can't solve. I want to call stored procedure from an other database with some input parameters and want to store the result of the stored procedure in a variable. All this I want to do dynamically...

Actually this query could be on top of your original query, but it could be on the table directly also. In this case, you should extend it with some conditions, as they are in your original query. The second case is better from point of view of performance.

Hi, If I understand you right, you want something like this SELECT LName, FName, IIf([Parameter:]="C1",[C1],IIf([Parameter:]="C2",[C2],[C3])) as Course FROM YourQuery; This query will display always 3 columns, in the Course column's content will depend on the value you enter into the...

Since my last post, I realized one thing, regarding the query which provides the dates for the given years. When using it in other queries, sometimes the provided dates are not treated by Access as dates. That's why I modified it and with this the results are treated always as dates. The...

Well, I found the problem, actually it was me. :-) In the query which provides the dates for the year, I included the current year and the following one. That's why in the result I have all the dates for the current year and the following one and when I summarized the numbers for months, every...

What records do you mean? From the final result or from a sub-query?

Hello, I'm stuck a bit with the following problem and hope somebody will have an idea which might help. So, I have a table about flats. In the fields of the table, among others, there is a date field which represents the starting date of the flat availability. I'd like to create a query which...

FormulaArray problem - alternative solution Hello again, Although, I couldn't point out what is the problem, I found an other solution, which provides the same result and the problem, I mentioned, doesn't appear with it. Below is an example with both way. Public Sub test() Dim rngAll As...

Thx for the reply! I've already read a lot of about problems with FormulaArray in VBA, and tried all the mentioned solutions and workarounds, but non of them was solution to my problem. My formula size doesn't exceed the 255 char limitation and as I've mentioned it is syntactically correct. The...

Hello, I want to assign formula to a cell's FormulaArray property via VBA code.The formula is correct, but when I try to make the assignment, I receive the error message, "Unable to set FormulaArray property of the range class". The formula is stored in a string variable. When execution of the...

Dear Experts, I have to create an application in MS Access with MS SQL backend where users can log in with their actual windows credentials, in order to trace each user's activity on the server. Additionally, at login, the program have to provide the possibility to log in with different...

Hello, I am not exactly sure if it is the best place for my question, if not sorry! So, I have an MS SQL 2000 backend with Access 2003 frontend. Some forms' recordset is set in runtime by run a stored procedure on the backend and its result is the recordset. It works good and fast enough, my...

Hm, you are right Banana, I scrambled the things a little bit. In my previuous post under module I've meant a part of the application and not a VBA module. There is only one .mdb file and depended on the user logged in, the assigned part of the appliction will be started, that's what I called...

Well, I am developing an application for a productive plant. There are six modules used in the production, each module at different machine types. These modules used to collect data about the production, mainly filled by the machine operators, but some data are coming from external ERP system...

My only problem with this solution is that, I don't want pass object to the function, only string. But in this case, only the select-case statement seems to me a solution and with a lot of custom classes it results a quite long code.

Thanks Lagbolt for the suggestion, but this is not exactly what I am looking for. I wasn't exact enough in my initial post.I want to create a function which can retrive various types of custom objects, in basis of the function's parameter. Eg.: Function CreateObject(pClass as String)...

Hello, I am writing an application and I have a lot of custom classes. I want to create a function which retrives with a new object, but I want to determine the class of the object in runtime as a parameter of the function. Is that possible somehow to declare a new object on an other way than...

Banana, Thanx for this simply, but great tip! It is exactly what I need! Really, I don't understand why didn't come into my mind! :-) Many thanx again! VoiD

Hello, Maybe, this or similar question has been arisen in the forum, but I didn't find solution to my problem which is the following: I have several queries with one or more paramters. I am generating reports from the results of queries. My target is to show the parameters value on the report...

Hello, I would like to create parameter query based, 'dynamic' reports in runtime, but not on exactly the 'usual' way. I mean under usual way that I give the query as recordsource to the report in design view and when I start the report the query also starts and asks for the parameters, then...