General :: Sync Tables When Connect To LAN
Nov 24, 2012
I want to make a database on my company server. There will be two tables. "Customers", and "Visit to customers".
There are 5 sales managers in my company and i want them to collect information about customers on the field.
My question is:
How to sync Customers and Visit tables from laptops with Customers and Visit tables on the server?
Can i do it over internet or i can make a button that will sync tables when sales managers come to the office and connect to lan?
View Replies
ADVERTISEMENT
Dec 1, 2013
I am using SharePoint 2010 lists as my tables in my access file.the users sometimes have no access to the sharepoint and I want them to sync their tables to sharepoint later once they do have access to the web.I have no problem doing it on the regular access file, but when I'm using the access runtime, I don't have the option to sync the tables after working offline.
View 1 Replies
View Related
Dec 11, 2014
I am creating an application that is using Access as the front-end for data entry, some manipulation, etc. In the example, my guys will get a ticket and then stamp that ticket with times of when things are done. The way I'm doing it now is that I have a second Access application that is working as the synchronizer. It just sits in the background and syncs the data.
The issue I'm having is that the guys are on mobile devices so if/when they lose connection to the database (they are constantly moving in trucks), Access doesn't do a great job of reconnecting to the tables, even if you drop the tables and re-add them. I've attempted to close the sync app from the main app and then re-open it but this just results in the sync app being in the foreground and I need something that sits in the background and is hidden.
View 8 Replies
View Related
Aug 16, 2012
We have been using a shared database (on the server and it's not spilt) that was converted to MDE file and was created in Access 2003, without any issues for more than 5 years now.
Since we upgraded our office to 2010 (and access 2010) all the sudden the autonumber field starts generates a number that is about 40 to 50 records less than what is should generates. All the records for the missing 40 to 50 numbers are still there and we can search them.
The only work around is to run the database and open a new data entry form (at which time the autonumber field will generates a new number) then close the form, and we keep doing that until we reach the number that should be generated next.
View 4 Replies
View Related
Nov 2, 2012
I have the following function which works well except when I want to run a search using date range and any other criteria on another text/listbox or combo box.
This is work i get in the immediate window (Where Status, TypeID, PurposeID are the other criterias used with the date range.):
Code:
WHERE ([Incident_Date] Between #02/06/2012# AND #02/06/2012#)[Status] LIKE '*Active*' AND [TypeID] Like '*1*' AND [PurposeID] Like '*2*'
And the Build Function is as follows:
Code:
Private Function BuildFilter() As Variant
Dim varWhere As Variant
Dim strField As String 'for the date field
varWhere = Null ' Main filter
[Code] .....
View 3 Replies
View Related
Sep 28, 2013
I am just starting out learning how to connect Access to Excel. From an Access form, I need to connect to an Excel spreadsheet, and loop through every row/column to look for data that matches a database field data, then populates the associated cell data. I don't want to import the spreadsheet since the user who created it is using it manually, and I am attempting to automate the task. This is probably the most elementary code, but I would like to start out with the best way to do this. What I am finding is code that appears to be much more complicated than I need, for more complicated situations.
View 2 Replies
View Related
Dec 18, 2013
I 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".
After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.
View 7 Replies
View Related
Feb 23, 2005
Hello,
I am really stuck - I have a form of companies with a subform of contacts.
In the DB (SQL) the tables are related one to many CoKey to ContactCoKey.
How do I synch these so any new contact record automatically gets a "new" ContactKey as well as the related ContactCoKey?
Thanks,
View 1 Replies
View Related
May 31, 2005
Hi Gang,
I am using Access 2000.
I have a Main form that displays a sub-form. On the sub-form is a image box that displays a jpeg associated with the current record. The jpegs are stored outside of the db as links and the links are stored in a table in a field called Image1Lrg_Path. Due to the GUI design the image box is a set size = 4cms X 5cms.
On the sub-form I have a cmd button that when clicked should open a seperate pop-up form that *should* display a large version of what ever jpeg is being displayed on the sub-form. The user would then have to close this pop-up to return to the db in order to continue scrolling through the records as normal.
Main Form = frmPlant_Main
Sub-Form = frmPlant_Sub1
Sub-Form Control = Garden_Sub
Image Box = Image1
pop-up form = frmLargeImage1
pop-up Image Box = Image1Lrg
Here's my problem:
If I set the pop-up form up a normal form and have a linked control on it (to display the image) and a text box (in which to type in the image path and name) and a cmd button that, when clicked, sets the image box to the value of the text box. Then this all works great, what ever jpeg file name I type in the text box, providing it exists of course, is displayed when I click the command button. Iset it up this way first as a test to see if I could get the image displayed OK.
Just for reference, here is the code I use for the command button;
-------------------------Code Start---------------------------
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Me!Image1Lrg.Picture = Me!Image1Lrg_Path.Value
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
----------------------Code End--------------------------------
Now, if I try to link the pop-up to the image being displayed in the sub-form Access throws up "Can't find the form" errors.Just while I set this up, I am using the cmb button to set the path but in the final db I will want the pop-up form to select what ever jpeg is being displayed on the sub-form as its path.
Can any one suggest how I can get this to work?
Again, for reference, here is the code that I am trying to use when linking the image in the pop-up with that shown on the sub-form;
-------------------------Code Start---------------------------
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Me!Image1Lrg.Picture = Forms![frmPlant_Main]![Garden_Sub].Form![Image1_Path].Value
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
----------------------Code End--------------------------------
My grateful thanks in advance,
Kenny
View 2 Replies
View Related
Jan 18, 2006
Hi,
My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,
Thank-you for your help in advance, and i apologise for such a lengthy post!
Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.
Chris
View 6 Replies
View Related
Mar 14, 2008
I need the same database as managed and unmanaged in repl manager, I think.
My replica set got scrwd up and now I need to re add an unmanaged replica.
Previously the map displayed a scheduled synchronization line to the replica not managed by synchronizer.
I can add the unmanaged replica, but how do I add the synchronization line?
Do I need the same replica added to the map 2x? 1 managed and the other unmanaged?
i tried uploading 2 bmp files to show the way it was and is now but i dont see them, how do u add bmps to post?
View 1 Replies
View Related
Oct 13, 2005
Hi
Could someone help with showing me how to sync a DSUM to a record as i am currently summing all the records instead of the ones i need?
Thanks
View 12 Replies
View Related
Mar 16, 2006
Does anyone have any idea how to sync two forms so that I can create one record in a table from the pair of them.
I have a form which is so big that I have had to place a continuation to a new form on it. However, when I move to the new form, the data is placed into a new record instead of continuing on from where it left off.
Someone please help
Regards
Jason
View 2 Replies
View Related
Aug 27, 2006
I have a table with fields ID, NAME, ITEM, QUANTITY and DATE_IN. I have a query "qry_Logged_In" based on the table. I then have a form based on the query.
I created a combo box as a "go to record" selector and used the following Row Source:
SELECT DISTINCTROW qry_Logged_In.ID, qry_Logged_In.NAME, qry_Logged_In.ITEM, qry_Logged_In.QUANTITY, qry_Logged_In.DATE_IN FROM qry_Logged_In ORDER BY [ID];
On the After Update proceudre I have the following code:
Sub Combo135_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo135]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
It works fine, but one thing I would like is that as I toggle through records using the record selector (forward/backward) buttons, I would like for the record number in my combo box to also change keeping in sync with the record number. Unfortunately, it currently stays to the number I last selected in the combo box.
Any suggestions on how to make the record number showing in my combo box to change with the record number?
Thanks,
Jim
View 7 Replies
View Related
Feb 25, 2008
I have a Tabbed form where one of the tabs shows about 20 rows of a table. Another tab shows a single record from that table with all the fields for that record.
I want to be able to move from tab to tab and and stay on the same record (hopefully that's clear).
What is the cleanest approach... any suggestions?
Thanks
View 12 Replies
View Related
Feb 23, 2006
I have written a VB.net application that uses an Access database. I have a table that displays the following information.
Customer Name
Customer Phone
Customer Address
Shipping status
Now in my vb.net application I am displaying these 4 things in a data grid. But here is the problem. The shipping team updates their database daily with the new Shipping status. So to get the latest shipping status I created a linked table, lets call is link_shipping. Now All I have to do is somehow get the shipping status field from link_shipping and update the respective table in my database with this info.
To do this I created a query. but now I am having to manually go into my database and run this query to make sure the shipping dates sync up. How can I do this in a better way. The only thing I can think of is to find some way to automate the running of this query every day. But I dont know how to do this. Can anyone suggest anything here.
View 3 Replies
View Related
Jun 25, 2014
Yesterday my work's IT department moved a network drive to another location. The old location still worked as read-only. I have two Access databases: One contains the tables and the other contains the forms and queries, and has links to the tables in the other files. In order to avoid having to use the linked table manager every time I move the databases, I use the networkaddress notation instead of drive letters, such that the database with the linked tables was pointing to the old, read-only location. I deleted the linked tables and relinked to them using the new location, and noticed that there was a discrepancy of 30 records I had entered through the forms not showing up once I linked to the tables in the new location.
It was clear that the database I use to enter data never actually inserted those records into the linked tables, but still acted as though it had in that it showed all records. Once I deleted the linked tables and linked to them again, those records completely disappeared. What's odd to me is that I'd entered these data into the database over a week ago. Why does Access take so long to synchronize the data between the linked tables and the actual tables? Are there any settings I can change to make sure the data are synchronized when I exit the application? Is it the ODBC refresh interval? If the default is 25 minutes (1500 seconds), does it mean that the data are never synchronized if I don't keep the database open for at least that long?? This is really puzzling.
I was able to go back to the old network location and get the old database showing all the records it's supposed to have. I had it import the linked tables as local tables and it looks like the local tables contain all records. This is not an ideal solution, but at least it seems like I recovered all the data.
View 6 Replies
View Related
May 7, 2015
I have an application that is using SQL Express as a backend and syncing to a SQL database through SQL web synchronization. This all works great and my clients have my custom application to interface with their local database and do work and it syncs back to the corporate database and I've got it scheduled to run in Windows every minute. What I would like to do is have a button or on event set of code that forces that sync pairing to run and I'm not exactly sure how to do that.
View 3 Replies
View Related
Oct 15, 2014
I have a normal Access table. The first column is ID and is the primary key. The second column is a text. The table consists of two records and is sorted in ascending order. First comes the data set with the ID 1.
Sub test()
Set rs_access = CurrentDb.OpenRecordset("tab1")
rs_access.MoveFirst
MsgBox (rs_access.Fields("id").Value)
End Sub
The message box shows 1. So everything is fine. Now I sort the table descending. But I get the same message. Why? Appearently the recordset doesn't know that the table was modified. The recordset should register that the table is modified.
View 1 Replies
View Related
Jul 14, 2006
Hey Guys,
I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address.
I understand how to sync a combo box to an option group ( -- great article by the way)
I Guess what I'm looking to do is:
1. Sync a "Same As" Checkbox to multiple text boxes in the form (Unit, StreetAddress, City, Province, Postal) such that these fields are UPDATED (writen to) with the same information as the billing address
2. [U]IF the "Same As" Option is selected, I need the updated fields to lock, allowing no further update... but must by unlocked if the "Same As" option is NOT selected.
Please help me out with this one guys.. I really need it.
View 2 Replies
View Related
Feb 17, 2015
I have tblEmployees for employee info
tblEmployeeAbsences for employee absences
tblVacation for employee vacation info
While entering the employees hours I want an adjacent subform to show the matching employees absence and vacation days taken if any.My approach was to use a Cartesian qry for the record source for the subform and link it with a fake key from the main form.
View 3 Replies
View Related
Aug 29, 2012
I have a main form and four subforms all of which were created from the tables without queries. The main form pulls employees personal data (never changes). The subforms pull Events attended, Lodging at the event, Family that attended the event and Employee minutia which changes per event. I'd like to have a button on the main form that changes the records in view for all of the subforms at once. This way it is easier for the users and I know that I am view all the pertainent info for event A instead of viewing event A's lodging info with event B's family info.
View 3 Replies
View Related
Apr 14, 2006
what options do i have to connect to my database if back end of my db is in newyork and front end is in washington. how do i connect to my db??
View 1 Replies
View Related
Jul 28, 2014
I have a main form with multpile tabs - each tab containing a different subform.
Link Master Field: ClientID (field in Master Form)
Link Child Field: Client ID (field in all subforms)
There is another field that all the subforms (continuous type) have: ObligorName. All the subforms are based off of a huge table (subtable) with fields: Obligor Name, Address, Zipcode, City, DOcuments Required, Bank Account Number, etc......
Essentially, the user will fill in the 10 obligor names associated to ONE client on the first subform on the first tab + address + zip code + city.
When the user clicks on the second tab to fill out the next subform, I want all 10 obligor names to be there already, so then they can fill out Documents Required + BAnk Account Number.
If I fill out the first subform and then exit out of the form and then reopen it, the other subforms autofill.
HOWEVER, I dont want to have the user have to do this. It wastes a lot of time. What can I do about this so that the table is automatically updated right away. They are all based on the same table so I do not see why there is so many issues.
View 14 Replies
View Related
Oct 29, 2007
Hello my helpfull friends,
I am going to build a multi-user database with the tables en queries stored on a server. So I will deploy multiple front ends.
Here is my question:
What is the best way to connect to the BE?
Should I link the backend using the linkingmanager (bound to a recordset) of access 2007
OR
should I interact with the data in the backend using undbound form using a disconnected recordset
OR using SQL
I would prefer the first option because it's the easiest way.
But what do you guys (and girls) recommend?
View 7 Replies
View Related
Mar 9, 2006
I tried referencing a table in my Access DB that held my login id and password info but it didn't work. How can I make it work?
ODBC;DSN=DB2Q;UID=[Table].[UserID];PWD=[Table].[Password];MODE=SHARE;DBALIAS=DB2Q;DISABLEKEYSETCURSOR=1;DIS ABLEUNICODE=1;IGNOREWARNINGS=1;
View 8 Replies
View Related
