Not Saving Info Until I Close The Form
Oct 9, 2006
I have a form and one of the fields is a drop down box with autofill. If I enter an information that it is new, it doesn't show in the drop down box even after I click on the Save button I created on the form. In order to show up, I need to close the form, then reopen it again.
I am running this particular drop down box from a query in order to facilitate the autofill and because it also automatically fill other fields when the information has been already entered.
I also tried linking the drop down box directly to the table instead of the query, but it did not worked.
So basically my main problem is that in order for the new information to appear in the drop down box I need to close the form and reopen it.
Any ideas what can I do here?
Thanks
View Replies
ADVERTISEMENT
Feb 28, 2014
I have a form frmAddNewProject that is a Data Entry form.When you click Add Project on the form, it creates folders and copies files to a location and also creates new record(s) in the ProjectT table with appropriate information.Here is my code:
Code:
Private Sub cmdAdd_Click()
Dim FSO As Object
Dim FromPath As String
Dim ToPath As String
Dim FolderPath As String
Dim strType As String
Dim strYear As String
Dim strGPN As String
[code]....
Everything works fine till here. Now I would like to close the form but closing it gives me an additional empty record.
Code:
Dim ctl As Control
On Error Resume Next
For Each ctl In Me.Controls
ctl = ctl.DefaultValue
Next
Set ctl = Nothing
to remove all values, but then it just adds an empty record.Is there a way to close that form without removing my legitimate new records and without adding empty ones?
View 4 Replies
View Related
Jun 3, 2015
I have a form I would like to close without saving the record using a button. here is the code I have but it closes the form and it also writes the record to the table.
Code:
Private Sub ClosewoSave_Click()
Cancel = True
Me.Undo
DoCmd.close
DoCmd.OpenForm "frmMenu"
End Sub
I found in a thread that Cancel = True would not write the record.
View 4 Replies
View Related
Jul 30, 2015
I have a timer form which closes the database after a period of time with DoCmd.Quit. Another form is open at this point but if a user has left it in the middle of editing it I want to be able to save the record in the other form and close it before the timer form closes the database.
What VBA do I need in the timer form to save the record and close the other form before DoCmd.Quit? Just to be clear the code is...
Private Sub Form_Timer()
On Error Resume Next
Me.Tag = Val(Me.Tag) - (Me.TimerInterval / 1000)
Me.Caption = "The database will exit in " & Me.Tag & " seconds"
If Val(Me.Tag) <= 0 Then
[code]...
View 1 Replies
View Related
Sep 21, 2004
I want to close an Excel application without it prompting me if I want to save it or not
that's what I use
set xlApp=nothing
it doesn't seem to work cause when I shut down my computer, it still asks me if I want to save it
looks like the application is still running in the background even if i set it to nothing
I could use xlApp.quit but I don't want anything poping up
can it be done?
View 2 Replies
View Related
Oct 14, 2004
Can anyone tell me how to have Access automatically close a report without saving any changes.
I do not mind if the user closes the report manually but do not want Access to prompt the user to save changes. I want it to automatically abandon any changes that were made.
View 6 Replies
View Related
Jun 5, 2013
I have a form with a child that holds a query and for 99.9% of the time remains locked as it's for viewing data only. However, if the user wishes to make a change then they need to press an unlock button first then make the changes.
The problem I have is when closing the form; if this child's query has been unlocked I'm getting a message asking do I wish to save the changes to the layout of the child's query. The answer will always be "No".
I've added the following line of code to all sorts of procedures with no success.
DoCmd.Close acQuery, "LinkTableManager_Frmqry", acSaveNo
how to stop the message appearing when the form is closed.
View 5 Replies
View Related
Nov 7, 2006
I need help on this, from what the best concept is, to what I need to look into using:
I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.
As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?
Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...
Thank you.
View 2 Replies
View Related
Aug 26, 2014
I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.
View 3 Replies
View Related
Aug 19, 2013
I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
View 2 Replies
View Related
Nov 17, 2014
I am using the method from allen browne [URL] .... to open a form and add it to a collection and when removing it it closes. actually, usually it does work so but i have now a form which does not close until i am hitting the reset button in VBE , is there something i could check why it's not functioning as desired ?
Just to add, this form has a subForm as well (might be the cause ?)
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
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
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
Dec 9, 2012
why a form won't close. Each time I try to I am prompted to save and when I do, the form doesn't close. When I closed the DB and reopened, none of the changes were saved.
View 6 Replies
View Related
Oct 25, 2006
Hi,
I want to have some queries run during the database is closed, like the functiona with "Repair on Close". But I don't want to use a form with a VBA code doing it. Is there any other possibility to do it? :confused:
Thanks in advance for answers.:)
View 14 Replies
View Related
Mar 9, 2005
Hi,
I've got a database with a linked table to a CSV file which is automatically extracted from some logging software. The Database is used to search for text strings (e.g. "example") within several fields wichin the automated extract and then show the results with any duplicated instances taken out (via an append to table query which is indexed with no duplicates).
So:
Text is entered
FieldA is looked through for a match, if a match is found the whole record gets appended to the Append table.
FieldB is looked through and if a match is found the whole record (including field A) is appended, however if the match has already been found in A, then the record is not copied.
It does this for several fields and then you get a table which is every record containing the searched for text with no duplicates.
This table is then displayed as a subform on another form in it's "table" view.
The form I'm trying to close is the form which contains the above subform.
I've tried:
A macro with close -> form -> formname which doesn't work.
Code:
Private Sub Toggle2_Click()
On Error GoTo Err_Toggle2_Click
DoCmd.Close
Exit_Toggle2_Click:
Exit Sub
Err_Toggle2_Click:
MsgBox Err.Description
Resume Exit_Toggle2_Click
End Sub
Which also doesnt work!
HOWEVER, just to make things interesting, if I click to view the form design, then run the form again, it will close fine using either method. It just seems not to work on the initial run of the text search which then opens the form displaying the subform.
Any ideas?? I can't understand why it won't work.
Cheers - Hope I explained it ok :)
View 1 Replies
View Related
May 20, 2005
It seems so simple to do, but I've spent ages looking through the forums and haven't found a simple implementation of it.
How would you close a form based on a query called 'Retired' if no records are found?
I assume it's going to be a bit of VBA code, but I'm still learning VBA. :-(
View 8 Replies
View Related
Jul 12, 2005
Hi guys,
I have a form that the user uses to input data. If the user tries to close the form by clicking on the X then a warning message is displayed such as:
The field cannot contain a Null value because the required property for this field is set to true. Enter a value in the field.
What I want to happen is that when the user closes the form via the X, then no updates are undertaken (in effect a cancel operation).
How do I do this???
Thanks
View 6 Replies
View Related
Jul 17, 2005
Hi, all. I am sorry if i do something wrong but it is my first time here.
Situation:
I have an application with a login form. Once you press the login button the login form is hidden (visible=False) to be able to pass the userid to another form. In order to close the application the user needs to press a button in the swithcboard but that is not possible because the hidden form.
Question: How can i close the hidden form to be able to close the application?
Thx in advance.
View 2 Replies
View Related
Jul 27, 2005
I have a form that is loaded through a hyperlink from another form. On this form I have placed a command button which closes the form (DoCmd.Close) I have also used the full syntax including form name and no save prompt. When i close this form using the command button I get a request for two paramter values that are used in queries in this form (I don't want this to happen) when I click the close button on the control box "X" this doesn't happen also it doesn't happen if I use file close. This problem only occurs on some of the slower machines in my workplace, any suggestions would be greatly appreciated. The is one combo box on the form in question which is set to run a macro after update, this macro requeries the 52 list boxes on the form.
View 4 Replies
View Related
Dec 14, 2005
I am building a database to track employees. I have a form to input the personal information and want to close this form and open a new form to input the employee's training information. I have a cmd button to open the Training form for the individual, however I can not make it close the employee input form.
Can someone help with this?
View 6 Replies
View Related
Feb 1, 2006
how do I make a form closure password protected? basically a customer will be using a a form to browse products and the only way to have access to the rest of the DB is to enter the correct password to close that form when a close command button is clicked (more security features protecting rest of DB) how do I go about this? or is there a better way? explanation of any code will be very much appreciated! thanks :)
View 4 Replies
View Related
Feb 14, 2006
I can't seem to figure out how to close current form.
I have form1 and I open form 2 from form1. I can't figure out how to close form1 when form2 opens.
Any help would be greatly appreciated.
View 6 Replies
View Related
Feb 19, 2006
Hi all,
I have a small problem....
Assume we have a form called formX with a button on it, clicking this button will open another form called formY, I know how to do that.....
But what I want is when I click that button, formY to be openned and formX to be closed at the same time.....
Thank you in advance, and sorry for bothering you......
Regard,
View 3 Replies
View Related
