Go Back   Access World Forums > Search Forums

 
Showing results 1 to 14 of 14
Search took 0.03 seconds.
Search: Posts Made By: rgwfly
Forum: Reports 01-29-2018, 04:34 PM
Replies: 9
Views: 374
Posted By ridders
Re: Outputs, Reports, KPI's stc.

Just wondering why you think pie charts are more difficult to do in Access?
See attached
Forum: Reports 01-29-2018, 11:33 AM
Replies: 9
Views: 374
Posted By boerbende
Re: Outputs, Reports, KPI's stc.

I do similar things: Our products are delivered with a Certificate of Analysis. I generate this one by opening an Excel template, pumping the required information from a query in Excel, saving it as...
Forum: General 11-22-2017, 06:21 AM
Replies: 5
Views: 461
Posted By The_Doc_Man
Re: Thanks to all you experts

You are welcome.

As to being helpful:

I got seriously involved with Access at work and as a result learned enough to save a failing project. I started "returning the favor" shortly after...
Forum: Modules & VBA 08-11-2017, 07:24 AM
Replies: 3
Views: 215
Posted By Minty
Re: Access to outlook body questions.

Nearly - The syntax is Nz(Expression,ValueIfNull) so for your arrays it would be
aRow(3) = Nz(rec("PersName"),"")
Forum: Forms 06-27-2017, 02:21 AM
Replies: 2
Views: 296
Posted By moke123
Re: MsgBox Twice

you also appear to have a stray "End With"
Forum: Forms 06-26-2017, 10:12 PM
Replies: 2
Views: 296
Posted By JHB
Re: MsgBox Twice

I don't know if that would help, but use the event's Cancel instead of "DoCmd.CancelEvent"
...
"Please select from the drop down box.", _
vbCritical, _
"Canceling Update"
Cancel=True...
Forum: Queries 06-09-2017, 05:30 AM
Replies: 4
Views: 468
Posted By The_Doc_Man
Re: Select all records after first meets criteria

Be aware that whatever query you try will have to include an ORDER BY clause. If not, then "all the records after that (record)" has no meaning.

Tables in Access have no intrinsic "natural"...
Forum: Queries 06-08-2017, 09:25 AM
Replies: 4
Views: 468
Posted By plog
Re: Select all records after first meets criteria

To achieve what you want, I would use a DMin to retrieve the "First" ID value that contains your value and then use it in the criteria to pull all ID values after that.

Here's some code that...
Forum: General 03-23-2017, 03:00 PM
Replies: 7
Views: 589
Posted By CJ_London
Re: Crosstab with more than one header row

not quite sure what you are asking, but a crosstab can only have one 'header' column such as budget, actual, forecast, etc

If you require more, then you need to create multiple crosstabs - one...
Forum: Code Repository 03-15-2017, 02:23 AM
Replies: 2
Views: 2,774
Posted By CJ_London
Re: importing data from Access into Excel

I'd forgotten about that method - have modified the code in the original post
Forum: Theory and practice of database design 11-07-2016, 01:11 PM
Replies: 9
Views: 1,614
Posted By The_Doc_Man
Re: Database assignment design.

The rules to follow in this case - and most other cases, actually - are quite simple.

Rule #1: If you can't do it on paper, you can't do it in Access. Meaning, you have to be able to enumerate...
Forum: Modules & VBA 09-08-2016, 03:48 AM
Replies: 7
Views: 258
Posted By sneuberg
Re: SQL New Record Problem

The immediate cause of the problem your are experiencing is this code

Private Sub Form_AfterUpdate()
On Error GoTo ErrorHandler
Me.Welder = Forms!frmEventDetails!cbWelder

ErrorHandler:
...
Forum: Modules & VBA 09-07-2016, 04:29 PM
Replies: 7
Views: 258
Posted By moke123
Re: SQL New Record Problem

i took a quick look at your db and noted extensive use of lookup fields in your tables. Please take a look at this...http://access.mvps.org/access/lookupfields.htm
lookup fields in tables often mask...
Forum: Sample Databases 09-05-2016, 06:37 AM
Replies: 0
Views: 5,402
Posted By CJ_London
multi select form

Responding to a thread where I suggest using a multiselect listbox, I thought it would be useful to upload this simple example where you can turn a form into a multi select form. It only does a...
Showing results 1 to 14 of 14

 
Forum Jump



All times are GMT -8. The time now is 01:46 AM.


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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World