Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: CJ_London
Forum: Forms 11-17-2019, 08:18 AM
Replies: 6
Views: 173
Posted By CJ_London
Re: Multivalue combobox does not show all values in subform

it's in the 3rd attachment and is a value list.

I don't use multivalue fields and certainly not with a value list, but I suspect if you were to edit the value list, you will create issues such as...
Forum: Modules & VBA 11-17-2019, 04:06 AM
Replies: 8
Views: 189
Posted By CJ_London
Re: VBA Coding question

in certain parts of the world you use semi colons instead of comma's - and the decimal notation can be different (dots for thousand separators, commas for dp), given the OP's name, I suspect they are...
Forum: Modules & VBA 11-17-2019, 02:03 AM
Replies: 8
Views: 189
Posted By CJ_London
Re: VBA Coding question

what have you tried? the VBA for right(field;5) is the same in access vba

the equivalent of the excel IF function is IIF
Forum: Tables 11-15-2019, 03:26 AM
Replies: 4
Views: 86
Posted By CJ_London
Re: Lookup table properties

you appear to be trying to create a lookup in a table - this is generally a bad idea - you store a number but display text. Use lookups in forms and reports, not tables. Just because you can, doesn't...
Forum: Modules & VBA 11-15-2019, 03:22 AM
Replies: 3
Views: 117
Posted By CJ_London
Re: label connected to control. how to detect?

from a coding perspective you can reference the label's parent property to determine if it is linked to a control, or you can reference a controls control collection to determine if it has a label.
...
Forum: Tables 11-13-2019, 11:45 PM
Replies: 2
Views: 80
Posted By CJ_London
Re: Importing old data into multiple tables

Agree with Pat, one append query for each (affected) table in Access. I would add it is important to get the order in which you run them correct - update all parent tables first, followed by child...
Forum: Macros 11-13-2019, 08:30 AM
Replies: 10
Views: 159
Posted By CJ_London
Re: Skip Append Query if 0 Rows

it will also work with select queries but as you have surmised not action queries such as insert.

you could have two queries - a select query and an append query using the select query as it's...
Forum: Queries 11-11-2019, 06:24 AM
Replies: 6
Views: 93
Posted By CJ_London
Re: 2-Month Warning before Expire Dates

if expiration date includes a time element then it will never be a whole number so you will never get your formula to =80. Agree with DBG's suggestion - if only because if you don't run the query...
Forum: General 11-11-2019, 01:13 AM
Replies: 20
Views: 295
Posted By CJ_London
Re: Moving Access Database to OneDrive

Curious as to why management would want to move it to onedrive. If working well now, what would be the perceived benefit?
Forum: Tables 11-07-2019, 01:34 AM
Replies: 5
Views: 156
Posted By CJ_London
Re: Table with 50000 records

you might find this link helpful to understand the benefits of indexing
https://www.access-programmers.co.uk/forums/showthread.php?t=291268&page=5
Forum: Tables 11-06-2019, 02:31 PM
Replies: 5
Views: 156
Posted By CJ_London
Re: Table with 50000 records

among many factors that affect performance it depends on your indexing - if fields regularly used for joining, filtering, criteria and/or sorting are not indexed then you will see a performance...
Forum: Queries 11-06-2019, 03:10 AM
Replies: 4
Views: 100
Posted By CJ_London
Re: EXPORT QUERY *.csv format

If I've understood correctly you need to use a union query

SELECT [Ordine_Versamento] & ";" & "V" & ";;;;"
FROM TABELLA_IPOS_VERSAMENTO
UNION SELECT [Ordine_Versamento] & ";;" & [Material] &...
Forum: Modules & VBA 11-05-2019, 01:09 AM
Replies: 5
Views: 158
Posted By CJ_London
Re: Access Data Errors When Running, But Not in Debug Mode (Synchronous or Parallel??

Just to add a comment about doevents and sql server - sql server events occur on the server and not on the local machine - and doevents refers to events on the local machine
Forum: General 11-04-2019, 03:03 PM
Replies: 22
Views: 280
Posted By CJ_London
Re: datasheet conditional formatting not working on one field only

if [Field1] is a boolean, do not use the quotation marks

booleans are numbers: -1=true/yes, 0=false/no
Forum: General 11-04-2019, 03:01 PM
Replies: 22
Views: 280
Posted By CJ_London
Re: datasheet conditional formatting not working on one field only

this post was moderated - have now approved
Forum: Tables 11-03-2019, 02:55 PM
Replies: 25
Views: 677
Posted By CJ_London
Re: Why does autonumber started at 2 with 1 around the middle and 4 in the last?

just a small correction - there are 86400 seconds in a day - plus 59 if you want to include leap seconds
Forum: General 10-31-2019, 03:09 PM
Replies: 19
Views: 274
Posted By CJ_London
Re: The query cannot be completed

before trying to save as .accde, do you compile your code?

And do you have Option Explicit at the top of each module?

I suspect this error is more to do with attempting to compile the code for...
Forum: Tables 10-31-2019, 05:06 AM
Replies: 19
Views: 357
Posted By CJ_London
Re: Issue with absent SubTable via Shared Relational DB

I suspect it is because for the subdatasheet to work, tblBarCodeEvents needs to be linked to the tblProducts primary key - something you don't appear to have
Forum: Queries 10-31-2019, 04:34 AM
Replies: 6
Views: 117
Posted By CJ_London
Re: Latest Date per product

1. create an aggregate query - call it say qryLatest

SELECT FELD1, Max(Feld2) as Latest
FROM Tabelle1
GROUP BY FELD1

2. Create a second query

SELECT Tabelle1.*
FROM Tabelle1 INNER JOIN...
Forum: Queries 10-31-2019, 03:15 AM
Replies: 7
Views: 223
Posted By CJ_London
Re: Query - Running slow - Advice needed

as others have said, formatting in your where clause precludes the use of indexes

For example why do you have this

WHERE Format(tblAGLGRN.AGLGRN,'00000') <> Format(GS1DECODEextended.[AGL...
Forum: Tables 10-31-2019, 12:52 AM
Replies: 19
Views: 357
Posted By CJ_London
Re: Issue with absent SubTable via Shared Relational DB

sorry, images are no help, need to see the relationships in the backend as a start, plus evidence that the tables you are talking about are in the front end. You've never said what are the subtables,...
Forum: Modules & VBA 10-30-2019, 10:03 AM
Replies: 34
Views: 597
Posted By CJ_London
Re: can't figure where I'm going wrong

going back to the original post - you are missing a single quote

"WHERE ((tbl_tickets.[DateOpened]) LIKE '*" & CmbYear & "')", dbOpenDynaset)
Forum: Forms 10-30-2019, 09:49 AM
Replies: 82
Views: 1,133
Posted By CJ_London
Re: Determining when user moves to webcontrol

get a bigger monitor? Or rotate 90 degrees for portrait mode

Also the invisible form will have mouse events - perhaps that could be translated into a scroll command for the pdf/web control
Forum: General 10-30-2019, 08:03 AM
Replies: 5
Views: 119
Posted By CJ_London
Re: Exporting Query with linked subdata in same format

If you are talking about size to fit in terms of column widths rather than the number of columns, you could create a datasheet subreport - then a bit of code to loop through the columns and set...
Forum: Forms 10-30-2019, 07:56 AM
Replies: 82
Views: 1,133
Posted By CJ_London
Re: Determining when user moves to webcontrol

My example showed a full page view so there was no need to scroll
Showing results 1 to 25 of 500

 
Forum Jump



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