Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.42 seconds.
Search: Posts Made By: Pat Hartman
Forum: Tables 11-15-2019, 09:39 PM
Replies: 23
Views: 399
Posted By Pat Hartman
Re: Could use a mentor...

It is not hard at all. You just have to take off your Excel cap and put on your RDBMS cap. Relational databases work nothing like spreadsheets. For starters, in a spreadsheet, every single column...
Forum: Tables 11-15-2019, 09:24 PM
Replies: 26
Views: 381
Posted By Pat Hartman
Re: Table Design & Relationships

You are really struggling with the concept of data being rows rather than columns. There is no reason in the world that I would ever need to know all the names of all the components of all the...
Forum: Tables 11-15-2019, 09:12 PM
Replies: 18
Views: 262
Posted By Pat Hartman
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

If you want to suffix with _pk and _fk, I don't object. I don't do it, but it is not wrong. CustomerID_PK and CustomerID_FK is not confusing. It is the subtle differences like customer vs...
Forum: Forms 11-15-2019, 09:01 PM
Replies: 11
Views: 222
Posted By Pat Hartman
Re: Have combo box on form save to table on new record subform

Take a look at the picture you drew that shows how the fields map. This is a good reflection of the underlying problem. The table needs to be split into two tables. The "header" data goes in the...
Forum: Forms 11-14-2019, 10:36 PM
Replies: 4
Views: 128
Posted By Pat Hartman
Re: save changes to form and subform

Understanding form level events is the key to controlling when a record is saved. Unbound forms are not necessary.

Your save button should not have any validation code. All it should do is to...
Forum: Forms 11-14-2019, 10:18 PM
Replies: 9
Views: 202
Posted By Pat Hartman
Re: New to Access - difficulties with forms

Do not use the 9 digit number as the PK. It is better to use an autonumber and leave the unique number as a data field with a unique index to prevent duplicates.
Forum: Forms 11-14-2019, 10:00 PM
Replies: 4
Views: 109
Posted By Pat Hartman
Re: Combobox not working

When working with an option group, you do NOT reference individual option buttons. You reference the option group value


Private Sub frameRep_Click()
Select Case Me.frameRep
case 4
...
Forum: Queries 11-14-2019, 09:35 PM
Replies: 10
Views: 194
Posted By Pat Hartman
Re: Combining two rows into one..

Maybe it's a grandparents thingy :D
Forum: Tables 11-14-2019, 09:29 PM
Replies: 26
Views: 381
Posted By Pat Hartman
Re: Table Design & Relationships

You need to work more on the normalization.

All product likes will end up in a single table. You would NOT have a table for each product line. Pull out all the common attributes and put them in a...
Forum: General 11-14-2019, 08:52 PM
Replies: 26
Views: 284
Posted By Pat Hartman
Re: Import/Export Data Tasks

I don't have any trouble in A2016. I never use the new methods because I believe them to be less useful. These tables were never created by default. They are only created if you actually save a...
Forum: Queries 11-13-2019, 11:16 PM
Replies: 10
Views: 194
Posted By Pat Hartman
Re: Combining two rows into one..

It would appear that I was sleep-typing when I answered the question. Please pay no attention to anything I said - except that we need a better description of the actual input file.
Forum: Tables 11-13-2019, 11:10 PM
Replies: 2
Views: 80
Posted By Pat Hartman
Re: Importing old data into multiple tables

Taking a flat file and normalizing it is easy enough to do if you understand the data. Typically you would start by running totals queries on the "parent" table data to group all the duplicates into...
Forum: Tables 11-13-2019, 11:05 PM
Replies: 18
Views: 262
Posted By Pat Hartman
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

The point was consistency, not that the underscore was inherently bad.
Forum: Tables 11-13-2019, 09:34 PM
Replies: 18
Views: 262
Posted By Pat Hartman
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

One more comment on the schema. Using different names for PK-FK pairs is confusing to people unfamiliar with the schema and using multiple differences - CarrierID, Carriers, Carrier is even worse. ...
Forum: General 11-13-2019, 09:12 PM
Replies: 26
Views: 284
Posted By Pat Hartman
Re: View & Edit IMEX Data Task Specifications

Good job as usual Colin but I probably wouldn't make this procedure accessible to the user. Whenever you need to make changes to the import/export spec, they should be made to the master copy of the...
Forum: Tables 11-12-2019, 12:54 PM
Replies: 5
Views: 104
Posted By Pat Hartman
Re: Update record in record in table

What happens if two people try to update the same record at the same time? There is no way you can reconcile and merge the results.

If you are going to do this, I would add a LockedBy field to...
Forum: Modules & VBA 11-11-2019, 07:31 PM
Replies: 5
Views: 219
Posted By Pat Hartman
Re: DLookup in VBA code

If any of the lookups return null, the result of the expression will be null. if there is any possibility of nulls in an expression, use Nz() to convert them to zeros.

Me.MonPotAcntPts =...
Forum: Forms 11-11-2019, 07:20 PM
Replies: 17
Views: 203
Posted By Pat Hartman
Re: OpenArgs not evaluated in Current event

Yes, Modal. Thanks Micron and theDBguy
Forum: Forms 11-11-2019, 07:12 PM
Replies: 11
Views: 179
Posted By Pat Hartman
Re: Using an If statement for every record in a subform

You never said and no one ever asked - what event is this code in?

It should work as you intend if it is in the subform's Current event.

I understand J7's question regarding why yes and now are...
Forum: Forms 11-11-2019, 06:56 PM
Replies: 17
Views: 203
Posted By Pat Hartman
Re: OpenArgs not evaluated in Current event

This is the reason that I hide formA when I open formB so that the user has to close formB before reopening it. If both formA and formB need to be visible, then I open formB as a dialog so that...
Forum: Queries 11-11-2019, 06:45 PM
Replies: 15
Views: 345
Posted By Pat Hartman
Re: Update Query Via FORM Input. Please advice

If you are copying data from one table to another, don't. It is poor design strategy to duplicate data. When the source data changes, what prompts the copies to be updated? -- that's why we don't...
Forum: Queries 11-11-2019, 06:42 PM
Replies: 4
Views: 129
Posted By Pat Hartman
Re: Two queries into one (Income minus Expenses)

Is there some reason you can't join the two queries on client?

I would use a left join of income to expenses just in case there are are no expenses.
Forum: Queries 11-11-2019, 06:38 PM
Replies: 10
Views: 194
Posted By Pat Hartman
Re: Combining two rows into one..

I'll start with the obvious. Did you try creating a query that joins the two tables on EmployeeID or whatever the related fields are called?

If the issue is that table 1 has one row but table 2...
Forum: Tables 11-11-2019, 06:20 PM
Replies: 11
Views: 189
Posted By Pat Hartman
Re: Design of table structures

Once you have broken the repeating data into separate tables, there are different ways to bring it back together for different purposes. For forms, you wouldn't use one massive query that...
Forum: General 11-11-2019, 05:30 PM
Replies: 11
Views: 362
Posted By Pat Hartman
Re: Access: The DB that will not die

That doesn't explain why Microsoft's own SQL Server sales team doesn't know that Access isn't ACE. The MS SQL Server team itself has been responsible for several of the "Access is dead" rumors. ...
Showing results 1 to 25 of 500

 
Forum Jump



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


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