Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.46 seconds.
Search: Posts Made By: Pat Hartman
Forum: Modules & VBA Yesterday, 07:31 PM
Replies: 5
Views: 118
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 Yesterday, 07:20 PM
Replies: 15
Views: 153
Posted By Pat Hartman
Re: OpenArgs not evaluated in Current event

Yes, Modal. Thanks Micron and theDBguy
Forum: Forms Yesterday, 07:12 PM
Replies: 11
Views: 159
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 Yesterday, 06:56 PM
Replies: 15
Views: 153
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 Yesterday, 06:45 PM
Replies: 15
Views: 240
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 Yesterday, 06:42 PM
Replies: 4
Views: 65
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 Yesterday, 06:38 PM
Replies: 7
Views: 115
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 Yesterday, 06:20 PM
Replies: 10
Views: 136
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 Yesterday, 05:30 PM
Replies: 11
Views: 325
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. ...
Forum: General Yesterday, 05:25 PM
Replies: 5
Views: 120
Posted By Pat Hartman
Re: Useful links

The utter Access link is broken.
Forum: General Yesterday, 05:13 PM
Replies: 20
Views: 238
Posted By Pat Hartman
Re: Moving Access Database to OneDrive

If it is possible to create a folder on OneDrive that you can update and share but that NO ONE ELSE can update, you could use OneDrive to share. As long as OneDrive ALWAYS downloads a copy and opens...
Forum: General Yesterday, 05:04 PM
Replies: 13
Views: 144
Posted By Pat Hartman
Re: Import/Export Data Tasks

I'm going to have to disagree with that assessment. They are one of those "improvements" are are designed to shelter people from details. If you can't get to the details, you can't change anything...
Forum: Modules & VBA 11-08-2019, 09:34 PM
Replies: 4
Views: 102
Posted By Pat Hartman
Re: Variable not defined

When using the "Form_" syntax from anywhere, you MUST include the entire path starting with the main form.

When you are in the "parent" form for the subform, you should use the...
Forum: Tables 11-08-2019, 08:38 PM
Replies: 5
Views: 111
Posted By Pat Hartman
Re: Table Design & Relationships

I can't make any sense out of table1. Looks like everything to the right of email has a data value as the column name and the values are all empty so I have no idea what they are for.

You started...
Forum: Modules & VBA 11-07-2019, 01:42 PM
Replies: 8
Views: 286
Posted By Pat Hartman
Re: Multi Approvals Task Management (Dashboard Control Form)

When working in a relational database environment think DOWN rather than ACROSS. Data repeats as rows. Each department is on a separate row. You would never repeat columns as you do with Excel.
...
Forum: Forms 11-07-2019, 01:33 PM
Replies: 8
Views: 167
Posted By Pat Hartman
Re: Knowing Previous number

Start by keeping the two fields separate. Then you can use a DMax() to find the highest numeric value for the department and add 1 to generate the next number.

Me.NextNum = Nz(DMax("SeqNum",...
Forum: Forms 11-07-2019, 01:29 PM
Replies: 31
Views: 589
Posted By Pat Hartman
Re: Copy previous record fields into new record form fields

You're getting advice on how to work around the problem of an unnormalized schema. If you want to build a better foundation, please start a new thread with that as a goal so we can be clear what we...
Forum: General 11-07-2019, 12:52 PM
Replies: 15
Views: 261
Posted By Pat Hartman
Re: Link to a powerpoint slide from an Access form

The "governator"

When you're ready, we're here.
Forum: General 11-07-2019, 12:49 PM
Replies: 5
Views: 126
Posted By Pat Hartman
Re: Advice on data management practice

Not if you properly tag the data as you import it.

I have an application where I import bank statements for four different accounts. It is important that no month be missed for an account or...
Forum: General 11-07-2019, 12:37 PM
Replies: 15
Views: 261
Posted By Pat Hartman
Re: Link to a powerpoint slide from an Access form

150 slides??? Are you interested in making this more efficient? There are simple ways to make questionnaires, surveys, etc using a relational database where you don't have to hard-code the...
Forum: General 11-07-2019, 12:25 PM
Replies: 13
Views: 186
Posted By Pat Hartman
Re: Today's date in a calculated field

Now I remember why I have never used any calculated fields in tables. Given when the calculation happens, it makes perfect sense that they would not support Date() or Now().

Just do the...
Forum: Queries 11-06-2019, 08:30 AM
Replies: 15
Views: 240
Posted By Pat Hartman
Re: Update Query Via FORM Input. Please advice

I'm going to ask a silly question.

Why are you using an update query instead of a bound form?
Forum: Tables 11-06-2019, 08:28 AM
Replies: 10
Views: 140
Posted By Pat Hartman
Re: Importing Excel into Access Database

Excel may be fooling you as to the actual contents of the field. Since the record imported when you imported into a new table, the problem may be the data type. Check the data type of each column...
Forum: Tables 11-06-2019, 08:25 AM
Replies: 5
Views: 135
Posted By Pat Hartman
Re: Table with 50000 records

I have tables with millions of rows. As theDBguy says, images and other attachment types take up tons of space and it is better to store a path to them than to store the document itself.

The...
Forum: General 11-06-2019, 08:19 AM
Replies: 13
Views: 186
Posted By Pat Hartman
Re: Today's date in a calculated field

To simplify:
Today() is not a valid function. It would never work
Date() is a valid function and it might work.
Showing results 1 to 25 of 500

 
Forum Jump



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