Yittbox Is Your One-Stop Shop For Custom IT Solutions. We Aim To Create The Best Possible Solution For Your Business By Offering A Wide Range Of Services.
Yittbox Started With One Individual Trying Out The “Gig Economy” Freelancing. Providing Freelancing IT Services, Focusing On Small - Medium Size Business, Quickly Exploded. There Is An Inherent Void In The Small - Medium Market With Needing Customized IT Solutions, But Not Ready To Spend The “Big IT” Prices On Consulting Or “Off The Shelf” Solutions. Within A Year Of Beginning, A Team Of Individuals Had Been Hired And The Freelancing Service Evolved And Re-Branded Into Yittbox And Is Quickly Working To Fill That Void.
In Our Years Of Experiences, We Believe The Small-Mid Size Market Does Not Have Competent, Affordable, Reliable IT Partners. The Big 5 IT Consulting Firms Cater To Fortune 100 Companies As The Norm But We Believe In Challenging The Status Quo. We Believe In Thinking Outside The Box And Enabling The Small-Mid Size Market To Compete.
Know MoreHaving worked with a host of small and medium- sized businesses, here's a glance at some of our latest works and the solutions deployed for each one. Dive in to know how we pay attention to precision when it comes to customizing solutions for our clients.
Don't believe what we say, hear it straight from our clients.
Apr 12, 2021
Feedback: Great work from [YittBox]!
Apr 08, 2021
Wonderful collaborator and helped solve a tricky Google Data Studio issue in under an hour. Thanks [YittBox]!
Apr 07, 2021
Very good!
Apr 06, 2021
[YittBox] did an excellent job communicating with me. From the moment I received his response I could tell this was someone I wanted to follow up with immediately. After reading his background and skill sets along with the many excellent reviews, I was convinced that [YittBox] was the right person for my project. [YittBox] was both prompt and professional. He was very quick with help when I needed it. I never felt rushed during my questions and I had plenty. Other than a learning curve on my part the invoice creator that [YittBox] produced immediately saved boat loads of not only my time but that of the others who are using it as well. What once took me hours to do....invoicing my property management clients now takes less than an hour. Great Job [YittBox]! Thank you again.
Apr 06, 2021
Great work! Was responsive to feedback and finished project quickly!
Mar 31, 2021
[YittBox] provided what was requested of them. I will hire again.
Mar 30, 2021
[YittBox] was great.
Mar 30, 2021
Good estimation of work and communication! Completed work as expected within good timeline!
Mar 25, 2021
[YittBox] is a great guy to work with. He is committed and is available whenever you need him. More than happy to give contract to a person like [YittBox].
Mar 25, 2021
Great!
Mar 25, 2021
Fast and professional work, see you soon
Mar 25, 2021
[YittBox] is a pleasure to work with. We wouldn't hesitate to hire her again. Excellent work.
Mar 24, 2021
[YittBox] did a great job. His work his high quality and he gets things done quickly. I highly recommend him
Mar 22, 2021
[YittBox] offered expertise needed and went over and above what was expected. I would highly recommend him.
Mar 18, 2021
[YittBox] took my limited information and was able to execute and expand the scope of my project tracking in ways I never imagined. Incredibly fast turnaround and great communication. I will absolutely be using [YittBox] again in the near future!
Mar 15, 2021
[YittBox] was very professional and quick with her responses throughout the duration of the contract. She asked relevant questions and delivered on all key objectives.
Mar 15, 2021
Great experience.
Mar 12, 2021
[YittBox] is extremely responsive to requests and takes pride in delivering the best quality work.
Mar 11, 2021
[YittBox] was great. Communicative and timely. Will use him again in the future - thank you once again!!!
Mar 02, 2021
[YittBox] was very knowledgeable and extremely good at what he does!
Mar 02, 2021
Great & Fantastic work in web security!! Thank you so much.
Mar 02, 2021
Working with [YittBox] was an absolute pleasure. He made himself available during my timezone and did not hesitate to jump on a screen share call to walk me through the work he did. Super helpful went above and beyond to complete the work on time exceptional communication skills and extensively knowledgeable in his line of work. I highly recommend [YittBox].
Feb 24, 2021
[YittBox] was excellent to work with. Will hopefully work together again.
Feb 23, 2021
great work
Feb 23, 2021
[YittBox] is amazing! She did everything I needed her too as soon as I needed it. I had a business emergency and will not need anyone for a bit. I will definitely use her again :)
Feb 23, 2021
[YittBox] is highly experienced in MS Dynamics CRM and especially his knowledge on Field Services really helped us to gather speed in the early stages of the discussion itself. We were expecting to be a difficult code based project but with his experience he was able to provide us multiple solutions and take it to where we wanted the application enhancement to go. Highly recommended.
Feb 23, 2021
I am really happy I choose [YittBox] to create the database of my construction company . He did really awesome work and was available for all the changes I requested so the database worked 100% the way I wanted.
Feb 23, 2021
Incredible and fast designer! Highly recommended looking forward to working with him in future projects!!! Thanks!!
Feb 05, 2021
[YittBox] and his team did a great job understanding our requirements and delivering on them. We gave verbal requirements on some proprietary critical software. They had no trouble digging into the application and updating it per our needs. They turned around the project quickly, kept us informed the whole time, and responded promptly to our feedback. I would whole-heartedly recommend [YittBox] and his team.
Feb 03, 2021
Great copy. Easy to communicate with and made changes easily
Feb 03, 2021
[YittBox] was a pleasure to work with and helped me identify the problems that was causing the issues with my website.
Feb 02, 2021
Excellent work, fast feedback and high-quality content, very impressive! Your article is so impressive, you have understood the concept of my project even better than its creator, let me express my admiration for your talent.
Feb 01, 2021
This is my 2nd time hiring [YittBox] and he always does a great job. He understands the requirements and asks questions if they are unclear. Looking forward to our next project.
Feb 01, 2021
[YittBox] is skilled, patient, and a pleasure to work with! I will continue to seek out his help with future projects.
Feb 01, 2021
[YittBox] is an excellent choice. She is intelligent, and gave great suggestions to improve our project.
Jan 31, 2021
I have worked with many developers over the years and I have found [YittBox] to be the consummate professional. We are working on a very complex app and his planning, communication, and execution skills have made this project a success. It has been a pleasure to work with him and the app has exceeded my expectations. I highly recommend [YittBox] as long as you don't take him away from our project. :)
Jan 27, 2021
This task was on the backburner for literally years, and after contracting with [YittBox] he was able to help untangle it all and get it to exactly what we wanted. He was very knowledgeable on the platform, patient with access delays from end-client, and even helped walk me through a screenshare.
Jan 27, 2021
[YittBox] is a consumate professional. Work is always on time and done to perfection. Documents everything too. Don't hesitate to hire him for any size project!
Jan 25, 2021
[YittBox] did the project extremely well and also well before the deadline. He completed the improvements of the database successfully and everything works. I will hire him again.
Jan 18, 2021
We've been working with [YittBox] for over a year now and I'm constantly impressed with his work. He has an excellent attention.
Jan 18, 2021
[YittBox] did a great job with this project, I highly recommend him, have used him many times before and was excellent, will use him again!
Jan 18, 2021
Good copywriter
Jan 18, 2021
[YittBox] is an expert. [YittBox] was able to deliver a very complex project within an aggressive timeline.
Jan 18, 2021
I hired [YittBox] for some HTML and Power App work and they did a great job. I am working on hiring [YittBox] again for my next project.
Jan 18, 2021
[YittBox] had great follow-up and took initiative. [YittBox] was able to do more tasks than I expected.
Dec 22, 2020
[YittBox] was able to complete the work quickly and the contents were extremely useful for me. They were quite matching with what I was expecting too without much explanation.
Dec 21, 2020
[YittBox] has rewritten a lot of content for our application. Our team was highly impressed with the quality of his work. Moreover, his adherence to schedule and time-management skills made our cooperation very productive. We will definitely hire [YittBox] again when we have more tasks for him, because it was a pleasure to work with him. Thank you, [YittBox]!
Dec 21, 2020
[YittBox] is extremely professional and was able to get the task done quickly! [YittBox] was very helpful and communicated well!
Dec 21, 2020
YittBox completed the work under budget. There was an issue with the VBA that YittBox fixed even after the contract had ended. I invited them to rebill out the remainder (to fix the issue) to fix the VBA, but it was fixed for $0. Thank you.
Dec 21, 2020
[YittBox] did a good job writing for our personal finance blog!
Dec 10, 2020
I enjoyed working with [YittBox]. He completed our job quickly and efficiently.
Dec 10, 2020
[YittBox] and his team are fantastic! Super responsive. Very knowledgeable. Fast. Accurate. Patient. Fairly priced. I was most impressed that they so quickly picked up on our highly proprietary software and even recommended additional productivity enhancements. I would absolutely hire them again for this type of project or for work on other technologies that I know they are more than capable of. I have worked with many many contractors over my 20+ years of doing this and I can honestly say that this has been one of the best contractor experiences I have had.
Dec 10, 2020
Very responsive and responsible. Would like to work with him again in the future.
Dec 10, 2020
What a great freelancer. Really happy I hired [YittBox].
Dec 10, 2020
[YittBox] did an excellent job and was able to get me and put it into words. Speedy writer. I'm more than satisfied with the work done. Thanks!
Dec 02, 2020
[YittBox] was great... He knows his stuff...
Nov 29, 2020
We highly recommend [YittBox] - her work is very good!
Nov 29, 2020
Great work again!
Nov 29, 2020
[YittBox] is a very good creative writer thinker and followed the flow very well of what we were looking for for this creative. She's a very important part of our Team with an excellent sense of breathing new life into all of her work.
Nov 29, 2020
[YittBox] communicated professionally & her work followed. Amazing work! Great to work with will definitely hire again!
Nov 29, 2020
It was great speaking with [YittBox] for my project. She has a wealth of experience and expertise she can draw from which was perfect for my projects.
Nov 29, 2020
[YittBox] was always responsive when I needed him. He delivered on time and satisfactorily. He's a great asset in the Upwork community. I would hire him again in the future.
Nov 29, 2020
I'll be contacting [YittBox] again for more work. She helped my writing and suggested changes as well as corrected my manuscript. We exchanged thoughts and documents over the 3-4 weeks of the contract. That worked for me. The last deliverable was her story evaluation some of which I used to make final changes to my book now published.
Nov 29, 2020
[YittBox] is awesome!
Nov 29, 2020
Was great to work with!
Nov 29, 2020
[YittBox] is very good.
Nov 29, 2020
Completed as specified. Thanks.
Nov 29, 2020
Was able to quickly understand the issue at hand and resolve the issue
Nov 29, 2020
[YittBox] was hired for admittedly an easy task for a person familiar with Access as we had an internally developed database suddenly throwing an error and the creator/developer was no longer working for the company. He solved the issue within minutes as well as provided some enhancements and returned the solution files to me free of charge. [YittBox] was very professional and after a dialog exchange it is clear he is very knowledgeable with Access. I would not hesitate to use his expertise in the future and will definitely keep his name handy and on the short list for db related projects in the future.
Nov 29, 2020
We have a MS Access loan monitoring application that was single user. We hired [YittBox] to convert and migrate the back end to SQL Azure while keeping the front end in Access. There are so many great qualities about [YittBox] that made this project successful and easy for me. He's such a great communicator and does an amazing job documenting the steps/process. He's so patient - I had unusual amount of trouble with my Azure account and he patiently worked out the issues with multiple departments at Microsoft to resolve the problem. He does not take short cuts - the original database was developed by an ammeter (me) and [YittBox] patiently fixed the parts where would cause issues later on when the back end is on Azure. I was super impressed by how [YittBox] was able to work so independently which made the process absolutely as painless as possible. He struck the right balance of when to ask for directions when to give the client an update. [YittBox] takes deadlines absolutely seriously. Sometimes I wonder if he ever sleeps! Overall I will recommend [YittBox] to anyone I know. Our project is an absolute success the experience and outcome exceeded my expectations!
Nov 29, 2020
great work
Nov 27, 2020
I invited [YittBox] to help me with an Access problem because of his extensive experience with that specific program. I have 20 years experience with Access but had hit a wall on a form I could not get to work. In the past, I had tried hiring freelancers by price but spent more money getting the work done than if I had hired a more qualified freelancer. In one case, the freelancer never got the application he worked on me to work. I looked for an experienced freelancer and got it.
Nov 26, 2020
[YittBox] was very responsive and flexible to changing requirements.
Nov 26, 2020
[YittBox] Understood the project and delivered Great work. Thank you!
Nov 26, 2020
I had a very good time and will come back again.
Nov 24, 2020
We hired [YittBox] to convert an Access database from Access 2007 to the current version. This project ended up with some difficulties that were created by our end. Long delays, a database in bad shape as well as many changes from the original scope. Through it all [YittBox] was very patient with us and responsive when we finally moved forward. It was a pleasure and 10/10 I will use his services again.
Nov 21, 2020
[YittBox] was very responsive, and with me being so busy, frankly very patient. He helped us tweak an Excel spreadsheet and we look forward to using him again.
Nov 13, 2020
[YittBox] has rewritten a lot of content for our application. Our team was highly impressed with the quality of his work. Moreover, his adherence to schedule and time-management skills made our cooperation very productive. We will definitely hire [YittBox] again when we have more tasks for him, because it was a pleasure to work with him. Thank you, [YittBox]!
Nov 06, 2020
[YittBox] did a wonderful job. She wrote interesting, funny blurbs for our products just as we had asked her to do. We will def consider using her for future projects. Thanks [YittBox]!
Nov 03, 2020
[YittBox] is extremely professional and was able to get the task done quickly! She was very helpful and was communicated well!
Nov 02, 2020
Easy to cooperate with taking the feedback on board and implementing changes as required.
Oct 30, 2020
[YittBox] is knowledgeable, professional, and very responsive. Highly recommended!
Oct 29, 2020
[YittBox] is a pleasure to work with. He communicates well. His work is thorough. He has the ability to adapt on the fly and give the customer the end product they are looking for. What more can you ask for? Hire him. You will not be disappointed!
Oct 29, 2020
[YittBox] did an amazing job with this custom access database. Fixed all the problems from performance issues to crashes, added all the features and really took a burden off my shoulders. Thank you [YittBox]!
Oct 19, 2020
I had an excellent experience working with [YittBox]! He did great work and had great communication. I would definitely consider hiring him again for future work.
Oct 04, 2020
My instructions were not as clear as they could have been in the beginning but [YittBox] preserved and got the job done and in a place that was better than I even expected.
Sep 30, 2020
Grateful for [YittBox]'s experience, know how and flexibility on jobs big and small.
Sep 30, 2020
Easy to work with. Came up to speed on requirements quickly and delivered an outstanding solution. Happily recommend
Sep 30, 2020
Great at what he does - fast and concise with a plethora of knowledge in data base management.
Sep 28, 2020
[YittBox] was a lifesaver. He was able to update our very antiquated software seamlessly and painlessly. Every interaction with him was beyond professional. Highly recommend.
Sep 24, 2020
[YittBox] was excellent to work with. Highly recommend his services. Will be working with him again soon.
Sep 17, 2020
Good Writer
Sep 17, 2020
Great copywriter, thanks [YittBox]!
Sep 17, 2020
Thanks [YittBox]!
Sep 17, 2020
Very good writer and timely deliverables.
Sep 10, 2020
[YittBox] communicated professionally & their work followed. Amazing work! Great to work with, will definitely hire again!
Sep 10, 2020
[YittBox] was always responsive when I needed them. [YittBox] delivered on time and satisfactorily. Great asset in the Upwork community. I would hire [YittBox] again in the future.
Sep 10, 2020
Gave me exactly what I needed!
Sep 10, 2020
Very fast response during tender process and completion of work. Very responsive to changes and willing to make the necessary changes quickly for a very fast project turn around.
Sep 10, 2020
amazing to work with! creative and quick! will definitely work with [YittBox] again
Sep 10, 2020
Reliable and responsive! Have enjoyed working with [YittBox] the last few months and what originally began as creating org charts for us, quickly evolved into much more as [YittBox] has great capabilities!
Sep 10, 2020
[YittBox] was great throughout our project(s) and I am looking forward to working with them again in the future. Excellent communication and timing always!
Sep 10, 2020
I had a great experience. Thank you!
Sep 10, 2020
YittBox is great!
Aug 29, 2020
[YittBox] has made my life so much easier! He did multiple things for our company, but most notably he built out a spreadsheet database that streamlined a process for me that traditionally took hours of manual data entry. Now with the automation he built, the process is now down to a matter of minutes. So brilliant! I'll definitely be reaching out to [YittBox] again for any excel and formula work.
Aug 15, 2020
[YittBox] was excellent and I highly recommend him. He was able to complete my project within a few weeks after another developer had been working on it for over a year. [YittBox] was able to take my ideas and develop a program that included all the necessary information and place it in a very comprehensive, easy to use and follow method. His work provided for a professional product that is highly received by my customers. [YittBox] worked within an agreed budget and went above and beyond to be sure that I was satisfied with the end result. He was very responsive, answered any questions almost immediately. He was able to pick up and quickly modified, added information and concluded the entire project within two weeks. Initially reluctant to hire someone on-line, I would not hesitate to re-hire and would highly recommend him to all.
Aug 13, 2020
[YittBox] is very detailed, responds quickly and answers any questions we have. Very easy to work with. He has helped us on multiple projects.
Jul 06, 2020
Offered a thoughtful solution to the problem. Recommended!
May 15, 2020
[YittBox] was very quick to respond and was able to gather the requirements and get our issues fixed. We've had others try to fix the database issues and [YittBox] was the only person to deliver!
May 08, 2020
Was prompt and informative throughout entire process. Strongly recommend. Great Job!!
May 06, 2020
[YittBox] was extremely responsive and helpful with an immediate project need. Professional and capable.
May 05, 2020
[YittBox] was very helpful and thorough. He asked great questions and delivered what I asked for.
May 04, 2020
[YittBox] did an excellent job. She is a thoughtful, writer. She gets her jobs done in a timely manner, with a high level of attention to detail. Will definitely use her services again.
May 04, 2020
What a fantastic experience. [YittBox] is always prompt with communication, an excellent writer, editor, copywriter, and overall excellent at Digital Marketing. An absolute joy to work with and I'll be reaching back out to her for my next project.
May 04, 2020
Great to work with. Understood instructions and executed the best result for what could be done.
May 04, 2020
[YittBox] did a great job. Communication was excellent and the skill set was excellent. Would use again.
May 04, 2020
This is an outstanding contractor. He completed the project on the same day and followed the instructions perfectly.
May 04, 2020
[YittBox] was awesome to work with and we will be working with him again on the next project. He was excellent in several ways. He's personable. He communicates well and was willing to hop on last minute calls. He's fast. And he knows his stuff!
May 04, 2020
What a fantastic experience. [YittBox] is always prompt with communication, an excellent visual designer, report creator, VBA coder, and overall excellent at anything "Data Related". An absolute joy to work with and I'll be reaching back out to him for my next project. You are worth the money x 2!!
May 04, 2020
If I have a another similar project I will be coming to [YittBox] first
May 04, 2020
[YittBox] is knowledgeable, highly responsive and engaged. He consistently met our deadlines. We are continuing to work with [YittBox] on additional projects.
Apr 11, 2020
[YIttBox] continues to be a great resource. He works hard and fast and always delivers.
Mar 24, 2020
[YittBox] was the first to respond to my post. His resume was impressive and he was very responsive. I am not terribly good with understanding the "behind the scenes" of software and he was able to explain things to me so I could understand them better. Unfortunately, the project is being postponed just a bit but we will definitely look to hire him in the future!
Mar 21, 2020
very good skills. will rehired him :)
Mar 08, 2020
I was really impressed with [YittBox's] honesty. He actually suggested a much lower scope than I had in mind saying he thought that was all I needed. He was right and I appreciated it. Did a good job with what we landed on and was fast.
Mar 01, 2020
I had a pretty small but in-depth workbook I wanted created to keep track of our smaller companies finances, track customers, create estimates and invoices. [YittBox] went above and beyond what I needed. I had a very specific workbook in mind and was going to be picky about it. [YittBox] changed what I needed to make it exactly what I wanted! It will save me a lot of time and I'm glad used [YittBox]!
Feb 27, 2020
Amazing person to work with! Responded very quickly. Job was completed fast and perfectly!
Feb 14, 2020
Excellent experience working with [YittBox]. Will continue to use his firm's services.
Feb 11, 2020
Got the job done right!
Feb 07, 2020
Excellent experience working with [YittBox]. Will use him in the future.
Jan 29, 2020
[YittBox] was very easy to work with. He explained things well and provided a recap of his work.
Jan 02, 2020
Very professional and knowledgeable. A good communicator, responds in a timely manner, kept the project moving forward...
Jan 01, 2020
[YittBox] did excellent with my very picky preferences. After the work was done he also helped me understand a bit about what he did. This small business is super glad to have found him and we will definitely be doing more with with him in the future as needed!
Jan 01, 2020
Highly recommend [YittBox]. He communicates well, brought ideas to the table and delivered a quality product. We will be using him again for future projects.
Communicative and precise. [YittBox] took the time to not only work through our specifications, but also to understand our business objectives.
A true gentleman who is highly skilled and knowledgeable. Cannot recommend this freelancer enough. He makes the whole process very easy and was able to provide all work requested to a very high standard. He will definitely be my first choice in the future. A very satisfied customer.
Everything was quick and perfect.
[YittBox] did a great job we are very happy with his work.
[YittBox] is very skilled in MS Access and quickly turned around quality work. I recommend and would hire again!
[YittBox] was terrific. Very quick turn around that worked perfectly the first time. Will be needing his expertise again.
[YittBox] was an excellent hire! Worked quickly, packaged the new solution up very nicely, provided written instructions and documentation, and most importantly made the process way more efficient and easy! Very impressive!! Will definitely hire again for future projects!
Project went quite well. Developer was flexible with scheduling as this was a low priority project that got bumped often. No major complaints and I would use this person again.
[YittBox] will not give up. He will complete the job and goes out of his way to make his customers happy
[YittBox] was amazing! He was soooo patient with my lack of knowledge with my system and went above and beyond to get the job done. I am so grateful for his work!
Very satisfied with this person
Overall, I will recommend YittBox to anyone I know. Our project is an absolute success, the experience and outcome exceeded my expectations
Project has been shelved due to financial reasons on my side. I stillhave plans to see this project finished this year. The Developers project organization and thought process was excellent. I hope he is available later this year to finish what we have started.
I had a chance to work with YittBox again and I continue to be impressed. They understand the business issues very well and I don't have to describe much to them, they get it very quick. For the latest database requirement, what I thought would be a major task, YittBox completed in no time and the solution was very elegant. Again, highly recommended.
I highly recommend YittBox. They helped me design a fairly complex access database, did exactly was I needed, and made several recommendations that I haven't thought of myself. Quality work and done on time. I also appreciated frequent, on-point communication. I'm very happy with the work.
Super-fast, great communication. Finished project the same day we hired him
YittBox created an Access database for us with some custom code. They did it quickly, added all requested features, and had the initiative to solve some problems that we did not anticipate. I hope to hire them again in the future.
Great work quality, responsiveness, availability and communication!
YittBox did a fantastic job helping me with configuring an Access front end and back end database to work in as a simple supply solution. This will literally save our company $1000 or more per month on a solution that doesn't work.
Totally knowledgeable on MS Access and did the rework on my database quickly and efficiently. Also make improvements that were very valuable after checking that we did want these items taken care of. Will definitely use them again
YittBox worked on a supply/charge database for our chargeable items. The database has served the purpose we needed it too. It was a Microsoft Access database that works across multiple workstations by using the Microsoft Runtime Environment.
YittBox was very skilled with data manipulation and visualization. Highly professional. I would definitely hire them again!
Excellent experience all around. Wonderful communication,worked to fully understand the project, and kept in communication about ideas, improvements, and considerations as we progressed. I will definitely rehire for my next database project.
Very competent Access Programmer. Was able to clean up mess another programmer left us with. Can't say enough good things
We're answering some of your common questions here. We're here to cater to any additional queries.
Hello. I found a post of similar question and the solution for it. Credit for Daniel Pineault from devhut.net. '--------------------------------------------------------------------------------------- ' Procedure : VBE_GetProc ' Author : Daniel Pineault, CARDA Consultants Inc. ' Website : http://www.cardaconsultants.com ' Purpose : Return a VBA proc's text - a way to extract vba procedures ' Copyright : The following is release as Attribution-ShareAlike 4.0 International ' (CC BY-SA 4.0) - https://creativecommons.org/licenses/by-sa/4.0/ ' Req'd Refs: None, uses Late Binding ' ' Input Variables: ' ~~~~~~~~~~~~~~~~ ' sModuleName : Name of the Module that contains the procedure to navigate to ' sProcName : Name of the procedure to return the text of ' bInclHeader : True/False - whether to include the procedure header in the returned ' string ' ' Usage: ' ~~~~~~ ' ? VBE_GetProc("Module1", "fOSUserName") ' ? VBE_GetProc("Module1", "fOSUserName", False) ' ' Revision History: ' Rev Date(yyyy/mm/dd) Description ' ************************************************************************************** ' 1 2018-12-28 Initial Release, forum help ' 2 2018-12-28 Swicthed to Late Binding ' 3 2018-12-31 Added bInclHeader to include/exclude the proc header ' Minor code optimization '--------------------------------------------------------------------------------------- Public Function VBE_GetProc(ByVal sModuleName As String, _ ByVal sProcName As String, _ Optional bInclHeader As Boolean = True) Dim oModule As Object 'CodeModule Dim lProcStart As Long Dim lProcBodyStart As Long Dim lProcNoLines As Long Const vbext_pk_Proc = 0 'Req'd for Late Binding On Error GoTo Error_Handler Set oModule = Application.VBE.ActiveVBProject.VBComponents(sModuleName).CodeModule lProcStart = oModule.ProcStartLine(sProcName, vbext_pk_Proc) lProcBodyStart = oModule.ProcBodyLine(sProcName, vbext_pk_Proc) lProcNoLines = oModule.ProcCountLines(sProcName, vbext_pk_Proc) If bInclHeader = True Then VBE_GetProc = oModule.Lines(lProcStart, lProcNoLines) Else lProcNoLines = lProcNoLines - (lProcBodyStart - lProcStart) VBE_GetProc = oModule.Lines(lProcBodyStart, lProcNoLines) End If Error_Handler_Exit: On Error Resume Next If Not oModule Is Nothing Then Set oModule = Nothing Exit Function Error_Handler: 'Err 35 is raiised if proc not found MsgBox "The following error has occurred" & vbCrLf & vbCrLf & _ "Error Number: " & Err.Number & vbCrLf & _ "Error Source: VBE_GetProc" & vbCrLf & _ "Error Description: " & Err.Description & _ Switch(Erl = 0, "", Erl <> 0, vbCrLf & "Line No: " & Erl) _ , vbOKOnly + vbCritical, "An Error has Occurred!" Resume Error_Handler_Exit End Function
Welcome to YittBox. Thanks for posting this question. To minimize the navigation pane, but not hide it completely, you can try this code: DoCmd.NavigateTo "acNavigationCategoryObjectType": DoCmd.Minimize
To break page on a specific section, you can open the report in design view, select the section on property pane, then change "Force New Page" setting to "before section" or "after section".
You can subscribe and you will have access to the full VBA Reference Library under the "Free Code" section in the bottom left. Enjoy!
Here is a possible solution: 'Ensure properly formatted paths were supplied, adjust as req'd If Right(sPathSource, 1) <> "\" Then sPathSource = sPathSource & "\" If Right(sPathDest, 1) <> "\" Then sPathDest = sPathDest & "\" 'Build fully qualified path\filenames for the move process sSourceFile = sPathSource & sFile sDestFile = sPathDest & sFile Set oFSO = CreateObject("Scripting.FileSystemObject") 'Ensure the supplied paths (Source/Destination) actually exist If oFSO.FolderExists(sPathSource) = False Then If bDisplayErrMsg = True Then sMsg = "Source path '" & sPathSource & "' does not exist." Debug.Print sMsg Call MsgBox(sMsg, vbInformation Or vbOKOnly, "FSO_MoveFile Error") End If FSO_MoveFile = False GoTo Error_Handler_Exit End If If oFSO.FolderExists(sPathDest) = False Then If bDisplayErrMsg = True Then sMsg = "Destination path '" & sPathDest & "' does not exist." Debug.Print sMsg Call MsgBox(sMsg, vbInformation Or vbOKOnly, "FSO_MoveFile Error") End If FSO_MoveFile = False GoTo Error_Handler_Exit End If 'Ensure the File to be copied actually exists If oFSO.FileExists(sSourceFile) = False Then If bDisplayErrMsg = True Then sMsg = "Source file '" & sSourceFile & "' does not exist." Debug.Print sMsg Call MsgBox(sMsg, vbInformation Or vbOKOnly, "FSO_MoveFile Error") End If FSO_MoveFile = False GoTo Error_Handler_Exit End If 'Check to see if the file already exist in the Destination folder If oFSO.FileExists(sDestFile) = True Then If bAutomaticOverwrite = False Then GoTo Error_Handler_Exit Else Kill sDestFile End If End If oFSO.MoveFile sSourceFile, sDestFile FSO_MoveFile = True Error_Handler_Exit: On Error Resume Next If Not oFSO Is Nothing Then Set oFSO = Nothing Exit Function Error_Handler: MsgBox "The following error has occured" & vbCrLf & vbCrLf & _ "Error Number: " & Err.Number & vbCrLf & _ "Error Source: FSO_File_Move" & vbCrLf & _ "Error Description: " & Err.Description & _ Switch(Erl = 0, "", Erl <> 0, vbCrLf & "Line No: " & Erl) _ , vbOKOnly + vbCritical, "An Error has Occured!" Resume Error_Handler_Exit End Function
I'm not sure I understand this question; First, instead of the "IIF" function, I would use the "Nzz" custom function (which can be found via the "VBA Reference Library" in the YittBox Free Code section).