Search results

  1. C

    Trouble setting Temp Var

    Hi there, I have a table [Employees] which has the following Fields - TxtEmpID - StrEmpName - StrEmpPassword Which I use for my login table with the following script: If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[TxtEmpID]=" &...
  2. C

    Disable import of an Access .accdb

    I have already linked the tables, i would prefer not to make it .accde and i have all hidden in .accdb with codes to block navigation panes and edit and toolbars... will read that link later. Ta
  3. C

    Disable import of an Access .accdb

    Thanks for reply, but i have users using it the whole time and that isnt an option.
  4. C

    Disable import of an Access .accdb

    Hi, I have a .accdb with security where ihave hidden navigation pane and toolbars... Now left with one more thing, is it possible to disable anyone trying to import stuff from my database? Maybe some code or is there a setting somewhere in current db? Ta
  5. C

    Need some twitting on my code!

    hi there, I use the following code in my database: DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar", acToolbarNo DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand acCmdWindowHide I have an admin form which does this: DoCmd.ShowToolbar "Ribbon"...
  6. C

    Wanted to update my login script and incl admin

    Sorry to drive you mad but would it be possible to add that for the admin everything is unlocked e.g. navigation pane, toolbar, design view... but for regular users all is blocked e.g. navigation pane, toolbar, design views... If you want to send me your own database with script i would be...
  7. C

    Wanted to update my login script and incl admin

    Hi there i have the following code i use for my database on startup for users to login. I wanted to add that if [TxtEmpID]=1 (the administrator) then open form called "admin startup" and all others how i currently have it. I would be most grateful if someone can help me change the current...
  8. C

    Performing a spell check on the contents of a userform field (EXCEL)

    Re: Performing a spell check on the contents of a userform field I used this code. DoCmd.RunCommand acCmdSpelling Was wondering how to create a code that afterupdate make words with if there is a spellcheck error, red font colour or underline..... If anyone could help i would be most...
  9. C

    How to move records with the down button in a tabular form

    Thank you very much for your replies. i am trying this code, My form is called "Input data query art" and the field i want to use to make the script for is called "artcomments". This gets an error!!! ****************** Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If...
  10. C

    Spell check on a form not working like access says

    This is the case and it was turned on so i think it is automatically correcting. Many thanks
  11. C

    How to move records with the down button in a tabular form

    Thanks for your reply, Basically i have a db which i made to keep track on students. i have an update query that places all the student in a table called 'term' which once updated they fill in the rest of the data on that term by the students name which was placed through the query. I made a...
  12. C

    How to move records with the down button in a tabular form

    Is it possible to move down records with the down button in a tabular form to the same field in the next record. Ta
  13. C

    Spell check on a form not working like access says

    If you look at the attachment in access settings it says it is set how to auto correct and "INDICATE SPELLING". in my forms/tables/queries... it will not bring up spelling mistakes or the sort. Please help desperately. Thanks...
  14. C

    Performing a spell check on the contents of a userform field (EXCEL)

    Re: Performing a spell check on the contents of a userform field Would there be a way like in word it automatically comes up as you type to do the same in access. also i used this code "DoCmd.RunCommand acCmdSpelling" how would i exclude a certain field in the check from my form i.e. i want...
  15. C

    Make a nice designed report

    I was looking to make tables like in word/excel with the table themes you can select for nice tables. I hear what your saying, i think its just i am not used to microsoft 2003 style and all the property settings, i just like 2007/2010 which is lovely format to work. (matter of opinion). Anyway...
  16. C

    Embed all pictures in forms at once

    Hi there, I made a db with tons of forms and they all have pictures on. i want to know if there is a quick way to embed them all so i don't have to go in the settings of every picture and do it manually!:banghead::eek: Thanks
  17. C

    Make a nice designed report

    Good eve, Wanted to make a lovely looking Report that includes tables. The problem is that in access it is extremely limited as to what you can do. Is there a way to maximize the options and add edit tools. I also noticed when you put a border on a table in a report it drops it lower with a...
  18. C

    Sql update query

    Many thanks
  19. C

    Security

    Good eve, Was wondering if there is third party program or what the best way to make a usernames with administrator rights in a database. I have made codes and a login dialog that requires a password but the problem being it is as simple as holding down the shift key whilst opening the database...
  20. C

    Sql update query

    Hi there, I unfortunately don't have that button on my screen, maybe you can help. Ta
Back
Top Bottom