Search results

@moke123 how can I add validation on a multilistbox? The code works except if I have a multi select listbox it highlights red even though I have items selected. I tried adding below but I get error 2455 " You entered an expression that has an invalid reference to the property ItemSelected" If...

Thanks @pbaldy and @arnelgp Function VerifyMainFormData(frm As Form) As Boolean Dim ctl As Access.Control Dim strErrCtlName As String Dim strErrorMessage As String Dim strMsgName As String Dim blnNoValue As Boolean For Each ctl In frm.Parent.Controls ' Refers to...

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 and the code below is saying there isn't data in my listbox because when ran it highlights it and there are several items selected so there are things there...

@arnelgp your post #6 worked... Thanks! @arnelgp Can you explain what ;@ is for please?

I did notice something, I commented out the .Range("D1:H5000").NumberFormat = "hh:mm:ss" to extract the excel workbook without errors then looked at the time field and it shows the 01/00/1900 but when I click on the 01/00/1900 in the workbook it shows the time after the 01/00/1900 in the formula...

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.

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 me to a line in my code for a time field. The time in the excel workbook converts to 01/00/1900 for every record in the Excell workbook instead of the format...

@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 the menu at the top is gone as it was supposed to be while open.

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 learned my lesson!

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 databases I have played with. I tried adding the acToolbarNo in both load and open events and I get the same results. What's weird and got me stumped is I can open...

Hello, I always use: DoCmd.ShowToolbar "Ribbon", acToolbarNo ' Hide ribbon AND DoCmd.ShowToolbar "Ribbon", acToolbarYes ' Show ribbon To hide on open and unhide on close which I always use but this time its not working completly and leaving this bar at the top, any ideas as to...

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 ) or to many )

Hello, I can't figure out what I'm missing in this filtered search. It either says I'm missing a ) or I have an extra ) in my query expression. Its one of my 3 searches I have causing it. '*********************************FILTER SEARCH START********************************* Private Function...

You are correct thats what i wanted to do.... Ill look into how i can do your solution thank you!

Hello, I have a check box on frm_Main called chkReleaseALL and when checked I want all checkboxes on my sub form to be true if it isn't already checked which that's what I got it doing with the code below BUT what if I uncheck the checkbox (chkReleaseALL) on my main form, how do I revert/undo...

Thanks everyone for the examples, ill play with them when I get back to work after the weekend 😀

I am using a multi listbox that is unbound and saves the selections id's as a comma-delimited string in my table. @Pat Hartman I dont want to use a bunch of code like you said. I still want to save the selections as a comma-delimited string in my table though. Can you show me an example please...

I have a multi select listbox which is a long list, so I wanted to move the selected items to the lists top, so I won't have to scroll through the list upon reopening the form.

@arnelgp your example worked on printouts thanks!

@MajP I'm sorry I tried your example in my reports load and when printing, it's still prints normal with no yellow background? I see what your saying with your X and Y example I get the error 13 also as you stated BUT I changed the long date to mm/dd/yyyy like you suggested and its outcome is...