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:
New posts
New profile posts
Latest activity
Menu
Log in
Register
Home
What's new
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
.
Latest activity
What's new
New posts
New profile posts
Latest activity
isladogs
replied to the thread
Solved
Adjust Luminosity via VBA of any color value to it's lightest shade
.
Why not export to a template Excel file which already has the required formatting then save as a new file to leave the template...
Apr 26, 2024
zelarra821
posted the thread
Solved
Export to Excel and leave the workbook open
in
Modules & VBA
.
Hello, people. I have this code to export a form to Excel: Private Sub CmdExportarExcel_Click() Dim xlApp As Excel.Application Dim...
Apr 26, 2024
mloucel
replied to the thread
Solved
SubForm [Continuous Form] not updating data.
.
HA... GOTCHA [for me...] That was the reason of that particular subroutine and why I didn't use the proper name function of access, I...
Apr 26, 2024
mloucel
reacted to
Gasman's post
in the thread
Solved
SubForm [Continuous Form] not updating data.
with
Like
.
So why are you not using bound forms?
Apr 26, 2024
mloucel
reacted to
Pat Hartman's post
in the thread
Solved
SubForm [Continuous Form] not updating data.
with
Like
.
I agree, this takes almost no code with a bound form. When searching for proper names, be aware that they may contain apostrophes'...
Apr 26, 2024
MajP
replied to the thread
Solved
FAYT User type undefined
.
Unclear, but I assume you do have the class module in the project. If so then my first guess is there is a broken reference to...
Apr 26, 2024
P
Pat Hartman
replied to the thread
Solved
SubForm [Continuous Form] not updating data.
.
I agree, this takes almost no code with a bound form. When searching for proper names, be aware that they may contain apostrophes'...
Apr 26, 2024
G
GeoWorld
replied to the thread
Solved
Adjust Luminosity via VBA of any color value to it's lightest shade
.
Mike, I apologize (I'm a fool), your HSLtoRGB function works perfectly (my debug statements above even prove it). I just misinterpreted...
Apr 26, 2024
mloucel
replied to the thread
Solved
SubForm [Continuous Form] not updating data.
.
Done The SQL instruction did work, no problem, it actually game exactly the record found, display it without any issue. So that leaves...
Apr 26, 2024
mloucel
reacted to
tvanstiphout's post
in the thread
Solved
SubForm [Continuous Form] not updating data.
with
Like
.
set a breakpoint where strSQL is constructed. In the Immediate window: ?strSQL Copy that text, and paste it into a new query, switched...
Apr 26, 2024
T
tvanstiphout
replied to the thread
Solved
SubForm [Continuous Form] not updating data.
.
set a breakpoint where strSQL is constructed. In the Immediate window: ?strSQL Copy that text, and paste it into a new query, switched...
Apr 26, 2024
mloucel
replied to the thread
Solved
SubForm [Continuous Form] not updating data.
.
Thanks for your suggestions, The CleanUp was actually a leftover from the OLD program I had for this sub routine, is clean now. I had...
Apr 26, 2024
T
Thales750
replied to the thread
Another mass shooting
.
Well, I am from Texas. So, there is that.
Apr 26, 2024
mloucel
reacted to
Gasman's post
in the thread
Solved
SubForm [Continuous Form] not updating data.
with
Like
.
Yes, every site has limits. You only need enough to show the problem. I always refer to form controls as Me. No,. your file is too big...
Apr 26, 2024
mloucel
posted the thread
Solved
SubForm [Continuous Form] not updating data.
in
Modules & VBA
.
MODERATORS PLEASE: I tried to attach my database but no matter how small, just the essentials, no data, Zipped and I still keep getting...
Apr 26, 2024
Home
What's new
Top
Bottom