Search results

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 both Thanks for you time with this. Its working fine now, its also made me tidy up the relationships aswell. Cheers again. Kev

Hi neileg I want to show the colleagues from the colleagues table that are either in/not in the tblTempNew. I have tried using the join but get exactly the same result. Cheers Kev

Hi Rabbie That doesn't work either (unless there is one record) 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...

DatePart - SOLVED Hi I have found out why it was sorting incorrectly. The original DatePart below was sorting correctly, but by the week number. Week 1 of this year started on 31/12/06. =DatePart("ww",[Date],1,1) I changed the DatePart as below, the difference with this is that the first...

I have changed the SQL to LEFT JOIN and it works now. Thanks for you help. Cheers Kev.:D

Hi Rick I've checked all my sorting and formatting and it all seems to be right. I have attached a small sample of my database just so you can see the tables query and report. What am I missing?:confused: Cheers Kev.

Hi How do you left join. Here is the sql - Do i just have to change the innerjoin to left join. SELECT qryColleagues.WCN, qryColleagues.ClgName, qryColleagues.TLName, qryColleagues.Shift, tblPerformance.OTCode, tblPerformance.ShiftWorked, tblPerformance.Date, tblPerformance.PickHours...

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 Krava Thank you for you help, the code below does the job PERFECT. Sub modQuery() Dim db As Database Dim QryDef As QueryDef Set db = CurrentDb Set QryDef = db.QueryDefs("qryTeamPickStats") QryDef.SQL = "SELECT qryColleagues.WCN, qryColleagues.ClgName, qryColleagues.TLName...

I was reading somewhere else stating that you had to use the .tag when modifying queries in vba. I have tried now to assign the form.tag to the date criteria as below Me.Tag = ">= #" & myFromDate & "# And < #" & myToDate & "#" Then in the query I have put the following expression in the Date...

C+S+S not working when imported Hi all Firstly, the examples in this thread are great, just what I have been looking for. question regarding the post below I took the password ("PW2") out of the VB code (as it wouldn't let me import the modules with the password on). The code works to...

Moniker Thanks for you reply, I can't seem to get it to work though. I have made myFromDate and myToDate global as you said. How do I reference the variable in the query. >=[myfromdate] And <[mytodate]-1 I had entered it like this but when I run the query or report it says enter parameter...

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

Hi Bob I added the line like you said, it modified the headings as I wanted but didn't apply the filter. I have now changed the code so that the filter is applied in the DoCmd. This seems to work fine now. DoCmd.OpenReport "rptIndPickStats", acViewPreview, "", _ "[WCN]='" & myFilter & "'...

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