Search results

  1. I

    Turn null into 0

    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'...
  2. I

    hiding or encrypting tables for certain users

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

    Display Records under one header

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

    Code problem where it should be working

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

    Code problem where it should be working

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

    Encrypt textbox

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

    Encrypt textbox

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

    Code problem where it should be working

    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:
  9. I

    Code problem where it should be working

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

    Code problem where it should be working

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

    Code > Module / Class?

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

    Code > Module / Class?

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

    Error Number of Duplicate Record Error

    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??
  14. I

    Error Number of Duplicate Record Error

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

    Excel pulls in 0 instead of null

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

    Error Number of Duplicate Record Error

    Hi, I want to create my own error message on a duplicate record. The problem with the normal error message, is that the text is very long, and for users sometimes not understandable. So I want to create an error message, with 'normal' language, instead of the technical error message there is in...
  17. I

    Suggestions needed..

    The tables don't matter that much. I have one table in which the reservations are stored. It's called tblReservation and has the following fields: reservationnumber_ID personcode_ID programcode_ID date number_pers cost_US cost_NAF Reservation ID is used for future reservations (people are...
  18. I

    How do I store Constant values

    I have for example a form, which shows PeronID, name, date of birth etc. If someone wants to add contact information, a form pops up, with on top the filled in name, date of birth etc. Under that is a subform on which the contact information can be added. The popup form, opens on a after_update...
  19. I

    How do I store Constant values

    How do you store that information. do you want it to be stored in the memory or do you want it in a table..
  20. I

    Code > Module / Class?

    So there is no way to use a module / class for the code? I know that with VB it can, but I don't know how to refer to the code that should be used from the formcode. Does anyone know this?
Back
Top Bottom