Search results

  1. C

    Login Interactive form

    Hi Bob Please find attached the db. The main tables and forms are tbl_users and the login form is called frm_login In the FormQuote I would like to see the login Fullname and Position on the screen In the report Quotecom, I would like to see the Fullname and Position shown on the from...
  2. C

    Login Interactive form

    Hi bob Unfortunately I wont be able to get the database till Tuesday/Wednesday next week. I dont suppose you ahve an example we can work with in some way, or using the link one above. Thanks
  3. C

    Manage Users and permissions Access 2010

    Hi David I tried applying the example we had to the real DB but could not get it working. i took myself through this tutorial and created a similar situation. http://www.about-access-databases.co...-box-form.html and I created a login screen and it works, apart from I cannot see who is...
  4. C

    Trimming address fields

    Hi The voss as decided he does not want the address field in a string but in a block, for example Name Address 1 Address 2 County Post code So if the county or any other field is empty how do you make it so it goes up one to coover a blank, so if I had Colins Company 1 high Street...
  5. C

    Login Interactive form

    Hi Sorry but is there anyway you (or anyone) could help me with this. I have tried all sorts but seem to be getting into a further mess as I go along.... Thanks
  6. C

    only have logo on first page

    Hi bob I put it in the Event procedure and it works fine. Thanks for the help
  7. C

    only have logo on first page

    Hi Bob I have put this in the Pageheader On Format me.image8.Visible = ([Page] = 1) but I get a message saying Microsoft Acess cannot find the macro Me Any ideas please thanks
  8. C

    only have logo on first page

    Hi We want to have the date, idquote number and page numbers at the top of every sheet of a report. However, we want it to go above our logo rather than below. So for the date etc.. to show on every page I know it as to go in the Page header If I put it above the logo in Report Header I...
  9. C

    Login Interactive form

    Hi Bob the form for login is purely as a drop down login and then verifys password, it is called frm_login. It as a table attached called tbl_users and in there we have the username, full name, job position etc...... I am using a form called formquote to make the quoatations and it is from...
  10. C

    Login Interactive form

    Hi I have tried this many times but still having problems. I basically want a user log in screen but then want to be able to oput the user name and job position onto a report front page. Several have tried to help me so my apologies if I seem to be going round in circles. I have used this...
  11. C

    Question Upload mulitple grpahic links in one go

    Hi I found an Access database that let you point to a directory (in a form) where you graphic files were kept ad upload them all at once. I lost the file and I cannot find it on the web. So 1. Does anyone know of a sample database out there that does this.. 2. if not any ideas how I can do...
  12. C

    Manage Users and permissions Access 2010

    Hi David I left the username blank in the tbl-permissions and then it asked me to create a password in the login form. This works ok. In the TBL users it keeps the name Colin and on the forms we did yesterday it shows Colin, so thats good. In the table permissions it changed the name...
  13. C

    Manage Users and permissions Access 2010

    Hi David Could you explain how I can add a user and password into the database. I added my name into the user table and I added userid (13) into the permission table and wrote in my password. When i try and log in I get a runtime error. Could you advise please. Thanks
  14. C

    Manage Users and permissions Access 2010

    Hi That is excellent, I also applied it to my Form 1 just so I understood it complete and it works in that as well now. So a big thank you. My thinking now is this... To apply this to the real database, I; 1. Copy all tables , forms and code from the example DB. 2. Then I add in a Job...
  15. C

    Manage Users and permissions Access 2010

    Hi I cannot open 2010 on this laptop, any chance it can be saved as 2003 version. I am doing this for 2010 but wont have that machine until Tuesday. Thanks as always
  16. C

    Manage Users and permissions Access 2010

    Hi I have attached the database with the form. I ahve named the text box mewhoamI and added onload an event with me.whoamI=strUserName I am now getting compile errors. Is it possible you could adjust the form correctly (Form1) and then i can understand better. many thanks
  17. C

    Manage Users and permissions Access 2010

    Hi In the control source of the text field in From1 I have tried [StrLoginName]=Me.CboUser StrLoginName=Me.CboUser =Me.CboUser =CboUser and all of them come back with #Name? any ideas please Thanks I am definately logged in as Delilah
  18. C

    Manage Users and permissions Access 2010

    Hi Ok I found the code and understand that bit. I have created form1 and added a text box and in the source, what do I out in to get the name Delilah to show. I have tried =Forms!FrmLogin!CboUser but I get a name error in the box. Any ideas Thanks
  19. C

    Manage Users and permissions Access 2010

    The database example already as code on the afterupdate in the form Frmlogin. How do I do this in the example databse?? Thanks
  20. C

    Manage Users and permissions Access 2010

    Sorry forgot, also how do I make the new field Craeted by see the application user name.. And again sorry I do not understand what you mean by variables to pass the info to the reports Thanks
Back
Top Bottom