Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.31 seconds.
Search: Posts Made By: June7
Forum: Reports Today, 11:09 AM
Replies: 17
Views: 210
Posted By June7
Re: Group on first letter

I already confirmed that doing the calc in report design does work for me. Group On Expression.

However, try doing the calc in query and see if that resolves your issue.
Forum: General Yesterday, 11:59 PM
Replies: 4
Views: 67
Posted By June7
Re: Printing from list box

Filling a listbox with filepath/filename is fairly easy. Review http://allenbrowne.com/func-02.html

However, printing document is entirely different.
Forum: Forms Yesterday, 08:10 PM
Replies: 7
Views: 324
Posted By June7
Re: Conditional Formatting using vba

@aindoe, if you have a question, should start your own thread instead of hijacking an old one. Use DLookup() or join tables in query.
Forum: Visual Basic 03-24-2019, 11:51 PM
Replies: 18
Views: 307
Posted By June7
Re: Attach second report to email

That's really the same procedure you originally posted.

Then what do you mean when you said the hyperlink works perfectly?

Follow the example code. Modify to use your info.

Can't use...
Forum: Queries 03-24-2019, 11:48 AM
Replies: 3
Views: 91
Posted By June7
Re: Add a row based on a field value

One way requires a table of records with a 'counter' field - a field that has values 1 through 10 (10 records). Or use the hidden MySysObjects table which is certain to have enough records. In either...
Forum: Modules & VBA 03-24-2019, 11:38 AM
Replies: 3
Views: 125
Posted By June7
Re: Search for specific Outlook contact card and email members

See if this helps https://officetricks.com/send-mass-email-outlook-using-distribution-list-vba/
Forum: Visual Basic 03-24-2019, 11:11 AM
Replies: 18
Views: 307
Posted By June7
Re: Attach second report to email

What exactly do you not understand about the example code? You said your hyperlink works so you must have already written code to test. If you want to dynamically build hyperlink in code, then...
Forum: Forms 03-22-2019, 11:46 PM
Replies: 1
Views: 52
Posted By June7
Re: Form: 2 Tables Reading sum of field in second table

Not understanding what you want.

Do you mean each expenditure type has its own field? This is not a normalized data structure. If you want to provide db for analysis, follow instructions at...
Forum: Forms 03-22-2019, 03:33 PM
Replies: 8
Views: 136
Posted By June7
Re: Navigation sub-forms opening in new window

Don't try drag and drop with Navigation form, just type the form name on the 'tab'.
Forum: Visual Basic 03-22-2019, 11:46 AM
Replies: 18
Views: 307
Posted By June7
Re: Attach second report to email

That is described back in post 5.
Forum: Forms 03-22-2019, 11:42 AM
Replies: 8
Views: 136
Posted By June7
Re: Navigation sub-forms opening in new window

None. I avoid Navigation form - don't like it.

If you want to provide db for analysis, follow instructions at bottom of my post.
Forum: Reports 03-22-2019, 11:37 AM
Replies: 17
Views: 210
Posted By June7
Re: Group on first letter

Yes it is. So something else is involved in your design. When I use Expression for the group header, I get the output you do.
Forum: Reports 03-22-2019, 12:40 AM
Replies: 17
Views: 210
Posted By June7
Re: Group on first letter

Not the result I get. The initial shows above every record.
Forum: Reports 03-21-2019, 07:07 PM
Replies: 17
Views: 210
Posted By June7
Re: Group on first letter

@MickJay, you are grouping on field Who, not the first letter of Who.

Group on Expression.
Forum: Reports 03-21-2019, 12:42 PM
Replies: 17
Views: 210
Posted By June7
Re: Group on first letter

I do this calculated extraction and grouping in report design and it works just fine.

But I agree, doing calc in query might correct whatever is causing error.
Forum: Forms 03-20-2019, 08:45 PM
Replies: 15
Views: 183
Posted By June7
Re: Variable to pass current forms new on Open New Form

Unless the form is set to always open only to new record, need code that first checks if on new record, otherwise you change value of existing record. Use Open or Current event.

If Me.NewRecord...
Forum: Forms 03-20-2019, 07:43 PM
Replies: 15
Views: 183
Posted By June7
Re: Variable to pass current forms new on Open New Form

Really doesn't explain why you need to know name of calling form.

If form really needs the FK then pass that with OpenArgs.

How are you passing FK in the other forms?
Forum: Reports 03-20-2019, 12:05 PM
Replies: 4
Views: 102
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 03-20-2019, 11:03 AM
Replies: 3
Views: 76
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 03-20-2019, 10:58 AM
Replies: 17
Views: 210
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 03-19-2019, 06:08 PM
Replies: 8
Views: 117
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 03-19-2019, 02:28 PM
Replies: 8
Views: 117
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 03-19-2019, 02:12 PM
Replies: 16
Views: 193
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 03-19-2019, 01:34 PM
Replies: 16
Views: 193
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 03-19-2019, 12:04 PM
Replies: 16
Views: 193
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...
Showing results 1 to 25 of 500

 
Forum Jump



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