Search results

Hi David, I don't know if they is a set way of doing it but I could remove the blank spaces by a trick. The can grow and can shrink does not make any difference if the sub report is null as it leaves blank spaces. So I went to the design view of the main report and reduced the height of each...

Both 32 bit... All references means? The Accde is linked to the BE file which is located on my computer. The FE file can be accessed from my colleagues computer and its working fine. But the problem arises when I am using ACCDE file.

Access and OS versions on both the computers is the same (Office 2007 and Windows 7 Pro) Tried compact and repair, followed by compile. No errors were found. Made the ACCDE again but the issue remains unresolved.

I am trying to work in a multi user environment for the first time. I have used the split database option and distributed the FE to my colleagues. To prevent any chances in the table I tried making the accde file. The file is working well on my computer but when I am opening it on my colleague's...

I am kinda stuck. Someone please suggest a way out.

I'm using the date entered in a form(combo box) in a report. I want the date to be displayed in the format mmm-yy and so I have specified it in the properties in the report. But still access displays it in the format dd-mm-yyyy the first time. Interestingly when we change the date once it...

Thanks Paul. Problem solved but it resulted in another problem. I used the requery method. The form is working quite well but when I am trying to use the month value from the form in a report I am unable to change it format. Does this method change the date to a string?

I have a form which has 2 combo boxes; one for financial year (name : 'Year') and one for month (name : 'Month'). Currently the year and month display all the months in the source table. I want that after selection of year only those months should appear which corresponds to the selected year...

O Paul!! You Rock Dude!! Problem solved... :)

I have a report (report1) which is based on a single query (query1). There is a second query (query2) which returns just a single value (say 100) and I want the result of the query2 to appear at the bottom of the report1. The query2 is not related to the query1 so I cannot join them. When I...

Point taken Gina...thanks...started a new thread...

I have a report which contains 3 subreports. Now I require to do the following: 1. Hide the subreport if there is no data. 2. Remove the Blank space created when the data in subreport is null. I tried to Set Can Grow and Can Shrink to Yes but still the blank space was not removed. When I...

I want that if the sub report has no data then it should not be displayed and at the same time the blank space which is generated by it should also be removed... I am able to remove the subreport with no data with the above code but the blank space still persists... Pls Help

Ok. Then why am I getting the error? is there some problem in my file/PC?

The query is running properly on its own. When I am opening the report wizard and clicking next after selecting the fields it shows this error. Paul just open the Sample DB I uploaded in the previous thread and try making a report by wizard for qry1. It will make the problem clearer.

I am trying to generate a report from a select query using the report wizard. The wizard is showing the error of subscript of out range. What is the reason and how can be rectified?

Paul!! Thanks a lot dude.... The problem has been solved... :)

I have uploaded the sample database. The qry1, qry2 and qry3 should be made into a single report such that all the information for field_block A should come together and it should be followed with the information of field_block B.

I am not sure joining will solve the problem because: - In query1 there is just one record for each student whereas in query2 and query3 there are more than one record for each students (e.g. marks of 4 semesters in 4 rows) - Say I go ahead and join the query1 and query2 but how will I join...

I have to compile a report from more than two queries. All queries have a field common between them. eg. query1 gives name, address and contact number of all the 30 students in a class query2 gives semester wise marks obtained by each student query3 gives performance in sports of each...