Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.95 seconds.
Search: Posts Made By: CJ_London
Forum: Reports 01-21-2020, 09:59 AM
Replies: 13
Views: 180
Posted By CJ_London
Re: Clumping prior year, detail current

an alternative to a union query is to use an aggregate query with a conditional clause - but will only work if the table has a unique field (typically an autonumber field).

query might look...
Forum: Reports 01-09-2020, 07:19 AM
Replies: 32
Views: 588
Posted By CJ_London
Re: Create crosstab report from Crosstab query

not sure what version of access you are using but it's not a bug. You can create a report based on a crosstab without specifying column headings (the IN part of the pivot)- but what will be created...
Forum: General 01-08-2020, 10:19 AM
Replies: 4
Views: 165
Posted By CJ_London
Re: Error 3265 executing Query

ok - implies a field is missing or not identified - what is the sql to the query. Perhaps you have two fields from different tables with the same name. Other causes can be a null value somewhere in...
Forum: Forms 01-05-2020, 04:25 PM
Replies: 17
Views: 273
Posted By CJ_London
Re: Set Datasheet Column Widths - How?

no. The code provided dynamically resizes all the controls depending on the contents of the field identified in the control source.

you need to identify columns by name (you can by number, but it...
Forum: Forms 01-05-2020, 03:37 PM
Replies: 17
Views: 273
Posted By CJ_London
Re: Set Datasheet Column Widths - How?

like a number of properties, the columnwidth property can only be accessed using VBA.

you could use code along the following lines to set the column width to fit the data

dim ctl as Control...
Forum: Modules & VBA 01-02-2020, 04:12 AM
Replies: 3
Views: 135
Posted By CJ_London
Re: Loop through Forms Controls excluding SubForm

yes - each control has a type - see this link https://docs.microsoft.com/en-us/office/vba/api/access.accontroltype

so your code would be

for each ctl in me.controls
if...
Forum: Modules & VBA 01-01-2020, 09:17 AM
Replies: 19
Views: 628
Posted By CJ_London
Re: RTE 3085 Undefined Function in expression

you are also missing a comma - there should be three after the name of the report. At the moment you are providing a filter name parameter, not the WHERE parameter. The filter parameter would be the...
Forum: General 12-20-2019, 05:28 AM
Replies: 23
Views: 5,365
Posted By CJ_London
Re: MS Access runtime won't open DB

happy to be of help - but it is an autoexec macro, not a file. Runtime has limited functionality such as no navigation window, not able to edit objects, no right click menus, etc. However you can...
Forum: Forms 12-12-2019, 05:17 AM
Replies: 3
Views: 117
Posted By CJ_London
Re: Continuous subform partly scrolls to the right on load / requery (AC2013)

does your subform have any code to set the focus to a particular control? or code to 'go to last record' or similar.

Also check the tab order for your controls
Forum: Modules & VBA 11-17-2019, 02:03 AM
Replies: 8
Views: 266
Posted By CJ_London
Re: VBA Coding question

what have you tried? the VBA for right(field;5) is the same in access vba

the equivalent of the excel IF function is IIF
Forum: Modules & VBA 11-15-2019, 03:22 AM
Replies: 3
Views: 133
Posted By CJ_London
Re: label connected to control. how to detect?

from a coding perspective you can reference the label's parent property to determine if it is linked to a control, or you can reference a controls control collection to determine if it has a label.
...
Forum: Macros 11-13-2019, 08:30 AM
Replies: 10
Views: 229
Posted By CJ_London
Re: Skip Append Query if 0 Rows

it will also work with select queries but as you have surmised not action queries such as insert.

you could have two queries - a select query and an append query using the select query as it's...
Forum: Queries 11-11-2019, 06:24 AM
Replies: 6
Views: 107
Posted By CJ_London
Re: 2-Month Warning before Expire Dates

if expiration date includes a time element then it will never be a whole number so you will never get your formula to =80. Agree with DBG's suggestion - if only because if you don't run the query...
Forum: Tables 11-06-2019, 02:31 PM
Replies: 5
Views: 213
Posted By CJ_London
Re: Table with 50000 records

among many factors that affect performance it depends on your indexing - if fields regularly used for joining, filtering, criteria and/or sorting are not indexed then you will see a performance...
Forum: General 10-31-2019, 03:09 PM
Replies: 19
Views: 321
Posted By CJ_London
Re: The query cannot be completed

before trying to save as .accde, do you compile your code?

And do you have Option Explicit at the top of each module?

I suspect this error is more to do with attempting to compile the code for...
Forum: Queries 10-31-2019, 04:34 AM
Replies: 6
Views: 166
Posted By CJ_London
Re: Latest Date per product

1. create an aggregate query - call it say qryLatest

SELECT FELD1, Max(Feld2) as Latest
FROM Tabelle1
GROUP BY FELD1

2. Create a second query

SELECT Tabelle1.*
FROM Tabelle1 INNER JOIN...
Forum: Modules & VBA 10-30-2019, 10:03 AM
Replies: 47
Views: 984
Posted By CJ_London
Re: can't figure where I'm going wrong

going back to the original post - you are missing a single quote

"WHERE ((tbl_tickets.[DateOpened]) LIKE '*" & CmbYear & "')", dbOpenDynaset)
Forum: Forms 10-30-2019, 09:49 AM
Replies: 82
Views: 1,372
Posted By CJ_London
Re: Determining when user moves to webcontrol

get a bigger monitor? Or rotate 90 degrees for portrait mode

Also the invisible form will have mouse events - perhaps that could be translated into a scroll command for the pdf/web control
Forum: Tables 10-30-2019, 02:18 AM
Replies: 19
Views: 435
Posted By CJ_London
Re: Issue with absent SubTable via Shared Relational DB

you can if you zip them and upload the zipped file.
Forum: Forms 10-24-2019, 04:19 PM
Replies: 82
Views: 1,372
Posted By CJ_London
Re: Determining when user moves to webcontrol

I have a possible solution for you if all you are trying to capture is the page number.

I was unable to disable mousewheel in the web control and page up/down went out of sync after a few pages...
Forum: Queries 10-24-2019, 04:33 AM
Replies: 7
Views: 122
Posted By CJ_London
Re: Unmatched Query?

sorry I meant your two queries

left joins are used in unmatched queries

double click on the join and select the option 'include all records from your table....'

Recommend you learn how sql...
Forum: Queries 10-24-2019, 01:27 AM
Replies: 7
Views: 122
Posted By CJ_London
Re: Unmatched Query?

left join your locations table to the other two tables then set is null to the PK that appears in both those tables
Forum: Queries 10-23-2019, 02:35 PM
Replies: 23
Views: 494
Posted By CJ_London
Re: Top Value Query by Group

using subqueries can be slow for large datasets - particularly in your case because you have a calculated value which does not have indexing. How big is your dataset?

Your second query won't work...
Forum: The Watercooler 10-23-2019, 02:10 AM
Replies: 50
Views: 1,031
Posted By CJ_London
Re: Distractions, Distractions, Distractions

this may put things in perspective

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=77117&stc=1&d=1571825374
Forum: Modules & VBA 10-22-2019, 02:05 PM
Replies: 25
Views: 415
Posted By CJ_London
Re: Best string Function

if this is in vba then use the split function

dValue=cDate(split(mystring," ")(0) & " " & split(mystring," ")(1) & " " & split(mystring," ")(2))
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:31 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World