Recent content by 11010101

Wrong thread Sorry, now I seen that a specialized topic concerning reports exists ... from now on I will be more carefull, BUT I still wait for a reply if someone can help.

Hi. Is there a way to set the record source of a textbox control from an access report to something else then a field from a table or query ? I didn't found one. I wanna to display in a report some processed and parsed data from a memo field (the processing and parsing is done in a function from...

Good solution Yes, it's the right solution, I already done that and it worked, BUT thanks very much for your quick help, it's very valuable. Thanks again, Mihai.

Re-Explain the problem I will re-explain the problem: - i wan't to implement a role-rights management system in my "mdb with linked tables" application. I don't wan't to use the access feature of declaring groups and users ..., I wan't to implement this system in the MSSQL (create users for my...

Linked tables connection string Pat, I bother you with another dilema: - it must be a way to edit the linked tables access project's connection string to MSSQL, BUT I just can't find it. I look over the ODBC but can't find it.

Thanks Yes, you where right, I need to put on the form the second table foreign key (I'm not very hapy for this), instead of the fact that it's say that if one change the access application to a linked tables one, no changes in code are required. Muchos gracias, Mihai.

Hi again, I'm coming back with a new question. I have an access bound form which has as datasource a query (representing an inner join between two linked tables). My problem is that in this form, I can insert only data from the first table; the data from the second table cannot be entered (the...

Problem stii remaining Why bother with A2K ? these are the specs but this in not an A2K problem. I also had no problem in transferring the validation rules, the BIG PROBLEM is that the validation texts are not transferred and I don't have any ideea on how to manage them. To copy them from...

Solved Hi, I solved the problem using the ADOX library: the validation texts can be read or set using the next piece of code: .Columns("Rating").Properties("Jet OLEDB:Column Validation Text") = "Must be between ..." .Columns("Rating").Properties("Jet OLEDB:Column Validation...

MSSQL trigger - no solution Hello, thanks for reply. I know this solution (MSSQL triggers) BUT as far as I know, the validation texts will not be suported by the MSSQL, nor will be converted automatically by the access upsize wizard. And, in another order of thoughts, my problem is more...

Hello, I'm new in the Access World. I have a small question, but a bigger problem: I have a big application developed in Access 97 with more then 200 tables. I wan't to move all the validation rules and texts from back-end to front-end (mean that I wan't to make the validation on the form...