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 More
Having 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.
[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.
We've been working with [YittBox] for over a year now and I'm constantly impressed with his work. He has an excellent attention.
[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!
Good copywriter
[YittBox] is an expert. [YittBox] was able to deliver a very complex project within an aggressive timeline.
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.
[YittBox] had great follow-up and took initiative. [YittBox] was able to do more tasks than I expected.
[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.
[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]!
[YittBox] is extremely professional and was able to get the task done quickly! [YittBox] was very helpful and communicated well!
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.
[YittBox] did a good job writing for our personal finance blog!
I enjoyed working with [YittBox]. He completed our job quickly and efficiently.
[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.
Very responsive and responsible. Would like to work with him again in the future.
What a great freelancer. Really happy I hired [YittBox].
[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!
[YittBox] was great... He knows his stuff...
We highly recommend [YittBox] - her work is very good!
Great work again!
[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.
[YittBox] communicated professionally & her work followed. Amazing work! Great to work with will definitely hire again!
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.
[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.
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.
[YittBox] is awesome!
Was great to work with!
[YittBox] is very good.
Completed as specified. Thanks.
Was able to quickly understand the issue at hand and resolve the issue
[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.
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!
great work
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.
[YittBox] was very responsive and flexible to changing requirements.
[YittBox] Understood the project and delivered Great work. Thank you!
I had a very good time and will come back again.
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.
[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.
[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]!
[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]!
[YittBox] is extremely professional and was able to get the task done quickly! She was very helpful and was communicated well!
Easy to cooperate with taking the feedback on board and implementing changes as required.
[YittBox] is knowledgeable, professional, and very responsive. Highly recommended!
[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!
[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]!
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.
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.
Grateful for [YittBox]'s experience, know how and flexibility on jobs big and small.
Easy to work with. Came up to speed on requirements quickly and delivered an outstanding solution. Happily recommend
Great at what he does - fast and concise with a plethora of knowledge in data base management.
[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.
[YittBox] was excellent to work with. Highly recommend his services. Will be working with him again soon.
Good Writer
Great copywriter, thanks [YittBox]!
Thanks [YittBox]!
Very good writer and timely deliverables.
[YittBox] communicated professionally & their work followed. Amazing work! Great to work with, will definitely hire again!
[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.
Gave me exactly what I needed!
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.
amazing to work with! creative and quick! will definitely work with [YittBox] again
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!
[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!
I had a great experience. Thank you!
YittBox is great!
[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.
[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.
[YittBox] is very detailed, responds quickly and answers any questions we have. Very easy to work with. He has helped us on multiple projects.
Offered a thoughtful solution to the problem. Recommended!
[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!
Was prompt and informative throughout entire process. Strongly recommend. Great Job!!
[YittBox] was extremely responsive and helpful with an immediate project need. Professional and capable.
[YittBox] was very helpful and thorough. He asked great questions and delivered what I asked for.
[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.
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.
Great to work with. Understood instructions and executed the best result for what could be done.
[YittBox] did a great job. Communication was excellent and the skill set was excellent. Would use again.
This is an outstanding contractor. He completed the project on the same day and followed the instructions perfectly.
[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!
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!!
If I have a another similar project I will be coming to [YittBox] first
[YittBox] is knowledgeable, highly responsive and engaged. He consistently met our deadlines. We are continuing to work with [YittBox] on additional projects.
[YIttBox] continues to be a great resource. He works hard and fast and always delivers.
[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!
very good skills. will rehired him :)
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.
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]!
Amazing person to work with! Responded very quickly. Job was completed fast and perfectly!
Excellent experience working with [YittBox]. Will continue to use his firm's services.
Got the job done right!
Excellent experience working with [YittBox]. Will use him in the future.
[YittBox] was very easy to work with. He explained things well and provided a recap of his work.
Very professional and knowledgeable. A good communicator, responds in a timely manner, kept the project moving forward...
[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!
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).
