Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.45 seconds.
Search: Posts Made By: CJ_London
Forum: Modules & VBA Today, 08:31 AM
Replies: 2
Views: 55
Posted By CJ_London
Re: Deleting and Appending data in a table from a separate database

you can do it in a query

delete * from tableB in 'C:\path\to\databaseB.accdb'

INSERT INTO tableB ( fldName ) IN 'C:\path\to\databaseB.accdb'
SELECT tableA.fldName
FROM tableA
Forum: Queries Today, 05:25 AM
Replies: 5
Views: 103
Posted By CJ_London
Re: Access query - calculated value or VBA?

you should be able to do this in a query


SELECT *
FROM myTable
WHERE ftnregex(SSN)=true

this assumes ftnregex is a public function which inspects the SSN value passed to it and returns...
Forum: Modules & VBA Today, 12:52 AM
Replies: 3
Views: 65
Posted By CJ_London
Re: Too few parameters expected one

it may be your query references a form for criteria - which you can't do when opening a recordset.

if this is the case, either build the full query sql in vba or remove the criteria in the query...
Forum: Queries Yesterday, 06:04 PM
Replies: 6
Views: 136
Posted By CJ_London
Re: Tricky query Criteria, between dates if textboxes are null

you are getting your ands and ampersands confused

Between "#" & [Forms]![frmMainMenu]![txtD1] & "# And #" & [Forms]![frmMainMenu]![txtD2] & "#"
Forum: Queries Yesterday, 12:41 AM
Replies: 6
Views: 136
Posted By CJ_London
Re: Tricky query Criteria, between dates if textboxes are null

from a user perspective and simpler code, have your start and end date boxes default to be populated with date-3 months and date.

Then your code is the same whether the user just clicks the 'go'...
Forum: Modules & VBA Yesterday, 12:34 AM
Replies: 5
Views: 95
Posted By CJ_London
Re: Import txt file from same folder as Database

is the database split?

for the front end you can use currentdb.name to give the full path - remove the name to give you the path.

if the backend, inspect the tabledefs for a link table to...
Forum: Modules & VBA 10-18-2017, 02:33 PM
Replies: 7
Views: 187
Posted By CJ_London
Re: Programming Issue

Wecome to the forum.

If you want help ou will need to address a couple of things,

Your code is long, difficult to read and no explanation of what it is trying to do. Suggest you repost and...
Forum: General 10-16-2017, 04:22 PM
Replies: 15
Views: 381
Posted By CJ_London
Re: How to make default value disappear when clicked

what else to you expect? - include a default value you need to change or have it blank if you don't enter anything?

only other thing I can think you can try is to have a bit of code in the...
Forum: General 10-16-2017, 09:04 AM
Replies: 15
Views: 381
Posted By CJ_London
Re: How to make default value disappear when clicked

rather than using a default value, use the format property for the control and leave the default value empty.

your examples are all strings so for a string you could use

@;[Red]"N/A"

for...
Forum: Queries 10-16-2017, 01:40 AM
Replies: 4
Views: 138
Posted By CJ_London
Re: Display "No records found" on Access Form

cross posted here with answers http://www.accessforums.net/showthread.php?t=68608

@luzz - please read this link about the etiquette of cross posting
http://www.excelguru.ca/content.php?184...
Forum: Theory and practice of database design 10-16-2017, 12:48 AM
Replies: 3
Views: 211
Posted By CJ_London
Re: Looking for an employee scheduling solution

Hi XV,

I worked with a client to help determine their scheduling needs (not just employees but also contracted in staff, maintenance, facilities and other resources) and was then commissioned to...
Forum: Theory and practice of database design 10-15-2017, 10:12 AM
Replies: 3
Views: 211
Posted By CJ_London
Re: Looking for an employee scheduling solution

You need to define what you mean by a good solution.

Or are you asking someone to write a solution for you or suggest an off the shelf solution that might meet your needs?

If the latter...
Forum: Queries 10-15-2017, 10:05 AM
Replies: 3
Views: 142
Posted By CJ_London
Re: Grouping text strings in query result

take a look at the concat related function

http://allenbrowne.com/func-concat.html

be aware of the 255 char limit for strings, not tested but the variant datatype might work OK for a memo...
Forum: General 10-13-2017, 03:37 AM
Replies: 16
Views: 515
Posted By CJ_London
Re: Running slow in design mode

No. In vba code in the open event of the first form to be opened when the db opens
Forum: Forms 10-12-2017, 05:00 AM
Replies: 5
Views: 150
Posted By CJ_London
Re: WHy does it go to the next field when I've asked it to set focus to a specific bo

if you use the before update event you need to change your code slightly

If Me.Txt_NewVolume.Text Like "*[A-Z]*" ......

otherwise the code will be working on the original Txt_NewVolume value...
Forum: General 10-11-2017, 03:27 PM
Replies: 16
Views: 515
Posted By CJ_London
Re: Running slow in design mode

another thought. Is your desktop cluttered with many and/or large files? If so, try moving them off the desktop. I had a similar problem on XP many years ago, clearing the desktop solved the problem....
Forum: Queries 10-11-2017, 02:21 PM
Replies: 5
Views: 146
Posted By CJ_London
Re: Crosstab query criteria from subform control

for some queries, including crosstabs, you need to declare your parameters (always a good idea anyway) - see the parameters option on the ribbon in query design view - your crosstab should look...
Forum: Forms 10-11-2017, 12:55 PM
Replies: 7
Views: 209
Posted By CJ_London
Re: Drag & Drop file to Access form

you may or may not have seen this suggestion

https://bytes.com/topic/access/answers/947863-how-create-drag-drop-field-files

needs some work to drag and drop an email attachment and heed the...
Forum: Queries 10-11-2017, 04:27 AM
Replies: 7
Views: 179
Posted By CJ_London
Re: SQL Pivot not working

does sound like your data is not normalised and you are trying to get a normalised view.

You haven't said what your error is, but it may be to do with the fact that for crosstabs you have to...
Forum: General 10-11-2017, 12:51 AM
Replies: 34
Views: 634
Posted By CJ_London
Re: Alignment of text

with no more information the best I can suggest is to set the control(s) alignment to right (or left) in control properties - or from the ribbon in design view under the format tab
Forum: General 10-11-2017, 12:18 AM
Replies: 34
Views: 634
Posted By CJ_London
Re: Alignment of text

not at all clear from your attachment whether this one control or more or what you mean by alignment. Need more information to provide any sort of suggestion
Forum: The Watercooler 10-10-2017, 05:38 AM
Replies: 5
Views: 132
Posted By CJ_London
Re: Interview Question

I agree with Ranman, that is the order of things for any software development. But depending on the environment in which you are working but you might want to google about test scripting - an...
Forum: Queries 10-10-2017, 05:10 AM
Replies: 5
Views: 149
Posted By CJ_London
Re: "Tick" result used in a query result

you can - but would suggest in a form or report since you cannot specify a specific font for a specific column in datasheet view (query or table)

for the relevant control, specify the wingdings...
Forum: Queries 10-10-2017, 02:36 AM
Replies: 7
Views: 179
Posted By CJ_London
Re: SQL Pivot not working

In Access, a pivot query is a view that can only be seen as a query - the underlying query is a simple select query. You cannot use it as a recordsource to a form or report and have it appear as a...
Forum: Modules & VBA 10-09-2017, 04:02 PM
Replies: 6
Views: 227
Posted By CJ_London
Re: Windows 10, 64 bit upgrade, crashing my code

not sure if it is relevant but you seem to have gone over the top with longptr. Only pointer type data should be changed to longptr. 64bit still uses longs where relevant.

Looks like the code has...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:42 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World