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
.
oxicottin's latest activity
oxicottin
replied to the thread
Solved
Move/Tab to next control
.
@MajP I'm getting variable not defined on the On load events "mdlNextControl" Private Sub Form_Load() Set AvailableTabs =...
Apr 11, 2024
oxicottin
replied to the thread
Solved
Move/Tab to next control
.
Im trying to figure out how to move to next control after a selection from a popup. I cant use setfocus or go to control because the...
Apr 9, 2024
oxicottin
posted the thread
Solved
Move/Tab to next control
in
Forms
.
Hello, I need to automatically move to the next control in my tab order on my form using VBA. What can I use to accomplish this? Note...
Apr 9, 2024
oxicottin
replied to the thread
Solved
Cant hide ribbon all the way
.
Just don't forget, in order for you to show the menu's if you want to work on the DB you have to open the DB while holding the shift...
Apr 3, 2024
oxicottin
replied to the thread
Solved
Cant hide ribbon all the way
.
Sure.... On your main form (The first form that is opened), just put the VBA below in its on open event. Private Sub Form_Open(Cancel...
Apr 3, 2024
oxicottin
replied to the thread
call subform validation from main form
.
@moke123 how can I add validation on a multilistbox? The code works except if I have a multi select listbox it highlights red even...
Mar 26, 2024
oxicottin
reacted to
pbaldy's post
in the thread
Solved
Multiselect listbox loop showing there isn't data
with
Like
.
If all you want is to see if anything is selected: If ctl.ItemsSelected.Count = 0 Then
Feb 29, 2024
oxicottin
replied to the thread
Solved
Multiselect listbox loop showing there isn't data
.
Thanks @pbaldy and @arnelgp Function VerifyMainFormData(frm As Form) As Boolean Dim ctl As Access.Control Dim strErrCtlName As...
Feb 29, 2024
oxicottin
posted the thread
Solved
Multiselect listbox loop showing there isn't data
in
Modules & VBA
.
Hello im looping controls on my main from from my subform and I have one issue "So Far". I have a multi select listbox on my main form...
Feb 28, 2024
oxicottin
reacted to
Uncle Gizmo's post
in the thread
Solved
Export report to Excel with VBA
with
Like
.
I see that you have your question answered. I'm posting a link to some VBA code for anyone else who sees your question because I have...
Feb 22, 2024
oxicottin
replied to the thread
Solved
Export to Excel error '1004' With time format
.
@arnelgp your post #6 worked... Thanks! @arnelgp Can you explain what ;@ is for please?
Feb 21, 2024
oxicottin
reacted to
arnelgp's post
in the thread
Solved
Export to Excel error '1004' With time format
with
Like
.
record a macro and it will show you the correct way. here is what i got: With XL .Range("D1:H5000").Select Selection.NumberFormat =...
Feb 21, 2024
oxicottin
replied to the thread
Solved
Export to Excel error '1004' With time format
.
I did notice something, I commented out the .Range("D1:H5000").NumberFormat = "hh:mm:ss" to extract the excel workbook without errors...
Feb 21, 2024
oxicottin
replied to the thread
Solved
Export to Excel error '1004' With time format
.
I cant its on a PC that I cant remove anything from so I would have to either build a database to show or type it all out.
Feb 21, 2024
oxicottin
posted the thread
Solved
Export to Excel error '1004' With time format
in
Modules & VBA
.
I have a export to Excel and I keep getting an error message. Runtime error '1004' Numberformat method of Range failed I and it takes...
Feb 21, 2024
Home
Members
Top
Bottom