Search results

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]=" &...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Many thanks

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

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