Recent content by disgruntled

Hello there.....I have a report that I am trying to alter. There is a detail section and two footer sections. I would like to insert into the report footer a "total" textbox where the sum of a value in one of the footer sections is shown. The name of the field in the footer is "Region_Total". I...

Your logic wasn't right. it would have only done the full loop on the first x then every one after that would have only compared the last value. hth while x < UBound(PcArray) While y < UBound(PcArray) If PcArray(x) = PcArray(y) AND (x <> y) Then msgbox PcArray(x) & " has been enterred twice!"...

Thanks for the quick response...seems to work like a charm.

I have built a db that acts as a reporting tool. I have many forms that criteria is entered and various forms are created. I have disabled my min/max/close buttons. My problem is that I do not want the forms to be allowed to be min/maxed. When I generate a report the user will certainly...

this will add a column to the table. Dim tableSQL As String tableSQL = "Alter TABLE [" & tableName & "] ADD COLUMN COLUMN_NAME Integer;" db.Execute (tableSQL)

I cannot remember how to denote the current directory. It is for the following example: Set MyXL = GetObject(".\SL_Template.xlt") It will be bundled up with the dB so i would like it to work regardless of where the user places the folder.

That is part of it but I would really like it to insert a carriage return after each sentence. In my code i used a chr(13) but it just shows up in the table and report as a little box?

One of the values returned in my report can sometime be quite lengty with numerous sentences. is it possible to format the box to insert a carriage return after every period and have the box size accordingly???? you'd be a lifesaver.

The big picture: I have imported a range of cells from an excel doc into a acces table. I have added and extra field to this table titled "ERROR". I run various SQL queries on the data comparing it to the data in my database and will eventually create a report of the discrepencies. As a result...

this will take care of it if you wrap it aroud anything where the problem may occur. ex. '" & SingleQuoteSearch(ClientName1.Value) & "' Public Function SingleQuoteSearch(ByVal searchString As Variant) 'the function searches for single quotes, and 'replaces them with a blank space so that 'SQL...

Thanks for the help but it turned out to be a side effect of an incomplete table in the dB.

I've tried on the same line and below and even in it's own column and none seem to work. I don't think and if - else is what I need as I want all the values between the range as well as the null values returned so maybe it short circuits once it isn't fitting into the range?????

I have a form where a user enters criteria that determines a query that is executed and sent to a report. My situation arises in one field of the table where in some cases a null value. My form allows the user to set a range for this field but i would also like the query to return the null...

asked the same question a month or so ago....I was referred to this page: http://www.candace-tripp.com/_pages/HTML/default_HTML.asp go to the cascading combo box example. Works like a charm!!!!!

i have a report with an embedded chart i created through the wizard. the report is passed a query to use as it's recordsource as they serve at least 4 queries per report. i need to pass this same query to the chart but cannot seem to get at the chart rowsource property. Assuming because it's...