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 Complete Forum Thread with Replies
Related Forum Messages:
Automatic Refresh
Hello everybody, I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this? Thank you very much.
View Replies !
Make A Datasheet Larger
I have copied and pasted some data into a table from Excel but Access wont let me add in any more data to the table - a notice comes up saying "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data". How can I add my extra information to the bottom of the table?
View Replies !
Realtime Clock
I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?
View Replies !
Realtime Data
I am trying to update an Access 2000 Database used by our Shipping Dept. The Shipper currently runs 3 Queries to populate 3 local tables with data from a SQL Server 2000 database used by our production process, he then will run another query that populates another local table with the data from the 3 local tables. His next step is to open a form where he scans a barcode from a label on the finish material tote to field #1 that is a Select Query. This allows for minimal scanning in the load makeup routine. The problem is that the data is not realtime and he must periodically refresh the tables. I need to find a way to use the linked tables to provide near Realtime data. (Existing Barcode field1) SELECT DISTINCTROW ProductionTable.BatchNo, ProductionTable.CmpdNo, ProductionTable.Recipe, ProductionTable.CustomerID, ProductionTable.Gross, ProductionTable.Tare, ProductionTable.Net, ProductionTable.expires, ProductionTable.PartNo, ProductionTable.PONo FROM ProductionTable ORDER BY ProductionTable.BatchNo; (Trial 1 – It Works for 1 production line only) SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo; (Trial 2 – Does Not Work) SELECT DISTINCTROW dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo, dbo_Mixed_Material_Batchoff4.BatchNo, dbo_Mixed_Material_Batchoff1.CmpdNo, dbo_Mixed_Material_Batchoff3.CmpdNo, dbo_Mixed_Material_Batchoff4.CmpdNo, dbo_Mixed_Material_Batchoff1.Recipe, dbo_Mixed_Material_Batchoff3.Recipe, dbo_Mixed_Material_Batchoff4.Recipe, dbo_Mixed_Material_Batchoff1.CustomerID, dbo_Mixed_Material_Batchoff3.CustomerID, dbo_Mixed_Material_Batchoff4.CustomerID, dbo_Mixed_Material_Batchoff1.Gross, dbo_Mixed_Material_Batchoff3.Gross, dbo_Mixed_Material_Batchoff4.Gross, dbo_Mixed_Material_Batchoff1.Tare, dbo_Mixed_Material_Batchoff3.Tare, dbo_Mixed_Material_Batchoff4.Tare, dbo_Mixed_Material_Batchoff1.Net, dbo_Mixed_Material_Batchoff3.Net, dbo_Mixed_Material_Batchoff4.Net, dbo_Mixed_Material_Batchoff1.expires, dbo_Mixed_Material_Batchoff3.expires, dbo_Mixed_Material_Batchoff4.expires, dbo_Mixed_Material_Batchoff1.PartNo, dbo_Mixed_Material_Batchoff3.PartNo, dbo_Mixed_Material_Batchoff4.PartNo, dbo_Mixed_Material_Batchoff1.PONo, dbo_Mixed_Material_Batchoff3.PONo, dbo_Mixed_Material_Batchoff4.PONo FROM dbo_Mixed_Material_Batchoff1, dbo_Mixed_Material_Batchoff3, dbo_Mixed_Material_Batchoff4 ORDER BY dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo, dbo_Mixed_Material_Batchoff4.BatchNo; (Trial 2 Does Not Work) SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff3.BatchNo, Dbo_Mixed_Material_Batchoff3.CmpdNo, Dbo_Mixed_Material_Batchoff3.Recipe, Dbo_Mixed_Material_Batchoff3.CustomerID, Dbo_Mixed_Material_Batchoff3.Gross, Dbo_Mixed_Material_Batchoff3.Tare, Dbo_Mixed_Material_Batchoff3.Net, Dbo_Mixed_Material_Batchoff3.expires, Dbo_Mixed_Material_Batchoff3.PartNo, Dbo_Mixed_Material_Batchoff3.PONo FROM Dbo_Mixed_Material_Batchoff3 ORDER BY Dbo_Mixed_Material_Batchoff3.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff4.BatchNo, Dbo_Mixed_Material_Batchoff4.CmpdNo, Dbo_Mixed_Material_Batchoff4.Recipe, Dbo_Mixed_Material_Batchoff4.CustomerID, Dbo_Mixed_Material_Batchoff4.Gross, Dbo_Mixed_Material_Batchoff4.Tare, Dbo_Mixed_Material_Batchoff4.Net, Dbo_Mixed_Material_Batchoff4.expires, Dbo_Mixed_Material_Batchoff4.PartNo, Dbo_Mixed_Material_Batchoff4.PONo FROM Dbo_Mixed_Material_Batchoff4 ORDER BY Dbo_Mixed_Material_Batchoff4.BatchNo; Anyone have any ideas? Many thanks in advance to all responders Bob
View Replies !
Hiding Columns Realtime In Subform
Hello! The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have. I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.
View Replies !
Update / Refresh A Form Upon Entering Data In A Popup Box / Form
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple. ************************************************** Scenerio: I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry. Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen. Million Dollar Question: How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form. ************************************************** Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool: Thank You
View Replies !
Refresh Form
I have approximately 20 people using a shared database form. When someone updates a form creating a new record I want everyone to be able to see that new form record without having to close the form down and reopening it. Each form is given a form number by autonumber. Thanks in advance!
View Replies !
How To Refresh A Form
What is the best way to refresh a form that has check boxes, list boxes, and text fields ? The table used as source was cleared, but the form was not.
View Replies !
Refresh Form?
I wrote some procedures which handles each a seperate unit. When a procedure finishes, I want to write an entry to listbox 'lbLogbook' so the users sees what's happening. But the entries in the listbox only appears when all the procedures are finished. When I go into break-mode and go step-by-step then I see the listbox filling up. Do I have to manually refresh the form or so? Regards, Johny
View Replies !
Form Refresh
Hi, I am having a crazy situation. I have a form (f1)which has 2 sub forms. this form is getting called from another form(f2). When f1 gets loaded , its subforms will have a set of data, and when i want another set of data to be visible or refreshed it is not happening on the subforms. we have tried. form.refresh form.requery and also f1!subform.form.refresh & f1!subform.form.requery. What is it that is not allowing to refresh the data on the subforms. Please Advis.e hari
View Replies !
Refresh Form From Report
I have a report that, when closed, I would like to refresh the main form, or subforms in it (Whichever is easier) Main form: frmMain Sub form A: subWebLCSel Sub form B: subWebPartSel Report: rptLabels I tried: forms!frmMain!subWebLCSel.form.requery- told me it cant find the field subWebLCSel Forms!subWebLCSel.Requery - tells me it cant find the form subWebLCSel Any ideas?
View Replies !
Refresh Main Form
Hi I have a sub form and a button on the main form that needs to be pressed to refresh the data in the main form after data has been entered into the sub form. Is it possible to have the main form refresh on exit from the sub form field automatically without having to press the button?? Could i hide the button and run a bit of code that runs the refresh button on the main form on exit from the subform field? thanks in advance
View Replies !
Form Refresh Problem
I have a form with linked fields. If I keep this form open and I input the data in the linked table using another method, but not the form, the form is not refreshed. I would like to add a button to the form that refresh the form with the new data, but I dont` know any functions or VBA code that can do that. How can I solve this problem? There exisist any refresh form function/method in VBA? Thank you in advance!
View Replies !
Form Page Refresh
Hi, I have one main form, inside it there are 5 pages, is there any code I can use so that when I go between pages the data is refreshed. e.g. I have a "fault" page where I log a call, then an "open calls" page where the calls go, however I have to close the form and reopen it for the data to appear!
View Replies !
Sub Form Navigation After Refresh
After a refresh of the sub form, I want to go back to the last record edited. This might be a record not fitting on the top of the screen, let's say record no. 2000. After the refresh the sub form shows the first records, and you need to scroll down. How to solve this?
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 !
Refresh A Different Form On Close
HI basically i have a form which dislays records in a continous list, then an add button which adds records to the list. to view the newly added records you have to close the form and open it again. I have inserted a refresh button but what im after instead is when i close the 'add form' it refreshes the list form. Below is the code for the refresh button could someone tell me what i need to add/change to make it refresh a particular form on close? Private Sub Command45_Click() On Error GoTo Err_Command45_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Command45_Click: Exit Sub Err_Command45_Click: MsgBox Err.Description Resume Exit_Command45_Click End Sub Thanks for any help
View Replies !
Refresh Form Fields
Hi I have a query that picks up 2 dates from 2 fields in a form. If I change the values of the fields the Query picks up the old values. I have tried Requery and saving the Form programatically prior to running the Query, but the only way I can get the Query to use the latest field values is by closing the DB completely and then opening again. ViRi
View Replies !
Refresh A List Box From Another Form.
Currently I have a Tabular view List (of text boxes) populated from a query. What I am looking for is a way to refresh the list. I presumed me.refresh, me.requery or me.repaint would work, but it doesn't. If I open, then close the list it refreshes. So presumably I could close then open form for an update, but that is crude and there must be a way to do it properly? The user navigates between two windows (client list *name and age*) and (Client info *in depth info and history*) they click on a record in the list and are taken to (client info) whereupon they can edit or add a new record. The records that are updated do so without a hitch, however the new records do not update in the list. Paul
View Replies !
Refresh Form Data
I just realized why I wanted to stop using Access long ago...anyway here's my problem. I have two tables: table1 and table2 (I know,creative). Anyway, table1 is linked from another database, table2 is local to the open database. I use table2 as a temporary table to hold data from table1. table1 is then set as the datasource of one of my forms. I have a button which is used to refresh the data. Basically, it deletes everything in the temp table (table2) and inserts data from the linked table (table1). When I do this, the rows in my form then all contain #Deleted, but it never refreshes with the new data after I have inserted it. I've tried using the Refresh, Requery and even Repaint methods. Still no luck. Then, I clicked Remove Filter from the toolbar and the new data appeared, but I don't have any filters in place. So then I tried to do this programmatically by setting the subform (I'm using subforms ) Filter = "", its FilterOn to False and its OrderBy = "". Any suggestions? Cheers
View Replies !
Populate A Datasheet And Extraction Of Data From Datasheet
Hi, There is a requirement for 1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented? 2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet. Pls let me know. Thanks, Savita
View Replies !
Datasheet Different Than Form
hello, I'm working on someone elses database, and I'm not too familiar with access. He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics. The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update: However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description. Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view. Any help would be greatly appreciated. Thanks
View Replies !
Refresh Form When Click Out Of A Specific Box?
I have a refresh button next to a box in my form. I would like to make it so that when someone clicks another field or out of the key box it will refresh the form automatically because that box makes other fields autopopulate and the way I have it set up thus far is that you half to refresh the form somehow to get that date to come over. How do you like that run on!?!?! :p Thanks for any help!
View Replies !
Refresh A Differnent Form On Close
HI basically i have a form which dislays records in a continous list, then an add button which adds records to the list. to view the newly added records you have to close the form and open it again. I have inserted a refresh button but what im after instead is when i close the 'add form' it refreshes the list form. Below is the code for the refresh button could someone tell me what i need to add/change to make it refresh a particular form on close? Private Sub Command45_Click() On Error GoTo Err_Command45_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Command45_Click: Exit Sub Err_Command45_Click: MsgBox Err.Description Resume Exit_Command45_Click End Sub Thanks for any help
View Replies !
Refresh Pivot Table In Form
I'm trying to use a PivotTable Form (in Access), in order to automate a process (previously data was exported to Excel and the pivot table was created manually). I've got my pivot table form working fine but I need to provide the user with a way to refresh the Pivot table - i.e. re-run the underlying query. In Access Help it says to select design view and then click the Refresh button (the one with the big red '!' icon). This does work and the data is updated but it's not a user friendly option. Opening the form doesn't automatically refresh the pivot either, so does anyone know a way I can provide a button with VBA code or whatever to manually update the pivot so it reflects changes in the underlying data?
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 !
|
TRACKER
