Back Button
Jun 2, 2005I have some parameters set up the user needs to enter information. Is there any way to put a back button on these parameters, so, if the user makes a mistake, he/she can just go back one step. :confused:
View Replies
ADVERTISEMENT
Database Back By Button???
Mar 6, 2008Does anyone know of a way to make a database back up by a click of a button in a main form in the database? (so a customer does not have to go tools/database utilities/back up database)
View 9 Replies View RelatedBack Button On Switchboard
May 15, 2006is it possible to create a back button on your switchboard so from your main switchboard your subwitchboards or your sub sub switchboards you just click the back button to go the the previous switchboard?
View 13 Replies View RelatedToggle Button, Focus, Switching Back And Forth
Feb 6, 2006Here's a little design problem, all of my VB script works fine, it's just a design problem:
Toggle Button (onClick) {
if pressed in, unlock protected field, pass focus to protected field
else (if not pressed in), lock protected field
}
Protected Field (lostFocus){
When Focus is lost, protect field then reset toggle button
}
See, there's no way that I know of for Access to tell what field has focus at any given moment. It lies inert until an event fires off then it responds. You can't wake Access up and tell it to go do something. So, Protected Field has to lock itself when it loses focus.
Here's the problem. If a user unlocks the field but then decides not to make a change and clicks the toggle again to lock the field, first Access fires the script to protect the field (locking it), then it resets the toggle button, then it registers the toggle button click which unlocks the field. See the problem? If the user changes their mind about changing the field and then tries to lock the field, it ends up unlocked. I need something that will work whether the user is good about it or whether the user is in a rush and forgets about it.
How To Disable Back Button Of Record Selector
Aug 17, 2005How can i disable back button of record selector, i dont want my user to fiddle with the data which is already entered.
View 3 Replies View RelatedForms :: Button Back Color Change When Pressed
May 10, 2013Is it possible that once the command button "Send Cost Request" in red is pressed it will change to green?
View 3 Replies View RelatedForms :: Command Button To Unlock And Lock Fields / Edit Button?
Feb 19, 2014I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.
SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.
I have changed the Form properties so that Data Entry and all the "Allows" are set to No...
Difference Between A Command Button And A 'label' Button
Aug 12, 2005Hi, I have got a small problem and maybe someone could advise me.
I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: :
Private Sub Labelsearch_Click()
Me!itemquery.Requery
End Sub
Private Sub Labelsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.SpecialEffect = 2
Me.Labelsearch.BackColor = 255
Me.Labelsearch.ForeColor = 10092543
Me.Labelsearch.FontItalic = True
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.ForeColor = 255
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
'Come back to initial state when button release'
Me.Labelsearch.SpecialEffect = 1
Me.Labelsearch.BackColor = 16373685
Me.Labelsearch.ForeColor = 8388608
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End
If I create a command button with the wizard and assign the code :
me!itemquery.Requeryto the on_click event my form is working fine.
Why is his code is not working if I assign it to a label? :o
Back End Security
Apr 25, 2005Hi,
I have a database which is secured via a workgroup.
I have just ran the database splitter to seperate the data into a back end. But now I can open the back-end directly without any password.
How do I ensure that the back end is still secured when doing this?
Thanks,
Adam.
Back End Security
Jul 28, 2005Hi folks,
I've built a few simple databases in the past, but never one where security was required. Now someone wants a database where access to certain areas is limited. Everything I read about Access Security here makes it seem complicated, and flaky, so I was wondering about doing something simpler ;
1. Make the Back End password protected so no one can open it
2. Make the front end an MDE. Put certain forms behind a form which prompts for a password. Store the password in a table to allow it to be changed if required.
So this looks like a crude method to me, but it is for a small user base, where the manager needs access to certain info which employees shouldn't see. I suppose if an employee was so minded, and put in some effort, they could get around the simple password-protection, but is it worth setting up proper security for a small project ?
Can anyone offer any advice on how much more secure the database would be if I did it properly ?
Thanks,
StepOne
Back-up And Recovery
Oct 12, 2005Hi,
I come with a mainframe background so please excuse me for my Ignorance on Ms-Access/VBA. :(
I am in the process of developing a solution using Access/VBA. I want to include custom Database Backup and Restore facility within my Application. :rolleyes:
For example:
Say I take a backup of the Database before the monthly update and store the backup (in a folder).
After the update, if a user thinks that the monthly update did not go as he was expecting (this could be because of the data that he fed into the application) - I want to give a option asking user if s/he want to rollback to a previous version of the database. (This will be similar to Windows SYSTEM RESTORE facility).
The Database sits on a network drive (mostly this would be used by one user for the update part and may be 1-2 users who would be viewing the reporpts that come out of it)...So I can safely say it is a stand-alone, single user system.
What I would to ask your help is on following.
1. While my application is running how do I do the restore?
Or do I have to have a seperate application which performs this (ie., restore/backup) operation?
2. While my application is running, Can I take a backup copy of the Entire Database?
Any other hints/help regarding this would be much appreciated. :)
TIA,
PW.
Back End Won't Open
Jun 12, 2007For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end.
I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any ideas on what has happened and how I can fix it?
Back End And Front End
Oct 19, 2007Hi friends,
I think I am having some problem with my back end and frond end files. I have a mde file that anytime I enter new data or change some things in the old clients file, it does not update on the mdb file. Anytime I need to change forms or report or any thing at all, I am suppose to copy the BE file and the MDB file to my workstatio, remove the table link, make the changes I want to make on the design mode and then import the files back to the live copy of the mdb file then make another mde file to work with. But When I copy the BE and the MDB files, I don't have the updated client list or new client just added. So as not to affect other users, I can not make changes in the MDE file and even the MDE file will not even let me make any changes in design mode. I don't know If I am making sense but any help will be appreciated
thanks
Back End Database
Oct 24, 2007Cannot open back end database.
There are no other users logged on
Tried opening it in open exclusive mode but still error message.
Front end on number of desktop PC's.
Back End on server.
I need to get in design mode on back end but won't let me.
I get logon screen but when try to log on get message below
I can log onto front end ok.
Error message something like.
* You do not have perimission to open or enable database
* You must have open/run open/exclussive administer permissions.
* Request other users to log off
e.t.c.
Front End And Back End
Oct 27, 2007I am having a trouble with a multiuser DB. I have split it using the Splitter Wizard and have put a copy of my FE to a second computer and relinking its tables. When I opening the bound form in computer 1, computer 2 can not open that form and sometimes computers lock and had to restart the machines. But if I open that form in computer 2 first and then the same form in computer 1 , it works fine. I have set full sharing to computer 1. I am using Access 2007 and Windows VISTA.
Both have FE, the BE is located in a shared folder with full permissions in C: in computer 1, the FE of computer 1 is in that same folder. Both computers are connected via a Cat5e Cable.
FE in computer1 table links to c:databaseBE and computer 2 links to computer1_IP_Addressc:/databaseBE
Can anyone help me please!!!
I'd appreciate it a lot
Thank you!!
Front End & Back End
Mar 23, 2007Hi there, :cool:
I've one FE & BE related question here. Ok first of all I've BE in server and each user have copy of FE in local PC. But I've one problem with linked tables between FE & BE.
Is there a way that FE can programmatically create connection to BE linked tables or user is able to link those tables manually, if FE can't find/connect to linked tables in BE? Or do I just have to manually configure each users FE linked tables?
All replies are welcome and well approciated at all costs! :D
ADO Connection To SQL Back-end
Aug 30, 2005I am working on an MS Access database that will connect to an MS SQL db back-end through ADO code only (no constant connection), so I am using connection strings when it is needed to pull back data, other wise it is not connect to the back-end database.
I am trying to get the code correct, and I believe I am close but missing one piece. Here is an example of what I have so far:
--------------------------------------------------------
Dim cat As New ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
cat.ConnectionString = "PROVIDER=SQLOLEDB;SERVER=KCNTLBASE;DATABASE=Test;U ID=testuser;PWD=testpassword"
cat.Open
Set cmd = New ADODB.Command
cmd.ActiveConnection = cat
cmd.CommandType = adCmdText
cmd.CommandText = "Select MttrNm from dbo.Page0"
cmd.Execute
Set rs = New ADODB.Recordset
rs.Open cmd 'cmd.Execute
MsgBox rs.RecordCount, vbOKOnly, "Test"
'Debug.Print rs.GetString
cat.Close
-------------------------------------
I believe my error is at this line:
cmd.ActiveConnection = cat
I want the cmd to use the connection string. But all the help I find is just the code "CurrentProject.Connection" which only connects me to the MS Access database itself.
Does anyone know what I need to place here so that the cmd is using the correct connection string to the SQL back-end?
Thank you for your time.
TJ Bernard
Autonumber Back To 0
Mar 8, 2007the autonumber datatype in access automatically adds numbers when a new record is added, since i have been using it to test my database new users already started at 100, without creating a new table how do you change it back to 0.
View 3 Replies View RelatedImporting Data To Back End
Jul 25, 2005Hi,
I have a DB that relies on text file imports as well as input and I recently split it. Unfortunately now my refresh script that updates the tables based on the text files imports them into the FE rather than the BE. I have messed around with workspaces but am struggling to get a solution. Ideally i'd like to be able to call DoCmd commands directly in another database but if anyone could give me the code to execute a function I can take it from there.
Thanks, Tom
Accessing Back End Over Network
Oct 31, 2005Hi
I've got a back end database on one of my computers and i'm trying to get the link tables to work over a network from another computer. Ive set the link tables up but it wont let me edit any data because it is read only. Its not read only when i run the front end from the computer that stores the back end. How do i enable the front end to edit the data over the network?
also, it is a multi-user system so i want multiple front end parts accessing the one back end but whenever i try and access the data from one system when another is already open it says the file is in use and i can't do anything!
I'm really stuck at the moment and i really need some help please! :confused:
Decompile Both Front End AND Back End?
Nov 22, 2005Hope this isn't too silly, but I've just discovered "decompile". Instructions don't mention back ends and front ends. Do you have to run decompile on the FE and again on the BE, or is it sufficient to do it only on the FE (which has links to tables in the BE).
Cheers,
Christine
Front End/Back End Issue.
Jan 26, 2006I have a db that I have split out into a front end and a back end. The back end is on a network drive, and I have a copy of the front end on each user's computer.
The issue that I'm having is that 2 people can open the front end and 2 cannot.
When the database opens I have a form that loads on startup with a username/password combo.
On the 2 machines it works on, everything loads flawlessly, on the others they get an error message stating "\networkpathaccess.mdb" is in use
we are all using the same version of Access...
they are all using windows xp...
anyone have any ideas I can check out?
BLOBS - Front End Or Back End?
Apr 18, 2006I am about to place my database on a network. I have two extra folders in the database. The first contains excel spreadsheets that are lined to a form. The second contains .pdfs that are linked to a second form.
Where is the best place to put the folders, front or back end.
Many thanks for any assistance.
Back Ground Colors
May 3, 2006Hello everyone,
Does anyone know how to translate the background colors used in Access to RGB?
Thank you.
Let Only One User Edit My Back End?
Jun 6, 2006Is there a way to only let one user at a time edit or save to the table in the back end of my database? For example; I want it to pop up and say "you dummy there is another person with this file open"
Can I do this just incase two people try to edit the same table information???
Auto Back Up Of Access
Jul 13, 2006What I would like to do is put a re-writable CD into the CD drive and leave it there. Access would copy it's back end onto the CD every day (say at 3 AM).
The "network" is the PC. Others link to it.
I've done a search and checked a few other places but no one seems to cover this.
I would like to keep it in Access but if I have to do somthing in Windows I will.
Using Access 2003 and WindowsXP Pro
Thanks