Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.15 seconds.
Search: Posts Made By: CJ_London
Forum: Forms Today, 03:04 PM
Replies: 9
Views: 76
Posted By CJ_London
Re: use a textbox as a resizeable and colourful checkbox

just tried to add a textbox - you have other code which is generating a bunch of errors - however box displays a cross or a tick per the setting.Only issue is you seem to have code that disables the...
Forum: Forms Today, 02:47 PM
Replies: 9
Views: 76
Posted By CJ_London
Re: use a textbox as a resizeable and colourful checkbox

Had a look at your db - I see checkboxes, I don't see textboxes
Forum: Tables Today, 02:44 PM
Replies: 5
Views: 53
Posted By CJ_London
Re: Aggreagte - adding new column to table

think the first data column is a rownumber
Forum: Tables Today, 02:43 PM
Replies: 5
Views: 53
Posted By CJ_London
Re: Aggreagte - adding new column to table

suggest virtual table is the way to go in access - basically including your second query in the first query


SELECT A.sex, A.index, Level, count(A.ID) as X, B.Y
FROM myTable A INNER JOIN (SELECT...
Forum: Reports 07-20-2019, 04:58 AM
Replies: 15
Views: 156
Posted By CJ_London
Re: Moving Text boxes on a report

perhaps I should have said text alignment. With it set to centre, you would end up with per your post 1
Forum: Reports 07-20-2019, 03:15 AM
Replies: 15
Views: 156
Posted By CJ_London
Re: Moving Text boxes on a report

why not make the width of each of the company detail controls the width of the report - then set the alignment to left, centre right as required
Forum: Access Web 07-19-2019, 05:33 PM
Replies: 6
Views: 1,813
Posted By CJ_London
Re: Access as frontend

you need to look at your router performance, perhaps it needs to have a higher capacity.

Also consider using terminal server or citrix or perhaps migrate your sql server to azure
Forum: Modules & VBA 07-19-2019, 09:08 AM
Replies: 6
Views: 112
Posted By CJ_London
Re: PDF to Modules

depends on the volume but you might want to investigate OCR

MS does have a library that converts an image to text - see these links, but does depend on what version you are using, it moved from...
Forum: Modules & VBA 07-19-2019, 05:13 AM
Replies: 12
Views: 137
Posted By CJ_London
Re: Open Admin Form after Login

your login code does not contain an openform command so implies either it does not work at all, or your are opening the form somewhere else

in principle the code would be

if user=admin then
...
Forum: Modules & VBA 07-19-2019, 12:24 AM
Replies: 7
Views: 124
Posted By CJ_London
Re: Dlookup with two criteria

the problem with doing that is that it potentially hides the true problem. If you don't want to show your real names do as you did but say something like 'I've changed the names to make it easier on...
Forum: Queries 07-18-2019, 01:23 PM
Replies: 15
Views: 128
Posted By CJ_London
Re: handle time average

not sure how you would average a date - no idea what it means.

Suggest you explain in simple english what you are trying to achieve.

Using the data you provided in your first post - explain...
Forum: Forms 07-18-2019, 09:50 AM
Replies: 3
Views: 77
Posted By CJ_London
Re: Yes/No field

take a look at this link which implements DBGuys suggestion

https://www.access-programmers.co.uk/forums/showthread.php?t=305659
Forum: General 07-17-2019, 09:54 AM
Replies: 26
Views: 346
Posted By CJ_London
Re: Validation Key for DB - hash email and exp date

so the bad guys go free:) And the honest guy can copy the app to 100 of his friends?
add a licence key to so that the db shuts downthat's a bit harsh - suggest start sending warning messages a month...
Forum: Queries 07-17-2019, 05:57 AM
Replies: 1
Views: 63
Posted By CJ_London
Re: Invalid Procedure Call error in select sum query

you can't start field names with non-alphanumeric character

AS [# Invalid]
Forum: Queries 07-17-2019, 02:45 AM
Replies: 3
Views: 63
Posted By CJ_London
Re: Combining tables in one sql instead of 2 in query

To add to MajPs suggestion, to maintain the left join the criteria needs to be

where qry...Done.serverID = tbl...ServerIDFK OR tbl...ServerIDFK is null

Another way is to combine the two smaller...
Forum: Modules & VBA 07-17-2019, 02:39 AM
Replies: 2
Views: 73
Posted By CJ_London
Re: Using the Replace function

take a look at the documentation for the replace function here https://support.office.com/en-us/article/replace-function-6acf209b-01b7-4078-b4b8-e0a4ef67d181
you need to add a value to the compare...
Forum: Forms 07-16-2019, 07:01 AM
Replies: 1
Views: 87
Posted By CJ_London
Re: Using Connection String instead of ODBC for form

not looked at the rest of your code but try

Set me.recordset = cmd.Execute

note you can populate your form with a ado recordset but access built in features such as find/sort/filter will only...
Forum: Modules & VBA 07-16-2019, 05:02 AM
Replies: 3
Views: 81
Posted By CJ_London
Re: Check folder name and copy

still confused

provide some examples
Forum: Modules & VBA 07-16-2019, 04:04 AM
Replies: 3
Views: 81
Posted By CJ_London
Re: Check folder name and copy

afraid it doesn't



doesn't mean anything -
is that the partial match?
or what you want to find a partial match to?
and if the former which bit are you trying to match?
and is ABC_123 a...
Forum: General 07-16-2019, 03:26 AM
Replies: 4
Views: 102
Posted By CJ_London
Re: Issue with Relationships (I think)

you need to use a different query

I take it the the connection 'direction' is irrelevant i.e.

component A is connected to component B

is the same as

component B is connected to component A
Forum: Modules & VBA 07-16-2019, 12:17 AM
Replies: 2
Views: 89
Posted By CJ_London
Re: Making code run faster with Azure SQL

not sure where you got that idea from.

many inexperienced users will use a table as the recordsource to a form, which is generally bad practice for tables with more than a few records and which is...
Forum: Queries 07-15-2019, 09:16 AM
Replies: 16
Views: 203
Posted By CJ_London
Re: Condensing a history

what happened to row 2 start date?:)
Forum: Queries 07-15-2019, 08:57 AM
Replies: 16
Views: 203
Posted By CJ_London
Re: Condensing a history

you haven't really clarified all the possible exceptions so the only way I can suggest is based on there only every being two records that are next to each other per your example - and since you...
Forum: Queries 07-15-2019, 07:57 AM
Replies: 16
Views: 203
Posted By CJ_London
Re: Condensing a history

according to your data on 1/1/2009 you had both 25 and 47 players. same issue for 1/1/2004 correct your data to what you really mean first.

And to be clear, is this a one off tidying up exercise...
Forum: Forms 07-15-2019, 06:57 AM
Replies: 4
Views: 158
Posted By CJ_London
Re: Maintain cost after order submitted and price changes??

cross posted here with answers, question phrased slightly differently but requires same answers

https://www.accessforums.net/showthread.php?t=77591
Showing results 1 to 25 of 500

 
Forum Jump



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