Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.44 seconds.
Search: Posts Made By: June7
Forum: Reports Today, 12:05 PM
Replies: 2
Views: 34
Posted By June7
Re: Put duplicated data in a report

It is possible to force a record to repeat but I've never tried for an entire section.

Possibly easiest to use 2 subreports.

Are you just trying to conserve paper? What if invoice extends over...
Forum: Queries Today, 11:03 AM
Replies: 2
Views: 27
Posted By June7
Re: Applying Criteria to DateDiff Expression

"Doesn't work" means what - error message, wrong result, nothing happens?

Should be able to have criteria under the calculated column. Maybe should use Date() instead of Now().

However, if...
Forum: Reports Today, 10:58 AM
Replies: 1
Views: 22
Posted By June7
Re: Group on first letter

Assume there is also a textbox bound to FileAs field?

Do a test without the Nz() and UCase() functions. What happens? Try including a specific alternate value for the Nz(): Nz([FileAs], "None").
Forum: Queries Yesterday, 06:08 PM
Replies: 8
Views: 91
Posted By June7
Re: Need query to group sums where two fields match

Yes, there are always exceptions to a 'rule'. See if this helps http://allenbrowne.com/AppInventory.html
Forum: Queries Yesterday, 02:28 PM
Replies: 8
Views: 91
Posted By June7
Re: Need query to group sums where two fields match

I question the need for this. Why do you want to calculate and save aggregate data?
Should save raw data and calculate aggregate data when needed, not save it.
Forum: Queries Yesterday, 02:12 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

Without AS Derived alias, it gave error "action query cannot be used as row source".

Picture a SELECT INTO FROM without the nested subquery. There would be a table/query name following the FROM....
Forum: Queries Yesterday, 01:34 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

I was responding to The_Doc_Man.

Go with whatever works. Just pointing out that what I provided also works and it is one query. See post 4. As stated, remove the Src field if you don't want...
Forum: Queries Yesterday, 12:04 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

Having the calculated Src field can provide an identifier so the row will not be duplicate of row in other tables. Yes, the Src field could be included in the outer query - my oversight not showing...
Forum: Queries 03-18-2019, 08:14 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

Well, I tested with and without the alias name. Only worked with.
The one SQL in post 4 worked so why run 2 queries?
Forum: Modules & VBA 03-18-2019, 05:30 PM
Replies: 10
Views: 106
Posted By June7
Re: CDO question

Explore SendOnBehalfOf or SendUsingAccount properties.
https://stackoverflow.com/questions/15937849/vba-outlook-send-message-from-one-of-multiple-mailboxes
Forum: Queries 03-18-2019, 05:20 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

I described in post 4 how to eliminate or include duplicate pairs.
Forum: Queries 03-18-2019, 01:45 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

Okay, need to use an alias name for the subquery.

SELECT F1, F2 INTO myTb FROM
(SELECT F1, F2, "T1" AS Src FROM T1
UNION
SELECT F1, F2, "T2" FROM T2
UNION
SELECT F1, F2, "T3" FROM T3
UNION ...
Forum: Queries 03-18-2019, 01:15 PM
Replies: 16
Views: 164
Posted By June7
Re: Query to update table from a Select query

SELECT INTO creates a table, not updates or inserts existing.

Remove the as derived from each SELECT (missing a space in 2 of them).

Also have closing paren in wrong place. And must end the SQL...
Forum: Modules & VBA 03-17-2019, 10:09 PM
Replies: 7
Views: 124
Posted By June7
Re: Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

See answer provided in referenced cross-post thread.
Forum: Modules & VBA 03-17-2019, 07:08 PM
Replies: 7
Views: 124
Posted By June7
Re: Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

No luck means what - error message, wrong result, nothing happens?

Your export code creates (or tries to) a query in the remote db then the OutputTo looks in the local db for the query and can't...
Forum: General 03-17-2019, 12:33 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

What is too complex about option 1? It is the simplest of the 3.
Forum: Tables 03-17-2019, 12:27 PM
Replies: 13
Views: 148
Posted By June7
Re: Hyperlinks

Hyperlink question answered in related thread https://access-programmers.co.uk/forums/showthread.php?t=304293
Forum: General 03-17-2019, 12:24 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

I described the structure of hyperlink in post 8. Also review http://allenbrowne.com/casu-09.html

SQL (Structured Query Language) is the language of queries. Build a query in Access with the Query...
Forum: General 03-17-2019, 12:06 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

Options:

1. calculate 3-part hyperlink string in textbox ControlSource: ="#" & [fieldname] & "#" and set textbox IsHyperlink property to Yes.

2. create a new hyperlink type field and populate...
Forum: Modules & VBA 03-16-2019, 06:07 PM
Replies: 8
Views: 141
Posted By June7
Re: Search Using only part of the Text

Code in what event?

If you want to provide db for analysis, follow instructions at bottom of my post.
Forum: Modules & VBA 03-16-2019, 05:39 PM
Replies: 8
Views: 141
Posted By June7
Re: Search Using only part of the Text

What other criteria is used to build filterStr? What you have using LIKE and * should work.
Forum: General 03-16-2019, 05:30 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

Cannot be hyperlink, just a simple text string of the file path.

A hyperlink is composed of 3 parts separated by # character. A calculation using string manipulation functions can extract the file...
Forum: General 03-16-2019, 04:41 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

It is a control on the Design tab, just like a button or textbox. It is the last one. You will probably have to click down in the Controls box.
Forum: General 03-16-2019, 02:51 PM
Replies: 15
Views: 197
Posted By June7
Re: Inserting Photo's to specific forms and linking to a file

Don't use Picture property of Image control.

1. text field in table

2. enter the file path for image into each record

3. Image control on form or report, set ControlSource property to the...
Forum: Modules & VBA 03-16-2019, 10:27 AM
Replies: 15
Views: 281
Posted By June7
Re: QR code in Ms Access Module without internet

Review https://www.access-programmers.co.uk/forums/showthread.php?t=299675 (https://www.access-programmers.co.uk/forums/showthread.php?t=299675)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:38 PM.


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