Access 2013 Desktop small data macro

Dear, Bonjour, I am MS Access expert since 11 years. I know this error, it's due to comparison between 2 different type of parameter. I can solve it right now. Please let me know.

I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC. I'm not sure where you are getting your Short Text format from, I'm on 2010, is it in 2013? Could be causing it. Have you thought of creating an append query and running it from VBA attached to the go button, I think that would be my prefered approach. Would like to work with you opn this and future projects Regards David

Dear Client, I have looked at the attached file. I don't see any error with the codes. It looks like the issue exist with data of "Movie Copy From" and ""Movie Copy To" drop-down box values. Area you both are has at least two columns and first id column is made with to 0 to only see the description of second column. According to your design the dropdown boxes should return the ID (numeric) value of the movie. If you like you can send me the file for the look. Furthermore, I am excellent in VBA coding for any kind data manipulation. Thank you. Regards, Shiv

Hi, I have gone through details of your project requirement and attachment to check cause of the error in Macro. Since it is data type mismatch error, I noticed that there is a problem in setting and comparing of values in the macro. We can talk further on the chat and I will help you in correcting the problem. Waiting for your response for the same. Thanks.

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access and Visual Basic to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,

Hi, Since data type of [Rental].[Movie_IDFK] field is Number, and i assume that parMovie_From parameter gets value from first Dropdown list on the form (Movie to Copy From) which value is in the text format. Other possibility is that dropdown has 2 columns (one for value in number format, which is hidden and another for presentation). Error you get points to this, since problem is in criteria and Week data type is Number which is good. That's all from me for now, i am too tired, i had a very tough day. If yo want to discuss further, contact me tomorrow at any time. Very Best, Nebojsa Lukovic

Dear Sir, I'm Expert at access and vba, i'm interested o working for long term. Kind Regards, NourElDeen

This can be fixed. However, I would suggest using VBA code for such tasks instead of Access macros. Regards, Svet.

Dear Reader, I have an experience in this work, and I can successfully complete your work. You can see my profile to more understand about my skills. I hope you will satisfy with me and my work. I want to discuss with you. Thanks Adnan

I coudl help you with Macro Error. . .

A proposal has not yet been provided

Hi, I have gone through your requirements and attachment as well.I am a DBA at CMMI-5 Level company since August 2010.I am working on MS Access,MySql,SQL,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.

Error: parMovie_From might return the description not the value Id Why use macro when you can do this easily on code.

I can see a datatype mismatch between values you are providing to the query and the data type your table expects. The solution is very simple. Let me know if you need my help.

Here is quick solution. After cursory view of your database structure, and macro code. The problem is in WHERE condition/criteria, you are trying to compare Number field with the string and getting error of "Data type mismatch". The field rental.movie_idfk is a numeric field and "parMovie_From" will have the value "FarFor5" and this is literal string value. You cannot compare numeric with the string. What you can do is to use the index of the combo box selected value and then compare. But you should have already these values in your table in order to compare. The index values of combobox starts from 0, 1 etc.. so if FasFor5 is in first position in the list it will have 0 index value, and the next will be 1 and so on. To get the index value of selected string from labeled "Movie to copy from" combobox use the method ListIndex of combobox. So instead of saying parMovie_From = [Movie_From], you can say parMovie_From = [Movie_From].ListIndex But again as I said at the top, you should already these index values in Movie_IDFK stored as Foreign key values in the rental table. But I have to see your complete database, macro and the data inside the table. But it is easy to make changes.