Tracking Synchronization
Jan 25, 2008Is there any way in access 2003 or 07 to track when a database was last synchronized with any one of it's replicas?
It would be useful to know and be able to store this in a table.
ADVERTISEMENT
Combo Box Synchronization
Nov 13, 2004Hi
I'm totally stuck creating a form because I don't know how to set up my combo boxes. The database is about tiles and the forms for data entry to create an invoice with one combo box to hold the tile range eg: White, blue, etc. I want the second combo box to hold the details on the tile names of the range chosen in the first combo box. eg: if 'white' is selcted in the tile range combo box, then only the names of the white tiles should appear to be selected from in the 'tile name' combo box.I then have a separate field to display the price of the tile depending on the range chosen.
This is for some exam coursework and the guidelines specify that I'm not allowed to use VB or other code. Could someone please tell me how exactly I can sort this out so that the three are linked (2 combo boxes and the price field)?(queries?adjusting form properties?) All the details on tiles are stored in one table. Any guidance is greatly appreciated.Thank you so much.
-Camryn
Synchronization- Search Key Not Found
Aug 16, 2005We are running Access 2002 on Win2k. The database has been split into front and back ends, and synchronization occurs directly over LAN with 7 replicas. During synchronization I received a failure message "The search key was not found in any record. (Error 3709)."
I have tried several things found on Microsoft KB and other forums-- Compact and repair, removing indexes from memo fields, updated Jet and Microsoft Data Access Components-- but nothing has worked. Does anyone have any ideas on this one?
Thanks,
James
Internet Synchronization Error
May 23, 2007I have an Access 2002 database (about 120mb) which was replicated using Replication Manager (version unknown). It is set up to use Internet Synchronization. We use it on state government LAN and WAN as well as the Internet. It works well in most cases, but on a few computers we get the error "Http address not found" when synchronization is attempted. The address is indeed visible to those computers. We have determined that reloading Windows (XP Pro) will usually solve the problem at least for a while but when GIS mapping software is installed it reappears. More worrisome is that some brand new laptops with factory-installed Windows are showing the same problem, which means it could get worse as we upgrade equipment.
Has anyone else encountered this error?
Synchronization Between MS Outlook And MS Access?
May 22, 2012MS Outlook contacts to MS Access database table to get in,MS Outlook contacts to an Access database?
View 12 Replies View RelatedSynchronization Failure And Design Change
Apr 30, 2007Hello. i'm working with 10 replicas and a design master, but when i tried to add new tables and forms i get the message (Error 3492) " The synchronization failed because a design change could not be applied to one of the replicas" and after that, i cant synchronize anymore!!!
i don't understand what could be the problem.
thanks if anyone can help.
Synchronization Problem - Error 3709
Nov 7, 2007Trying to sync between a back end database and one of the replicas we use. Getting the error "The search key was not found in any record" Error 3709 while peroforming ISAM Seek.
Does anyone know how to find the offending record that is causing the problem? It's not related to an indexed memo field either. The only field that is indexed is the AutoNumber Primary Key field.
The only other option I see is to bring up both tables, manually input the differences, and create a new replica.
Thanks!
Forms :: Synchronization In Form With Subform
Jun 15, 2013I have created a form with sub-form and I would you tell me how I should do in order to screen data in sub-form transferred from main form. It looks like:
Main form
Employer
Client
Date_of_transaction
Number_bill_of_sale
Sub-form
Employer
Client
Greatness_of_order
Worth_of_transaction
It's about printed words. How should I do this properly?
Forms :: Subforms / Drop-down Box And Synchronization
Aug 30, 2013The subform, which is in datasheet view, contains two dropdown boxes, Country and District (1-n). I want the district dropdown to only display records based on what's selected in the country dropdown. There will only ever be any content in District if one country is selected (let's say country 'A').
I've used the code below (one of many attempts!) to try to achieve this, but it doesn't seem to have the effect I want. It seems that if I select country 'A' from the country dropdown, the District rowsource is as expected for that particular record. However, the rowsource for every other District in the list of records in the subform also now has the same rowsource even where the country <> A.Similarly, if I select <>A from Country, the rowsource fro every district is now empty, even if the country selected in another row is A.
Dim strSQL As String
strSQL = "SELECT DistrictID, District, DistrictOrder "
strSQL = strSQL & "FROM tblDistrict "
strSQL = strSQL & "WHERE CountryID = " & Me.cmbCountryID & " "
strSQL = strSQL & "ORDER BY DistrictOrder"
Me.cmbDisctrictID.RowSource = strSQL
Combo Box Synchronization Between Main Form And Subform?
Jul 17, 2005I have a main form with a subform. On my main form, I have a combo box set to "find a record on my subform, based on what I select in the combo box." This works great! At the same time, I want to use this main form combo box to synchronize with a combo box in the subform to display a value based upon the value selected in the main form's combo box. I have tried several things and searched Access newsgroups without success. I am using MS Access 2002, producing an Access 2000 database. Has anyone got any ideas? I could really use some help. Thank-You.
Denny G. :confused:
Design Master Reverts To A Replica After Synchronization???
May 15, 2006Hello I have a perplexing problem …
I have been using replication successfully for years. Recently the PC where my Design Master resided crashed taking the hard drive with it. No problems I thought, I used a replica to recover the design master and placed it on the new hard drive (the OS and Access was upgraded from 2000 to XP, however the Access 2000 file format was retained – there are still a couple of laptops with only W2000 software). I understand that moving the path of replicas or design masters is no no, so I proceeded to start from scratch and create a complete new batch of replicas based from the new design master.
Everything was going to plan UNTIL a replica was routinely synchronized with the design master. The design master reverted back to a replica. I recovered the design master again, everything looking fine until again a synchronization causes the design master revert to replica.
Next plan of attack to hopefully fix a potential corruption problem: create a new blank database, import all (non-system) tables, compact and repair, and create a new replica from scratch. From the design master, I created the complementing replicas and sure enough the Design Master again reverted to a Replica after a routine synchronization.
I repeated this “start from scratch” procedure, and the same results prevailed. I am at a loss especially since I verified that the hidden system MSysReplicas table had only two entries after the Design Master and Replica were first created.
I would greatly appreciate any ideas of where to go next with this problem.
Thanking you for your time.
Synchronization Of Database Setup And Form Design
Jun 7, 2013I have recently created a database meant for managing inventory. I have started writing queries and building forms, and a lot of it is running smoothly, but I am having a few snags.
To give a brief background, I am currently designing a form in which a user will fill out when an incoming part comes into our company. The form NEEDS to ask the user for at least the PartNumber and the PONumber, but the way I have my relationships set up, I am not exactly sure how to design the forms (not the physical layout, but where the data goes). So when I have an incoming part, will I use the PartPOID to figure out which part number and PO number it is? I am not exactly sure how to make a form for the user that is not confusing.
Attached is a picture of my relationships and my database.
New Compressed (zipped) Folder.zip
General :: Calendar Synchronization - Access 2010 To Outlook 2010
Mar 23, 2015I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?
Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.
Training Tracking
Sep 1, 2006Does anyone have a sample training tracking system / database they'd be willing to share?
Or, barring that, can someone point me in the direction of where I might find one?
Thanks in advance! Looking forward to it!
Tracking Training
Sep 12, 2006Does anyone have a sample training tracking system / database they'd be willing to share?
Or, barring that, can someone point me in the direction of where I might find one?
Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there.
All replies are gretly appreciated!!
Tracking Training
Jan 4, 2007I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this.
My tbls are as such,
1st Table:EMPLOYEEtbl
EmployeeID
EmployeeName
(Other information)
2nd Table:CLASStbl
className
classID
3rd Table:CompleteClasstbl
EmployeeID
classID
DateTaken
What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?
Equipment Tracking Db
Dec 31, 2007I need help finding an existing or making a db. This db does not have much to it, so I am getting frustrated finding/making one.
My company has equipment that is stored in one of three places, customers, trucks of employees, and other(like warehouse, or out for repair). The db should be able to give me a report of where everything is on a given day, and a report of what was in a given customers property during the job(this is not for a single day, but for the duration of the job).
If someone knows of an existing db like this, I would appreciate a link. If you want to help, it is appreciated. At this point I would not mind paying someone to do this for me, as long as it wont cost too much.
Bug Tracking Solution
Feb 12, 2008Hi,I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.It may or may not be commercial software.If anyone knows of such an available solution, please let me know.(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)thx
View 5 Replies View RelatedNeed Better Tracking With My Tables
Oct 19, 2005I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure:
Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text
If more info is needed please let me Know.. Thanks in advance.
Scott
Tracking Changes To Database
Mar 26, 2008Is there a way to track changes made by different users to access tables? For instance if several users update or change data in various records is there a way to track when and what was changed (before and after data)?
View 1 Replies View RelatedTracking Updates
Sep 22, 2006I have read all of the audit trail stuff and searched on my subject but I think my solution could be simpler,
All I want to do is copy the values of the current record on my form into a history table with all the same fields.
Example Form:
[ID], [Machine], [Task], [Task Due], [Task Complete]
I want to put a button on the form that reads complete task and when the user pushes the button it copies all of the details for that specific record they are looking at into my History Table that contains all of the same fields.
This will give me basic history on when each task was completed for a machine and I can access for reporting
Tracking Database Help
Oct 10, 2007I consider myself an intermediate ACCESS user and can get around it with little trouble with the help of the internet and the help file.
I am trying to design a database that is fairly simple in design, it is for tracking the status of documents at our work center. Basically we have personnel reports that are passed around the different people and different dates.
I have a main form that has the info on the person along with dates that it is due.
Then a sub form that has the date sent and where it went to.
My problem lies in that I want to keep track of the whole history of the document but when i print out a report or export the data to excel to put up in powerpoint I need to have just the most recent date sent only item.
I have 2 tables one with user info and another with the routing info with its own primary key along with a identifier key to link the primary and sub form.
Of course it is easy to create a report with the data to show all the different routing steps but not just the one with the most recent date.
Thanks in advance for the help.
Bug Tracking Solution
Feb 12, 2008Hi,
I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?
My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.
It may or may not be commercial software.
If anyone knows of such an available solution, please let me know.
(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)
thx
Question-Database Tracking
Nov 12, 2005I would like a field on my main switchboard that displays the last time the database was modified.
Simple question, and I can not find an answer anywhere.
Thanks!
Anyone Try Tracking Org Charts In Access???
Jul 6, 2006I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???
View 1 Replies View RelatedTracking Employee Training
Aug 18, 2006I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:
View 3 Replies View Related