How To Have Actions At The Close Of Mdb
Jul 13, 2006
How can I perform an action when ever the db closes…
Basically I have a table, users, and when the db starts a logon form is used. Once the logon is successful it records into the user table that a user is logged in. I want to at the close of the db rewrite the record to show that the user is not logged in.
So say user A logs in successfully so then the users table would show
Key | Name | password | logged date | currently logged on(these are the column headers)
Somekey | user a | ***** | somedate | yes
I want to rewrite the yes to a no when the db closes and the user is currently not logged on.
For the rewrite I can use a simple SQL statement to update the users table, the question is where would I place this code, the on close property for the switchboard is not enough, is there an on close property for the entire db.
View Replies
ADVERTISEMENT
Jan 6, 2007
Hello all,
About 2 years ago, I created a database (my first real one actually) which is extensively used. I havent had to maintain it too much in this time but I was looking at the live table data and noticed that the users are placing inappropriate entries in fields designed for other data such as listing the Company name where the last name of the person should appear and also they are using the first name field for the entire name of the person (lastname, firstname). Knowing this is an issue, I contacted the user who didnt seem to care as thats how they chose to use the database. Since Im the person who created it and Im ultimately responsible for it, I would like to prohibit these types of entries in the future. Does anyone know of a way to force integrity in an example such as what I outlined above? I thought about trying to prohibit the use of a comma in the form field, but then I suspect they would probably choose something else or nothing at all and we would be at the same point with no resolution. Im not trying to be a jerk, but the point of the DB is being tossed away because the users choose to be stupid. Any help would be greatly appreciated.
Thanks!
Steve
View 3 Replies
View Related
May 19, 2012
I have a report, which shows all unsold items for a particular auction date, and I have created a form using this report.
I'd like my sister in law, to be able to go through and easily select which items to relist, and which to return.
I've tried using a subform, but I've either not done it correctly, or its not quite the right tool for the job. I've tried listbox control but can't get it to work properly either.
Once she has gone through the list ticking one or the other, I'd like to be able to automate with a button "Relist" and a button "ReturnItem".
I'd like Items to be returned - to automitcally close item off so it no longer incurrs a weekly listing fee and change status to "ReturnToSeller" and the relist ones, to create a new entry line into the main item table, with replicated information, except it clears out the "lot number", as they enter that manually when the generate a new list for the next auction, my ID numbers remain current and unchanged but the tableID is automated to a new one which is my key number.
then on my invoice, I get for instance, 3 rows for one Item, which could have 3 different lot and ID numbers, and get a listing fee of £1.20 for each week you see.
How can I automate the actions to relist and Return to Seller?
View 3 Replies
View Related
Jun 17, 2005
Hi.
I have a table used for years. I added new fields bringing number to 160.
When I go to insert another row, I get message saying 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'
BUT as the number of records had not increased and I am under the 255 limit why the error message?
I tried in vain to copy and compact/repair the database, but still no luck.
Ideas?
Russ
View 14 Replies
View Related
Apr 8, 2015
Suppose I need a database with customers, able to store: what different events, were performed on what date.
So let's say possible actions are: a customer called, emailed or visited.
(note, it might be possible that a customer both called, emailed and visited on the same day)
Should I start with four different tables for: customers, called, emailed, visited? Or would the three actions just go into one table?
Another aspect that I don't understand at all yet is how to proceed with the dates.
Should I create another table with a long list of possible dates for the coming x-years?
I would like it to work:
I am thinking about creating a form with buttons behind the terms 'called', 'emailed' and 'visited'. When one of those buttons is pressed, I want an entry for that action, day and customer entered in the database.
So that later on I could e.g. look up on what day how many customers called, etc. etc.
View 11 Replies
View Related
Oct 20, 2015
I don't know if this can be done. I'm using Access 2010 and I have users updating information on a hourly basis.
Can I have a field that basically shows the last user that edited the form or saved it?
View 6 Replies
View Related
Aug 11, 2005
Hi,
How can I edit a query in SQL view to run multiple lines of SQL?
For example I can use the GUI to create a query, then in SQL view enter the following:
DELETE
FROM Employees_copy;
which clears the Employees_copy table. Perfect. But what if I want to do this for mulitple tables in the same query eg for a second table Employees_copy_2 as well? I've tried
DELETE
FROM Employees_copy
DELETE
FROM Employees_copy_2;
which gives a syntax error, as does
DELETE
FROM Employees_copy,
DELETE
FROM Employees_copy_2;
any suggestions?
View 2 Replies
View Related
Feb 27, 2014
how I can automatically change the Client settings either with a macro or code. Specifically for the three confirm actions (Record Changes, Document deletions and Action queries). I have a database that is distributed to end users in different offices around the world. The old way lazy way, was to go to each computer and set these settings to "off" manually, but this isn't possible. I want to be able to run delete queries and action queries in the back end without the end users knowing its happening and having to select yes all the time.
View 3 Replies
View Related
Jan 31, 2014
Test findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all three forms.
Scenario 1:OpenForm1, Refresh, OpenForm2 Refresh, OpenForm3, Refresh
Scenario 2:OpenForm1, OpenForm2, OpenForm3, Refresh
View 5 Replies
View Related
Apr 6, 2005
:mad: I could really use some help here! Apparently, completing a mail merge automation process is much more complicated than I originally thought. I have it doing absolutly everything I need it to do (open merge document, merge data, print, and close all in the background) but I am missing one critical but probably simple step. I want to merge just the CURRENT record only, not the entire database. I've read all 500+ posts concerning merging, but I'm still lost.
-how do I specify just the current record's information?
-do I need to create bookmarks, and how do I do this?
-how do I properly use the WHERE statement?
This may be the last thing I need to do with my database, if I can get it working right. Currently, it's trying to print all 883 records and takes about 10 minutes to run the command (probably because it's trying to pull all of the records instead of just one.) I will post my code, if you like. I know this is simple, but I can't work it out on my own. Please help me!
View 2 Replies
View Related
Jan 22, 2007
Hi,
I used ShellExecute function to open the speicific pdf file,
I want to create a button which can close the speicific pdf file.
Are there any API function to close the file?
View 1 Replies
View Related
Jul 11, 2005
If I start access and try to create a new database or view any database after a second or so this dialog box saying access needs to close appears. It has only happened after I closed the program and it asked if i wanted to save the current dbase. If I view the offending database (by copying it via a pen drive) on my other computer every thing works perfectly!
I have tried the "repair program", same result. I have reinstalled the program, same result. I have totally uninstalled Office XP professional and reinstalled it SAME RESULT! As I am not a programmer I am at a loss!
View 14 Replies
View Related
Jul 28, 2005
I am using code in Access to run a merge in Word. I'll call the database containing the function (MergeWord) that runs the merge Database1. The table used in the merge is in a different database. I'll call the database that contains the table Database2. When the merge is run, another instance of Access is automatically opened with Database2 open. How do I close the second instance of Access (Database2)?
Here's my code so far:
Function MergeWord()
Dim ObjWord As Word.Document
Set ObjWord = GetObject("H:SHAREDFORMSTest.doc", "Word.document")
ObjWord.Application.Visible = True
ObjWord.MailMerge.OpenDataSource NAME:="H:AccessDatabase2.mdb", Linktosource:=True, Connection:="TABLE NewFileExport"
ObjWord.MailMerge.Destination = wdSendToNewDocument
ObjWord.MailMerge.Execute
ObjWord.Application.NormalTemplate.Saved = True
ObjWord.Activate
ObjWord.Close False
Set ObjWord = Nothing
Exit Function
End Function
View 6 Replies
View Related
Sep 29, 2005
We have a couple Access 2000 database's that are updated from Oracle data each night. There is a routine that opens Access, updates, then closes. However, on numerous occations, when it closes, the ldb file is still there. I can not delete the file without rebooting the server which I do not want to do every day.
Also, I noticed that the ldb file date is changed when I exit Access not when the db is opened. I thought the opposite was suppose to happen.
Any ideas?
Thanks,
SKK
View 11 Replies
View Related
May 8, 2006
i have close button on my form made thru the command button. But it does not show an error message when the form closes if information has not been entered in the reqired fields. it does not save the field though. how can i get the error messages to be shown before the form closes asking the suer to enter the missing data. thanks
View 2 Replies
View Related
Mar 1, 2007
When the user clicks to close the form the Before Update event runs, and has the following code to check that all the required fields are completed:
If IsNull(Me.ToxReceived) Then
stdresponse = (MsgBox("You must enter the toxicology received date before continuing." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _
"Do you want to do that now? Click YES to return to complete the form, click NO to undo the record", vbYesNo, "Missing Data"))
If stdresponse = vbYes Then
Me.ToxReceived.SetFocus
Else
Cancel = True
Me.Undo
Exit Sub
End If
End If
If the user clicks no, and the record is undone, how do I get the close form event to still continue?
D
View 14 Replies
View Related
Apr 19, 2007
Hi,
I apply Compact On Close (Tools->Option->General tab). So, every time, it will compact the database when closing the file.
However, will it do repair the database automatically? It seems just do compacting.
View 1 Replies
View Related
Jun 8, 2007
I used the following code in the on close event of my form and it works when the value of [maingameformation.playid] is not previously entered but if there is already a value there it won't overide it? Is this possible to do?
Private Sub Form_Close()
[Forms]![gameentryfrm]![maingameformation.playid] = Me.playid
End Sub
View 4 Replies
View Related
May 9, 2005
i put a button that run the command "docmd.close" but i found when i click it it close the form but with saving all data in field in the table, but this button should cancel record insertion, i hope i can find the answer here.
Thank you
Best Regards
View 1 Replies
View Related
May 13, 2005
I have a form that I want only to be opened from another form (i.e. the user presses a button from form1 and form2 is magically displayed).
My solution: In form2, I check to see if form1 is open in "use" mode. If not, I display a message and close form2.
The problem: The close code (docmd.close) is at the beginning of Form_Current. Apparently, Form_Current doesn't like to be interrupted. I receive a run-time error 2585 (This action can't be carried out while processing a form or report event).
Ok, so, umm, how exactly am I supposed to close the form? I tried the check during Form_Load instead, using the cancel variable instead of the docmd.close. However, I don't think this code got executed. It's almost like the form was already loaded or the Form_Load occurs after Form_Current (In my handy chart here, it says that Form_Current occurs when a form containing data is first opened and when you move to a different record.. so, I suppose it is possible).
Any thoughts?
View 3 Replies
View Related
Jun 14, 2005
How can I close two forms at the same time. to close the first form I use DoCmd.Close how can I do form 2 from the same button, Thanks
View 3 Replies
View Related
Jan 13, 2006
I'm trying to close one form by using a button on another. This is my code:
DoCmd.Close acForm, frmSimCount
It dosen't work but comes up with an error:
Run-time errer '2493'
This action requires an object name.
I thought that was the name of the form, which is frmSimCount, could someone put me in the right direction please.
View 3 Replies
View Related
May 9, 2006
How can i setup a popup message when the user closes the DB.
I need to have an reminder to the user every time they shut the program down!
View 4 Replies
View Related
Jun 17, 2005
Hi all - Having a problem getting my macro to run with the ON CLOSE event of a form. Before users exit the form (or database completely), I want the macro to run. The macro is designed to run an update query that updates 3 fields in my main table. Right now, the macro runs and but it only updates 2 of the 3 fields. It's as if the database closes before the update query gets a chance to finish. Any ideas on this?
Thanks,
Dan
View 3 Replies
View Related
Sep 29, 2005
We have a couple Access 2000 database's that are updated from Oracle data each night. There is a routine that opens Access, updates, then closes. However, on numerous occations, when it closes, the ldb file is still there. I can not delete the file without rebooting the server which I do not want to do every day.
Also, I noticed that the ldb file date is changed when I exit Access not when the db is opened. I thought the opposite was suppose to happen.
Any ideas?
Thanks,
SKK
View 4 Replies
View Related
Feb 15, 2006
I'm having an issue with part of my code. I have a logout function which closes one form and then reopens the login form. It does this fine, but I can't type in any of the text boxes on the login form unless I close it out and reopen it manually. Here's the code:
vb Code: Original - vb Code Private Sub cmdLogout_Click()On Error GoTo Err_cmdLogout_ClickDoCmd.OpenForm "userlogin", acNormal, , , acFormReadOnly, acWindowNormalForms!userlogin!txtuserid.SetFocusDoCmd.Close acForm, "Control Panel", acSaveNoForms!userlogin!txtuserid.SetFocusExit_cmdLogout_Click:Exit SubErr_cmdLogout_Click: MsgBox Err.Description Resume Exit_cmdLogout_ClickEnd Sub Private Sub cmdLogout_Click()On Error GoTo Err_cmdLogout_ClickDoCmd.OpenForm "userlogin", acNormal, , , acFormReadOnly, acWindowNormalForms!userlogin!txtuserid.SetFocusDoCmd.Close acForm, "Control Panel", acSaveNoForms!userlogin!txtuserid.SetFocusExit_cmdLogout_Click:Exit SubErr_cmdLogout_Click: MsgBox Err.Description Resume Exit_cmdLogout_ClickEnd Sub
I've tried setting focus as shown above, but still no luck. Any ideas?
Thanks,
JMH
View 2 Replies
View Related
