Go Back   Access World Forums > Search Forums

 
Showing results 1 to 20 of 20
Search took 0.03 seconds.
Search: Posts Made By: rgwfly
Forum: Forms 08-21-2018, 07:15 AM
Replies: 1
Views: 190
Posted By Frothingslosh
Re: Make table prior to form loading.

Instead of doing it on form open, create a procedure that does everything you need. Have your 'form open' button actually run the procedure, and then have the PROCEDURE open the form.
Forum: Queries 08-06-2018, 11:55 AM
Replies: 8
Views: 192
Posted By plog
Re: Songle row one to many

Sounds like a job for Allen Browne:

http://allenbrowne.com/func-concat.html
Forum: Forms 07-30-2018, 10:12 PM
Replies: 6
Views: 144
Posted By arnelgp
Re: Only One checkbox Allowed

you already have the answer and is the best so far (post #1).
Forum: Forms 07-30-2018, 07:59 AM
Replies: 6
Views: 144
Posted By Uncle Gizmo
Re: Only One checkbox Allowed

Do you mean like this:-

https://youtu.be/7NJTtqCLhZc?t=2m55s

Sample dB available on my Website HERE:-
http://www.niftyaccess.com/loop-through-a-set-of-controls/
Forum: Forms 07-30-2018, 07:32 AM
Replies: 6
Views: 144
Posted By Mark_
Re: Only One checkbox Allowed

Example "Air code"
Sub Clear_CB
Me.Cb01 = False
Me.Cb02 = False
.
.
.
End Sub

Sub Set_CB
Forum: Forms 07-30-2018, 07:25 AM
Replies: 6
Views: 144
Posted By Mark_
Re: Only One checkbox Allowed

As an "After the fact", after update you set all of your check boxes to false and have a select case based off of your option to set ONLY the one you want to true.

Does mean you would need to...
Forum: Reports 01-29-2018, 04:34 PM
Replies: 9
Views: 462
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: 462
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: 547
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: 243
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: 322
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: 322
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: 507
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: 507
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: 669
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: 3,029
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,821
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: 267
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: 267
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,783
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 20 of 20

 
Forum Jump



All times are GMT -8. The time now is 03:41 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World