
MS Access Fix
- or -
Post a project like this2835
$15
- Posted:
- Proposals: 3
- Remote
- #1944321
- Awarded
Description
Experience Level: Intermediate
Need the following issues fixed in an MS database
PRINT
Before opening up the backend of the database, go to All A2O cases > View (any record) > A2O Unemployment > export case
As you can see the report opens in print preview but the print ribbon is not shown.
SEARCH RESUME
The search does not give any result on any of the tabs
ASSIGNMENT FORM
The assignment form is showing up blank from the second record onward and is giving an error whenever an assignment/reassignment is done.
This was working fine with the code
With rs
.Edit
.Fields![Case Status] = 1
.Update
.Close
End With
but when it was changed the following code the form stopped functioning as it should
With rs
If .Fields![Case Status] = 2 Then
.Edit
.Fields![Case Status] = 1
.Update
End If
.Close
End With
Before opening up the backend of the database, go to All A2O cases > View (any record) > A2O Unemployment > export case
As you can see the report opens in print preview but the print ribbon is not shown.
SEARCH RESUME
The search does not give any result on any of the tabs
ASSIGNMENT FORM
The assignment form is showing up blank from the second record onward and is giving an error whenever an assignment/reassignment is done.
This was working fine with the code
With rs
.Edit
.Fields![Case Status] = 1
.Update
.Close
End With
but when it was changed the following code the form stopped functioning as it should
With rs
If .Fields![Case Status] = 2 Then
.Edit
.Fields![Case Status] = 1
.Update
End If
.Close
End With
Jacqueline L.
100% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
43%
Last project
19 Jun 2018
Trinidad and Tobago
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies