Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.63 seconds.
Search: Posts Made By: CJ_London
Forum: Forms Today, 01:30 AM
Replies: 3
Views: 54
Posted By CJ_London
Re: Slow Loading form

I suspect too much vba code, too much conditional formatting.

For my calendars/planners etc I set 'conditional formatting' by using rich text to set either fore or back color, or both. This is...
Forum: Forms Yesterday, 10:06 AM
Replies: 9
Views: 119
Posted By CJ_London
Re: Calendar icon on date fields

Actually, it looks more like a character that represents a calendar. Similar to webdings chr 166
Forum: Web Design and Development Yesterday, 06:57 AM
Replies: 2
Views: 52
Posted By CJ_London
Re: Website for Form entry linked with MS Access Database

access does not make a good backend for websites, many hosts will not support it - as DB says, use sql server or mysql. either way, it will need to be located online, not on your servers which means...
Forum: Tables Yesterday, 06:45 AM
Replies: 8
Views: 90
Posted By CJ_London
Re: excel to table

not essential to have a unique ID - just depends on what you want to do. Excel data is seriously denormalised so depends what you want your search to return.
Forum: Modules & VBA Yesterday, 05:55 AM
Replies: 20
Views: 196
Posted By CJ_London
Re: refresh with code after update

in the control afterupdate event put some code along the lines of

if dcount("*","myTable","myField=" & txtmyField)>0 then msgbox txmyField & " already entered"
Forum: General 08-15-2019, 03:49 AM
Replies: 45
Views: 938
Posted By CJ_London
Re: calculate cumulative late

crossposted here with answers https://www.accessforums.net/showthread.php?t=77950
Forum: Queries 08-15-2019, 01:34 AM
Replies: 2
Views: 65
Posted By CJ_London
Re: Using a validation rule with an update query

you need to set up validation in your table

or if appropriate you can use your validation in your query to exclude them e.g.

WHERE Right([Post_Code],3) Like '#[a-z][a-z]'

or perhaps have...
Forum: Queries 08-14-2019, 12:17 AM
Replies: 14
Views: 230
Posted By CJ_London
Re: DSUM in Query

@madcats.

So to be clear, your desc column is not populated with

"Balance"
"Serial1"
"Serial2"

as shown in your first two posts but
Forum: Queries 08-13-2019, 04:53 PM
Replies: 14
Views: 230
Posted By CJ_London
Re: DSUM in Query

looks like you have

[Desc]>='"

it should be

[Desc]<='"
Forum: Queries 08-13-2019, 02:49 PM
Replies: 14
Views: 230
Posted By CJ_London
Re: DSUM in Query

have you tried

DSum("[Amt]","[InfoTable]","InvID='" & [InvID] & "' AND Desc<='" & [Desc] & "'")
Forum: Queries 08-13-2019, 09:29 AM
Replies: 32
Views: 466
Posted By CJ_London
Re: Lookup the value from a previous record

you can do it that way, but it makes for more complicated queries. Don't confuse presentation with table design which is the Excel way. tables are for data, queries/forms/reports for presentation. If...
Forum: Excel 08-13-2019, 08:53 AM
Replies: 2
Views: 77
Posted By CJ_London
Re: Getting image in Excel header to center/fit as background letterhead

not sure which version of excel you are using or whether this will work for you, but for more recent versions go to page Layout>Print titles>Header/footer. There is an option for different first page
Forum: Queries 08-13-2019, 08:15 AM
Replies: 32
Views: 466
Posted By CJ_London
Re: Lookup the value from a previous record

please find attached my attempt to help get you going. The data is based on your spreadsheet less a number of duplicate records such as these

16/11/2018 Nitto ATP Finals - London Novak...
Forum: Queries 08-13-2019, 04:04 AM
Replies: 32
Views: 466
Posted By CJ_London
Re: Lookup the value from a previous record

they are limited in scope - and certainly can't do what you are look for
Forum: Queries 08-13-2019, 01:47 AM
Replies: 32
Views: 466
Posted By CJ_London
Re: Lookup the value from a previous record

I don't have a lot of time today, but first you need to normalise your data. Suggest the structure would be something like


tblLocations (not really required since it does not bear on the...
Forum: Queries 08-12-2019, 03:09 PM
Replies: 32
Views: 466
Posted By CJ_London
Re: Lookup the value from a previous record

not sure if I am in a position to offer any help. But the way a problem is solved in excel is frequently not the way you would solve it in a database.

For a start, data needs to be normalised in a...
Forum: Queries 08-12-2019, 06:18 AM
Replies: 22
[SOLVED] Error on IIF
Views: 211
Posted By CJ_London
Re: Error on IIF

just realised I have the formula the wrong way round. It should be

PercentUnsuccessful: Sum([Successful]+1)/sum(abs(Successful]))*100
Forum: Queries 08-12-2019, 04:52 AM
Replies: 22
[SOLVED] Error on IIF
Views: 211
Posted By CJ_London
Re: Error on IIF

No. There is no need to change anything I haven’t mentioned. I suggested removing formatting not changing anything
Forum: Queries 08-12-2019, 03:04 AM
Replies: 22
[SOLVED] Error on IIF
Views: 211
Posted By CJ_London
Re: Error on IIF

add back your grouping then your percentage would be

PercentUnsuccessful: Sum([Failed])/Sum([Boarded])*100

note your failed and boarded values need to be numeric

at the moment this generates...
Forum: The Watercooler 08-11-2019, 03:00 PM
Replies: 2,976
Views: 578,707
Posted By CJ_London
Re: What's your best/worst joke?

"Bless me Father, for I have sinned. I kissed a girl."
The priest asks, "Is that you, little Joey Pagano?"
"Yes, Father, it is."
"And who was the girl you were with?"
"I can't tell you, Father. I...
Forum: Forms 08-10-2019, 02:22 PM
Replies: 5
Views: 117
Posted By CJ_London
Re: quick filter sometimes working

the drop down does not show if the number of possible entries is too great. Not sure what that number is however - it is less than what excel might display, although that has it's limits as well.
Forum: Forms 08-09-2019, 04:19 PM
Replies: 13
Views: 180
Posted By CJ_London
Re: Incorrect SQL Statement while using more than one criteria

when you paste your code into your post, highlight it and click the code button (the # button)
Forum: Forms 08-09-2019, 02:43 PM
Replies: 13
Views: 180
Posted By CJ_London
Re: Incorrect SQL Statement while using more than one criteria

Please use the code tags - your code is otherwise very difficult to read and will put off people responding.
Forum: Forms 08-08-2019, 09:50 AM
Replies: 6
Views: 113
Posted By CJ_London
Re: Making a Default Value Appear as "no"

you are using a combobox - so what is the rowsource to your combo? if it is something like

0;No;-1;Yes

then set the default value to 0
Forum: Modules & VBA 08-06-2019, 05:25 AM
Replies: 18
Views: 297
Posted By CJ_London
Re: Optimum method of handling subforms from large SQL data sets

isnull in TSql should not be confused with the VBA isnull function - TSql isnull is the equivalent of the nz function (another VBA function). See this link...
Showing results 1 to 25 of 500

 
Forum Jump



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