Refreshing The Form And Automatic Saving Question
Dear all
My inquiries is 2 fold
1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form.
In more elaborate terms, I have a Main Client Form, and a Fee tracking subform. Each Client can have more than one account, so in the Fee tracking subform, I have a account combo box that provides the value that correspond to the client on the main form based on a query i generated.
>> My question is everytime i scroll through the clients, I still get the same drop down values for the previous client. I installed a refresh command button and upon clicking that, it gives me the new account numbers that correspond to the current client upon. What I would like to ask is if there is any simpler or automatic way of refreshing?
2) I am not that familiar with how Access records the data in the underlying tables, but right now, all the changes I make is recorded. Is there anyway to do so such that changes will be saved only upon the user confirmation and not automatically?
Thanks a lot in advance on any advice
Regards
TK
View Complete Forum Thread with Replies
Related Forum Messages:
Refreshing A Data Entry Form After Saving Data
This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!
View Replies !
Further Help Needed - Saving/Refreshing
Okay, I've got the following code which works great, except to copy the fields I need in to the subform, I first need to save the current record before it will update or go into another subform or record. The docmd.save doesn't seem to be working. Can anyone see where I am going wrong? Thanks in advance for your help. Code: 'DoCmd.SetWarnings False DoCmd.Save DoCmd.RunSQL "insert into [enquiry_mainsite] (mainsite_entity, mainsite_unit, mainsite_streetnum, mainsite_street, mainsite_suburb, mainsite_state, mainsite_postalcode) " & _"SELECT enquiry_entity.entity_id, enquiry_entity.entity_postalunit, enquiry_entity.entity_postalstrnum, enquiry_entity.entity_postalstreet,enquiry_entity. entity_postalsuburb, enquiry_entity.entity_postalstate, enquiry_entity.entity_postalcode " & _"FROM enquiry_entity " & _"WHERE ((([enquiry_entity].[entity_id])=forms![enquiry_entity]![entity_id]));" 'DoCmd.SetWarnings True enquiry_mainsite.Requery
View Replies !
Refreshing A Form
I have an orders form which contains an items subform. To populate the items subform I have a button which opens a separate pop-up form. Is there a piece of code which would allow me to click a button on that pop-up form which actually refreshes the other opened form (orders form)??? Anyone know if this is possible? Thanks, Paul.
View Replies !
Refreshing Form - Please Help
Hi I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box. Please help Thank you
View Replies !
Refreshing A Form
Hi all, How are you? I have a small problem... I have a form with 3 textboxes and 1 button. When filling these textboxes, and clicking the button, a record will be added to a table. I want when I click the button, the record to be added to the table with removing the the old record from the 3 textboxes for the new record to be added. How can I do that??
View Replies !
Refreshing A Form
I have some dLookUp text boxes on a form. They don't refresh though till after I change the record I am on. There are only two fields on the form that actually change the dLookUp boxes and they are both combo boxes. Is there some refresh code I can put in the combo boxes so that the form refreshes after someone changes data in the two combo boxes?
View Replies !
Form Keeps Loading/refreshing
Hi all, I encountered some weird symptons with my Access forms. I am using the form to display images(done by setting the OnCurrent and After Update property). When my PC is just powered on, and i try to load say form "ENGLISH". Form "ENGLISH" will appear, but the focus will switch in between form ENGLISH and the MS ACCESS program window. This action will onli settle down after abt 10 secs. When the ENGLISH form is loaded, i will attempt to switch from one record to another, but the same thing occurs again. IT will load/refresh for abt 10seconds, with the focus toggling btwn ENGLISH FORM n MS Access.. IN addition, it opens a second copy of FORM "ENGLISH" in the background as can be seen on my taskbar. When i close my 1st form ENGLISH and i attempt to close the 2nd FORM tat is appearing on the taskbar, there will be an error msg, English : MSACCESS.EXE-Application Error, Instruction at....(refer to the attached jpeg file for detailed error location) Y is it tat this weird behaviour onli applies to the forms tat are used to display images but not those normal forms tat contains of purely text? The entire behaviour will be eliminated after i close MS access, and reload the DB abt twice.....
View Replies !
Refreshing A Form On Click
I have a form that has a status, and a button that changes that status when clicked. This should remove the record from the current form and put it in another. Is there anyway I can refresh the form after that button is clicked to show the record actually dissapearing instead of having to close/reopen the form?
View Replies !
Form Not Refreshing After Submit
Hi, I have a form, that has some text fields and a couple calendars for the user to select the dates from. What I would like to happen is, after the user enteres the data, and they hit submit. I want the form to go back to a new entry, but it's not quite doing this. The data they type in dissapears after submit, but the calendars seem to hold whatever date they used. And when they try and enter another entry, they can't select the same date as before. They have to hit a different date first, before it allows them to re-enter the same day. Anyone know why? Is there a way to make the form refresh, or reload after they hit submit? So it will allow them to enter something for the same day? thanks chris.
View Replies !
Problem Refreshing A Form
I have an invoice form that I open and store the line items in a table temporarily. There is a button to edit the customer data that opens another form. I don't close this first form as there are issues with saving the data etc. Anyway, I open the edit customer and at the end when the user hits a save button I do an open of the new invoice form (simply to send it control as it is already open in the background). This works fine in that we are back on the New Invoice form. However, I can't figure out where to put the code that I want to execute (Close the Edit Customer form, requery, refresh). It doesn't hit the On Open and I've tried several other paragraphs Got Focus works, but that is hit too many other times and causes the screen to flicker etc. What Event paragraph will it hit coming back in when I do the Open in the Edit Customer form? Any help would be great! Thanks!
View Replies !
Requerying / Refreshing After Form Is Closed.
Hi all, I am stumped as to how to get a form to update/refresh. Heres what I have! My main form:[Daily Log From] is opened, with a subform:[DailyDSQry subform] populated by a Query. This form has a command button that opens another form: [NewDSLog] in "acAdd","acDialog". What I need is: when the [NewDSLog] form closes, the [DailyDSQry Subform] needs to requery/update so that it displays the new entry. I have tried the following in a command "CLOSE" button in form [NewDSLog]: docmd.Runcommand AcCmdRecordSave Me!Forms![Daily Log]![DailyDSQry subform].Refesh Me!Forms![DailyDSQry subform].[Query].!Requery doCmd.close but no LUCK.....Keep getting errors Any Ideas Thanks all, I do appreciate the help Enviva
View Replies !
Refreshing Form After Deleting From Subform
Hopefully a quick one, this. I have a form containing a subform, as a datasheet. The form displays the full details of whichever record I select in the subform. When I click on a button to delete a record that I've selected in the subform, it vanishes and the subform row that displayed it is cleared. I have a figure displaying the total count of rows in the subform (thanks to Ghudson for that one) and this also reflects the change. the form, however, still displays the details it previously did. As the last line in the code behind the button I have: [Forms]![form name].Requery however, when the code runs and hits this line, it displays a message that says 'Runtime Error 3167: Record is deleted' Without this line, the form doesn't refresh (obviously) and I get no error messages, but when I next select any row in the subform I get a message: 'Record is Deleted' and all the fields in the form display 'Deleted#'. Selecting another row fixes the problem. It seems pretty clear that I'm not refreshing the form correctly, but in spite of searching the forum and finding a fair few threads on this topic I can't work out the syntax I should be using. Hopefully, someone more knowledgable tham me can point me in the right direction.
View Replies !
Printing Report Without Refreshing The Form
Okay, here is the situation that is slowly driving me crazy.Form: Clients ACTIVESubform: Clients ACTIVE - closureReport: Clients ACTIVE - closure (created by a save as by the subform)My database was created to keep track of clients in a centre. The clients files are eventually closed by a checkbox. Then a number of reasons are inputted in as for why the file is now closed by means of a combo box (lost contact, graduated, etc). After the files are closed, the users want to print a simple one-page report that they can put in their manual (paper) file. I created a subform that allows the users to preview what will be on the resulting report. I also created a button that they can click to print the report.NOW for the problem,The report will not show the new information (closed checkbox = yes, reason for closure, notes about closure, etc). I can't refresh because then the client no longer shows up in the form as it only includes ACTIVE aka open files aka Closed=No.Here is my coding for the button that I have:Private Sub Closure_Click()On Error GoTo Err_Printable_Click Dim stDocName As String stDocName = "Clients ACTIVE - closure" stLinkCriteria = "[StudentNumber]=" & "'" & Me![StudentNumber] & "'" DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria Exit_Printable_Click: Exit SubErr_Printable_Click: MsgBox Err.Description Resume Exit_Printable_ClickEnd SubHELP ANYONE??? :) My only idea is to do this is something like where is matches the student numbers, refreshes the form, and prints the report. BUT no matter where I put the refresh or requery command, it doesn't work. It ends up printing a blank report as it can not find the student number in the ACTIVE form as the client is now closed.
View Replies !
Write Conflict From Refreshing Form.....
I have a form that runs a macro that refreshes by doing Goto Record Next Goto Record Previous which generally works fine. But if I change combo box values a few times I get the following error message (titled "Write Conflict"): Is this a refresh issue, or should I be looking for something else?
View Replies !
Refreshing A Form From A Second Form (not Subforms)
i need to be able to refresh the data on a form, when i click a button in a second form. the onclick events runs some sql that alters the data that form a is based on, then closes form b. The changes are not reflected on form a until the form is reopened or i use a button on the form a to refresh. is there anyway to achieve this? surely there must be an easier way than closing a form and reopening? thankyou.
View Replies !
Automatic Entries On A Form
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form. Can anybody point me in the right direction as to how this can be achieved Thanks DD
View Replies !
Automatic Population Of Fields On A Form
Hello, we are creating an input form to update a file in access. We would like to enter an order number and use that number to retrieve extra data from, a non access database. The extra data would be used to populate the fields in the access file.
View Replies !
Trying To Create An Automatic Payroll Form
Hello, I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system. 3 Total Tables. tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level. tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales. tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3 In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year. I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this. This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have =DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"). This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable. This also doesn't work, but gives you an idea of my though process. =DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work. I might be way off base on how to do this, but I am trying. Thanks for any help. Chris
View Replies !
Saving From A Form
I have a form "release_details" having fields date, version, cksum ,comments,labels, and is link to a table, it has a button "mai"l ,on clicking this button a new form is open which has a button "send mail" on clicking this a mail is sent and pops a message "mail sent".I need when "send mail" is click it should also save the fields of form "release_details" to the table. Thanxx
View Replies !
Saving From Another Form
I have a form "release_details" having fields date, version, cksum ,comments,labels, and is link to a table, it has a button "mai"l ,on clicking this button a new form is open which has a button "send mail" on clicking this a mail is sent and pops a message "mail sent".I need when "send mail" is click it should also save the fields of form "release_details" to the table. On "release_details" their is a button which saves the fields of it to the tabe having code DoCmd.GoToRecord , , acNewRec
View Replies !
How To Make Automatic Refresh / Realtime Form Datasheet
fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and allready use with multi user the problem is : I want to automatic refresh / realtime form datasheet, if the data allready changed, deleted or add new. I try to solve it with 1. timer event + requery but i thing it's not a good idea because if data not changes, the form will be allways requery. 2.I use winsock so every user change the data, the will be send an event and i use arrived event to refresh form datasheet. And it's not solve the problem again because prosedure save/add data is more slow than event send data with winsock. so guys , plx help me to solve the problem. thx Esugiawan
View Replies !
Saving Data On A Form
Is there a simple way to make sure all fields on a form are filled before the data is saved to the table? I looked into using thew IF is Null Then but for 30 fields that is alot of code. Does anyone know a easier way? Jim
View Replies !
Saving Record From Form
Hello, I have a form and I have a button so people can open records to load into the form. The problem is that whenever they close the form it updates the information in the table. How do I stop that from happening? I want the information in the table to update only when they hit the button I made (which works). And how do I stop it from loading the record when I open the form, or maybe I can specify to load a blank record instead, how do I do that? Thanks in advance!
View Replies !
Saving Form As Report
Hello all! I would like to have one stupid question, because I could not find any answer on this forum. I want save the Form as Report. I can do that from "Menu bar", but I want to do that from the code (VBA or Macro) without inputting the output parameters by users. Do you have any idea how? Many thanks. Krava
View Replies !
Saving Form Designs
Hi I have created a form which I would like to save, and use as my own template. This is because the form is linked, and when I try to make any structural changes to the database, I have to delete the link, start again, and then redesign the form. Is there anyway I can save the form, to use again, instead of starting from scratch? Thanks so much! Hayley
View Replies !
|
TRACKER
