Search results

Hi all Is it possible to refer to a variable from a string. I can refer to a field by a string but can't get a string to be used aa a variable. Heres what I have rs.Fields(vField.name) = "a" & Replace(vField.name, " ","") I know the first part works (before =) as I have tried just putting...

Hi How do I open a report and set the Orderby property. DoCmd.OpenReport "rptColleagueByTeam", acViewPreview, "qryColleagues", "[Shift]='" & strshift & "'" Here is the code that opens my report, now I want to sort by 'TLsurname' I thought I would just be able to add the order by on at the...

Hi all I have a report that is grouped by ethnicity and in each ethnic group is then grouped by gender. My report currently shows the split of male/female in each ethnic group and shows a total in each group. At the bottom of my report it gives me a grand total of all, but what I want is to...

Hi all is there a way to display a relating field to a control source property in a report. e.g Controlsource = TeamLeader Teamleader is a lookup in my table from TLno/ TLname. bound column to 1, column count to 2, width to 0;2.5cm (so only the name is displayed in the table but the...

Hi I have a form that is has record source set to a table. if the user does not click the save button I want any changes that have been made to the record to be undone. i.e if the user makes a change but then clicks next/prev record. I only want the record to save when the user clicks on a...

Hi all How do I stop #ERROR from appearing in a text box when there is no data in a required field. my function is =Age([DOB]). This works fine as long as there is a date in the DOB field. I need something along the lines of =IF(IsError(Age([DOB])),"""",Age([DOB])). Or is this the wrong...

Hi all I have read various posts relating to this but can't find a solution to whats happening. Basically, what I am doing is hiding access while a splash form is shown, then when the splash form is closed access is shown again. here is the code (found on this forum) Option Compare Database...

Hi all Bit vague but.. Is it possible to change the size of a report window via vba. my report opens in a popup window and I want to be able to change the size of the window so that it shows the page width (when page is at 100%). Cheers Kev

Hi All Can't understand why the following doesn't work when changing the operator. Using the "<>" SELECT qryColleagues.WCN, qryColleagues.ClgName, qryColleagues.Shift FROM qryColleagues, tblTempNew WHERE (((qryColleagues.WCN)<>[tblTempNew]![WCN])) GROUP BY qryColleagues.WCN...

Hi all I am using the sorting and grouping in my report, but the report is not sorting the records as intended This is the date part grouping I'm using. =DatePart("ww",[Date],1,1) It is grouping all the weeks but the last week is appearing first. e.g 31/12/06 26/11/06 03/12/06 10/12/06...

Hello again Sorry, just posted this in reports, moved it now. Could someone point me in the right direction please. I have seen a thread similar to this before but I can't find it now. I have a query that is made up from 3 different queries. These 3 queries show the stats totals in the last...

Hi all I have a report rptTeamPickStats which source is a query qryTeamPickStats The query has columns such as name, id number etc which are GROUP BY and hours, cases as SUM and there is a DATE field where I originally had a WHERE statement specifying the from and to dates. I want to be...

Hello all I have this code below in access, which in itself works fine. The only thing I want to change is I want the report to print automatically. If I change the acViewPreview to acViewNormal it errors? How do I change this so that I can send the report directly to the printer and apply...