Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.16 seconds.
Search: Posts Made By: CJ_London
Forum: General 12-13-2019, 01:30 PM
Replies: 7
Views: 132
Posted By CJ_London
Re: Database Size, Table Back End, Compact and Repair

Your db is very small so I don't think file size is the issue

your explanation of your setup does not go far enough. Front ends should be local to each user, not on the network as implied by what...
Forum: Forms 12-12-2019, 10:36 AM
Replies: 14
Views: 178
Posted By CJ_London
Re: How to view record from another table in unbound text box in a form

according to Facebook there are now 71 genders;)

https://www.telegraph.co.uk/technology/facebook/10930654/Facebooks-71-gender-options-come-to-UK-users.html
Forum: Forms 12-12-2019, 05:17 AM
Replies: 3
Views: 81
Posted By CJ_London
Re: Continuous subform partly scrolls to the right on load / requery (AC2013)

does your subform have any code to set the focus to a particular control? or code to 'go to last record' or similar.

Also check the tab order for your controls
Forum: Modules & VBA 12-10-2019, 10:10 AM
Replies: 22
Views: 405
Posted By CJ_London
Re: Problems importing file into Access 2019

no idea what logic you are using, I've never had your crashing issue and it has never failed me, although most of my apps import on a maximum of an hourly basis not minute basis. I don't use the...
Forum: General 12-10-2019, 06:17 AM
Replies: 3
Views: 104
Posted By CJ_London
Re: Sales & Purchase Order Database

possibly, really depends on how your db is intended to work. I've used both methods in the past. A single table takes more managing and won't really show much benefit is space saving unless you have...
Forum: Modules & VBA 12-10-2019, 03:09 AM
Replies: 22
Views: 405
Posted By CJ_London
Re: Problems importing file into Access 2019

it doesn't - you tell it

SELECT Fld1, Fld2, .... FROM (SELECT * FROM [TEXT;....) AS txt

If data does not have headers? you add HDR=No within the square brackets (don't forget the semi colon)
...
Forum: Modules & VBA 12-09-2019, 02:42 PM
Replies: 22
Views: 405
Posted By CJ_London
Re: Problems importing file into Access 2019

perhaps you can just use a query rather than transfertext. The basic select query would be

SELECT *
FROM [TEXT;DATABASE=C:\pathtofile].filename.csv;

note pathtofile does not have an ending \
...
Forum: General 12-02-2019, 08:54 AM
Replies: 11
Views: 180
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: 180
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: 299
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: 180
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: 9
Views: 213
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: 9
Views: 213
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: 189
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: 221
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: 837
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: 260
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: 234
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: 234
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: 118
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: 110
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: 197
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...
Showing results 1 to 25 of 500

 
Forum Jump



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