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
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...
Tuesday at 6:48 PM
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
oxicottin
replied to the thread
Solved
Cant hide ribbon all the way
.
@Gasman @arnelgp I figured it out I was right, I created a new DB and exported all tables, forms, querys etc. to it and ran it and now...
Feb 13, 2024
oxicottin
replied to the thread
Solved
Cant hide ribbon all the way
.
I just made a DB copy and got rid of everything and still did it.... Don't worry I always make backups and extra ones to work on, I...
Feb 13, 2024
oxicottin
replied to the thread
Solved
Cant hide ribbon all the way
.
This has happened to me before a long time ago and I can't remember why.... The startup code is no different than any of the other...
Feb 13, 2024
oxicottin
posted the thread
Solved
Cant hide ribbon all the way
in
General
.
Hello, I always use: DoCmd.ShowToolbar "Ribbon", acToolbarNo ' Hide ribbon AND DoCmd.ShowToolbar "Ribbon", acToolbarYes '...
Feb 13, 2024
oxicottin
replied to the thread
Cant get form filter to work correctly
.
Whats weird is if I run the search for the first time it works then I clear it and run again and I start getting these errors missing )...
Feb 8, 2024
Home
Members
Top
Bottom