Find Jobs
Hire Freelancers

Access 2013 Desktop small data macro

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I have written a single data macro.... does not work, see attached. If you find the solution, I pay the fee and hire you for the fine-tuning of 2 small databases (budget of US$ 500 per database). But that will be a new project through Freelancer.com. Please quote for the resolution of this error only. Description is attached. If I see that you know what you are talking about (instead of a sales pitch, please refrain) and can start giving me a good solution, then I will send the full database. Thank you, JeanLouis Vergaert
Project ID: 6116089

About the project

22 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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.
$35 USD in 3 days
4.8 (10 reviews)
4.5
4.5
22 freelancers are bidding on average $76 USD for this job
User Avatar
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
$70 USD in 5 days
4.8 (11 reviews)
5.3
5.3
User Avatar
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
$155 USD in 3 days
5.0 (4 reviews)
5.0
5.0
User Avatar
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.
$50 USD in 1 day
4.9 (28 reviews)
4.9
4.9
User Avatar
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
$46 USD in 1 day
4.9 (18 reviews)
4.8
4.8
User Avatar
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,
$44 USD in 3 days
4.9 (8 reviews)
4.7
4.7
User Avatar
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
$30 USD in 0 day
5.0 (13 reviews)
4.7
4.7
User Avatar
Dear Sir, I'm Expert at access and vba, i'm interested o working for long term. Kind Regards, NourElDeen
$30 USD in 1 day
5.0 (40 reviews)
4.7
4.7
User Avatar
This can be fixed. However, I would suggest using VBA code for such tasks instead of Access macros. Regards, Svet.
$50 USD in 1 day
5.0 (3 reviews)
4.5
4.5
User Avatar
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
$90 USD in 3 days
5.0 (3 reviews)
3.7
3.7
User Avatar
I coudl help you with Macro Error. . .
$61 USD in 1 day
5.0 (1 review)
1.8
1.8
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
4.6 (1 review)
1.8
1.8
User Avatar
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.
$64 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Error: parMovie_From might return the description not the value Id Why use macro when you can do this easily on code.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
76
Payment method verified
Member since Jan 15, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.