Recent content by RDS2

Thanks Laurie - works like a charm!

I have two combo boxes on a form. The underlying query which supports the list detail in the second combo box is based on a selection in the first combo box. Everything works as it should for the first selection (first combo box) when I open the form. When I change the selection in the first...

Is there a way to count the number of rows that will be imported to an Access table using the Transfer Spreadsheet method? I want to count the rows (in a selection) and display this in a message box so that I can cancel out of the routine if the row count is wrong.

Is there a way to evaluate each chnage in a report page (a row change in a query) and calulate a number based on a vaue contained in that row? For example Row 1 has a tax calc method of 1 and needs a calulation routine, Row 2 has a method of 2 and needs a separate routine, etc. I believe that...

I don't believe that you can do this during data entry; and that is what I'm trying to acheive. For example you can do this in Excel by selecting it in options. The short of it is that I'm trying to save as many keystrokes as possible inasmuch as this is a very data intensive application.

Why doesn,t this work????? If I exclude the "IF" portion the formatting works ok. I want "negative numbers" to be enclosed by (). This works (no error) but I still get a intintial "-" in front of the number. =IIf(Round([tot_ugl],0)=0,"-",(Round(FormatNumber([tot_ugl],-1,-1,-1,-1),0)))

Is there a way to enter a number in a bound form control and have the decimal point automatically inserted (2 decimal places)? For example enter 12345 and have the number stored as 123.45

Yes - if there are only say, 20 lines remaining (because some controls can grow) when the page break is encountered then I want to force the page break (i. e. the page break control remains visible.) If there are more lines remaining on the page when the page break marker is encountered I would...

I have a page break hard coded in a report (always visible.) The break is in the detail section of the report. Is there a way to set the page break to "not visible" if only "X" lines remain on the page?

I have a text box on a form and I want to set its control source to a field value in a query. In this case the query is a TOPN(N=1 in this instance) and I want the value to dispaly in the text box. Can I enter the SQL code in the control source property box or can I use VBA code to accomplishe...

Thanks posters - dhookom; your code attached to the command button that loads the report gets the job done. I understand the ampersand issue - many times my fingers are a "ketstroke" ahead of my brain! Merci.

I want to change the RecordSource property of a sub-report when the main report opens. In my case the sub-report name is "Rpt_r&a_tdoc". The code in the main report event "On Open" is: "Me.Rpt_r&a_tdoc.RecordSource = Qry_docrev_tdoc" This bombs the report out - but - I'm not sure where the...

Can anyone provide some advice on how to insert a "conditional page break" in an Access report? I want to start a new page if there are only "X" lines remaining on the page.

I have a form with a bound OLE object field on it. The object is created (an Excel worksheet) with a double click event attached to a command button on the form. What I need is a method to cancel (or at least get a confirmation that this is what the user wants) the re-creation of the worksheet...

I don't think there is a hyperlink with repspect to the control. I don't believe that there is evan an external address for the Worksheet. Isn't stored with the DB and only accessible through that?