Search results

Whoa ! Peter

Thanks for the reply. How did you 'see' there were two passes? You have obviously been able to break into the process between them, to write your array, so any could any control's value be changed at that time, do you think? Cheers

Any channce of you sharing some of your code, sounds interesting? Cheers

Can't you add the Version table to the underlying query?

I was afraid of that! I found a useful link that describes exactly what I want to do and the example there works perfectly. I am even more puzzled now! :rolleyes: Cheers http://www.fontstuff.com/access/acctut19.htm

It seems that some report properties can only be set in vba in design view and others only in preview. Are these 'rules' detailed somewhere? Altering the recordsource in design view then open in preview works fine, however... I am also taking the user input to provide a heading and discount...

RG, I think the Where condition will not allow me enough options but I will have a look at it Thanks

Thanks Brian opening in design view worked ! Cheers

Thanks for your replies. And congratulations Liverpool celebrating Capital of Culture tonight! The code is on a db at work so this is from memory Report has Record source of a query by default Form button vba is currently as follows: Assign user entered data Create SQL string from a template...

Can anyone help me solve this? A form takes some user entered data and provides a button to open a report in preview. I want the report to get its record source dynamically, from the form (an SQL string). If I run the code with report closed it errors saying it isn't open or misspelt. If I run...

You have proabably cracked it by now but you could put a Debug.print SQLtext line under it and then look at how it is being read in the Immediate window

I have found a start to a solution but come up with an odd error It is possible to set the RecordSource property of the report in VBA so the SQL string can be 'put' there. If I run my code with the report not open I get an error saying the report is not open or reference is spelt incorrectly If...

Then I suggest you add an extra field to your table for 'cumative total' and sum all the records in to that each time they entered. That way you can query the table to find the max ABS value of the cum' total and it associated date detail. Peter

Too late now but you have to provide a Specifcation to export with that command, for example DoCmd.TransferText acExportDelim, strSpec, strFile, "Z:\strTxtFile & ".txt", True Creating the export spec is easy but convoluted to find. You have to manually export the table, choose the csv type and...

Are the impact figures daily measurements? It is difficult to handle if they are associated to varying date ranges. If the dates are not important can you just not sum all positive impacts for each reference, and the last entry date detail? Peter

So no suggestions then ??? Peter

Neil, it seems I haven't understood your question! You want to sum the impacts with the same ref no, in a date range, and just see which one has the highest value? Or see the day that has the highest sum of a single reference? Please give us some more to work with! Peter

As very simple way, but a bit clumsy, would be to select the data with parameters in the Query. Place: Between [Start Date?] And [Finish date?] in the Criteria of both the Start Date field and Finish date fields. and [Reference?] in the criteria of the Ref field. Then run the query. It will...

I am trying to tidy up some report code and add some new features, can anyone point me in the right direction. What I currently have is: 8 Reports based on 8 queries all listed in a macro. The user clicks the button the macor runs and 8 reports are previewed. I want to 'convert' this to VBA...

They both Front End / Back End Dbs so what you have suggested is the same as my first thought. I just hoped there might be a quicker/easier way !