Search results

CJ_London, Thanks for the reply, but I'm not sure how to apply what you are recommending. In the situation I have now, I have two forms, one is the primary form where data is added. The second form is an actual form, not a subform, that provides a summary of a work order. Once the user...

Hi All, Thanks in advance for the help everyone here is so great at providing! My issue today is that I am trying to switch the focus between two forms. One form is the main data entry form for a particular task, the second form is a popup type form for reference only. When a user selects...

boblarson, Sorry, it didn't. I was reading through it last night and it appeared that I had to place that code sample into every GotFocus event on the form. If you have time, can you give me a quick rundown on how I need to apply your code? I understand how to apply the Function but not...

John Big Booty, You are correct, when I tried to use your code recommendation I forgot to remove =[Screen].[ActiveControl].[ControlTipText] from the Control Source section of the Data tab in the Form Properties. Once I cleared that out your idea worked like a charm! It would seem that there...

John Big Booty, Thanks for the recommendation. I was thinking that your code would be easiest to enter because it would be just one line in each GotFocus Event. However, when I tried it I got this error message "You can't assign a value to this object." It would seem to me that bob's idea...

boblarson & John Big Booty, Thanks for the quick replies, ya'll have replied so fast, that I haven't had time to try either idea yet. I will try both ideas and see which one works best and get back to you as quick as I can. Some of my boxes in the form already have an action in the...

Hi All, An update to the issue, I just tried setting the Text box Data Control Source to =[Screen].[ActiveControl].[ControlTipText] and it shows the control tip for the first box selected, however after that, it doesn't update as you move through the form. It should refresh every time the...

Hi All, Thanks in advance for any help that you can provide. I have a form with many fields (25+), some with list boxes, some combo boxes and some regular text boxes. What I would like to do is have a label or text box in the form that will display the controltip text for the active control...

Hi All, I need a little bit of help on a form that I am working on. I have attached a sample database so that you can see the code that I am using or trying to use anyway. Here is what I am trying to do: I have a form with a subform in it. What I am trying to do is filter the subform based...

:) ChrisO, Thank you very much for your comments and recommendations! I really like your idea of putting it into a module rather than an event, I should be able to use it in all of the forms rather than change a reference for each one. I do have some questions however, so if you have time can...

Hi all, :banghead: Stuck again and everyone here is so helpful! Today I am trying to retrieve a subform's name so that I can incorporate it into a piece of code, but I am not having any luck after searching through the forum. I have established a variable like this: Dim currentFormName...

Jonathachye, It Worked!!!:D Thanks so much for your help! I only have one teeny tiny issue, and that is when it returns to the originating form, it doesn't go to the Area field, it goes to the next field in the Form. I believe that is because of the code Response = acDataErrAdded but I'm not...

Jonathanchye, Still have the mismatch in the message box for not in list sub of Form1 and Form3, so I Rem'd them out, now I get the same old message when closing Form3 (i.e. "Microsoft Access can't find the form 'fmName' referred to in a macro expression or Visual Basic code.) Any other...

Jonathanchye, Thanks for the reply, but I'm not able to make that work. I keep getting Mismatch errors now, but that is something new, so maybe it is progress. Let me give you a brief rundown of what I want to happen and maybe you can help me more. I have three forms, Form1, Form2 & Form3...

Thanks for the idea, but I can't make it work. Every time I run it, I get the error "Microsoft Access can't find the form 'fmName' referred to in a macro expression or Visual Basic code." I have set up a message box to show the form name (i.e. fmName) when it leaves Form1 and when it leaves...

I have figured out how to capture and keep the form name by creating a module called PubVarFormName like this: Option Compare Database Option Explicit Public fmName As String I have also verified that fmName is working as follows: Private Sub Form_Close() MsgBox ("Form Name = "...

Reply from mdlueck, I followed the link and kind of see where you are going with it, but am not for sure that it will work. I have included the ID for the table in the UI for all of the forms, but the field that starts the whole process is part of a record that hasn't been entered into the...

Thanks for the quick reply! What would the syntax for that look like? Would I have to put it in Form1 and Form2's code to capture the Form name or would it have to be a Public Function or something so that Form3 can get it?

I am working on the data entry forms for a database. I'm confusing myself trying to ask the right question(s) so here goes... I have three forms, Form1, Form2 & Form3. All are for entering data into tables. Form1 and Form2 have a Facility Name Field ComboBox Form3 is for adding New...

Perfect!! It works like a charm. If they can't fill out the form, the table won't be taking the data. Thank you for the quick reply! Here a copy of the final product: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctr As Control Dim strMsg As String 'Loop through every control...