Search results

You can link to your excel file File ,getexternal data, link tables select the excel file This now appears as a link table in your database and you can query it as you would any access table

RE:xt Field Character Limit in Reports In the memo fields properties (on the report) format and set can grow to yes

In your reports design select a field then from the menu bar select format ,conditional format This may give you a pointer

RE:RE:VB help needed!!!!! This works for me transfers the contents of a table to an excel spreadsheet DoCmd.TransferSpreadsheet acExport, 8, "Your table", "c:\aaatest.xls", True, ""

In your query that the report is based on add a new column; Reptitle:[Please Enter Your Report Title] In the header of the report create a text box, in its properties ,data section set control source to Reptitle

Check the subforms properties format, default view and change from datasheet to either single form or continuous forms

create a query and select the Id and surname click on the totals icon on the toolbar (sideways'M') This will group all the ids' and surnames

Have you tried using transfer database DoCmd.TransferDatabase acExport, "Microsoft Access", "\\spfp02\complaints\MI\KIP_Reporting\KPI.mdb", acTable, "Qry_Extract_For_Productivity", "Oteloproductivity", False the above code will transfer from the current database the contents of the...

In the on timer event of the picture form Open your main form close your picture form In the timer interval event type 2000 if the picture form doesn't display for long enough just increas ethe timer interval

Not sure whether you can change the colour of the background, but you can change the colour of the cells and lines whilst in data sheet view right click on the datasheet and choose datasheet from the list

Instead of having the reports data source as a table or query you can base each field in the report on each field on the form In the report fields data source type =forms![yourform]![fieldname] do this for each field on the report

On the form properties data tab set data entry to yes

REcommand button print In the on open event type Dim nodata as string nodata = nz(dlookup("[Columname]"."[Query reportis based on]"),"") If nodata = "" then Buttonname.visible=false end if

When you create your button to run the reportthe following code is generated for you Dim stDocName As String stDocName = "YourReportname" DoCmd.OpenReport stDocName, acPreview

Design the table and in the required columns data type to currency or In the field section of the query right click properties and set format to currency. or do the same in the report

You have a form that contains your report paramaters create a button using the wizard to run your main report Add all your sub reports to the main report open the form fill in your parameters and click the button your main report will open and so will the sub reports (if they have any data in...

In your query that the report is based on add a new column; Reptitle:[Please Enter Your Report Title] In the header of the report create a text box, in its properties ,data section set control source to Reptitle

I have attached your database The problem was wirh your query You have to supply <> True on each criteria line

In your query select agent1 ad a new column Agenttot:agent1 click the Totals Icon on the toolbar In the total section of the column Agenttot change group by to count

Have a look at the attached database previously posted by GHudson