Recent content by Gregory Peck

So I had one more field that I wanted to be able to enter a number into just like the search box. I added the same code for this field as I did for the search field and it works as far as the "on focus Me.AllowEdits = True" but the lost focus part is not working. I.E. I can click into the box...

If you go to File/options/client settings ans scroll down to the advanced area there is a check box to "Open last used database when access starts". If I uncheck the box I get the list to open from. Recheck it and it opens the old sheet. Errrr

Hello. I just got some great help from this forum so I thought I would try my luck with another question. A few years ago I set up a database and form for our products. At the time I found a setting that makes it so that access will open to the database that we are using when we open access...

I forgot to put the lost focus part in. Looks like it is working now. Thank you so much for your help. Been stuck on this for a day. Much appreciated

Thank you for the idea. I added that but now any field I click on I can edit. Here is the code that comes up when I click on the text box for my search then click the ... next to "on Got Focus" maybe I am not doing it correctly. Option Compare Database Private Sub Command625_Enter() End...

I had set this form up a few years back and made a search field and search button. It is basically a filter. So you type the item number in the text box the click the search button and it filters out everything that does not have the text in it leaving you with what your looking for. This...

Hello. I am not an access expert but I have been able to make a nice little access form that shows our products details, prices, sizes etc. I had it set that all the prices and other important data was locked so that no one could accidentally change the data. That worked great but if you wanted...