Find Jobs
Hire Freelancers

Help with MS Access form

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
I have attached a sample database. I need taught how to add a subform, or similar, to my current form that will allow me to enter pricing info for product condition variants, as well as retail vs whole sale pricing. Basically within the form for a product, I need a little table with three conditions down the left side of NEW, USED, and REFURB, and then across the top COST, RETAIL, and WHOLESALE. If I could have checkboxes to enable each condition all default checked to yes, that'd be great. Then when the record is saved, the the product name is saved in the PRODUCT table, but also saved to the STK table with a variant suffix, like ABC-NEW... along with the pricing info, see the sample data. I'd like to do this without VBA as I'm new to this and not ready to learn VBA yet.
Project ID: 17566162

About the project

13 proposals
Remote project
Active 6 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
13 freelancers are bidding on average $49 USD for this job
User Avatar
Hello, I have the good knowledge of Help with MS Access form. I have more than 5 years of experience in Database Programming, Excel, Microsoft Access. I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
$100 USD in 2 days
4.9 (416 reviews)
8.3
8.3
User Avatar
Hello, As an expert in ms access, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks
$30 USD in 1 day
5.0 (153 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 MS-Access program. Please give me more details about your project. 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
$23 USD in 1 day
4.7 (91 reviews)
7.4
7.4
User Avatar
Hi, Greetings. We could achieve all the options, however, bit code is necessary for netting the condition of saving to other table with new name. Please let me know if you are interested. Thank you.
$30 USD in 1 day
4.8 (112 reviews)
6.2
6.2
User Avatar
Hi Without coding VBA with SQL/ADO you won't reach here as you want . Do revert back to me if you interested in my bid - we can discuss about details. Regards, Zura
$77 USD in 2 days
4.6 (63 reviews)
6.4
6.4
User Avatar
I can do it now.
$45 USD in 1 day
5.0 (22 reviews)
5.0
5.0
User Avatar
Hello there, I am an expert in database development. I can help you add forms to your Access with ease. Get in touch for efficient services
$30 USD in 1 day
5.0 (8 reviews)
4.4
4.4
User Avatar
I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access certified. I'm confidence I can help you to finish this project for you as requested.
$30 USD in 2 days
4.9 (31 reviews)
4.5
4.5
User Avatar
i'm a future computer science engineer, i am working currently on a project using access, i can definitely help
$30 USD in 0 day
4.9 (2 reviews)
3.5
3.5
User Avatar
Hello, I am a Microsoft certified trainer, application specialist as well as a certified office expert and have been teaching MS Office (including Access and VBA) to corporate staff for over 13 years now. I have reviewed your requirement and it can very well be achieved without using VBA. We may need some basic macros however, rest assured there wouldn't be any coding involved (unless you explicitly need it). This is ofcourse based on my initial understanding of your project based on what you have explained so far. You will need to create a wildcard query which will take the input for the product condition from your products form where you can have your checkboxes. Likewise the same can also be done for the product type. For the later part, you will need to use data macros (no coding involved) to create the record in the stock table. I will walk you through the process and answer all related questions you may have pertaining to the task. P.S: While I understand your preference to not use VBA, there are certain tasks which can only be achieved using VBA. If we come across any such bottlenecks, I will try to propose work around (not involving VBA) however, in most such cases use of VBA may be the only way out. If you have any further questions, I would be happy to have them answered. I look forward to hearing from you. Thank you.
$60 USD in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Please review my profile I am working with skills that you required for this job for 16 years. I am working with MS Access, Excel, MS SQL, VBA and .Net for a long time. I can definitely help you with this job, to make your database design very proficient. I have done lots of split databases with MS Access to Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. I will show my advanced skills in MS Access/Excel via arranging demo via screen sharing session etc. Please contact me with your interest in my profile to discuss next.
$125 USD in 1 day
5.0 (1 review)
0.6
0.6

About the client

Flag of UNITED STATES
Jackson, United States
5.0
16
Payment method verified
Member since Jul 21, 2012

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.