Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.37 seconds.
Search: Posts Made By: Pat Hartman
Forum: General 06-29-2019, 10:25 PM
Replies: 28
Views: 840
Posted By Pat Hartman
Re: Entity Attribute Value Model datatypes

Here's a picture of the Product Definition form.
Forum: General 06-29-2019, 10:21 PM
Replies: 28
Views: 840
Posted By Pat Hartman
Re: Entity Attribute Value Model datatypes

Here's an example of an EAV data entry form for an insurance application. This is the ultimate in EAV usage since the User gets to define all the new terms including their data types and what...
Forum: General 06-29-2019, 09:54 PM
Replies: 2
Views: 150
Posted By Pat Hartman
Re: Building the process

Applications don't wear out but they sometimes outgrow the ability of their designers to implement changing requirements. The requested change should dictate whether you need to start from scratch...
Forum: General 06-29-2019, 09:51 PM
Replies: 14
Views: 310
Posted By Pat Hartman
Re: Loosing Data from tables

When you use a subform and set the master/child links correctly, Access takes care of adding the foreign key so that the child records contain the PK of the parent record. When you use a popup form,...
Forum: General 06-29-2019, 09:37 PM
Replies: 2
Views: 137
Posted By Pat Hartman
Re: Add vba in another part of the form

The other form is bound to different data. Can you explain in more detail why you want one form to run code in a different form.
Forum: Reports 06-02-2019, 12:46 PM
Replies: 9
Views: 346
Posted By Pat Hartman
Re: Hide a particular record in report

The presence or absence of a record should not affect how a report works. What exactly does not work for the report if the "blank" record is simply not selected by the RecordSource query?

PS -...
Forum: Queries 06-02-2019, 12:25 PM
Replies: 6
Views: 168
Posted By Pat Hartman
Re: Query a Table in another database Syntax Variations

I have seen this syntax but have never had a need to implement it. I use linked tables and that means that I can use saved querydefs. If I need to point to a different BE, I relink the tables.
Forum: Queries 06-02-2019, 12:17 PM
Replies: 9
Views: 181
Posted By Pat Hartman
Re: Unruly query: multiple iterations of same table, poor performance

I haven't read all the threads so let me apologize in advance if I step on anyone's toes. I use a code table in all my apps and that table contains dozens of tables. I don't think I have a case...
Forum: Tables 06-02-2019, 11:02 AM
Replies: 7
Views: 2,954
Posted By Pat Hartman
Re: Primary Key with date and increment

I'd like to change Doc's item #2 slightly. The expression should use DMax() rather than DCount() just in case you need to delete any records and it needs to handle a null value return as it will...
Forum: Tables 06-02-2019, 10:48 AM
Replies: 28
Views: 657
Posted By Pat Hartman
Re: Primary Keys...Autonumber or Field Name?

In some applications, I find that I have tons of simple lookup lists - status, rank, business type, category, transaction code, etc. After a while, it gets tedious to keep creating new tables and...
Forum: General 06-02-2019, 10:10 AM
Replies: 8
Views: 333
Posted By Pat Hartman
Re: Importing data across many-to-many related tables

To summarize,
If the spreadsheet has data that needs to be imported into different tables, you will need a separate append query for each target table.

I presume this is a one time event so once...
Forum: General 06-02-2019, 09:59 AM
Replies: 27
Views: 679
Posted By Pat Hartman
Re: Nz function - error "undefined function"

It depends on the version of Office. You cannot install the runtime of a given version along with the full version so you can install the runtime for A2013 if you have full A2016 installed but not...
Forum: General 06-02-2019, 09:49 AM
Replies: 2
Views: 208
Posted By Pat Hartman
Re: Read and import a Csv file

To expand on Dave's instructions.
Use File/Get External Data/Import --- depending on your version of Access, these might be slightly different.
Walk through the import wizard to choose fields and...
Forum: General 06-02-2019, 09:37 AM
Replies: 12
Question Vba
Views: 281
Posted By Pat Hartman
Re: Vba

You haven't explained the purpose of duplicating the record. Are you trying to create an update log?

The problem with duplicates is being caused due to the method you are using. As Micron...
Forum: General 06-02-2019, 09:20 AM
Replies: 14
Views: 461
Posted By Pat Hartman
Re: Entity Attribute Value Model

Didn't you have another older question regarding the inspections? Didn't I create an EAV sample for that for you?
Forum: General 06-02-2019, 09:14 AM
Replies: 11
Views: 325
Posted By Pat Hartman
Re: Anyone willing to tutor one on one?

Everyone here will be happy to help by answering questions in the forum but for the kind of personal service you requested, I'm pretty sure there would be a charge. I've done this kind of...
Forum: General 05-31-2019, 02:47 PM
Replies: 12
Views: 405
Posted By Pat Hartman
Re: table design parts drawing revisions and suppliers

I wrote a comprehensive drawing log system for a steel fabrication company. We didn't deal with parts separately although part number was an attribute of a drawing. Our purpose was to track who had...
Forum: General 05-31-2019, 02:19 PM
Replies: 17
Views: 1,047
Posted By Pat Hartman
Re: DB Design and dynamic data entry

Thank you both :)

I'm really happy that you stuck with it. As I mentioned originally, this is not a common design pattern but it is extremely useful when you find yourself having to deal...
Forum: Queries 04-23-2019, 07:07 PM
Replies: 7
Views: 146
Posted By Pat Hartman
Re: date()+1 not working with connected sharepoint calendar

Why not try to actually understand the problem?

When a date includes a time component, that influences the result. If the stored date is 4/23/19 23:15 that is greater than 4/23/19. So the answer...
Forum: Queries 04-23-2019, 06:37 PM
Replies: 7
Views: 193
Posted By Pat Hartman
Re: Search x two parameters

I'm not sure what you mean. The QBE generally shows a couple of empty criteria lines when you open the query in design view. Is that what you are asking about? Don't worry about extra lines.
Forum: Queries 04-22-2019, 01:25 PM
Replies: 56
Views: 878
Posted By Pat Hartman
Re: The Val function

At this point in your process, I'm sure you don't wan to hear this but hard-coding 12 classes is a poor design choice. It is "spreadsheet" thinking rather than relational design...
Forum: Tables 04-22-2019, 12:55 PM
Replies: 22
Views: 574
Posted By Pat Hartman
Re: Long Text Tables

Access is a RAD tool. When you choose to not use its rad features, you give up the primary reason for using Access at all. You are left with all the constraints and none of the benefits.

Forum: Theory and practice of database design 04-19-2019, 10:21 PM
Replies: 9
Views: 376
Posted By Pat Hartman
Re: Best Practice Advice: How to find out when a record is updated in read only BE

If you know the developer, you might be able to influence a change. Adding a last update field to each table is pretty easy as far as changes go. First you add the column to each table. Then you...
Forum: Reports 04-19-2019, 10:14 PM
Replies: 4
Views: 180
Posted By Pat Hartman
Re: Lines in rtf report export

Personally, I think Excel is easier to automate than Word so I would either export as a .pdf, which requires no extra code, or export the data to excel and then use OLE to format it.

If you are...
Forum: Forms 04-19-2019, 10:10 PM
Replies: 6
Views: 160
Posted By Pat Hartman
Re: higlight fileds with differetn color if the entry is null

You can use the BeforeUpdate event which is the event intended for this purpose by the original Access development team OR you can set some properties and put code in a lot of events and hope you've...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 06:25 PM.

Microsoft Access Help
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