Search results

This should be simple but I am stuck on this. I am having problem to get a result from query that is based on multiple value from a listbox. Appreciate if anyone out there can provide the solution. Thanx in advance

Recently I had been working on the database for monitoring outstanding payment. One of the feature is that it enable to printout Reminder Letter to customer on outstanding payment. I had assign a code in the Close event procedure of the Report (Reminder letter) that will run the Update Query on...

Thanx. Couldn't thought it would be to simple a solution.

I had try to use Delete query but it will delete the record totally, is there a way to delete certain fields from a record without deleting the record itself? Thanking in advance.

Are you using Access2000 for teh sample report. I 'd downloaded it but message "Unrecognizable database format..." appear. Really appreciate if you could send Access97 format. TQ

I have the following line in the event procedure: If Me.Text67 = 30 + n Then [Text131] = 1 + (n / 30) End if Me.Text67 is function for no of days for a range of period which can be any number that is 30days(1 month)+ n (variable that represent no of days) Me.Text131 is a function to...

I had created a database for electricity bill for 400 plants maintained by my company. One of its feature is that it can generate report for average consumption (Average Consumption Report)for past bills for a period of months-that is to be the parameter of the underlying query for this report-...

TQ, i never thought it so somple, I have search thru Access97 helpfile but couldn't get the answer.

Type "&" in a label but displayed as "_" not "&" This should be simple. Every time I type "&" for a label , i,e. M & E, the label display as M_E not "M & E" as I want it to be. How can I get the typed word to show "M & E" not "M_E"? TQ in advance.

Here is the zip file

The annoying thing is that I had applied your code but it does not work, is the module need to be modified?

Sorry for being too simplistic. What I want is to have a numbering in each page of a report start from 1. The counter I mention is actually the numbering for record printed in each page (this I did by assigning a textbox with source property =1 and running sum) but the problem is that the...

Rich you are simply fantastic, you had solve my long time problem. Thanx also to those who intiated this thread.

Well certain format is best done through excel, this is something that dissappoint me.

Is it possible to reset counter(textbox with running sum over group) on each new page even for the same grouping? Can this be done through some code workout? So far none come close to the solution. This should be a challenging problem to solve.

I guess that some of the limitation of Access report formatting flexibility

I had tried but there is 32 record appearing on 1st page,this is not I intend to achieve, I need to fix a maximum 30 record per page, in my case it should be 1st page 30 & 2nd page the remaining two record.

transfering it to excel is not a practical solution since you will lose some of the report format in excel.

I'd eagerly tried applying your code in my report, but when running the reprot a message appear as "Compile error User -defined type not defined" and when checking the code, the line Dim PrtMipString As str_PRTMIP is highlighted in yellow. Is there something wrong?

I try to open the your zip zile after downloaded it, but a message appear as "Cannot open file:It does not appear to be a valid archive...It is so frustrating coz I had been looking the solution for the same problem and thought I could use yours. Pleass e-mail to me.Please...