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

Hi all, 
 
My question is: 
 
I have a timesheet form that contains my depts employees timelog.  One of the 
 
fields is employeeID. 
 
I've created a switchboard where the employee clicks on a command button and 
 
it opens a form Timesheet which allows them to view/edit their time, However 
 
they have the capabilities to view all 9 employee's records. 
 
If possible, can someone help me with this task: 
 
I've created logins and passwords for each employee 
 
I need to create a code that does ...

I am updating an Access database created by a former employee that we use to 
 
track employee training as part of ISO, using ACCESS 2002-2003. 
 
When a WI/PRO is updated it is entered into the database incrementing the 
 
revision level by 1 (Assy-010-01 would become Assy-010-02). 
 
Employees are trained and/or training is required on job titles.  The way 
 
the dbase is currently set up is that when the revision is entered the old 
 
one is made obsolete using a check box and the new revisio ...

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

Hi folks, 
 
I have three tables: 
 
Table1: Contacts (PK = ContactID) 
 
Table2: WebComs (PK = WebComID) 
 
Table3: ContactWebComs (junction table - multi-field PK = ContactID, 
 
WebComID) 
 
I want to get a count of how many WebComs relate specifically to the 
 
current Contact. 
 
I am trying to use the following select statement but it keeps 
 
returning an error 3075 - syntax error, missing operator in query 
 
expression: 
 
strSQL = "SELECT * " & _ 
 
"FROM WebComs INNER JOIN ContactWebC ...

Lady only 24-Hrs +91 9810577227 
 
OR email to info@lenstar.org

Lady only 24-Hrs +91 9810577227 
 
OR email to info@lenstar.org

My browser froze each of the times I tried to post my question and I received 
 
a message from microsoft saying I was having connection issues. I can't find 
 
a way to delete my question, so I just wanted to apologize for three of the 
 
same questions.

I have a quoation table that is linked to a quoation details table. I then 
 
have a form with a quoation table main form and quation details subform. This 
 
subform contains three fields, all of which are controlled by the RTF2 
 
ActiveX control so that words can be individually formatted. The subform is 
 
linked to the main form by the Quotation No. 
 
Once I enter data into the form, subform, or both it essentially disappears. 
 
If I click my print preview button, the report is blank. If  ...

I have a quoation table that is linked to a quoation details table. I then 
 
have a form with a quoation table main form and quation details subform. This 
 
subform contains three fields, all of which are controlled by the RTF2 
 
ActiveX control so that words can be individually formatted. The subform is 
 
linked to the main form by the Quotation No. 
 
Once I enter data into the form, subform, or both it essentially disappears. 
 
If I click my print preview button, the report is blank. If  ...

I have a quoation table that is linked to a quoation details table. I then 
 
have a form with a quoation table main form and quation details subform. This 
 
subform contains three fields, all of which are controlled by the RTF2 
 
ActiveX control so that words can be individually formatted. The subform is 
 
linked to the main form by the Quotation No. 
 
Once I enter data into the form, subform, or both it essentially disappears. 
 
If I click my print preview button, the report is blank. If  ...

I need to design a table for product attributes that seem to go on forever. 
 
Basically, we're trying to get all the possible responses that could ever be 
 
asked about the product into a table. I just grabbed a bunch of the 
 
questions and cut-n-pasted below to give you an idea how these questions can 
 
go on forever. 
 
The big question is how you would name the [fields] and keep track of what's 
 
what? There could easily be 200 questions. Would you just name the fields a, 
 
b, c, d, e,  ...

Lady only 24-Hrs +91 9810577227

I have a table implementing the time sheets. Each row contains a 
 
worker's name (text, primary key), start time and stop time 
 
(date/time). This is updated daily. Presently I can use a simple query 
 
to display this but it keeps no history. 
 
How can I modify my table to maintain a one month history? Perhaps I 
 
could add the stop time to the primary key? 
 
If I did that, 
 
(1) how could I write an SQL SELECT statement to print only the most 
 
recent start and stop times for each worke ...

I have built a small application in Access destop ver. I want to use this 
 
application on PDA. Is there some way I can convert/run this app on PDA as a 
 
stand alone package or as of Access app. 
 
I am even not sure if there is any PDA version of Access out there? 
 
Thanks in advance

This is really made a mess.  I'm working on "fixing" a lease management 
 
database, (which at this point is just used to house data).  There are many 
 
tables in the database.  But the main table is called tblStores. 
 
The fields are: 
 
StoreID 
 
StoreNo 
 
Address1 
 
Address2 
 
City 
 
State-Province 
 
Zip-PostalCode 
 
Country 
 
Region 
 
Status (drop down box negotiating, approved, open and closed) 
 
I then have a table housing lease information such as, commencement date, 
 
expiry ...

Hi 
 
To date I have mainly built small one off databases and a few split network 
 
solutions (mde FE & mdb BE). I would like to start learning how to take 
 
create deployable for users beyond my network. I understand that ADE and VS 
 
Tools have packaging wizards that deal to some extent with installation and 
 
Access runtime. 
 
I would appreciate your thoughts and guidance as to the design considerations 
 
I should apply. 
 
Perhaps most significantly I am wondering how at a later date I ...

My database consists of three main tables: one for the data which contains 
 
only an item key, a date, and a value for each record; another for the item 
 
keys, which has descriptions and details of the items in the data table; and 
 
a third to give details on data sets that consist of a series of items listed 
 
in the item table.  Here is an example of the relationships: 
 
Data table records: 
 
ITEMKEYS:          DATADATE:      DATAVALUE: 
 
ALLCAR_US            2/1/2006                20 ...

I am building up an address database, where I will need to add data 
 
frequntly. The database is built up in a number of  tables and I wonder what 
 
is the right way of entering new data, without having got to enter them in a 
 
number of tables? 
 
I have tried making a qury that assambles all the fields , but not all the 
 
fields get updated in all the tables. I suspect that I have got to take a 
 
closer look at my relations for fixing this, but maybe there is an easier way 
 
of doing thi ...

Hi, 
 
I'm developing a courier appln which contains the customer rates 
 
different for each customer. 
 
i need to fetch the customer rates from the db. Each and every customer 
 
have different rates for the different countries, cities. I can't 
 
categarize into group bcos of variation in prices with customers. i 
 
give a sample price. 
 
For eg: Cust A 
 
Country          Doc                                       Parcel 
 
First 500g   Addn 500g    First 500g   Addn 500g 
 
USA 
 
LA       ...

Both for an Inventory DB I'm working on, and for general knowledge for future, 
 
wondering about the following situation - 
 
Intentory Item (parts) table, approx 2000 records at this time, having the usual 
 
fields; Vendor, Manufact., partNo., etc.  For about 25-50 of these 
 
records(parts/items),  will also print separate labels which will use three 
 
fields that are different.  For example, while these 25-50 will have Description 
 
field in common (among about 22 other fields in common), ...

Hi, i've been playing around with MS Access 2k3 for a while now, and am still 
 
trying to learn good database design. I've rebuilt my current one (For IT 
 
Equipment Tracking) and just get it right. Im looking for some 
 
recommendations for books to learn good database design. 
 
Thanks,

I'm wondering if I'm setting myself up for problems......am I wrong in my design 
 
of a fairly simple Inventory DB. 
 
This is for receiving only.  Some items will be stocked on shelf, but most items 
 
will be delivered directly to various departments. 
 
Most of the samples I see have a "Products" and/or "Inventory" Table, and a 
 
Transactions Table.  I only have a Transactions Table.  (and P.O. Table). 
 
To get current stock level, I sum the transactions field. (+24 for 24  ItemXYZ 
 
rece ...

i'm trying to set up a database tracking order history and order 
 
receipts for inventory items, but i'm not sure what should be in each 
 
table, what should be in the link table, and what kind of key should be 
 
used in each table. 
 
each item is identified by either IJ number or IA number. not all items 
 
have both numbers, but all have at least one. some parts are ordered 
 
under IA number and received under IJ number, or vice versa. some items 
 
are also referred to by multiple IJ or  ...

Does anyone have a attendence database to track attentence? 
 
-- 
 
CChandonnet

I have to match names from one list to another list that is in Excel format 
 
from TSA.  I need help on how to set it up, if a program that exists already. 
 
---------------- 
 
This post is a suggestion for Microsoft, and Microsoft responds to the 
 
suggestions with the most votes. To vote for this suggestion, click the "I 
 
Agree" button in the message pane. If you do not see the button, follow this 
 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
 
click "I A ...