Find Jobs
Hire Freelancers

Creating a Form with Serach Criteria to filter a report and open the filtered report in preview mode in MS Access 2003

$10-30 USD

Closed
Posted over 7 years ago

$10-30 USD

Paid on delivery
I have a Report in Access 2003. I want to run a report through a form which has search criteria for two columns in my Report. The first column is a date in the format (mm/ddmyyyy hh:mm:ss AM/PM) and the second column is a group column which tell to which group each record belongs to (G1,G2,G3,G4,G5). So I want to create 3 text boxes in the form (form is not bounded to any table or query) and enter date rannge in 2 text boxes and group in third text box and then when I click command button, it should filter my report between the date range and the group entered in the form and open the report in preview mode. PS. I need VBA code for the search button in a form to filter a report by a date range and a group and open the filtered report in the preview mode.
Project ID: 11699626

About the project

21 proposals
Remote project
Active 7 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
21 freelancers are bidding on average $44 USD for this job
User Avatar
Hello! It is easily doable. As I understand, you want to set report source using VBA (to build SQL based on the form criteria)? If so, that is a good idea and best way to do it. Let me have your DB and I will set this up for you in no time. Regards, Branislav
$25 USD in 1 day
5.0 (200 reviews)
6.9
6.9
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$24 USD in 1 day
4.7 (75 reviews)
7.2
7.2
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. 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, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$40 USD in 3 days
4.8 (84 reviews)
6.5
6.5
User Avatar
Hi there, if you'd really like to have a professional VBA code for the search button in a form to filter a report by a date range and a group and open the filtered report in the preview mode. for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$111 USD in 1 day
4.6 (38 reviews)
6.0
6.0
User Avatar
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$30 USD in 0 day
4.8 (58 reviews)
5.3
5.3
User Avatar
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details. This is a very easy task, I'd use VBA or macros to get the job done in less than an hour0 I'm looking forward to hear from you. Regards,
$20 USD in 1 day
5.0 (49 reviews)
5.3
5.3
User Avatar
Dear Buyer, I am working with Access databases since 1998. Your requirements seem rather straightforward and clear and I would like to offer my assistance in this project. Many thanks in advance for considering my bid. Looking forward to hearing from you. With best regards, Solon ...
$25 USD in 1 day
4.9 (24 reviews)
4.7
4.7
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$35 USD in 3 days
5.0 (19 reviews)
4.8
4.8
User Avatar
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.
$30 USD in 1 day
4.9 (28 reviews)
4.4
4.4
User Avatar
Hi there - my name is Paul. I have more than 25 years of experience in designing and developing MS Access applications especially for small and medium sized enterprises. I'm new at Freelancer and don't have so many feedbacks until now. But as you can see my existing customers were 100% satisfied! I'll provide one year free support for my developments and with a short specification before each change I can provide 100% customer satisfaction and a high qulity with a stamp "Software made in Germany"! Summarizing that I'm very interested to create a filter form for your report and if you report is based on a query there is no need to us VBA! Looking forward to hearing from you! Best regards, Paul
$30 USD in 2 days
5.0 (5 reviews)
4.4
4.4
User Avatar
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of the details. Regards, Sergey
$25 USD in 1 day
5.0 (7 reviews)
3.7
3.7
User Avatar
I have over 10 years of MS Access experience. I have done numerous projects that involve date ranges. I can do your project. I have great attention to detail and I will work on your project until you are satisfied with the result. I can start on your project immediately. Thank you for considering my bid.
$25 USD in 1 day
4.4 (6 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
$166 USD in 30 days
5.0 (7 reviews)
3.1
3.1
User Avatar
Please review my profile. I have 6.9 years experience in SQL. Please let me know more details and when will we start. Skype: jikenjd
$30 USD in 5 days
5.0 (4 reviews)
2.5
2.5
User Avatar
I have +5 year experience in MS Access Database Design and VBA programming. To Provide Quality,modular and object oriented coding. User friendly forms and Analytical Reports. Give me details of project.
$30 USD in 1 day
4.8 (3 reviews)
1.9
1.9
User Avatar
Hi, I'm very interested in this project, which I can accomplish due to my knowledge and experience. I'd like to talk about details. Thank you for your time. Kind regards, Cerim
$25 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
This is pretty simple. It will need a Visual basic code which will get the two dates from the text boxes and group code to filter the report. Open the Report in Print Preview mode.
$15 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
Pretty simple work and should be done within 2-3 days (if it as in excel). But I am optimistic that even in access it can be done within same time.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working with skills that you required for this job from 15 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient.I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as backend. I will shows my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Sono uno sviluppatore specializzato in tutte le Versioni Ms Access con pluriennale esperienza. Garantisco massima serietà e capacità di trovare la migliore soluzione possibile.
$55 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Sep 4, 2016

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.