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: Gzep
  • Order by date
  1. Gzep

    Preventing VBA Code Windows From Opening Up

    G'day. When you are not using source control, simply closing all code windows, before closing your database fixes this. Gzep.
  2. Gzep

    sorting a subform

    Hi. Did you resolve this issue? Error 2486 is a pain! So far I have seen it only in Access2000, and the line that crashes always starts out: Docmd. I believe that something triggers Access2000 to start a chunk of code, that runs either recursively or in an infinite loop. gzep, SoF.
  3. Gzep

    Date Criteria Problem in Query

    Hi. Did you ever track down that darn 2486 error? I'm having a real problem with that at the moment. I'm assuming that you are running Access2000, and the only lines that crashed start out: Docmd. gzep
  4. Gzep

    Help with a report problem

    Hi. I know that your post was old... Were you using access 2000, and did it only crash on lines that contained a Docmd. ?? gzep
  5. Gzep

    Filebrowsing in Access

    Hi. Sounds like you need to call windows explorer as an activeX object, and set the "view as web page" setting, to get a preview... I haven't tried this, but I suspect it would do what you ask... ::-) Gzep, S.O.F.
  6. Gzep

    Permission denied on asp page

    Hi Frankin1232 Sounds like the database security has got you! What database are you trying to use? If ms-Access, do you have database security enabled? If so, you may need to put DOMAIN/username in the username box to have the login succeed! Gzep, SOF
  7. Gzep

    TreeView - change background color - HELP

    Hi. My program had a listview control that had a color background, and so the users don't panic, I wanted to set the TreeView back color the same. In an Access97 enviroment, I am unable to change the back-color of a TreeView Control(where a listview was easy - it has a color picker on a...
  8. Gzep

    Tree Control Methods

    G'Day Mike. Private Sub InTrayTreeView_Click() Private Sub InTrayTreeView_DblClick() these are not listed on the controls properties list on my access 97 system either, but work fine! ::-) Regards, Gzep, SOF.
  9. Gzep

    Treeview

    Hi. If you havn't found out elsewhere, It can be used in 97 in exactly the same way. It can be used from most other microsoft environments that allow program development. Gzep, SOF.
  10. Gzep

    Treeview going out of bounds !!!

    Hi Matt. When the code breaks, use the immediate window (with debug.print) to show Treeview.nodes.count to see how many nodes it let you create. If it is a power of 2 +/- 1 then you are probably reaching the limit of the control. The user may have to select country (and county?) from a combo...
  11. Gzep

    Data Binding & Access

    Hi. Do you have an ADO connection (control) to the database? Have you tested the connection? There are TWO types of data-bound controls available in VB6. Try the other one! You have to set both the connection-control name and the data field name for your text box, for it to be data bound...
  12. Gzep

    Strange 80004005 Problem

    We had this problem... A user had to log into access to use the database, and that wasn't getting passed thru (as per above) I think that the solution was to put DOMAIN_NAME\username where username is supposed to go (in the dsn? - not sure)... so that it knew how to verify the credentials of...
  13. Gzep

    ActiveX will not load..?

    Sorry, Not a Solution. I am in the same situation! %-( I have a slider control - works on dev m/c progress control - doesn't work on dev m/c both these controls are in comctl32.ocx v5 (sp2). I have access to the server, and installed and registered the control there manually, and I still...
  14. Gzep

    Programmatically opening Microsoft Excel using Access

    Hi. Check out CreateObject(). oddly enough, it has a heap of examples and explanations! Your code can run Excel by itself. eg: Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.Sheet") alternatively there is an activeX control called: Microsoft Office Spreadsheet 9.0...
  15. Gzep

    Procedure @ arguments

    Hi. If you want to use the brackets, put CALL in front of the statement! Gzep. ::-)
  16. Gzep

    Functions

    Hi All, DCount was the best answer, but note that the Recordcount property only shows 0 or <not-zero>, until you do a moveLAST, then it will show the correct number! Gzep. ::-)
  17. Gzep

    getrow from 2 tables and past to another table

    Hmmm.. if I may interject... Usually i use: rs.movefirst do while NOT rs.EOF 'note the NOT... <do some stuff> rs.MoveNext loop if the data comes from two tables, use a query to merge them and open the query as your source recordset. Gzep, Soldier of Fortune. ::-)
  18. Gzep

    Between Check box and select box

    Hi. Would the multi-select feature of a list box describe what you are trying to achieve? ::-) Regards, Gzep.
  19. Gzep

    Setting Up ASP

    Hi. Have you solved this yet? I had this problem. if you enter as a url c:\wwwroot\inetpub\default.asp the html part works, and the asp doesn't run. if you enter a url of //localhost/default.asp, then both the htm and asp work. Regards, Gzep. (if this reply helps you, please vote! ::-) )
  20. Gzep

    Joining a table from a list box in an SQL statement

    Hi. If the me!Combo is returning a string, you will need to enclose it in Single quotes for the statement to work. Gzep.

Part and Inventory Search

Back
Top