Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.38 seconds.
Search: Posts Made By: CJ_London
Forum: General 12-02-2019, 08:54 AM
Replies: 11
Views: 169
Posted By CJ_London
Re: Simple select recordset suddenly not updatable (AC2013)

it is - you need a full version of access and choose the exclusive option before opening the backend directly

or vba code you can open exclusively by setting opendatabase options parameter to...
Forum: General 12-02-2019, 08:23 AM
Replies: 11
Views: 169
Posted By CJ_London
Re: Simple select recordset suddenly not updatable (AC2013)

no locking file implies the db had been opened exclusively - which means other cannot make changes. But that should be released once whoever opened it exclusively closes it again.
Forum: Queries 12-02-2019, 06:17 AM
Replies: 8
Views: 287
Posted By CJ_London
Re: SYNTAX ERROR when INNER JOIN

Would also help to know the exact wording of the syntax error.

Some thoughts

You don't need SELECT DISTINCT, just SELECT - a straight union query automatically use DISTINCT

perhaps the error...
Forum: General 12-02-2019, 06:00 AM
Replies: 11
Views: 169
Posted By CJ_London
Re: Simple select recordset suddenly not updatable (AC2013)

I presume each user has their own copy of the front end? If not, that can cause issues such as this
Forum: Modules & VBA 11-29-2019, 02:33 PM
Replies: 8
Views: 173
Posted By CJ_London
Re: Check for #deleted in a certain field.

screen.updating is what you would use in excel
Forum: Modules & VBA 11-29-2019, 06:24 AM
Replies: 8
Views: 173
Posted By CJ_London
Re: Check for #deleted in a certain field.

just before you run the delete code, turn off screen updating, then turn it on again after you have done your updating/requerying

think the command is

application.echo =false

then
...
Forum: Modules & VBA 11-25-2019, 07:57 AM
Replies: 15
Views: 239
Posted By CJ_London
Re: Update all fields in table

update on a field by field basis - something like

UPDATE myTable
SET myField1 = Replace([myField1],Chr(10) & Chr(13),","),
myField2 = Replace([myField2],Chr(10) & Chr(13),",")
Forum: The Watercooler 11-22-2019, 03:13 PM
Replies: 9
Views: 176
Posted By CJ_London
Re: How common is database corruption

A recent client managed to corrupt a database on sql server, don't know how.

A client from a few years ago had frequent corruptions on an Oracle database - after some months of investigations, it...
Forum: General 11-22-2019, 03:06 PM
Replies: 8
Views: 219
Posted By CJ_London
Re: Speed Over Remote Desktop and SQL

I agree with DBG - Access as a db is as 'fast' as SQL server. What matters is the way your db is designed and the speed of the connection.

See this link about optimising the design of your app -...
Forum: General 11-20-2019, 03:57 PM
Replies: 37
Views: 836
Posted By CJ_London
Re: What determines if someone has exclusive access to a database?

you have timer events running - makes it very difficult to edit code whilst code is running. Suggest disable all your timer events, then make your changes. Then reinstate them before final testing...
Forum: Forms 11-17-2019, 08:18 AM
Replies: 8
Views: 258
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: 229
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: 229
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: 105
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: 122
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: 106
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: 189
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: 100
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: 327
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: 188
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: 188
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: 121
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: 176
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: 299
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: 299
Posted By CJ_London
Re: datasheet conditional formatting not working on one field only

this post was moderated - have now approved
Showing results 1 to 25 of 500

 
Forum Jump



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