Search results

I'm going to run that by them, see if it works for them. Biggest issue with that I can see is the field itself actives on a double click to send email, and a single click or get focus goes to that, then it has to be exited before the double click will work. I resolved that just by making the...

The higher ups want it to auto-expand, with all the info on one screen. The main contact sheet is setup in a way that it echoes all the information of the paper copy, in addition to information pulled from other forms in regards to account status, things like that.

Hi everyone, Problem I'm running into is I need certian fields to auto-resize when they're hovered over (or have focus) so that all the information is viewable, but then resize back to normal afterwards. The forms contain a large amount of information, so the fields have to be smallish most of...

Thank you! Thanks for the help! It worked perfectly, and I also figured out my other problem with having blank fields shows Inactive using the following: If IsNull([Active Inactive]) Then [Active Inactive] = "Inactive" Thanks again for the help, that was a life saver! I'm getting a hang of...

Hi everyone, The problem I'm having is I need to have the background of a field change color depending on what's contained within the field. There's only three possible entries in the field: active, inactive, and a blank entry. I need it to show green if the field contains "active", red if...

Found a solution I found a solution by using me.undo for the undo. Here's the code that works: Private Sub Billing_Contact_BeforeUpdate(Cancel As Integer) Dim strMsg As String strMsg = "Data has been changed." strMsg = strMsg & " Save this record?" If MsgBox(strMsg, vbYesNo, "") = vbNo Then...

Definetly too much Yes, I agree they're looking for too much. Doing it to each field is going to be very time consuming, because one form alone has 30+ fields on it. I think having it ask for a safe after editing the whole form works best, too. Other users are going to complain if they have...

One last question That worked perfectly for an entire form. If I want to work it into an individual text box, I receive the error: Run-time error '2046': The command or action 'Undo' isn't available now. They want it per individual text box now instead of the entire form (which I think...

Thank you! Thank you! That works perfectly for what we need. I've been going nuts all day, and I'm not a coder, and this is a lot of weight off of my back. Thank you again, have a great one. -Walter

Hi everyone, I have a client I'm currently working for that has dumped Access on me. I'm not originally here for Access and am sort of learning as I go along (I'm here to setup, run, and maintain servers, etc.) The problem is they have a large contact database in Access, and want the forms...