Recent content by SrkrReds

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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

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