Sync MS Access Table with MySQL Table in a existing Form

€8-30 EUR

Tamamlandı

İlan edilme:

yaklaşık 8 yıl önce

€8-30 EUR

Teslimde ödenir

Project based on a MS Access Form in which the user can add/edit Events and plan rooms. All entrys are in one MS Access Table. The MySQL table is totaly the same as the Access excepting the Date field. If the user change or add an event every changes should assumed in the MySQL table(which is connected via odbc). Other way to solve the Problem is to use only the MySQL as the only keytable and exclude the Access Table. The problem is here that the functions in the form expect an integer for the Date and in the MySQL it's a date.

Microsoft Access

MySQL

Proje No: 10389769

Proje hakkında

9 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 8 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you would like to Sync Access Table with MySQL Table in an existing Form or you would like to link the MySQL Table directly to the form so that user can enter data directly in MySQL table. I have 6 year's experience designing and developing Microsoft Access Application with advance knowledge of SQL and VBA. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Thanks.

€26 EUR 1 gün içinde

5,0

(52 değerlendirme)

5,4

9 freelancer bu proje için ortalama €18 EUR teklif veriyor

@AlexandrK1

you can use the date from the id table .

€30 EUR 1 gün içinde

4,9

(12 değerlendirme)

4,9

@arityinfoway

Hello Sir, I have gone through your requirements regarding Sync MS Access Table with MySQL Table in a existing Form. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, JQuery, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration. I have developed more than 10 projects. Please send me message for further conversation. Thanks, Arity Infoway

€29 EUR 1 gün içinde

5,0

(7 değerlendirme)

3,8

@crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.

€12 EUR 1 gün içinde

4,9

(6 değerlendirme)

2,8

@iamashishgk

hi i am ashish i have read your requirements and ready to work with you on this task if you are ready to work with me then lets have a chat to discuss further thanks

€19 EUR 1 gün içinde

5,0

(3 değerlendirme)

2,0

@Bakhtiyor

Dear Sir or Madam, I am writing to express my interest in this project. My name is Bakhtiyor, I am a web developer from Tajikistan with more than 10 years of experience in this field. My mother tongue is Tajik and I am fluent in English, Spanish and Russian languages. During my working career I had a chance to work in several foreign companies too. They were Software company Orangeweb in Russia as a software developer, Center of singular investigation on information technologies at University of Santiago de Compostela as a researcher and Transparent Language Inc. in USA - leading provider of language learning software as a software developer. During my working career I worked with following programming languages and used technologies like: php, python, java, R, codeigniter, laravel, zope, oracle, mysql, apache, html5, css3, sass, less, javascript, angularjs, jquery, twitter bootstrap, gulp, bower, etc. I am well organized, highly motivated, communicative and very punctual person. I feel I am suitable for this project as I have a great deal of experience in this field because I worked and gained experience as a software developer and know several foreign languages. Thank you for taking time to consider my application. I am available for contact and/or interview at any time. Should you require further information, do not hesitate to contact me. Looking forward to hearing from you. Bakhtiyor

€24 EUR 0 gün içinde

5,0

(1 değerlendirme)

1,4

@solutionsocean

I m experience computer programmer in VB.net/vb/access Please consider me, I can solve it real fast.

€8 EUR 1 gün içinde

5,0

(1 değerlendirme)

0,7

@Asm4740

A proposal has not yet been provided

€19 EUR 10 gün içinde

0,0

(0 değerlendirme)

0,0

@SergeyKyiv

Greetings! 1) The kind of date format used in MS Access one specifies in the table designer, there are many of them. Moreover, one can specify even own format for the dates (to be correct, one chooses not a format, but rather kind of the representation of the format). Then , input field of the form that accepts the date you enter have to respond to the chosen format. 2) If some function in the form (?) need an "integer" representation of the data, no problem, there are cint(date value) and cdate(integer value) functions to use whatever you need. 3) Finally, if to leave everything as it is, you are flexible to perform cdate(your integer date) while saving date to MySQL. Just to doublecheck: one has to be careful with date representation concerning locale settings - 01 May of 2016 might be represented like 01/05/2016 or 05/01/2016 depending on it. I mean that Access and SQL may have (this is to check) different locales. So, I can either assist you via TeamViewr session or make needed changes if you send me the file. Or just make it yourself after these instructions :) Please feel free to contact me. Regards, Sergey

€14 EUR 1 gün içinde