Search results for query: *

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

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

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

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

Help please! I have a form which displays an OLE object field. In this case the object is an Excel worksheet. If I select the control which displays the object I can click the command bar as follows: Edit - Worksheet - Open This will open the object in Excel, which is want I want. My...

I have an OLE field in a table (an excel worksheet.) I am looking for a way to automate selection of that field (based on other criteria (with a query??)and have it open in its native application. You can do this by double clicking on the field contents in the table but I need a way to select...

I have an OLE field in a table (an excel worksheet.) I am looking for a way to automate selection of that field (based on other criteria (with a query??)and have it open in its native application. You can do this by double clicking on the field contents in the table but I need a way to select...

I have a OLE object frame on a form wich is used to create an embedded Excel worksheet. This is bound to a field in an underlying table. Is there a way to code, say a command button, so that it will create (actually insert) the worksheet object without having to go to "Insert Object" on the...

I have a form with a sub-form. The sub-form has a combo box whose drop down list is based on a query. The query has criteria based on a field in the main form. The combo box will display correct list items for the first pass through the form and subform. After that the query will not update...

I want my data laid-out in grid (very much like an Excel row) on a report. Is there a native way in ACCESS to size the grid row to the tallest field memeber of that row?

Is there a method/setting to keep the Output window on the screen when I run a project from the IDE. The window is displayed (opened) but when I execute a run(F5) all windows disappear (i.e. Solution Explorer, Tool Box, Output, etc.) I would like to see the output window as the project executes.

I have a DLOOKUP function as the bound source for a text box which returns a value based on a value entered in another control on a form. This works fine when the form loads or a new record is added. However if I change the source value for the DLOOKUP function the function does not...

How can I get a form to automatically enter data in a control (or multiple controls) based on the last entered record? For example the form has a date field. I want that entered date to automatically populate the date field on the succeeding record after the current record is saved.

Is there a way to to check for a null value in a custom dialog box/pop-up form and assign default values if that is the case? I want to do this as criteria in a query field.