Search results for query: *

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

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.

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

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

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.

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

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...

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.

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.

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...

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...

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...

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...

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...

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

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. ::-)

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. ::-)

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

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! ::-) )

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