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.
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 Randy'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
[YittBox] has made my life so much easier! They did multiple things for our company, but most notably they built out a spreadsheet database that streamlined a process for me that traditionally took hours of manual data entry. Now with the automation they 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.
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 project organization and thought process was excellent.
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).