Search results

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

The original full post is below called "setting recordsource" if I wasn't clear enough.

In the report_open() sub in the report itself you can set the recordsouce property. I have a similar project where the queries are different as per the criteria choosen on the form so I set a global variable to the query. But if you just have one you could write it in like so...

hi there...i have a access 97 dB that creates multiple reports. Each of these reports is created from a 0ne of four queries depending on the criteria. I would now like to embedd a chart into the report summarizing the data. However, the graph rowsource property does not seem to be accessable...

If anyone is interested i got a great response in a different group. It will be great if this topic is ever searched again: "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message news:<#HeQRbtJBHA.1128@tkmsftngp02>... > The Reports collection only holds open reports, so if your report is...

woops......forgot the code: If cbox_Status = "(ALL)" And cbox_Trait = "(ALL)" Then Reports("rptChar").RecordSource = "qryReport_Chars_none" DoCmd.OpenReport "rptChar", A_PREVIEW End If If cbox_Status <> "(ALL)" And cbox_Trait = "(ALL)" Then...