Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 35
Search took 0.00 seconds.
Search: Posts Made By: GoodyGoody
Forum: Forms 11-06-2019, 07:29 AM
Replies: 4
Views: 112
Posted By GoodyGoody
Re: Datasheet form refresh issue

Thanks for asking and yes. :)
Forum: Forms 11-04-2019, 11:53 AM
Replies: 4
Views: 112
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: 330
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: 330
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: 330
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: 330
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: 330
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: 330
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: 330
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: 330
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...
Forum: Reports 09-21-2019, 08:28 AM
Replies: 13
Views: 219
Posted By GoodyGoody
Re: Type mismatch between report control and table field

I took out the offending null field and it saved the rest of the data to the 'current' record including fields I was printing on the line as well as the hidden fields I created that were just marked...
Forum: Reports 09-21-2019, 07:08 AM
Replies: 13
Views: 219
Posted By GoodyGoody
Type mismatch between report control and table field

Hi, I have a report in which I want to save the data in a field on the report detail line which is numeric to a table field which is also numeric. Access is producing error 3164 which I assume is a...
Forum: Queries 09-21-2019, 06:37 AM
Replies: 9
Views: 200
Posted By GoodyGoody
Re: What Report level fields are available to the 'On Print' event

thanks for the explanation Pat Hartman. I do like to know why things are happening. Makes it much easier to remember for next time. :)
Forum: Queries 09-21-2019, 06:21 AM
Replies: 9
Views: 200
Posted By GoodyGoody
Re: What Report level fields are available to the 'On Print' event

Hi All, thanks for the replys. AS I suspected, it's because on a report the Query fields are available to the Collection but not the OnPrint event unless explcitly declared as Minty above said to. ...
Forum: Queries 09-16-2019, 07:21 AM
Replies: 9
Views: 200
Posted By GoodyGoody
Re: What Report level fields are available to the 'On Print' event

It's all referring to controls on the Report. The Me.RaceEventID field is on the query and is available to the collection within VBA as I can select it in VBA when I type me.etc . It is not...
Forum: Queries 09-15-2019, 10:44 PM
Replies: 9
Views: 200
Posted By GoodyGoody
What Report level fields are available to the 'On Print' event

Hi, I have a query with a number of columns that aren't printed on the report line but that I was to save to table for each line on the report. In the 'On Print' event I can successfully pick up...
Forum: Queries 09-15-2019, 10:37 PM
Replies: 1
Views: 63
Posted By GoodyGoody
Retrieve non-bound column from combo box in VBA

Hi, Can anyone tell me how I refer to the non-bound column(s) of a COMBO box in VBA? The default Me.Field for example in a Report event would give me teh bound column value but if that field has a...
Forum: Queries 09-12-2019, 10:59 PM
Replies: 3
Views: 102
Posted By GoodyGoody
Re: Refresh combo box on subform after insert

Easy when you know how! Thanks a million.
Showing results 1 to 25 of 35

 
Forum Jump



All times are GMT -8. The time now is 12:41 PM.


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