Search results

I have written a report which is returning 2 pages of data, in Portrait mode. However, the report is outputting 4 pages, with pages 2 and 4 blank. If I go into Design View, and right click the black square at the top right of the screen above “Report Header”, and then click on Properties, I...

My table X has a field “DateLastUpdated”, along with 7 other fields. I wish to set this field to today’s date whenever any of the 7 others change. To do this, I suspect I can set an ‘On Change’ [Event Procedure] for each of the 7, but is there a better way of doing this ? And can you suggest...

My report needs to showi occupancy in residences over the 52 weeks of a year. My fields will include location, week_number, tenant_name, co-habitant_name, and up to 6 dependents. As I do not want to have to define 52 * 8 fields in my table for all the occurences, is there a neat way, in table...

My Form accesses a query to return a dataset from 2 tables. There are almost 1000 rows returned, and I have the usual navigation buttons along the bottom. So if I want to retrieve a row from the middle of the dataset, it takes quite some time to get to it, using these buttons. I would like the...

My Form accesses a Query as follows : SELECT tblA.A, tblB.B, tblB.C FROM tblA LEFT JOIN tblB ON tblA.A = tblB.A UNION SELECT tblB.A, tblB.B, tblB.C FROM tblB LEFT JOIN TblA ON tblB.A = TblA.A where tblB.A not in (select TblA.A from TblA) This gives me all the rows from tblA, with tblB...

I have a query which accesses a table with 2 fields which are hyperlinks. There is no problem with the display. But if I then enhance this query with a union ,the hyperlinks now show "#" symbols at the beginning & end of each hyperlink in the query. Where do they come from, and how do I...

My table consists of 3 populated text fields and 2 blank OLE Object fields. For the last 2 days I have been creating the OLE Objects as follows : Initially I select Tables from the Objects list, and from the Datasheet view I click on the appropriate {blank} field, and then click on the...

My table consists of a few populated text fields and 2 blank OLE Object fields. For the last 2 days I have been creating the OLE Objects as follows : Initially I select Tables from the Objects list, and then from the Datasheet view I click on the appropriate {blank} field, and then click on...

Can someone advise on the following please ? I developed a system for remote offices which do not have access to network drives. I visited all these offices, and installed the mdb on their C drives. Each month, they all export 5 tables, and email them to their boss here in Head Office, who...

My table is called "table A". There is a date field in this table called "1st Date Issued". My Form accesses this table, and I would like to write an expression which looks at all the entries in my table, and if "1st Date Issued" is more than 14 days ago, then to bring up a MsgBox. I thought I...

My table has a {start of year} date in the format “dd/mm/yyyy”. I need to pick this up as ‘week1, and then add 7 days, for a whole year, so that I can display :- ‘week2’, ({start of year} + 7 days) ‘week3’, ({start of year} + 14 days) etc, etc, right up to ‘week52’. Is there an...

My table has a {start of year} date in the format “dd/mm/yyyy”. I need to pick this up as 'week1', and then add 7 days, for a whole year, so that I can display :- 'week2', ({start of year} + 7 days) 'week3', ({start of year} + 14 days) etc, etc, right up to 'week52', or 'week53' in a...

Is it possible in a Form for there to be a command button, or something similar, that, when clicked, sends the user directly to a unix session ? The table item being displayed in the Form matches a source file in a unix environment. By clicking the button, I want to be able to either navigate...

I have table 1 (t1) with 2 fields (f1) & (f2). I have table 2 (t2) with 2 fields (f1) & (f2). I have a one to many relationship set for t1.f1 and t2.f1. I need to design a form to show these records, with all occurrences of t2.f2 on the same screen as t1.f1 & t1.f2. I thought I could use a...

I am writing a report for Access using ACE reports. My final select looks like this :- Select A, B, count(*) as countx from {temp table} Group by A, B Order by A, B The rows look like : A1 b1 14 A1 b2 7 B1 b3 8 B1 b4 4 B1 b5 3 etc etc I would like the display below ...