Search results for query: *

Is there any way to retrieve the user's SMTP address? I am able to retrieve the domain and username information from the environments variables. I hate to use the word but, can I <font size=+1><b>assume</b></font> that combining these 2 field would equal the email address of the user?

When I try to open an Microsoft Access 2000 Action Query in Design View, the entire application closes. The Action Query is a Make-Table Query that used Linked Tables. The queries is part of several queries that make a report. If you run the all the queries, the report is produced, we just...

Good Day, I have a stored procedure (SQL Server 8) that runs for about 2-3 minutes. If I try to run the stored procedure using Access, I get a timeout error. Is there any way around this? All help is appreciated, Deborah

I am currently trying to create a report that only sums certain values. For instance (please note the totals with a * preceding), Trial Personal 6 Joint 4 Never Handled 8...

I am currently trying to run a query that will use values in a text box to filter. For example (taken from the SQL View of the Query Design): SELECT * FROM tbl01_CaseTimeDetail WHERE (((tbl01_CaseTimeDetail.attorney_branch) in ([Forms]![frm02_CaseTime]![txtBranch]))); Now here is the problem...

I require assistance with the following table: sample cycle idtype sample_date res1 res2 ------- --- ------ ----------- --- ---- 6861 1 M 05/17/1999 D <NULL> 6080 1 M 11/17/2000 A P 6080 1...

I would like to get a row count but I want to only count the distinct items in that row. For instance: Fruit ------- apples apples oranges grapes oranges oranges If I do a 'select distinct fruit from supermarket', I will of course return Fruit ----- apples grapes oranges I would like to do...