Search results

is there a way in vba we can check the status of Insert key if it is on or off when the form is loaded? i want for the insert key to be on, where the key strokes write over the existing entry. i do set the key preview to "yes" in the form, and it works fine, but i wanted it only on a...

i did a search and found this thread here, and the only problem i encounter is the min max buttons are gone though it was set up as both enable, can somebody enlightened me and give me a hint how to show those buttons. thanks in advance...

I have a workbook which is already opened and I want to close it. the code that i have is (see below) is not working. Anyone can share some inputs? Function CloseExcel(sExcelFile As String) As Integer Dim XLapp As New Excel.Application Dim ObjXL As Excel.Workbook On Error GoTo ErrorTrap...

I'm not sure if this was already taken up in here, here is my dilema: i have a textbox and i have a listview in a form, what i want to accomplish is when ever i type a value in a textbox it will search in the listview and hightlight the item, the code that i have is this: Private Sub...

Hello Guys, I do appreciate if somebody can show me the selected item in a Listbox without looping in the whole list, because my Listbox is multiselect and I want only the item that selected recently. Thank you.

Hi Guys, I have a Back end (with password) which resides in a netdrive while the front end is installed in each individual users desktop, the problem is, some of the users netdrive was mapped in a different way (different letters..some are J others are G). I'm looking for code that I can...

hi guys, i'm trying to create a query of all employees doesn't have any transaction for a certain range of date and will also shows the last transaction date they have. i have two databases one is the transaction file and the other is the user file. i'm trying to play around and yet i'm not...

Hi Members, I'm hoping that you can enlightened me with this case I'm working. I have this code to apply alternate color of my datasheet and it's working fine in my test database, but when I apply it into my production database (a split database), the out come is not consistent, as if the...

I'm Juan and a new member here, I'm an average access user and currently doing some small projects here at my work. I find this site very useful specially in seeking answers in my problems. Hoping by joining this site will enhance my knowledge by the help of my fellow members and of course by...