Search results

Thanks for your help I have set the Force Page propery but that seems to just put the footer over the main report which is full A4 - now only the top inch shows then the footer - any ideas??

I have put the subreport in the footer - how do I force the page as you mentioned - this is in Access 2003

Hi I have a main report 'WeeklyReport' that is currently 7 A4 pages long that works fine. I have an additional report that users a similar layout but different data that I wish to add to the end of the main report if possible 'WeeklyReport2' I have initially added the second report as a...

Hi All I'm setting up a Dbase which will sift through scheduled works from two business areas before sending bespoke reports out to staff concerned. The works list comes as an Excel Sheet which I have imported once to create tables within access with a Primary Key as [WorkID] When a job is...

Makes sense now and works exactly right Really appreciate your assistance with this one - a nice simple solution. Many Thanks

I've made a quick test table and it nearly spot on, only one niggle Data: Motorway J1 J2 Distance M6 30 31 2 M6 31 32 1 M6 32 33 3 The SQL Statement works but I noticed if Variable J1 is...

I see what yo're getting at Would this mean that the table would have to include data like J1 J2 30 31 30 32 30 33 i.e an individual distance for each possible eventuality or could it do a sum of all the distances in between

Certainly sounds along the right lines The question comes when there are numerous locations Say you have J30 to J40 and you have distances between each junctions. How could I get the table to throw out the total distance between 30 & 40?

I need some guidance on how I can do the following: Data will be [Junction] = text such as "M6 J29 to J30" [JunctionLength] = number such as '1.88' Objective If the data includes numerous junctions with their lengths is it possible to feed in a start and end point and get back the total...

Quick question about refreshing a chart on a form. I currently have a chart ICCSChart which gets data from a query qryICCS that simply sifts information from tblICCS by [Date] from an unbound field called [Date] on frmMain. On opening frmMain I would like the chart to update and show that...

Would StrFieldName = [Forms]![frmmain]![JunctionAhead] work Basically I have over 400 locations the map in frmmap and rather than write an individual line of code for each calcualtion for every unbound textbox I just wanted to use the value in [JunctionAhead] to determine which textbox would...

Sorry, here goes frmmain contains an unbound text box called [JunctionAhead], this is populated from another field and might look like "J18-J19" Now another form frmmap will contain an unbound textbox called [J18-J19] in which a calculation needs to go. The calculation itself remains the...

Thanks for your reply but I'm not looking for user input just to get a text box name from the field For example if the text box [Field1] = "Field2", then I would want the calculation (answer) in [Field2] text box, this will be done via vba so how do I get vba to check which textbox to enter...

Hi Quick one, if [Field1] contains text that is equal to the name of another field, how do i use [Field1] in vba as the field it contains rather than as Field 1. Basically I want to do some on screen calculations and [Field1] will say which field to place the answer in Many Thanks

I am using the output of a qryAVG to import into some GIS Mappring software. At the moment I have a location made up across fields say Field1-3. Ideally I need to merge these into one string such as "Field1/Field2/Field3" so the software can read it. How can I build an expression to do this...

Thank you both for your assistance, that has worked perfectly. I had picked this code up but wasn't sure how it worked

I have the form, frmAddStaff which contains the field - this is in the format User.Name@Email.com. The first part of the address is the Username which I want to add to a further table - tbltm. This contains the field [Username] How can I set up a query that will append the [Email] from the...

I often use the SendObject method in order to automate emails from databases. I also use a number of MS Exchange email accounts and sometimes need certain emails to send from a certain account. Is it possible for Access to set the From field in an email to do this? Thanks

I have a qryLog containing field [Account] I want users in a form to be able to alter the account name used to generate a subform based on which check boxes for example are ticked. These would be Account1, Account2 etc. How can I do this and then have the active subform update itself, maybe...

And I'm right in thinking this can be used within a DCount Criteria? Thanks for your help, appreciated