Search results

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, Thanks again for the tip, but unfortunately this is not what I am searching, becasue RecordCount property gives only one number - the number of records in the query. Let me show via an example what I want. I have a query, returns with let's say 10 records: Record 1 Record 2 ... Record...

Thanks for the tip, but I am afraid I don't understand it. How can give me the number of fields of a query the number of its rows? The problem must be with me, but I really don't understand it. Please explain it! Many thanks! VoiD:confused::confused:

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

Thnks Ray for the suggestion, but unfortunately it doesn't work, because on one hand currently I have more than 50 queries and the number is growing according to new demands. On the other hand I am looking for a solution which is 'dynamic' and in case of a new query it is enough to add the new...

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

Moniker, thanks for the idea, but I think, I've found out what I am going to do. My be is an ms sql db and the fe connects to it via odbc. There is one login for the db on the sql server and that's all. When the fe starts a procedure attaches all neccessary tables, using the login created on...

Thank you very much Moniker for the help! It is a good stuff, but doesn't solve the problem totally. The passwords can not be seen, but what about other fields and tables? My aim is to protect every data against unauthorized access or view without using Access' native security solution. I...

Thanks for the fast reply! It seems to be a good idea, but my problem is with it, that if somebody knows how to 'cancel' program running with shift key, presumably will know how to see the hidden or sys tables. The db structure is fe/be. I thougth what if I attach from vb code every time...

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

the solution ;-) Not a long time after I've posted my question, I had found out the answer also. The solution was very simple: When the error, which says that this property could not be found, occures, I have to create a user defined property, called Caption, for the given field and then assign...

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

Many thx for the advice!

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