Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 6.00 seconds.
Search: Posts Made By: CJ_London
Forum: General Today, 09:36 AM
Replies: 6
Views: 111
Posted By CJ_London
Re: Code Generators

one comment I would make is that if you get the table/relationships/indexing right first, form and report generation becomes much easier
Forum: Queries Yesterday, 06:25 AM
Replies: 8
Views: 118
Posted By CJ_London
Re: Strange behaviour of Access

faster that using a subquery would be to use a left join query


SELECT tblImages .*
FROM tblImages LEFT JOIN qryIm_DeleteImagesSelect ON tblImages.IMAGEIDPK =...
Forum: Modules & VBA 01-14-2019, 01:06 PM
Replies: 5
Views: 196
Posted By CJ_London
Re: Slow concat crosstab query

if you want help, please provide the information requested
Forum: Modules & VBA 01-14-2019, 01:05 PM
Replies: 26
Views: 641
Posted By CJ_London
Re: Variables instead of controls?

Many of my clients are large multinationals. They don't use access for 'enterprise' scale systems, but they sure as heck do for all the things that those large systems either cannot do or the cost of...
Forum: Forms 01-14-2019, 12:55 PM
Replies: 9
Views: 271
Posted By CJ_London
Re: Win7 to Win10 Clients form slow load

you haven't defined stpath or stDBFile, nor assigned any values. Similarly dbsObj

and this

stFileName = stpath & "\\Equipment\Prodcnt\Databases\Developer\MasterData\RTMgmtDemo_be.accdb...
Forum: Modules & VBA 01-13-2019, 11:21 AM
Replies: 5
Views: 196
Posted By CJ_London
Re: Slow concat crosstab query

do you mean Allen's concatRelated function? if so, not sure why you need it if doing a cross tab for a single invoice per month

Can't explain in more detail as you haven't provided any detail to...
Forum: Queries 01-11-2019, 03:06 AM
Replies: 17
Views: 619
Posted By CJ_London
Re: Syntax problem on building SQL using wildcard * on a numeric field

At one time you could not use leading wildcards in ADO recordsets, but I believe you can now.

As with other responders I avoid leading wildcards like the plague (although I accept there are...
Forum: Modules & VBA 01-11-2019, 01:10 AM
Replies: 12
Views: 407
Posted By CJ_London
Re: VBA code not working as expected

you seem to keep asking questions and not responding to the solutions provided
it is evaluating it and returning a value, just not P.

if gift ID is numeric, why are you adding a space?

when...
Forum: Debates 01-10-2019, 11:29 AM
Replies: 19
Views: 1,092
Posted By CJ_London
Re: UK Cycle paths Vs Roads

I know 'SAL', what's 'SOL'?
Forum: Modules & VBA 01-10-2019, 08:01 AM
Replies: 26
Views: 641
Posted By CJ_London
Re: Variables instead of controls?

bet if you did a filter or sort when the form opened it will take some time since it can't complete the action until the entire recordset is loaded. The form will normally display once there is...
Forum: Queries 01-10-2019, 07:58 AM
Replies: 6
Views: 192
Posted By CJ_London
Re: Practicing Group By - Advice welcome

until you understand the syntax better, always a good idea to use the query builder to get the result you require, then look at the sql window to see what has been generated. Access tends to overdo...
Forum: Queries 01-10-2019, 06:53 AM
Replies: 6
Views: 192
Posted By CJ_London
Re: Practicing Group By - Advice welcome

you only need to select the ID field and count the binsID field, you don't need to select


SELECT ID, Count(BinID) as CountofBinID
FROM Bins
GROUP BY ID


recommend don't use spaces in...
Forum: Forms 01-10-2019, 06:49 AM
Replies: 15
Views: 390
Posted By CJ_London
Re: Not Sure what this systax error is all about

this has already been answered - see post #6. Same applies, you need

if dcount(.)=0 then

or perhaps <>0, depends on what you want the code to do
Forum: Forms 01-10-2019, 06:27 AM
Replies: 9
Views: 271
Posted By CJ_London
Re: Win7 to Win10 Clients form slow load

just to clarify, are you running on the same network as your clients?

also this link may suggest some things that can be done to speed things up
...
Forum: Forms 01-10-2019, 04:03 AM
Replies: 4
Views: 148
Posted By CJ_London
Re: Multiple Combox use same list

sounds like you are talking about cascading combo's. You can try this

if valuelist for combo1 is '1,2,3,4,5,6,7,8'

then in the combo2 enter event put
...
Forum: Modules & VBA 01-10-2019, 03:21 AM
Replies: 26
Views: 641
Posted By CJ_London
Re: Variables instead of controls?

I agree with Colin on that one. just using a table as a recordsource (or rowsource to combo/listbox) is the best way to slow your app down if it contains any significant amounts of data. Only time I...
Forum: Forms 01-10-2019, 03:13 AM
Replies: 15
Views: 390
Posted By CJ_London
Re: Not Sure what this systax error is all about

so you expect us to scroll through hundreds of lines of text with no idea where to look for a syntax error and no documentation of what the code is doing? I see no use of dlookup or dcount in your...
Forum: Debates 01-09-2019, 03:39 PM
Replies: 19
Views: 1,092
Posted By CJ_London
Re: UK Cycle paths Vs Roads

I rarely see any on the roads, I would say I might see one a day!

clearly haven't been to Oxford recently. :D
Forum: Forms 01-09-2019, 03:38 PM
Replies: 4
Views: 157
Posted By CJ_London
Re: Tab Index Not Being Respected

nothing to really go on - perhaps the controls are disabled
Forum: Modules & VBA 01-09-2019, 11:19 AM
Replies: 12
Views: 407
Posted By CJ_London
Re: VBA code not working as expected

sounds like you are using lookup fields in your tables

and how is this supposed to work?

"GiftID= " & [GiftID] & " "

what is the additional space for? ID implies a number

either way...
Forum: General 01-09-2019, 11:10 AM
Replies: 8
Views: 215
Posted By CJ_London
Re: Split Database speed

'unsplitting' will not solve speed issues, if anything, will make it worse. And unsplitting will almost certainly result in a high risk of corruption.

Only other thing I can think you can do is to...
Forum: General 01-09-2019, 10:50 AM
Replies: 10
Views: 264
Posted By CJ_London
Re: Indexes in Access - when to use - modelling question

An index feature that is often overlooked because it does not appear in the field parameters is ignore nulls. What this does is not populate an index where the value is null. If you don't ignore...
Forum: General 01-09-2019, 09:54 AM
Replies: 10
Views: 264
Posted By CJ_London
Re: Indexes in Access - when to use - modelling question

you might find this link of interest

https://www.access-programmers.co.uk/forums/showthread.php?t=291268

it has attracted a lot of responses, but post #1 should be of interest
Forum: Modules & VBA 01-09-2019, 09:48 AM
Replies: 26
Views: 641
Posted By CJ_London
Re: Variables instead of controls?

It is not a practice I've ever followed though I have seen it taught - it may depend on the language. Back then, memory management was much more important so it might have been something to do with...
Forum: Modules & VBA 01-09-2019, 09:29 AM
Replies: 6
Views: 249
Posted By CJ_London
Re: Renumbering Module

If you have a large number of records, ensure that StockCode and OperationNumber fields are both indexed, otherwise it will be pretty slow
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:44 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