ASP.NET, SQL Server, WPF, C#, VB.NET

I use an access database on a FrontPage website where users record the hours 
 
and minutes they devote to a project.  This data is kept in 2 columns of an 
 
access table.  I need a way to at least total those columns and at best 
 
produce a total where the minutes over 60 are converted to hours. 
 
Any ideas would be appreciated.

I have created a Switchboard using the Switchboard Manager, but there is no 
 
Switchboard form in the list of forms. Hence, I cannot select the Switchboard 
 
to come up automatically at startup.

I have a mainform [Invoicefrm) and subform [InvoiveDetailsform] 
 
Invoicefrm has field "Invoice#" and "InvoiceDate" 
 
I want to set the Invoice # of the mainform to each line item of the subform. 
 
The Link master and child fields has already been used for another 
 
operation. is there anyway this can be done. I referenced the "Invoice#" 
 
field on the subform to that of the mainform and it works but the data is not 
 
passed to the underlying query. 
 
please help

In Access97 I'm writing a short routine that loops through the tables 
 
collection. I want to write the various table DDL information to an Excel 
 
file. How can I do that? Alternatively, would it be a whole lot easier to 
 
simply write a tab-delimited string to a text file; then manually import 
 
that into Excel? 
 
Thanks!

The Dell Axiom (I've been told is a Pocket PC) 
 
that can run wireless & use databases & Email. 
 
I understand "Microsoft databases" can run on 
 
Pocket PCs. 
 
Is Access a DB will can run on a Pocket PC? 
 
I'm looking to collect data & Email DBF files 
 
to be Imported at Regional Offices.  IF Lotus 
 
Notes can also run on a Pocket PC, I'm ready 
 
to make this work. 
 
I currently use Regional Access DBs to send DBF 
 
files via Lotus Notes for Importing at the Corporate Office. 
 
Any insight welcomed. 
 
TIA - Bob

I am looking for suggestions on good small fonts for Access reports.  I used 
 
to use "Small Fonts", but I see that is no longer an option.  TIA for 
 
suggestions! 
 
-- 
 
Carol

I can view gridlines on my list fom database but they do not appear when I 
 
print the form. The "Help" is no help at all.I've been through all the menus 
 
and nothing seems to work.

I cannot open a shared database and neither can anyone else that is on my 
 
network.  When we try to open it it gives us the error that someone else 
 
already has it open exclusively and lists the person as having it open as the 
 
one that is trying to open it.

Hi Guys 
 
I am populating a listbox from a table using an SQL statement. 
 
One column is currency. 
 
I want to show zero values as blank, not zero. I want to show none blank as 
 
usual currency format. 
 
Is there a format command I can use? 
 
Thanks in advance. 
 
Paul

I populate my subform by entering matching data into the main form. This is 
 
done by using the Master and Child fiels properties of the subform. Good! 
 
However I also want to past different data from the main form to the subform 
 
and after reading the posts they all suggest doing the same Master and Child 
 
Field properties please help. 
 
I found out that both cannot be done on the same form. 
 
Please help

Bill Gates will continue to chair but will leave "day-to-day" 
 
Microsoft role to focus on Bill & Melinda Gates Foundation. 
 
http://money.cnn.com/2006/06/15/technology/microsoft_news/index.htm?c... 
 
Mike

Is there a way of hiting a key to automatically go to a certain feild in a 
 
record.  For example the / key and it will go to a record. 
 
Thanks 
 
Chey

I have a csv file that is a download from an online form.  The online form 
 
has several text boxes in which users can enter as much info as they like. 
 
When I export the records into the csv file the data in those text boxes do 
 
not get thrown into one column but rather sometimes take up more than one 
 
column (I think its becuase the user hits the "enter" button while they are 
 
in the text box). 
 
Is there a way once in Excel that I can get the data for the text boxes to 
 
drop into  ...

I have a macro that is exporting data from a query to a spreadsheet.  the 
 
spreadsheat is recreated all the time I run that macro.  I would like to open 
 
that spreadsheet as soon as the macro finshes exporting.  How will I do that.

Can Access link into a program using Unify databases and stored in a 
 
dedicated Unix server?

I need to have a copy of my Access 2003 DB on the shared drive at our office. 
 
Coworkers must have access to my records, but I don't want them to be able to 
 
alter my records. 
 
I thought by copying and pasting my DB, it would create a separate DB and if 
 
they changed something, it wouldn't affect me. But, they are linked and any 
 
change they make appears in my DB and vice versa. I tried locking (read-only) 
 
the copy on the shared rive, but it locks mine as well. 
 
I simply right-cli ...

How Can I get Information from a Main form to a subform? 
 
Would Like to get “WaybillID” and “WaybillDate” from [Waybillfrm] to 
 
[WaybillDetailssubfrm] 
 
thanks

I have reciently noticed that when you load adobe 7.0 the pdfmaker 
 
modfies the MS products to include a new "toolbar" button on the 
 
startup menus called Adobe PDF.  This affects most microsoft products 
 
including MS Access. 
 
The problem I have noticed is the intialization of this application 
 
modification is after the MS Access security has intialized.  If you 
 
have MS Access security set for read only personal, or if mulitple 
 
people are accessing one shell at a time, there is a ...

I have a db that has begun to display an Invalid Argument error, when 
 
attempting to run an UPDATE statement.  I have looked at the data, thinking 
 
it may be an issue with a reserved character.  However, when testing other 
 
data, that have the same characters, the problem does not occur. 
 
Could this be record corruption, or does someone see a data issue, that I am 
 
missing? 
 
The data is: 
 
Standard Wireless Communications Kits (includes: 1 indoor with 15 inch 
 
antenna and 1 outdoo ...

Hi Everyone, I'm pretty new to using both XLS and Access, I'm required to do 
 
some reports for work and I've been using both XLS and Acces, is it possible 
 
to do all the functions in XLS in Access? Including custom functions I've 
 
created for XLS? 
 
TIA,

Let me start off by saying I am using Access 2000 and am not a programmer;-) 
 
having said that: 
 
I have two tables:  Mediator and Mediation information.  The Mediator table 
 
has Mediator_Name, Mediator_Phone, and Mediator_Address.  The Mediation table 
 
has 
 
Mediator_Name,  Mediation_Location, and Mediation_Time. 
 
I am using a combo box to list the mediator names and have the work phone 
 
numbers as column 2.  What I am trying to do is have a text box show the 
 
phone number for the ...

I would like to download Access 2003 trial version.  I can't find it anymore 
 
on Microsoft's site.  Where can I dowload a copy? 
 
Thanks.

I have a database with 3 tables. Each table has an account number field 
 
(account number are 16 digits and in a TEXT format) however the tables are 
 
completely different as are the account numbers that populate them. To go 
 
with the tables are queries that will bring in desired information. What i 
 
would like is for the user to input an account number on a form and have some 
 
code in the background that will find the account number in the table it is 
 
in and open the corresponding qu ...

I created a shell which includes about 50 variables, all of which have 
 
different validation rules and validation texts. There seems to be a problem 
 
with one of the variables. The validation rule says that valid answers are: 
 
Between 0 and 2 or Between 99 and 94 (which is the correct validation rule), 
 
and the validation text is: 0=.... 1=.... 2=.... (the options). However, when 
 
I enter 1 and try to move on the next variable, I get an error message that 1 
 
is not a valid response,  ...