Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 43
Search took 0.01 seconds.
Search: Posts Made By: GoodyGoody
Forum: Forms 11-16-2019, 03:01 PM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

Good point. Thanks for the reminder. :)
Forum: Reports 11-16-2019, 02:55 PM
Replies: 3
Views: 84
Posted By GoodyGoody
Re: Run report in but 'print' whole report

Well, the report is calculating things like position overall, position within gender and position within gender category as well as various other things which are just difficult to do on a line by...
Forum: Reports 11-16-2019, 02:06 PM
Replies: 3
Views: 84
Posted By GoodyGoody
Run report in but 'print' whole report

Hi, I am running Access 2013. I am writing a Race Timing database and when it comes to printing the times for a race I have a report which saves all the runtime data to a table so that when...
Forum: Forms 11-16-2019, 10:07 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

Sorted. Thanks again
Forum: Forms 11-16-2019, 09:58 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Forum: Forms 11-16-2019, 09:38 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed. :(
Forum: Forms 11-16-2019, 08:22 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no...
Forum: Forms 11-16-2019, 04:37 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

I was running both Refresh and ReQuery and they seem to interfere with each other. Just Requery on its own works a treat so thank you for checking. :)
Forum: Forms 11-06-2019, 07:29 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Re: Datasheet form refresh issue

Thanks for asking and yes. :)
Forum: Forms 11-04-2019, 11:53 AM
Replies: 15
Views: 223
Posted By GoodyGoody
Datasheet form refresh issue

Hi, I'm new to Access (but not coding) and have a datasheet which is just populated from a table. I have put a macro behind the 'ID' field so the user can click the ID field and it runs the Macro...
Forum: Queries 10-08-2019, 05:47 AM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Well spotted that man. That could be a real issue if you have several layers of SQL. A good reason to use the AS keyword sparingly and only if absolutely necessary. :)
Forum: Queries 10-08-2019, 01:09 AM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Attached a full backend DB with a cut down front end. Use SeriesID 2 or go to the Calculate Series menu and select the September 2019 series.
Forum: Queries 10-07-2019, 01:30 PM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Just need to know how to upload the files...I don't appear to have an option to attach files to a post. :)
Forum: Queries 10-07-2019, 01:25 PM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Thanks IslaDogs. I can see it works in the mini DB but I get the same top 2 results ignoring the grouping.
Forum: Queries 10-07-2019, 01:19 PM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Yes, I've tried playing around with the Order By clause but to no avail. I need the ORDER to be ASC for time as I want the fastest times. But if I use DESC i just get the expected slowest 2 times. ...
Forum: Queries 10-07-2019, 12:42 PM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Weird. I really cannot see the difference. (btw, how do I get that nice table image into this post? Anyway, here's my raw data:
RaceRunner RaceTimeSecs
Steve 1376
Steve 1387
Sara 1616...
Forum: Queries 10-06-2019, 06:40 AM
Replies: 17
Views: 336
Posted By GoodyGoody
Re: Selecting Top 'N' records within subgroups in a query

Thanks IslaDogs. Ok, so I am just getting the TOP 2 results of ALL runners rather than the top 2 results for each runner. Note of course that the time is not necessarily unique unlike the OrderID in...
Forum: Queries 10-05-2019, 10:15 AM
Replies: 17
Views: 336
Posted By GoodyGoody
Selecting Top 'N' records within subgroups in a query

Hi Guys, I want to calculate the top 'N' results of each runner within a series of races. I have the following SQL which nicely generates the valid runners (those who have run the requisite number...
Forum: Reports 09-24-2019, 02:52 PM
Replies: 5
Views: 149
Posted By GoodyGoody
Re: Can I tell Access NOT to print a line or to move on to the next Group

Thanks for the tips guys but I would like to use the same input query to run a report just grouped differently to try and keep the number of queries and reports to a minimum. And anyway, I was just...
Forum: Reports 09-23-2019, 10:33 PM
Replies: 5
Views: 149
Posted By GoodyGoody
Can I tell Access NOT to print a line or to move on to the next Group

Hi,

I am printing a report where I want to print UP TO the first 3 lines in each Group. In this case it is a report for runners by Age Category and I just want to show the top 3 (max) in each ...
Forum: Reports 09-22-2019, 03:30 AM
Replies: 13
Views: 219
Posted By GoodyGoody
Forum: Reports 09-21-2019, 02:07 PM
Replies: 13
Views: 219
Posted By GoodyGoody
Re: Type mismatch between report control and table field

Sorry, the ![SeriesID] = IIf(IsNull(Me.SeriesID), 0, CInt(Me.SeriesID)) line gives the error
Forum: Macros 09-21-2019, 01:41 PM
Replies: 12
Views: 239
Posted By GoodyGoody
Re: MessageBox

I know I can do it in VBA but from the answers above there doesn't appear to be a MACRO expression to do this. MessageBox definitely doesn't. All the examples are VBA code but I was looking for the...
Forum: Reports 09-21-2019, 01:37 PM
Replies: 13
Views: 219
Posted By GoodyGoody
Re: Type mismatch between report control and table field

Yep, PBoldy that is my experience. In the following code I am getting the error 'invalid use of Null'. Can anyone explain why? The field does have Null in it:

With rs1
.Edit
...
Forum: Macros 09-21-2019, 08:32 AM
Replies: 12
Views: 239
Posted By GoodyGoody
MessageBox

Hi, I have a button which runs a macro which in turn runs 3 Update Queries to finalise a process and 'fix' the results. I just want a message at the front of the Macro offering the user the choice...
Showing results 1 to 25 of 43

 
Forum Jump



All times are GMT -8. The time now is 09:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World