Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 6.28 seconds.
Search: Posts Made By: jdraw
Forum: Forms Yesterday, 08:10 AM
Replies: 5
Views: 114
Posted By jdraw
Re: School Electoral System

Threads merged --same topic, same poster, with responses.
Forum: Introduce Yourself 06-14-2019, 11:06 AM
Replies: 7
Views: 112
Posted By jdraw
Re: Dale in Pennsylvania

Hi Dale. Welcome. Glad to have you on board. As Doc said hope you can keep us all on the straight and narrow without too much effort. We are all here to learn.
I have 4 grandkids 5, 7,11 and 13.
Forum: Reports 06-13-2019, 08:02 AM
Replies: 18
Views: 276
Posted By jdraw
Forum: Reports 06-13-2019, 07:54 AM
Replies: 18
Views: 276
Posted By jdraw
Re: Report that prompts ID number, and then creates report based on that ID(s)

Can you describe what exactly this means (examples please)
.

What specifically is the same from one to another?
You can have several "reports" that could have parameters for Dates, Employee,...
Forum: Modules & VBA 06-13-2019, 06:39 AM
Replies: 10
Views: 146
Posted By jdraw
Re: Programming Logic for stopping events from occuring

I found this in a discussion on UA (http://www.utteraccess.com/forum/lofiversion/index.php/t2001736.html) re unhandled errors.
Forum: Forms 06-13-2019, 06:19 AM
Replies: 13
Views: 161
Posted By jdraw
Re: Validation For Form

Here is a reference link re Form Events sequence (https://support.office.com/en-us/article/order-of-events-for-database-objects-e76fbbfe-6180-4a52-8787-ce86553682f9).
Forum: Modules & VBA 06-13-2019, 06:15 AM
Replies: 15
Views: 209
Posted By jdraw
Re: only allow correct data input

I agree with the other responders ---avoid manual user entry where/if possible (typos,malcontents...). Provide options for selection where possible. If you have to isolate vast possibilities into...
Forum: Modules & VBA 06-13-2019, 06:07 AM
Replies: 10
Views: 146
Posted By jdraw
Re: Programming Logic for stopping events from occuring

I haven't tried any of this, but my initial thought.
I would try a TempVar, since it would be available across the application.
TempVars do not lose their value when an unhandled error occurs and...
Forum: Reports 06-13-2019, 04:55 AM
Replies: 18
Views: 276
Posted By jdraw
Re: Report that prompts ID number, and then creates report based on that ID(s)

You might get some ideas from Martin Green's Dynamic Reports (https://www.fontstuff.com/access/acctut19.htm).
Forum: Modules & VBA 06-13-2019, 04:43 AM
Replies: 8
Views: 124
Posted By jdraw
Re: VBA to load all the tables with sql server data

More info required.
Can you link to the SQL server tables directly in Access?
Perhaps you can tell us more of your environment and requirement in non-database terms, so we get the "bigger...
Forum: Reports 06-13-2019, 04:33 AM
Replies: 18
Views: 276
Posted By jdraw
Re: Report that prompts ID number, and then creates report based on that ID(s)

Reporting is done from the database.You haven't told us anything about your database -the tables, relationships....
Here is a link to several articles on Database Planning and Design...
Forum: Queries 06-13-2019, 04:28 AM
Replies: 5
Views: 71
Posted By jdraw
Re: Pulling two queries back into one

You may get some ideas from this free Equipment Maintenance data model (http://www.databaseanswers.org/data_models/equipment_maintenance/index.htm) from Barry Williams' site. Note he also includes...
Forum: Introduce Yourself 06-13-2019, 04:22 AM
Replies: 6
Views: 98
Posted By jdraw
Re: New User Hello

Welcome JR.
Forum: Modules & VBA 06-12-2019, 12:29 PM
Replies: 10
Views: 135
Posted By jdraw
Re: Scan String For Comma

Hi Guys,
I saw the slanted quotes and that reminded me of some old posts and personal experience where those quotes were not recognized and responded to that. The code works for me also. I don't...
Forum: Modules & VBA 06-12-2019, 12:07 PM
Replies: 10
Views: 135
Posted By jdraw
Re: Scan String For Comma

Give us an example with your real data.
The quotes you are using have often been misunderstood by Access in my efforts, but could be acceptable for your regional settings??

To find if a...
Forum: Forms 06-12-2019, 03:56 AM
Replies: 2
Views: 65
Posted By jdraw
Re: Combo Box binding

Review some of the posts in the threads listed in Similar Threads at the bottom of this page. There may be solutions or positive advice within.
Good luck.
Forum: Modules & VBA 06-12-2019, 03:16 AM
Replies: 11
Views: 153
Posted By jdraw
Re: Not finding end of the file in loop

Lanason,
Links for debugging and error handling concepts and techniques (https://www.accessforums.net/showthread.php?t=65220&p=352133#post352133); and many more articles on database planning and...
Forum: Forms 06-11-2019, 04:29 PM
Replies: 5
Views: 128
Posted By jdraw
Re: Passing Values from continuous form to another continuous form

Can you describe how FormA and the subform relate in plain English?
And perhaps an example (or 2) of the form and subform populated with values like you describe. Just trying to get an idea of what...
Forum: General 06-11-2019, 04:15 PM
Replies: 14
Views: 376
Posted By jdraw
Re: Entity Attribute Value Model

Tim,

Regarding the Dr patient analogy, here is a data model (Barry Williams' site) that may offer some insight. (http://www.databaseanswers.org/data_models/hospital_patients/index.htm)

As for...
Forum: Modules & VBA 06-10-2019, 12:14 PM
Replies: 18
Views: 301
Posted By jdraw
Re: Set Variable Based Off User Selection

Do you have a list the relates empolder and Name? If so, post a copy.

This does NOT do what you think.

staticFolder will be dimmed as a variant
empolder will be a string datatype.

With...
Forum: Modules & VBA 06-10-2019, 11:33 AM
Replies: 12
Views: 193
Posted By jdraw
Re: Fastest Way For VBA To Delete 4 Local Tables

Here is a link (https://btabdevelopment.com/how-to-use-a-table-to-exclude-data-from-a-query/) (it used to be a sticky here??) to an include/exclude approach from Bob Larson. It may not apply to you...
Forum: Modules & VBA 06-10-2019, 10:59 AM
Replies: 12
Views: 193
Posted By jdraw
Re: Fastest Way For VBA To Delete 4 Local Tables

If you know the names of the tables you wish to delete, you could put the names into an array, as below:
Sub removeTables()
10 On Error GoTo removeTables_Error
Dim i As Integer
...
Forum: Forms 06-09-2019, 04:41 AM
Replies: 2
Views: 119
Posted By jdraw
Re: Personnel andEquipment Tracking System

You may find this free data model from Barry Williams' site helpful.
Inventory of IT Assets (http://www.databaseanswers.org/data_models/inventory_of_it_assets/index.htm)
Forum: Forms 06-07-2019, 12:06 PM
Replies: 33
Views: 304
Posted By jdraw
Re: Text property of Combo in Form Footer (Access 2013)

Interesting. Don't know if it is significant, but it's what I tried.

When I adjusted the code
Private Sub cboPerson_Change()
Debug.Print Screen.ActiveControl.Name
Debug.Print...
Forum: Modules & VBA 06-07-2019, 05:16 AM
Replies: 4
Views: 129
Posted By jdraw
Re: default folder location on selecting a file

Gary,

See if this from M$oft helps (InitialFileName) (https://docs.microsoft.com/en-us/office/vba/api/office.filedialog.initialfilename)
Showing results 1 to 25 of 500

 
Forum Jump



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