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!

Register Log in
  • Congratulations Rhinorhino 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. Locoman

    Mouse hover

    Yes, I understood your intended function, but from what I know of the LEN keyword it returns an integer equal to the number of characters in the string, sstrHover. As written, I don't think the IF statement compares anything meaningful and probably defaults to NULL, so the code will 'drop...
  2. Locoman

    Mouse hover

    I don't quite see what you are expecting to compare in your code: If Len(sstrHover) Then... What length string are you expecting to compare / find in variable sstrHover at either of the branches?
  3. Locoman

    Open Access window with a fixed size

    I checked and found that my typical VBA code for each form was actually in the OnLoad area trather than OnOpen, although I don't think it make a difference. I also forgot to say that with your user's habit for changing things it's probably a good idea to put a DoCmd.Maximise before the...
  4. Locoman

    Currently used table...

    Hi, It would help if you identified how your open form selects the different table(s). Is this from another button, a combo box (drop-down list) or what? To get the required average could be straightforward; the action of selecting the table just needs to run some code to 'plug in' the table...
  5. Locoman

    Open Access window with a fixed size

    Hi Liz, no unfortunately it does not work for the main Access application. You have to add it to the 'OnOpen' code for each form. This sounds as though it is a bit of a chore but does have the advantage of allowing you to set the exact size of each form. As well as defining the form size it...
  6. Locoman

    Open Access window with a fixed size

    I always put a DoCmd.MoveSize command in the start of the code for ALL my forms. That way the user can't change the form other than by using the minimize or maximise buttons, and it will always reset when the form is next opened to the proper size.
  7. Locoman

    Form doesn't recognize that a field is not Null

    I don't think you can use IsNull to compare to a variable in the way you have, i.e. YourExpression >0. Null only checks for True or False: Quote from Access Help: "Important Use the IsNull function to determine whether an expression contains a Null value. Expressions that you might expect...
  8. Locoman

    How to use two multi-select list boxes to query table and make report.

    The way I would do this is: in the OnOPen property of the report, set this to an event procedure which uses the strCcriteria you have built, e.g. DoCmd.Apply Filter, "YourSQLstringCriteria"
  9. Locoman

    MSP 2000: Prioritise linked projects with shared resources

    Thanks, that seems to work just fine.
  10. Locoman

    MSP 2000: Prioritise linked projects with shared resources

    Hi folks, I have several linked projects with a shared resource pool. Can anyone advise if it is possible to set the priority of one project to be higher than another at the Project level so that the higher priority project has first call on the shared resource when levelling? (I know that you...
  11. Locoman

    Auto-reformat of charts after import from Access

    Hi Folks, I have an Excel application that I use to draw a whole series of charts from an Access database, and these are updated weekly. This means that the number of rows imported for each query increases by one each week. Originally I used the wizards to do all the connection stuff, and so...
  12. Locoman

    Excel - Find My Directory method

    Hi Harley - thanks for the prompt reply and Star for you. I tried Me.path but this would not work since I wanted to put this code in a Module. A bit of experimenting later and making it a function call got it to work as MyDirectory = MyObject.Path Thanks
  13. Locoman

    Excel - Find My Directory method

    Hi Folks, I want to be able to distribute an Excel graphs report spreadsheet, along with a corresponding Access database, for users to install in any directory. So, I need to be able to modify the importing of the various data to Access and queries from Excel to suit the installed path, but I...
  14. Locoman

    Merging separate Date & Time fields as single Date-Time field

    Thanks Skip - I did not realise you could actually add times to dates directly unless the field was set to the "general" date/time format. After experimenting with your solution it seems that both Date and Time variables have implicit components of each other, even if they are not always...
  15. Locoman

    Merging separate Date & Time fields as single Date-Time field

    Hi folks, I searched through loads of posts about Date arithmetic etc. but can't quite find a situation like I have: I work with an old database which has separate pairs of fields, StartDate and StartTime, and EndDate End Time. I need to calculate (in minutes) the elapsed time between start...
  16. Locoman

    Link Tables in Access from Web to Desktop

    Are you trying to find a db name where the location is unknown or is it that you just don't know how to get into it? If you are running Windows NT or 2000 over a WAN like our company, then instead of looking at just the local server choices when the "find db" window pops up, go into "Entire...
  17. Locoman

    Parts of Menu bar greyed out when .mde file is made for distribution

    Hi, I develop and maintain a database on our network and recently replaced the full standard menus with just a custom Report Menu to prevent users tinkering (built with the usual Access menu wizards). I have since found that the standard Access "Save As/ Export" function that I added to the...
  18. Locoman

    Access 97: Function won't run from a macro

    Hi Jebry and mp9, Well, I have the name as Public Function, and mp9 I tried entering an equals sign bbefore the name in the macro line, but this make no difference. As it may be something odd in my code I include it below: Option Compare Database Option Explicit Public MyDrive As String...
  19. Locoman

    Access 97: Function won't run from a macro

    Hi folks, I have a tested and working function that works out what the drive and path of the db application is. It is placed in the "modules" section of my database. When I try and "run" it with a RunCode command from my Autoexec macro (or any other) Access says it can't find the named...
  20. Locoman

    Security alert when Access 97 sends an e-mail via Outlook 2000

    Hi Ken, thanks for the link. Lots and lots of useful stuff to read through there, and hopefully a way forward. Regards, Brian

Part and Inventory Search

Back
Top