Microsoft Access - Recalling data on a form for editing
Asked By Bob on 16-May-12 04:03 PM
When a blank form opens (automatically) for entry of the next record, I want the user to have the option of calling up another record, in case it needs to be edited. The "search" and "go to" buttons do nothing: the data flashes in the fields, and then instantly disappears. I really cannot believe that Access provides no simple way of searching for a record and showing it in the proper form. So I assume I'm missing something very basic. What is it? Thanks, Bob
Bob replied to Somesh Yadav on 17-May-12 12:32 PM
I'm sorry, but I cannot accept your answer. The people at Microsoft are not fools. There has to be a simple answer to my problem. The "go to" and search" buttons are not working, which suggests that I have done something wrong with the controls, perhaps. It should not requre programming to make them function. Nor should it be necessary to add code to make the data appear in the fields. Where is Pat Hartman?
Bob
wally eye replied to Bob on 17-May-12 10:37 PM
Have you tried puttting a button on the form, and tying it to a macro that toggles DataEntry mode:
Private Sub btnToggleDataEntry_Click()
Me.DataEntry = Not Me.DataEntry
End Sub
Once you take dataentry mode off, you should be able to filter or change the recordset as needed to find the desired record.
kalpana aparnathi replied to Bob on 20-May-12 06:50 AM
hi,
Try below example Code:
Dim intResponse
intResponse = MsgBox("Login another sample with same data? Clicking No will create a new blank record, click Cancel to quit login.", vbYesNoCancel)
If intResponse = vbYes Then
'code here to continue login of new record with same data as previous record
ElseIf intResponse = vbNo Then
'code here to continue login with blank record
Else
'code to quit login such as DoCmd.Close acForm, Me.Name, acSaveNo
End If
Regards,
Pat Hartman replied to Bob on 20-May-12 04:29 PM
When you open a form in DataEntry mode, the recordsource is limited to only those records you have entered since the form opened. Once you close the form and reopen it, the recordsource is empty again. That's why the search won't work.
If you want to use a form for both edit and add, it is better to not use DataEntry mode. Instead, open the form normally. Let the user use the search features to find a particular record or use the * on the scroll bar to go to a new record. If you prefer, you can add a New Record button.
Bob replied to Pat Hartman on 20-May-12 05:38 PM
Thanks, Pat. As usual, your answer responds directly to the question, and helps me (us) understand better how Access works as a program and product.
am developing a form using microsoft access .in access am using controls.label, textbox, commandbutton.now am give some input data from the textbox
How can I put photos in Microsoft Access Form DataBase
I used the information BobLarson said in putting photos in Microsoft Access Form but it is not working. My computer keeps asking for Form1, which I deleted because can do this procedure. And how can I get my computer stop asking for Form1. Access Forms Discussions Access 2007 (1) Office (1) Application.FollowHyperlink (1) Database (1) Report (1) BobLarson (1) ActiveX (1
I had to use the following code in order a bmp file and 'activate' it, so that other users, when they open the pertinent form or report, would see the inserted signature. I found the solution for doing that online Me!VoucherStatus.SetFocus In the past, I've just left the image control on the form or report rather than inserting it. If there is nothing to display, just set .visible image path as necessary. It's not a static graphic file that is on the form and report. Rather, whichever user created and signed the voucher, that's whose signature needs I don't know that I have an answer to this. keywords: Outlook, SetFocus, SendKeys, Microsoft Access, Otherwise, database, report, image control, bmp file description: SendKeys in Microsoft Access I had
I have two linked tables, one representing an initial close) value, based upon separate counts at the two points in time. On the input form for the second phase / table, I would like to have the original count field appear a query to find and display the first number, or is there a feature of Access that will automatically display a field from another table on a form (based on a different table)? If I have to make my own query (easily done running the query in the background and drawing the result into the field on the form? Thanks, Bob Hi refer to the below links. http: / / office.microsoft.com / en-us / access
New Microsoft Access Database.zip I have An Attech Data Sample Please Solve My Problem Are you offering problem. I gave you a solution in your other post on the topic keywords: describe, Microsoft Access, Custom Report, Microsoft description: Custom Report Based On Form New Microsoft Access Database.zip I have An Attech
Adding PowerPoint slide to Access Form DataBase
How do I add an interactive PowerPoint slide to an Access Form (this will be on my switchboard)? Access Modules DAO Discussions PowerPoint (1) Douglas J. Steele (1) Microsoft Access (1) Access Form (1) Doug Steele (1) I do not believe it is possible. - - Doug Steele, Microsoft
Hi, How to add filter control to listbox in a form in access, just as we have filter options in an access table or excel sheet? Any DB examples or URLs would be great on this topic design view, and add Categories.CategoryID to the grid. Save, and close. • Create a new form , not bound to any table or query. • Add a list box from the Toolbox. (View
Hello I need to create a txt file from a form. I found the code I can use to do this simply enough. DoCmd.OutputTo acOutputForm something like this (all data before ":" is the name of the txt box on the form. CIN: 123456 123457 123458 123459 NDC: 123455 123456 123457 123458 Type: Item Add Priority: Immedate Close The data is not stored in a table. Its in text boxes on an Access form. I also dont get this line at all TextFile.writeline ( "C: \ softjuke \ files \ " & rst!songid
I am using the following in a query in Access, but it is not working [tbl_one]![tbl_one_F1] = [Forms]![frm_Construct]![TabCtl66]![1st_Stage]![txt_name] where, frm_Construct is the name of the form. [TabCtl66] is the name of the Tab Control [1st_Stage] is the name of the 1st WorkbooksOffice, Excel, Page, EventArgs, module description: Referencing a Textbox in a Tabbed Page in an Access Form I am using the following in a query in Access, but it is not working
I have a form that I was able to scroll up and down the form but for some reason the scroll bars are no longer showing. I did check the properties of the form and the "scroll bars" are set to both? Any idea why they are no longer visible? My gut reaction would be to say. . . Make sure the form is set to "Auto resize = Yes" and the detail portion of the form is set