Search results

:giggle: isladogs Felt as dumb as a Troll else I would have just trawled ;) arnelgp I had originally had it in there, I just reinserted into the onload event. Now it doesn't go to acNewRec when I close the VBA code window just shows the first record. Also closing and opening the form gives...

Hi, The following code works (waiting for a new record entry) when I enter it into the code window then change the form from design view to form view. But if I close the form and then re-open, it fails and just shows the last entry (or record). The form has a sub form showing the contents of...

I personally prefer paper books for learning. I have watched a couple of Steve Bishop's videos I find he is a good presenter. Regards

Thank you for that, I knew Monthly hours report had incorrect parameters, was waiting till the Monthly distance was working then going to correct the Xtab queries to reflect those changes. I have, since looking at the changes, fixed the other Xtab queries. Initially I did have the Xtab with the...

I thought that I was achieving this with (DatePart("m",[Date of Activity])) The report has the Month abbreviation that corresponds with the numerical representation. I wanted the month name displayed whether there was data for the column or not. I will study the suggestions in the pointers you...

I have managed to fix the date range problem, made a query to create an interim table of results from the date range and use that data in the Xtab query. The report on a full years data (last year) now displays correctly. BUT if I only use a partial year for the data I get an error which I...

Added a report and massaged the code. If it can't work directly in a Xtab query is it possible to select the date range with one query and then apply the Xtab query to the result?

I am aware that the "rptAnnualBookHours" has incorrect totals "Activity total hours" this is just for testing the date range of the Xtab. You will need to create a directory structure "C:\LogBook App\Reports" or modify the code where the reports get posted.. I have temporarily made report...

how do I post.. it is ready to go I think

Thank you Colin. I have spent some hours today modifying the SQL code to incorporate the date range using [Date of Activity],was mainly using a different less complex Xtab query. I can get it to run on the report but because access wants the [Date of Activity] to be in an aggregate, it...

I didn't notice this response that you posted same time as I was replying. I wasn't sure at the time of your original response if this had been caused by me trying to modify the Xtab query, but now that I have gone to a backup, I see that this is what the Xtab query wizard produced. I am...

I have had to go back to a backup, the changes I did to the Xtab query I couldn't recover from. I thought it might help to post the output of the report. For when I come back here for more assistance on this I hope its ok to come back to the same thread I am going to have to take a break for a...

I was (when trying in old code) getting a message that was indicating that it was too complex . I have removed the parameters believe this approach is not what I want, would prefer using [Date of Activity] parameters being passed from the code if I can.

Ref the parameters first time I have used them, accepted the default, thought it was strange but at the time accepted what thee system gave me. The code I put in "in line code tags" . Should I have posted the code in the window that is presented in the other option?

The date does change from the form where the date range is input , that form is used to select a number of reports.

Ok thought about this during the night! Tested in the old code this morning where it produced the report originally. That code didn't limit the date so it produced report of ALL records in the tables (this was an over sight in the original code), thats why I am trying to limit the date range...

Based on the information following, is there some way to select the date range? This procedure works in other reports that do not use a cross tab query. I am trying to generate a report based on a cross tab query, select a date range of the field [Date of Activity} SQL from Xtab query...

Re your response to #47 , at the time I didn't understand the CurrentDB I have a little better understanding now, This application is my first time dealing with VBA. In my past life I was a M/F technician, I did write a lot of code back then mainly in Cobol but Access VBA is a whole different...

I have a different issue... I created a startup form.. well modified one I copied from the net a few months ago. basically it has an image on the page.... no click events. an "on load" procedure to trigger the above code, an "on timer" procedure to close the form ( this works fine) and an "on...

Debugging VBA has been a major weakness in my knowledge. Thank you all for these links.