Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. freewilly

    Access Tricks?

    Hi team There is a key that you hold down that keeps Format menu displayed when you are doing multiple formats on a group of controls. It's really useful, but I can't a ref to it anywhere, does anyone know what key that is? Thanks FW
  2. freewilly

    Getting menus back after you have turn then off

    Hi Team The security on my db switches all the properties like "AllowFullMenus" to false on startup. But I want to give these properties back when the administrator logs on. I have tried Setting these properties to true and calling Properties.Refresh, but I still don't get the menus back. So...
  3. freewilly

    Switching CurrentDB.Properties like "AllowFullMenus" back to true

    Hi Team The security on my db switches all the functions like "AllowFullMenus" to false on startup. But I want to give these functions back when the administrator logs on. I have tried Setting these properties to true and calling Properties.Refresh, but I still don't get the menus back. So...
  4. freewilly

    IIF Statement to not Fill in Table

    Gina, Is the field's Required property set to Yes? What is the data type? If it is Text then you will have to also check the Allow Zero Length property. This need to set to Yes. Good Luke FW
  5. freewilly

    Problems adding new text box to subform

    hi osp Find out what the control source of the form is. Do this by right clicking in the little box at top left of the form and choosing Properties | Data | Record Source. (When the form has focus there will be a little black square inside the little box) It could be that the form is based on...
  6. freewilly

    Changing Report Control Values with Code

    Hi team I want to change the title of my report based on filtering the user chose. I can change the value of the control with: [Reports]![ReportName].lblTitle.Caption = "New Value" When I put: ?[Reports]![ReportName].lblTitle.Caption into the immediates window I get the new...
  7. freewilly

    Detecting Crystal Report Closing

    Hi Team I building a report viewer. All it does is display reports generated by another application. The other application gives the reports the extension hzj. When the user clickes on a hzj file it fires my report viewer and displays the report. The problem I have is that I can't detect the...
  8. freewilly

    Bringing a control to the front with code

    Thanks Rick. I have a list view and I want the user to be able to modify the values. I have done this in VB with the following code txtEdit.SetFocus txtEdit.Width = lvwInventoryAllocation.ColumnHeaders(htiHitTestInfo.lSubItem + 1).Width - 50 txtEdit.Left =...
  9. freewilly

    TwipsPerPixel in Access

    Thanks hth Just what I needed FW
  10. freewilly

    Bringing a control to the front with code

    Hi team How do I force a control to be on top of other controls with code? Thanks FW
  11. freewilly

    TwipsPerPixel in Access

    Hi Team Does anyone know how to get the VB equivilent of Screen.TwipsPerPixel in Access? I'm want to be able to edit the values in a ListView by double clicking it. I need TwipsPerPixel to know where I clicked. Thanks FW
  12. freewilly

    Popup Menu of Right Click on a Treeview

    Did you ever solve this May6? I want to do the same thing. FW
  13. freewilly

    Getting Popup Menus in a Treeview

    Hi Team I'm trying to get a right click popup menu in the tree view (mscomctl). The tree view does not have a Shortcut Menu Bar property like a text box. I have tried to set the Shortcut Menu Bar property on load, but no luck. So does anyone know how to make the popup work for a tree view? (I...
  14. freewilly

    Right click Popups in Access 2000 without macros

    Hi Team I have right click popups working using macros, but would rather call the code directly. How do I do this. Is there anything like the VB menu Editor? Thanks FW
  15. freewilly

    NT4 System disk mirror error

    I have created a disk mirror of my system disk (ntfs format). After committing the change and rebooting the system crashes stating I must restart with /crashdebug mode. any idea how or why I can't create disk mirror of my system drive?
  16. freewilly

    Set permissions on SQL objects

    Hi team Is there a way to set the permissions on database objects with one command? Currently we have to set the permissions one object at a time. We would like to be able to select a user or a role and give that user/role permission to do things on the objects in a database by running one...
  17. freewilly

    What dll connects to SQL Server

    Hi team, My install program won't pick up the correct dll for Crystal to read from SQL Server. Does anyone know what it is. I'm getting data from a stored procedure. Thank FW

Part and Inventory Search

Back
Top