Search results for query: *

Our LAN is currently setup using workgroups and we need to change to a domain configuration. I've looked extensively throught the MS site and can't seem to find any articles addressing this issue. Any articles available as to what steps are required to accomplish this? Also, can workgroups and...

I'm an experienced programmer but new to VB. I inherited a project that I modified and have successfully compiled. I had to reboot my machine, now when I open the project it can't find references to ocx, dll etc. The directories it is trying to find them in are not what it previously looked in...

I've inherited a VB app that opens a .hlp file when a user presses a 'Help' button. I need to change the name of the .hlp file but can not figure out where/how in the code this file is being opened. Code for button pressed just does a sendkeys {F1}. How are actions assigned to function keys?

I have a form based VB app that includes a VBA form in Access 2000 to run reports. Whenever I go to the reports form and then return to the VB app and try to open a form I get a Runtime Error 3163 - Field too small... This only happens when I return from the VBA report form and only seems to...

Is there a method that can be called that can change column names in access2000? Problem relates to the length of some column names that cause big problems via ODBC.

Get a 'General OLE Error 16386' when trying to connect to remote sqlserver 2000 from enterprise manager client. Yet I can connect just fine with utilities like osql or query analyzer. I've checked connect properties and they are correct. Worked fine up until a few days ago. Reboot didn't help.

Been messing with this for days now. Have two groups: inside group has a next page after which works fine. The outside group needs to print an additional page 'This page intentionally left blank' when the data for that group ends on a even page number. In other words, report must always end on...

I'm trying to place either a '$' sign or append a '%' sign to numbers in a row base on the value of another field. I can conditionally get the '$' to display correctly using a formula, but have not found any way to conditionally append the '%' sign.

I have a procedure that needs to select/sort through a table 10 times. The only thing different in each select is the 'where' and 'order by' clauses. I need to use a cursor to process but don't want to duplicate processing code for each cursor ten times since the routine is the same for each...

SqlServer 2000. Is there a method to declare a variable of the name and datatype of each column in a cursor, like %rowtype or %type in Oracle? Can table variables be mapped automatically to cursors?

Getting 'Workgroup file is missing or opened exclusively by another user' error when trying to use dts on access db. I can open the mdb just fine through access. It is on my machine so no one else could have it open. I close it before attempting the import. Any ideas?

I'm coming from a unix/oracle/c/java world to sql server/vb and would like some general hints/guidelines as to where to start as far as tools/books/articles etc. especially for vb. I've scoured the web and have found tons of sites/forums but not knowledgeable enough at this point to know which...

I've been working with Sun/Solaris for the past ten years and now have been thrust into the Wintel world. Anyone know of good sources for unix guys that can get me on the fast track to understanding w2k server? I've been reading this forum for a couple of weeks and there sure seems to be a lot...

I'm trying to get the connectors in my ERD to locate next to the fields they refer to; primary key to foreign key. Right now they just hook to the middle of the entity or some arbitrary point. Whenever I try to move them I lose the relationship. Tried creating connection points, but still...

Any good places to find objective comparisons, besides microsoft. Don't need failover/clustering or more than 4 cpus. Had read that standard edition does not allow concurrent full table scans. Any performance differences? 15-25 users, 750meg database, 50 tables. Heavy query, light update, OLAP...