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 Chriss Miller 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. SrkrReds

    Is there a utility to find out userID who is locking a record(page)

    Hello: Is there a utility(free ofcourse), that can be run against a database and findout who has placed a lock (and since access locks at 2k page levels, more than one record is locked) on a certain record OR is there some code somewhere that I can use to determine the userID locking the...
  2. SrkrReds

    Double sided Report printing in Access97??

    Shouldn't it be done programatically. By default(assuming), one-sided reports are printed and if printer supports double-sided, we need to do this programatically using printer object to print double-sided reports? I just dont know how and cant find any examples. Hopefully someone out...
  3. SrkrReds

    Double sided Report printing in Access97??

    Is it possible to print double sided reports in Access97? If so, please help me. thanx in advance
  4. SrkrReds

    Problem with Filtering records with DateDiff function??

    Sry for not mentioning in my previous post, I did correct the extra closing bracket and ran the sql and got the error. I ran the sql again now(just to see) and i still get the same error THanx
  5. SrkrReds

    Problem with Filtering records with DateDiff function??

    Thanx for the quick response PHV. I ran that sql and get the following error when i run it: The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning...
  6. SrkrReds

    Problem with Filtering records with DateDiff function??

    Hi: I have a table where there is a date field and I need to filter records (for how many passed within a given amt of time. if user wants to check past 30 days, they enter 30 when prompted.). I have a parameter query as below. SELECT [tbl Work Order].[Entry Date], [tbl Work Order].STATUS...
  7. SrkrReds

    Problem with Keyword Expansion for xml files....

    Hello: I am trying to add keyword expansion to *.xml files in one of our vss databases, but it is not working.. This is what I have in the srcsafe.ini file on the vss server. Keyword_Masks = *.a, *.a51, *.asa, *.asc, *.asm, *.asp, *.bas, *.bat, *.bld, *.c, *.cct, *.cfg, *.cls, *.cmd, *.cpp...
  8. SrkrReds

    Delete and insert in one statement...

    Thanx for the suggestion. I was doing something like that based on some criteria. I was wondering if all of it can be done in one sql statement (something like a subquery - selecting the deleted record from DELETED table) without declaring any variables. Thanx again.
  9. SrkrReds

    Delete and insert in one statement...

    Hi All.. Can someone help me with syntax on how to select a record from tableA(based on some criteria) and insert into tableB and then delete that record from tableA, all in one single statement in query analyzer. Do I use the memory resident DELETED table(can this even be used anywhere other...
  10. SrkrReds

    Searching for File existence on client side..

    Hi.. We have an application where a user types a file name with full path on any of our servers in our network or browses to it and selects it and this information(file name & file path) is saved in the database. Currently, user browses or enters a valid file and path and our validation...
  11. SrkrReds

    Disabling Keyword Expansion ....

    Hello All.. One of the project folders in our vss DB needs to have keyword expansion disabled. Is there any easy way to disable a project and it's subfolders from expanding keywords in the file headers. Ex: We have following lines in srcsafe.ini file to disable expansion for all files in...
  12. SrkrReds

    Accessing Visual Source Safe from ASP Page

    Hello All: Does anyone know how to access visual source safe from asp page? If so please help or point me in the right direction. THanx in advance.
  13. SrkrReds

    Launching vb app(exe) from asp page...

    This is an intranet application. I tried something like below <A href=&quot;http://myServer/TestProj/TestProj.exe&quot;>Run Application</A> . When the link Run Application is clicked a file download dialog box displayed with 2 options, &quot;Run this program from it's current location&quot...
  14. SrkrReds

    Launching vb app(exe) from asp page...

    Hi: We have a vb app(x.exe) that currently is being launched from MSAccess forms. Is there anyway to use the same app to launch from a web application(asp page, when user clicks on a button). Can someome help me out in this matter, on how to do this or point me to some website?? THanx in...
  15. SrkrReds

    Access pop-up dialog while closing a form...

    Hello.. We have an Access97 app ,with a front end and back end database. When users close one of the form to return to another, a pop up is displayed with the following message:&quot;Form Name has been changed since the last time you opened it, either by another user or because another instance...
  16. SrkrReds

    Compatibility..

    To All: Reposting this and hoping some one would reply. thanx
  17. SrkrReds

    Compatibility..

    Hello All.. What editions of SQL Server 7.0 and SQL Server 6.5 if any can be installed / run on Win XP Pro OS. thanx in advance..
  18. SrkrReds

    Application running in uncompiled state

    Hello: When we open one of our Access97 DB's this is the message displayed to users: Application is running in an uncompiled state and could experience poor performance. Please inform database admin if you see this message . Does anyone have an idea about this? I am wondering if we need...
  19. SrkrReds

    Getting Latest Version via automation....

    Hello.. We have a vb application(that uses Ole automation) that does pinning, getting latest and few other things in vss. Having a problem with Getting latest version when the file is pinned at a previous version. Ex: If a file is pinned @ version 5, and this file has versions until 8...
  20. SrkrReds

    Disk or network error

    We have an access DB that is split into front and backend(both on the same server on the network). Front end is about 12MB and backend is about 75MB. Since past 2 weeks some users keep getting Disk or Network Error. We feel it's a network problem, and IT thinks it's the DB problem. We...

Part and Inventory Search

Back
Top