@nico5038
Dear Sir
A very belated (just more than a decade) thank you for your answer.
10 years ago I was successful in clearing the checkboxes, the same exercise helped me even today in unchecking the yes/no field in my Question bank data table.
Once again thanks
mb60
Last Activity: Jan 22 '22, 08:52 AM
Joined: Aug 11 '08
Location: Hyderabad, India
-
Thank you sir
I got it.Leave a comment:
-
How to begin serial number of the records from 100 in access report?
Sir
I would like start serial numbering from 100 in access report. For example
100) xxxxxxxx
101) zzzzzzzz
102) yyyyyyyyy
Earlier I asked the same question. Expert Sri Rabbit helped in this regard but there might be some mistake from my side in using his suggestion. Once again I request your help in this regard
Thank you -
sir
In the control source of record number I put =100. Running sum ; Over allLeave a comment:
-
sir
the first record is beginig with 100, but 2nd record with 200, 3rd one with 300
I want the increment of number as follows
101, 102,103 etcLeave a comment:
-
How to start the record number with 100 in the place of 1 in access report?
In my access report the record number is starting from 1. I would like start with 100
Example
1. xxxxx
2.xxxxxx
but I want to begin with 100
100.xxxx
101.xxxx
102.xxx
I request your help.
Thank you -
how to add data automatically into a field
I have two columns in my access table -FIELD1 and FIELD2. Field1 has the names of some animals.
If I enter a name BIRD in Field 1, automatically a prescribed number , for example '2' should be added in field 2. 3 for cat, 4 for duck, 5 for elephant ....
How to add data automatically into a field? -
Thank You sir.
it worked.Leave a comment:
-
Sorting order by unique pattern
In my database I have a column named CHAPTER. It contains the names of chapters like - Echinodermata, BIrds, Cnidaria, Amphibia etc., When I tried to sort them they are sorted either in ascending or descendig orders. I would like to sort the records in the following order
Amphibia,BIrds, Cnidaria,Echino dermata,Amphibi a, BIrds, Cnidaria, Echinodermata.. . -
mb60 started a topic Even there is no image in the field the record should be seen in the access report.in AccessEven there is no image in the field the record should be seen in the access report.
My database has fields Q, 1,2,3,4,YES/NO, image.
The image field is meant for jpeg pictures. In the query, criteria has " IS NOT NULL" code.
When I select the checkbox the entire record is displaying without any problems. If the 'image' field is empty the entire record is missing from the report.
Even though there is no image in the field, if I select the record with checkbox option, the record should be seen in... -
Sir
As you directed I carried out the changes in my database. It is successful.
my sql is as follows
SELECT Table1.ID, Table1.Q, Table1.[1], Table1.[2], Table1.[3], Table1.[4], Table1.im, Table1.im.FileD ata, [im].[FileFlags] AS Expr1, Table1.im.FileN ame, [im].[FileTimeStamp] AS Expr2, Table1.im.FileT ype, [im].[FileURL] AS Expr3, Table1.sel
FROM Table1
WHERE (((Table1.im.Fi leName) Is Not Null) AND ((Table1.sel)=-1));...Leave a comment:
-
sir
your technic worked. removed the blank spaces. but images of all records are appearing in the sub report even though they are not selected by using yes/no check box option.
inspite of writing the entire code I used the ' is not value' in the criteria of query....Leave a comment:
-
It is not one. Such reports are manyLeave a comment:
-
How to save the query based report for future reference ?
I generated a query based report from access table.I would like to save it in the table for future reference.
Reason:
Generated report is a mcq question paper of a chapter. If I would like to give the same paper for my students for practice in the future how can save and recall it?
I request the experts to guide me to solve this problem
Thank you -
Thank you sir
successfully I got what I want that result
I salute for your interest in solving such problems
No words to express my happiness
(pl ignore the mistakes if any, in my english)Leave a comment:
-
sir
As you directed I extracted SQL and pasting here
Code:SELECT questionbank.question, questionbank.ID, questionbank.[1], questionbank.[2], questionbank.[3], questionbank.[4], questionbank.answer, questionbank.[select] FROM questionbank WHERE (((questionbank.[select])=-1));
Leave a comment:
-
Thank you sir
where I have to place that function in the database?
I don't know anything about SQLLeave a comment:
-
how to pull the correct answer from multiple choice questions database?
sir
In my database I have one column for question. Four columns are meant for options 1,2,3,4. The 5th column is YES/NO column.
The answers for the questions are entered into 5th column by a option box.
Now I would like to print a report with the questions and correct answers which are present in the 1,2,3,4 columns.
ExampleQ) aaaaaaaaaaaaaaa aa
1) bbbbbbbb 2) cccccc 3) ddddd 4) eeeeeee
answer... -
This time I got a run-time error '3061'
Too few parameters.Expe cted 1.Leave a comment:
-
sir
getting error in the second line ( Me.requiry)Leave a comment:
No activity results to display
Leave a comment: