Search results for query: *

Hello, we use faxpress thru access to fax documents.But this is restricted to one user at a time.is there any way multiple users can fax documents at same time.. Thanks

Hello, how do I select a record one less than max records for example id num 23 456009 45 456009 67 456009 I want to select 45..

Hello, How do I combine these two queries so that I dont have to use #temp table.The whole purpose is to get WorkGroup_Id from agent summary table for first select statement resultset create table #attempts (cnt int, ent varchar(20),edt datetime) insert into #attempts SELECT COUNT(*)as...

Hello, i know theres no way we can concatenate text.I am going through some problem and hope somebody can advice me on this. I have a text field where theres large amount of text. I need to concatenate this data to other field which is nvarchar for reporting purposes. I dont see anyway..Anything...

Hello, we have a field in table which needs to be parsed. These are basically comments which need to be parsed to separate table ln comments 2003 12/03/04 user called 01/04/04 fax was recieved 01/05/04 we responded 2004 01/01/04 case was registered...

Hello, I have a worksheet in excel with data like this ln id name 15 1 jack 16 2 john i need data in worksheet 2 as ln 15 16 id 1 2 name jack john Can anyone suggest a way for this Thanks

Hello, I am working with iewebcontrols.i coded and everything but 1.I cannot switch betweeen tabs in browser. 2.And also I cannot see the images.I can see the images in design mode Here is code.Please Advice <mytab:TabStrip id="tsVert" runat="server" BorderStyle="Solid" BorderColor="Gray"...

Hello, I am new to IIS.I am trying to install a trial version of SSL.I rightclicked on site on IIS,selected properties,File security, but I see Server certificate tab is disabled.Advice please Thanks

Hello, I have a view in Sql Server 2000 in which I can edit data and enter data.But the same view doesnt allow me to enter data in access project.Any work around please.. Thanks

Hello, I created a project in access2003.But the users having access2000 cannot edit records.I have gone thru knowledge base articles.Is there anywork around other than installing SRs and SPs Thanks

Hello, How do we get data for six months from today. Do we use datediff function? Thanks

Hello, How do we comment piece of code in visual interdev. Thanks

Hello, Is there any way we could save parameters supplied to a report?We are trying to track the parameters given to reports. Thanks

Hello , I am trying to integrate my access project into vss.My office version is office xp and I installed sp2.I still dont see visualsoucesafe in tools menu.Any ideas Thanks

How do we convert datetime to format d/m/yyyy (9/2/2004) Thanks

Hello Can the resultset from sp with parameter input from form can be displayed in immediate window? Thanks

Hello, I used stored procedure with parameter from form..I do not see the resultset when executed.. can we display the results just like int query or i need report to display results? I used the following code Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command Dim rec As New...

Hello, I migrated a databse from access to sql server200.Frontend is in access and backend in sqlserver.Problem is if I enter dates its send to sqltable as datetime..How do I fix this to insert just dates from access to sql server? Thanks

Hello How do I query on new field we create in query. something like select a.a1,a.a2,(a.a3+a.a4)as 'newfield' where newfield ='10' Thanks

Hi, I am importing data from as400 to sql and there are some date 00/00/00 which are creating problem when converting into date type.Can u please advice on how to handle that in vb script in DTS Rightnow I have Function Main() DTSDestination("ClearDate") =cstr(DTSSource("Col010")) Main =...