Search results for query: *

Hi all, I am using access 2007, i need to open a report and automically display the last page of the report, without re-ordering the pages or using send keys. So i have a open report button on a form that opens a 5 page report, when the button is pressed i want the report opened in print...

Update..... Hmmmm....i think the problem related to the tables that are linked to the back end. I've just noticed that when i linked them i inadvertently also linked the system tables as well, so i deleted all the linked tables, started the process again without linking the system tables and...

Hi, When i try and compact and repair my access 2007 accdb file i get a message box "Invalid Operation", has anyone else experienced this or does anyone know why it happens. Thanks, Dan

Once again PH you have saved the day, works perfectly. Thanks Dan

Hi all, I have the following query: ----------------------- SELECT tblCCMR.CMRID, tblClients.SBNo, IIf(IsNull([cmrDate]),"Awaiting 1st Review",[cmrDate]) AS LDate, IIf([confirmed]=True,Format(DateValue([cmrDay] & " " & [monthName] & " " & [cmrNYear]),"ddd dd mmmm...

Thanks again for you time and invaluable input.

Thanks alot PHV it now works as it should! Could you briefly explain why this change was neccessary for it to work properly so that i have a better understanding of what i was doing wrong. Dan.

Hi all, I have an annoying problem: I have a form (frmViewCMR) with a subForm (frmVCMR). This form is opened as a modal pop up when a button is pressed on another main tab form. The subform on frmViewCMR is a continuous list of records with held date and due date. I have an 'Add new CMR...

Thanks for the reply lespaul but the results where the same even when removing intC - all CountName column values were '1'. I have solved the problem but rather awkwardly: QUERY 1(rptB3F42s1): SELECT tblUsers.ufName AS [Staff Name], Left([Forename],1) & "." & [surname] AS CKW1...

Hi there, I have the following query: SELECT tblUsers.ufName AS [Staff Name], Left([Forename],1) & "." & [surname] AS CKW1, tblUsers_1.ufName AS CKW2, 1 AS intC FROM ((tblClients INNER JOIN tblCMRKWs ON tblClients.SBNo = tblCMRKWs.SBno) INNER JOIN tblUsers ON tblCMRKWs.KW1ID = tblUsers.userID)...

damn.. now i have problems with the format of the lines on the report. When i hide the duplicate names i then lose the surrounding text box lines...any suggestions?

Well i didn't think it would be as simple as that... Fantastic advice thanks

I have the following query results (simplified): Name. Payment For. Amount. John Smith Biscuits £20 John Smith Tea Bags £14 Ian Lins Alcohol £10 Lisa Deed Sugar £8 Lisa Deed...

Ok i have solved it.... I was suprised how easy it was.... I opened a recordset to the observations table, counted the number of records for the selected patient, divided the number of records by 18 to calculated how many pages of record they will have, used ('mod' recordcount 18) to...

I have just visited the link, downloaded the example, cut pasted and manipulated the code/modules to suit my purpose and it works perfectly for my needs but again the major problem is that the client uses office 2000. E.g. i can now use VBA to automatically print the last page of the report...

Thanks genomon, Thats exactly the type of solution I need, however my clients PCs have office 2000 not 2002. I don't suppose there is a similar method for office 2000 that anyone knows about?

Thanks for the reply but...... Maybe i should outline the working procedures involved... There is a paper based observations file with a section for each patient. Each patient can have 1 or many pages of observations. Each page can hold up to 18 separate observation records. The old process...

Hi, I have created an application where users can add to a patient's physical observation records which is done through a form. Once they save the new record i want to automatically open a report of all previous physical observations for that patient, go to the last page of the report and...

Thanks Crowley, that was just the type of confirmation i needed. I will go for the lookup table option. My initial thoughts were that because i already have a large number of tables/relationships/indexes in this database was it wise to create another table for just this simple purpose, but i...

Hi there, I am wondering what would be best practise in the following circumstances: I have a client benefits table that amongst over fields contains information about whether the client recieves a certain benefit (benefit recieved: yes/no), if yes then i need to show the benefit amount. Now...