Search results for query: *

Hi PHV, That worked perfectly!!!!! It takes two steps. That was my missing link. Thanks for all your help....Everyone. JennieL (happily skipping along)

Hi Bob & Zor, Thanks for the FAQ list...it is great for a User like myself. I tried the long route suggestion and get the same results: 'Forms![F-BU Tabs]!Child54.Form.StatusA.SetFocus - no error no jump 'Me.Parent.Child54.Form.StatusA.SetFocus - no error no jump I am coming down to the...

Hi Bob (& Zor) This is still not working for me. I must be missing something. The subform is: child54 The tab control is: TabCtl47 The page is: EEinfo The control I want to focus on: StatusA As I mentioned, I can set focus no problem on the subform (child54), but having no luck getting to...

Hi Bob, Sorry to be a pest, but I can't get past this one. I can set focus on subform (Child54) with no problem. However, trying to set focus on control is another story. I have tried all these listed below with no luck. Can you see anything funny? 'Me.Parent.Child54.SetFocus 'this works...

Thanks for the response Bob. That works great to get to PgGoHere. Do you know whether it is possible to actually set focus on a control on PgGoHere? Is to possible to : Me.parent.sfrmManyPages.PgGoHere.mycontrol.setfocus I get error message and never know whether its my code or just not...

Hi, I have a main form with a subform containing multiple pages (tabs). Each page contains a continuous subform. I want to set focus on a control on another page, after user error. However, I can't seem to get the code right. Can anyone help me with referring to a control that is on a...

Hi, I can't find anyone else asking the question. I must be doing something stupid.... Does anyone know how to save pivot table layout? Each time I get the pivot table set the way I want, so that user only needs to select from available options, it seems the layout disappears. If I go to...

Hi: I just wanted to let you know that I solved my problem. Stupid me added a menu bar which did not include the close command. Once I added the close command to the menu bar, the close button appeared again on the form. Thanks for your help! JennieL

Hi Ian: Thanks for the reply. Yes, I have tried compact and repair. Does not resolve. The only difference between the control that works and the one that removes to close button, is that only two forms are open on the good control and three forms are open on the bad control. If I enter...

Hi: I have a form that can be accessed via two controls. Each control opens a form where the user selects a group from a combo box and then either a form view or report view. When one control is used, the close button on the form shows with no problem. However, when the other control is...

Hey AceMan: I will give that a try. Thanks for your help. JennieL

Hi: I have a main form with a subform. I am trying to cancel closing where user left a null value on subform. Works fine if I test with main form only, but when I try cancel = true at onunload on main form with subform, I can't get closing to stop. It seems as though subform is closing...

Hi Little Smudge: Thanks for the reply. No password is set so that is not the problem. I did a save as type "Microsoft Excel 97-2002 + 5.0/95 workbook". Although I cannot explain, this did resolve the problem. JennieL

Hi: I have an Access database that links to worksheets in various Excel workbooks. All links work fine. Except there is one workbook that will not link unless the workbook is open. Does anyone know why this would happen? Your assistance would be greatly appreciated. Thank you. JennieL

FYI Problem seems to relate to Access 97. When I tested things in 2002, there was no problem linking.

That worked perfectly. Thank you very much....

Hi: I have a subform that uses Dlookup to find a value. When no value is found since there is no record created as of yet, the subform displays #Error. I would like to hide this error and replace with a zero until records are created. Any suggestions for me. Thank you.

PHV: Thanks for the quick reply. The indexed fields are: MCMCU nchar(24) MCMCO nchar(10) MCSTYL nchar(4) MCFMOD nchar(2) MCAN8 DESC = MCAN8 number Looking at it this way, it appears that 'MCAN8 DESC' is the problem, since the table only includes the field 'MCAN8'. It don't know what this...

Hello All: Hope you can help. I'm trying to link to tables in an Oracle database and I am getting the following error: Invalid field definition <name> in definition of index or relationship. (Error 3409). I am trying to link to Peoplesoft tables and only receive this error on certain tables...