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...

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.

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-...

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.

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.

Is there a way to make a textbox in a report grow horizontally depending on the size of character in the textbox? Any solutions welcome.TQ

One thing I notice that when you place some field in a report in line and put a rectangle box around those fields (like you format a borderline around a cell in Excel worksheet), it will only appear if there is data,if no data, the rectangular box not printed out. Is it possible that even if...

My report is based on my company standard report that require two feature : 1)Each page of the report must restrict to only a max 30 record per page, i.e. if there is 40 records, the 1st page must show record in sequential order from 1-30 and the remaining 10 appear in second page. 2)There...

How do I force new page after each set of 30 records? Thanking in advance.