Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.29 seconds.
Search: Posts Made By: CJ_London
Forum: The Watercooler 08-22-2019, 04:08 PM
Replies: 2,978
Views: 578,783
Posted By CJ_London
Re: What's your best/worst joke?

O’Toole applied for a forklift job at a famous Irish firm based in Dublin. A Norwegian applied for the same job and since both applicants had similar qualifications, they were asked to take a test...
Forum: Queries 08-20-2019, 08:59 AM
Replies: 6
Views: 70
Posted By CJ_London
Re: Crosstab query with qtr and year

the description of what you require is a bit confusing - can you provide an examples of what your required output looks like

e.g.

customerName, billtoName, Q1, Q2, Q3, Q4, 2018, 2019

Also...
Forum: Reports 08-19-2019, 03:12 PM
Replies: 9
Views: 219
Posted By CJ_London
Re: Access Rich-/HTML-Textbox does indents bulleted lists with wrapped text incorrect

Only thing I can suggest is to do some string manipulation. Using VBA, parse or split the string on "<ul>" (I think), determine how many characters can be shown on the first row and <blockquote> to...
Forum: Web Design and Development 08-16-2019, 06:57 AM
Replies: 2
Views: 75
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: Modules & VBA 08-16-2019, 05:55 AM
Replies: 22
Views: 273
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: Queries 08-13-2019, 02:49 PM
Replies: 14
Views: 242
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: 37
Views: 611
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: Queries 08-12-2019, 03:04 AM
Replies: 22
[SOLVED] Error on IIF
Views: 218
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,978
Views: 578,783
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-09-2019, 04:19 PM
Replies: 13
Views: 182
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: Modules & VBA 08-06-2019, 05:25 AM
Replies: 18
Views: 300
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...
Forum: Modules & VBA 08-06-2019, 03:22 AM
Replies: 18
Views: 300
Posted By CJ_London
Re: Optimum method of handling subforms from large SQL data sets

a couple of things

1. Currency is a reserved word and should not be used for field names
2. your passthrough query is using VBA functions (iif) which will slow things down. Recommend change it to...
Forum: Queries 08-04-2019, 01:58 AM
Replies: 8
Views: 186
Posted By CJ_London
Re: Replacing UNION Query Parts With Queries Names

1. no - although you can reference a query e.g.

SELECT * FROM qry1
UNION SELECT * FROM qry2

number of columns and datatype would need to be the same in both queries

2. In Access sql, no,...
Forum: Queries 08-02-2019, 09:21 AM
Replies: 2
Views: 84
Posted By CJ_London
Re: If date field is older than so many months, show text string.

I think what you want is
IIf([Certification Date]<=DateAdd("m",-12,Date()),"expired",IIf([Certification Date]<=DateAdd("m",-10,Date()),"Needs ReCert","NA"))
Forum: Queries 08-01-2019, 08:07 AM
Replies: 22
[SOLVED] Error on IIF
Views: 218
Posted By CJ_London
Re: Error on IIF

you need to check your values - suggest take out the summing and grouping and display the successful, boarded and failed columns to see what you actually have

successful can only be true or false,...
Forum: Queries 08-01-2019, 05:02 AM
Replies: 22
[SOLVED] Error on IIF
Views: 218
Posted By CJ_London
Re: Error on IIF

see post #3 - you are using text, not numbers and you can't do maths with text
Forum: Queries 08-01-2019, 03:48 AM
Replies: 22
[SOLVED] Error on IIF
Views: 218
Posted By CJ_London
Re: Error on IIF

when you say add a value of 1 do you mean the number 1 or the text "1" (you cant add text)

if successful is a boolean and you want the number 1 then all you need is

yes:abs(successful)

also...
Forum: Forms 07-31-2019, 03:32 PM
Replies: 8
Views: 169
Posted By CJ_London
Re: Equipment Calibration Database - Logic

from your description, sounds reasonable to me. However suggest your frequency should be in the first record, not the second e.g.

tblDates
ID...AnniversaryDate...ActualDate...Frequency...
Forum: Forms 07-30-2019, 06:33 AM
Replies: 6
Views: 119
Posted By CJ_London
Re: How to Recalculate all rows in subform Datasheet

In that case I would be inclined to put the calculation in the query unless that prevents you from editing
Forum: Tables 07-29-2019, 11:48 PM
Replies: 4
Views: 115
Posted By CJ_London
Re: Equipment Calibration Database Relationships.

Without knowing the underlying business process, there are some questions. Is the Site-Equipment table required? Surely a specific item of equipment can only be in one location? Unless you move the...
Forum: Forms 07-29-2019, 03:39 AM
Replies: 9
[SOLVED] Combo Box Search
Views: 129
Posted By CJ_London
Re: Combo Box Search

have you tried the example provided by Tera - it works for me
Forum: Queries 07-29-2019, 12:54 AM
Replies: 10
Views: 111
Posted By CJ_London
Re: Success rate on collection times

add them together

FromDate+FromTime etc

or if all times are always within the same day you just change the month(FromTime) to month(FromDate)
Forum: Queries 07-29-2019, 12:47 AM
Replies: 10
Views: 111
Posted By CJ_London
Re: Success rate on collection times

would have thought something like a aggregate function would work. Something like

SELECT month(FromTime) as CollectionMonth, abs(sum(ActualTime Between FromTime and ToTime))/count(FromTime) as...
Forum: Forms 07-29-2019, 12:15 AM
Replies: 9
[SOLVED] Combo Box Search
Views: 129
Posted By CJ_London
Re: Combo Box Search

the error message you get is quite clear - what do you not understand about it?

You are trying to find a record which matches on fullname, but your recordsource does not contain such a field....
Forum: SQL Server 07-27-2019, 10:37 AM
Replies: 13
Views: 206
Posted By CJ_London
Re: Best way to move tables to a new database?

more a question for a sql server forum. Regret I don't have an answer except that there are scripts that can be automatically generated if you right click on the db in SSMS. I've never had to go...
Showing results 1 to 25 of 500

 
Forum Jump



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