Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
raziel3's latest activity
raziel3
replied to the thread
Opening a Report does not make it the current screen
.
Opens fine on my PC. I've attached a zip copy.
Apr 7, 2024
raziel3
posted the thread
Opening a Report does not make it the current screen
in
Reports
.
Hello all, Let me see if I explain this properly. I am opening a report from a Pop up Form (the pop up is set to open as acDialog). The...
Apr 7, 2024
raziel3
reacted to
ebs17's post
in the thread
stream data to excel
with
Like
.
Dealing with hardware is not a core task of VBA. I once had a task with a certain similarity. To use a scanner, you first had to make...
Mar 26, 2024
raziel3
replied to the thread
Import Large Excel File
.
I'm not tying to offend anyone 😨. This is just my experience. People are more comfortable using Excel so I try not to interfere with...
Mar 24, 2024
raziel3
replied to the thread
Import Large Excel File
.
I prefer to link to the Excel file to maintain the integrity of the Excel data. If the Excel is the main source of the data (Call it...
Mar 24, 2024
raziel3
reacted to
MajP's post
in the thread
Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist
with
Love
.
I have had some people ask questions on working with Hierarchical data and Tree Views, which often involves using recursion. If not...
Mar 24, 2024
raziel3
replied to the thread
stream data to excel
.
By chance are you using Power Query to connect to the CoolTerm data dump?
Mar 24, 2024
raziel3
replied to the thread
exporting access table data to excel
.
I've had a problem with this recently...
Mar 24, 2024
raziel3
reacted to
plog's post
in the thread
Make table query error
with
Like
.
SELECT NPIMonsterPared.NPI, NPIMonsterPared.[Entity Type Code] , NPIMonsterPared.[Provider First Name] , NPIMonsterPared.[Provider...
Mar 24, 2024
raziel3
replied to the thread
Import Large Excel File
.
Import or Link? I would create a Link to the Excel file. One thing to also note is that if you have the Excel file open, Access cannot...
Mar 24, 2024
raziel3
replied to the thread
Solved
Problem calculating correct age from birth to death
.
I think everyone pretty much covered your problem but just one more small thing. Try to limit the use of the Nz() function. If in the...
Mar 24, 2024
raziel3
reacted to
The_Doc_Man's post
in the thread
Solved
Problem calculating correct age from birth to death
with
Like
.
The issue, I believe, is that DateDiff will isolate the years before doing the subtraction. (2021-1923 = 98). Take a look at this...
Mar 24, 2024
raziel3
replied to the thread
Hide inactive data and show active data only.
.
One thing I learned the hard way was NEVER make Forms based on your Table. Make a query then use that as the RecordSource for your...
Mar 24, 2024
raziel3
reacted to
MajP's post
in the thread
The Most Powerful form Filter and Requires almost No Code
with
Like
.
This is not really a filter/search form. It is a standard continuous form just wrapping the native Access functions in a more user...
Mar 24, 2024
raziel3
replied to the thread
The Most Powerful form Filter and Requires almost No Code
.
How many records can this handle? I find sometimes with filter/search forms the load and filter times starts to get slower the more...
Mar 23, 2024
Home
Members
Top
Bottom