Recent content by Ironis

Hey there I've got a problem with some queries. I want my queries to get a certain calculated value, but there is a problem. One querie has 2 fields, 1 record as an outcome, the 2 fields are outcomes of two other queries. Now when one of the values of the other queries is null, the 'final'...

Hey, I have quite a problem. I want several users to view the data of a table through a form, but when the accidentally open the Database Window, I want to prevent them from reading the tables. How can I do this? The reason is that people can't read creditcardnumbers from the form (ecouse its...

Hey there I'm quite new to using reports or programming reports. I want a report, that shows lines, like a word table.. In the table I want to have m,ultiple records appearing. I cannot get that fixed using a query or whatever, but I think this needs programming. I have attached a Word File...

Hmm, never mind.. I dd the following: changed rstGroups.FindFirst ("[UserName] = ' " & CurrentUser() & " ' ") Into: rstGroups.FindFirst ("[UserName] = CurrentUser()") And Now it works :) Dennis

Oke now it goes wrong again. I've installed my system, and I am building the final security (wizard asnd this code etc), and now the code gives up. I still have the same references, but now the code just won't work. It won't find a user.. Here's the code I am using: Public Function...

That could be useful for passwords, but the problem now is that I have read-only users, which aren't able to fill in data, but they can read all data. These users aren't allowed to see CC numbers. All personell will have access to the DB, and eventually also the customers. These will be very...

Hey there I want a textbox on a form, which encrypts itself when a certain user is using the DB. The encrypted text is a vreditcard number, and I only want the last few numbers to be visible. I already figured out how I can 'detect' wich user is 'online,' But I don't know how top make text...

Chenn, Thanx alot for helping me out. The first code works fine. I only had to remove the ADO 2.1 reference, and add the ADO 2.7 and ADO Recordset 2.7, and it works fine now. Thanks again for helping me out :) Ironis :cool:

The next problem is: Where do I put the Public Function? and another one: I'm working with Access 2002 Ironis

Hey there I have a form, which is hidden. The form starts up using the AutoExec macro. I want on other forms, to deactivate certain buttons with certain users. I do this using the following: In the macro, the form opens, with a table in it with user names en workgroups. The where condition...

and how can I call a module or a class if i got the code in there? That would make the overvieuw also better, for revieuwing or changes to the code..

I want the code from a form to be in a class or module, so I have a better overvieuw of the long piece of code. It's about 12 pieces of paper, times 6.. so thats why I want different classes/modules, also so that I can refer to it on multiple forms..

Hmm, just tested it, got some errors, but the Duplicate Record seems to be no error, becouse it appears in its own form, without an error number. The title of the box says "Microsoft Access", but still I'd like to have my own textbox there. Does anyone know how to capture this event??

Tanks, the last part i knew, but thanks for explaining :) Now I will find the right number i guess! Thanks again, Ironis :cool:

Oke, I'm quite new to this and trying to learn by helping other people, but couldn't you use a statement like: If IsNull(sht.Cells(1,1)) or sht.Cells(1,1) = "" then Presale(i).RFPLogin = Null End If Maybe you could try when sht.cells(1,1) = 0 then ... Just a thought, if this doesn't work...