Find Jobs
Hire Freelancers

VBA Search Issue on Access form

$10-30 USD

已完成
已发布将近 8 年前

$10-30 USD

货到付款
Very simple project. I have an Access DB. I have a main form with 4 unbound fields. I have a subform with all records from a table. I want to be able to fill in 1,2,3 or 4 of the fields, then hit a search button and the subform ONLY show the records that quality from the unbound fields in the main form. The company field column MAY have special characters like Apostrophes. The date fields may also have a time stamp which would matter. My fields in the main form: DropComp = Me!DropComp (Apostrophes) DropType = Me!DropType BeginDate = [login to view URL] EndDate = [login to view URL] My "SEARCH" button VBA that needs to be cleaned up: Me![login to view URL] = "TestDate >= #" & Format(CDate([login to view URL]), "mm/dd/yyyy") & "# And TestDate <= #" & Format(CDate([login to view URL]), "mm/dd/yyyy") & "#" & IIf(IsNull(Me!DropType), "", " and TestType='" & Me!DropType & "'") & IIf(IsNull(Me!DropComp), "", " and compname='" & Me!DropComp & "'") I think the time stamp issue should be worked out because of the CDATE. At least ONE field has to be filled in, but any field could potentially be left blank. So how do I write this to allow the possibility of special characters in the company column, allow blanks in any of the unbound fields, & show ONLY the results I want? I have created a sample DB & attached as a ZIP.
项目 ID: 10593980

关于此项目

5提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks regards Jawad
$30 USD 在1天之内
5.0 (53条评论)
5.4
5.4
5威客以平均价$33 USD来参与此工作竞价
用户头像
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA 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
$55 USD 在1天之内
5.0 (14条评论)
5.2
5.2
用户头像
I know how to solve your issue. Award the job to me and Im going to start working on it. I know how to solve your issue. Award the job to me and Im going to start working on it.
$25 USD 在1天之内
5.0 (1条评论)
2.8
2.8
用户头像
Hello sir , I believe I'm suitable for the job after reading your job request. As I can actually follow up the instructions that you provides smoothly and can add nice technical feedback about what's the cons and pros. I had a lot of experience on Access and so I can solve the issu Just let me check the details Please feel free to contact me. I am looking forward to hear from you. Yours Tamer ========================================================================== More about me * Skills: - Holding Software Testing Foundation Level Certificate. - System Analysis, Software Engineering, Data Mining, Mathematics (MatLab). - Expert Database trainer and developer (Oracle, MySQL, Access). - Web developer HTML, CSS, JavaScript, JQuery, PHP, WordPress, Joomla. - Expert at Semantic Web, Ontology, RDFS, RDF, XML Schema, XSL, XML. - Programming Java, C++, C, Pascal, Assmebly. - Microsoft Office (Word, Excel, PowerPoint, Outlook, etc) - Virtual Assistance and Admin Support. ========================================================================== * Qualifications and Experience: - MSc Degree of Information Technology - Ranked 1st at BSc Degree of Computer Science - Assistance Teacher for 1 academic year. - Currently working at University with 10 years experience manipulation data (entering, recalling, updating, reporting and monitoring). ==========================================================================
$30 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
Greetings! I am Sergey Murzin from Ukraine. I have 20 year experience with MS Access, so I can solve the issue. please feel free to contact me, it will not take much time. I will provide you with all needed explanations of my approach for sure. Regards, Sergey
$25 USD 在1天之内
0.0 (1条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
69
付款方式已验证
会员自4月 5, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。