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

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

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

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

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

Hello, I've faced a - for me - tricky problem when I've created a query from code. I have an MS SQL backend and in it there is a table which has a long time format field. I want to make an sql query where the condition is a time data. Unfortunately when I enter a time which is surely in the...

Hello, I've faced a - for me - tricky problem. I have a query, containing about 8 tables and this is the datasource of a form. I have to show the rownumber of the query on the form - I mean if the query has 10 rows, I have to number the displayed rows from 1 to 10. Does anyone have idea if how...

Hello, I assume, I've already asked here something similar, but I didn't receive answer. So, I have many queries in a list and when user double click on an item I would like to display the result of the query in a subform control. I tried to assign the query in runtime to the subform's...

Hi, I have to count value changes in a recordset and, to tell the truth, I can not find out how to do it with sql query. Anyway, is it possible? Unfortunately, I have to not simply count that how many different values are in a field, but how many times has changed the value of that field. e.g...

Hello, I use to write small apps in Access for multiuser enviroment and I am not satisfied with the native security possibilities of Access. I got lots of trouble with shared .mdws and such things. That's why I've decided to make my own login procedure. BUT, to make it, I have to store user...

Hello, I have an MS SQL 2000 backend, and I link the tables from here to an .mdb file. In that .mdb I would like to change the field captions of the tables in runtime, but when I try to assign value to a caption property which didn't have value before, I receive an error message which says...

Hello, I created an application in MSAccess and I would like to use it with MS SQL linked tables. The application would be used on more workstation in the same time. I would like to use one, shared workgroup file to handle the access rights of different workgroups' users. The application is on...

Hello, I have a strange problem which have to be solved in Access in all way, if it is possible. :-) I have to create a table similar to an Excell sheet. Row headings are name of persons, column headings are workplaces. The aim of this table is to register worked hours at each workplaces...

Hi, I have some queries in a list. When I run one of them I would like to show result on form. I made a subform and I defined from code in runtime the actually selected query as the subform's source object. It didn't work. :( Why? How could I show a query's results on a form? If somebody...