Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 4.93 seconds.
Search: Posts Made By: CJ_London
Forum: Modules & VBA Today, 12:49 AM
Replies: 14
Views: 199
Posted By CJ_London
Re: Sequential number generator that resets

In these situations I have a message box pop up with the newly generated (and committed) code. If user clicks the OK button before they have written it down, there is a fallback in that users have...
Forum: General Yesterday, 01:45 AM
Replies: 5
Views: 111
Posted By CJ_London
Re: Hello!

welcome to the forum

depends how you are importing but the easy way is to import without headers to a temp table the subsequent queries ignore the first row. This will give column names F1, F2 etc
Forum: Queries 09-12-2019, 11:54 PM
Replies: 8
Views: 120
Posted By CJ_London
Re: Too Few Parameters Expected 2 Error

I agree with Arnel, you need to deliminate dates with # - and the date format needs to be US format of mm/dd/yyyy if you are going to treat it as text.

Also, just to confirm - your...
Forum: Modules & VBA 09-12-2019, 09:28 AM
Replies: 14
Views: 199
Posted By CJ_London
Re: Sequential number generator that resets

a common enough question - investigate what is typically called 'dmax+1'
Forum: Queries 09-12-2019, 06:00 AM
Replies: 3
Views: 73
Posted By CJ_London
Re: SQL not working

just finished saying the same thing so no point repeating, but I would also add that when you typed

recCount = "SELECT Count(Standard_Actions.[WeekNumber]) AS recCount _
FROM...
Forum: General 09-12-2019, 03:19 AM
Replies: 7
Views: 115
Posted By CJ_London
Re: User Interface Form - Report

it should be possible

see this link for a similar requirement

https://www.access-programmers.co.uk/forums/showthread.php?p=1639470

start at the first post and work your way through.
...
Forum: Forms 09-12-2019, 03:14 AM
Replies: 8
Views: 147
Posted By CJ_London
Re: Rich text field and numbering list.....

regret I do not have any other suggestions, it might be a bug - do you have a colleague who may have had the same requirement? Alternatively try contacting MS

May take some time, but go to this...
Forum: Forms 09-12-2019, 12:54 AM
Replies: 8
Views: 147
Posted By CJ_London
Re: Rich text field and numbering list.....

it was the reading order of the Subject control I was referring to - it is still set to context in your file.

unable to properly test here because of default window settings but with these...
Forum: Tables 09-11-2019, 11:25 PM
Replies: 17
Views: 245
Posted By CJ_London
Re: Identify and rename MS Access latest table - SQL

you can't do things like rename tables in sql

you can use a make table though
Forum: Reports 09-11-2019, 03:13 PM
Replies: 7
Views: 133
Posted By CJ_London
Re: "Auto Height" vs. "Can Grow" / "Can Shrink"

if you want to adjust a section height (header/detail/footer) after reducing the height (or top) of the lowest control, just set its height to 0 - it will then default to the minimum height it can...
Forum: General 09-11-2019, 08:46 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Method question - Labels

in that case - look at arnel's solution. You will need to pick up two numbers, the one associated with customer/product and the other with 416. Strongly recommend store the number as number and...
Forum: Forms 09-11-2019, 08:03 AM
Replies: 8
Views: 147
Posted By CJ_London
Re: Rich text field and numbering list.....

unable to test but take a look a your control Reading Order property on the format tab - try changing to right to left
Forum: General 09-11-2019, 07:57 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Method question - Labels

re your output. I presume company is shipper, who's name is probably in column 2 of your combo so change this

[Forms]![myForm].CompanyName AS Company

to
...
Forum: General 09-11-2019, 07:52 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Method question - Labels

you've moved the goalposts and now I am not clear exactly what you require. It may be Arnel understands, but I'm not sure.

Provide an example of some label runs perhaps 5 labels in each run....
Forum: Tables 09-11-2019, 06:52 AM
Replies: 17
Views: 245
Posted By CJ_London
Re: Identify and rename MS Access latest table - SQL

although your query works, an alternative one would be

SELECT TOP 1 [Name], ID, DateCreate
FROM MSysObjects
Where Flags = 0
ORDER BY DateCreate Desc

note that Flags=0 could also potentially...
Forum: Reports 09-11-2019, 06:15 AM
Replies: 7
Views: 133
Posted By CJ_London
Re: "Auto Height" vs. "Can Grow" / "Can Shrink"

my bad - should have said report view:)
Forum: General 09-11-2019, 05:30 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Method question - Labels

do the following - change names if you prefer

1. create a table called admCounter with one numeric field called ctr
2. populate this table with 0..9 (a total of 10 records)
3. create a new...
Forum: General 09-11-2019, 05:00 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Method question - Labels

unique barcode2 based on what? a number incrementing from 1?
Forum: Modules & VBA 09-11-2019, 03:17 AM
Replies: 7
Views: 162
Posted By CJ_London
Re: How to find all combinations within a constraint

think you need to provide a more realistic example and expected result to take into account different cubages.

for example if 111 was 5 cubes and same cost of 600 would that be placed in the...
Forum: Introduce Yourself 09-11-2019, 01:00 AM
Replies: 2
Views: 60
Posted By CJ_London
Re: How to calculate remaining days between two dates

use the datediff function

datediff("d", [Due Date],[Assigned Date])

you may need to swap the two fields around depending on whether you want a positive or negative value
Forum: Forms 09-11-2019, 12:58 AM
Replies: 2
Views: 52
Posted By CJ_London
Re: Chart value cut

similar in access, use the iif function

iif(X1 > 1,5,1.5,X1)

replace X1 with the name of your field
Forum: Reports 09-11-2019, 12:12 AM
Replies: 7
Views: 133
Posted By CJ_London
Re: "Auto Height" vs. "Can Grow" / "Can Shrink"

cangrow also only works when printing a form (or report) it has no effect on a form viewed onscreen
Forum: Queries 09-10-2019, 11:56 PM
Replies: 19
Views: 447
Posted By CJ_London
Re: Hide data in combo box that has been previously selected

this link may help. Looks like it uses the Microsoft Windows Image Acquisition Library which should be available to you

https://www.utteraccess.com/forum/index.php?showtopic=2035296
Forum: Forms 09-10-2019, 05:03 AM
Replies: 18
Views: 202
Posted By CJ_London
Re: Complex query - readonly recordset workaround

At the moment, from your description it is not normalised and it's about making your design easier to do what you want. But it's your app, I'll butt out

go with the dbGuys solution - but perhaps...
Forum: Forms 09-10-2019, 04:37 AM
Replies: 18
Views: 202
Posted By CJ_London
Re: Complex query - readonly recordset workaround

these could be in one table with a field to indicate cash/cheque/bank credit.

You could also include the membership fee due in the same table with the above new field to indicate 'fees due'
Showing results 1 to 25 of 500

 
Forum Jump



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