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 derfloh 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: *

  • Users: HIM
  • Order by date
  1. HIM

    Linked Tables

    Would you happen to know of anywhere to find these pieces of code? I am in desperate need of this for a small project I am building. Thanks
  2. HIM

    Import multiple excel spreadsheets into access

    What about the multiple sheets in one file? I am having problems with this. I only get the first sheet into access when using TransferSpreadsheet....
  3. HIM

    Please help with edit form code

    I am not sure what it is you want. But on the form properties, there are several setting on the Data tab controlling the permissions of the data source. Check if Allow Edits, Allow Additions etc. are true. If they are, you might want to check the query if it is updateable.... run it from the...
  4. HIM

    Filtering a subform based on user input

    You can always modify the datasource of the child form to be based on a query.... adding a condition like this [Enter Week #] this will ask the user to enter a week number when opening.....
  5. HIM

    Remove spaces from file

    Hi Using the Str function returns a string with a space in front.... one of those small VB things.... use the function Trim around it.... and you are set.... like this Trim(Str(Value)) Have fun
  6. HIM

    Download an ASP file?

    Hi everybody I have created a website for my rowing club, and would like to be able to download files from the site. It is no problem to display all the directories and the files. I have allready created the browser, but I have realized that my knowledge of ASP and HTML is not enough when it...
  7. HIM

    run .BAT file in ASP

    Look into using a component called ASPExec. It is freeware and can be downloaded from virtually any site concerning ASP. (www.activeserverpages.com).
  8. HIM

    How to move report form from home puter to office puter?

    Or when at the office, open the database containing the report, and export this to the target database. Just like when you exported the report from the home computer.
  9. HIM

    Setting the 'hidden' property of objects

    You can change the .Visible attribute to false for any control, and this will hide it.
  10. HIM

    Open DB - HELP!

    I have a '97 db, which contain a very important db. It was developed on a win98 machine. I am still using win98, but I am running a winNT server in the background, doing all user validation etc. Now, the database refuses to open and just report the following error: The current user account...
  11. HIM

    Can't add new record to combo box?

    Ups! i forgot the email: hhmoeller@image.dk
  12. HIM

    Security 2,000 MDBs

    I have done something similar to this. Yes you can use your mdw for as many mdb as you like. You just need to associate every single mdb with the mdw. And you need to do this for every userprofile for every machine, or do some alterations to the registry with the logon-script. Feel free to email...
  13. HIM

    Global code needed

    Do you not have a problem with the form using the ForeColor for all the filed objects?
  14. HIM

    Can't add new record to combo box?

    You have to remember that you need to update the object's view. The Recordset object has no connection to the bound Recordset of the form. Use the requery, and after that a DataErrContinue. If you are interested, mail this adress and I will return an example of what I did to make it work. hhmoeller
  15. HIM

    Default Value for Table

    I belive you will have to code a little VB on the desired event for the field.
  16. HIM

    Set = nothing or close a recordset?

    Does the Nothing way work?<br><br>I did not manage to make it work in my database. Closing it does work.
  17. HIM

    Not enough Free Memory Error

    Another problem which can create this error, is if you use the predefined styles that come with Access 2000.<br>Try and remove these styles. This is documented on msdn.microsoft.com
  18. HIM

    Access 2K security problem.

    You need to activate the use of the workgroupfile on those computers as well.<br>This has shown to be the most irritating part of this. Why? Because you need to do it for every user on every machine (at least on an NT). If you have an NT environment, I can show you how to get around this at...
  19. HIM

    Memory problems with Access 2000!

    I can tell everybody, that this problem is a recognized problem by Microsoft. Remove all the preset styles, and you are flying.<br>A link to the paper on this problem will be found on a FAQ, this weekend.
  20. HIM

    Memory problems with Access 2000!

    I just tried making a new database. Just consists of four simple tables, linked togteher. Eats up the RAM faster than you can imagine.<br><br>HELP

Part and Inventory Search

Back
Top