thank you zmbd, but
i tried what you said ,and the numbers have over 15 decimal digits and hard to read . but even though the form is empty unless the number has one or 2 decimal digits but i can't fix it because it is a result of calculations
User Profile
Collapse
Profile Sidebar
Collapse
remas
Last Activity: Mar 24 '14, 11:42 AM
Joined: Feb 22 '14
Location:
-
problem with percentage format in access 2003
hi every one
i have data base with a table linked to excel table the excel table has a column with percentage format based on an embeded calculation among columns
there is a form with multiple comboboxes to enable the user to search the records " for example the employee with effeciency over 85%" when i choose 85% from this combobox " if it is rounded "then the resulting form is empty
all of combobox,table... -
thank you all again i did it with a query then copy and paste the code from sql viewLast edited by remas; Feb 25 '14, 11:30 PM.Leave a comment:
-
thank you all
the data base is a performance report for a company , the user should be able to search the required field either the code of employee , his name or the central name but for any field he is supposed to set the from date and to date to start the search "from and to are 2 different columns" and the resulting form should display all records that satisfy the 3 chosen conditions "from, to and one of the other fields"...Leave a comment:
-
thank you jim for replying
i'm sorry if i wasn't so clear but this is the first time i post a question
the data base has one table with columns "from as begining date , to as ending date, central , name and code" user is supposed to choose to search about one of the columns (code, name or central" and choose the beginning and the end of search date "they are different columns so i think i can't use between"...Leave a comment:
-
Open Form using Multiple Criteria
i have constructed database to display specific records according to user choice from multiple comboboxes based on one taBLE but tried with many ways and give up
can any one help me to correct the following code:
...Code:Private Sub search_Click() On Error GoTo Err_search_Click Dim stDocName As String Dim stLinkCriteria As String Dim stLinkCriteria1 As String Dim stLinkCriteria2
No activity results to display
Show More
Leave a comment: