Tables

How to user Dataset created by Visual Studio 2008
Hello, I'm new in .Net world and there is so many info that I'm lost. DataSet is creted by Visual Studio 2008 to handle a FireBird database. Where can I find documentation about how to use theses classes in a better way? What is the most efective way to use it: load table by table from the database and ... 2 Jul 2008 18:05

Looking for a design suggestion...
I have a database that tracks projects. One project may have several appointments related to it. I have a check box to mark a project as being complete. All of the appointments have a date field to enter the date the appointment was completed. I would like to prevent the user from completing a project unless al... 3 Jul 2008 17:40

Setting an autonumber back to zero
I am working on a table with an autonumber field as primary key, now that is ready I need to set theinitial value of the field to zero, how can I do dat if I a on access 2007 ... 4 Jul 2008 13:05

Group by (Selecting First) after Sorting
Hi, I am trying to figure out a process from queries to obtain correct data from a table. For example, I have 3 fields Apple Red Big Apple Green Small Now I would like to obtain the 2nd row as a result (I do not want to use individual criteria as I am working on a large transaction table ... 2 Jul 2008 16:01

Can't figure out the error message
Hello, I have desingned our church secretary database and I named it "Hahomion" all resideds in churchdata folder. The original design was in Indonesian, but since there is request to make it in English, I created the folder C:\ChurchdataEng, I modified everything in English, It seems OK, but any time I go ... 2 Jul 2008 11:54

Standard Operating Procedures - How to Manual
I have been working on an SOP for about 3month now and am getting frustrated at it. The problem is that when I need to change something, formating the page, column, tabs(!!!), numbering(!!!), it needs to be conguent with the rest of the document. Unfortuantly it is not working to my expectation with MSWord an... 5 Jul 2008 23:44

Text and only text datatype
My managers keep putting dates in a text field. Is there any way to use validation where they can't put dates in a text field or n/a or some other comment in a date field? I have all the datatypes set but they still manage to enter stuff in the wrong place on the form and it then ends up in the table. Thanks so... 1 Jul 2008 16:27

How do I prevent deletion or changing of a record in Access 20
Thanks Allen - very helpful - your site is now on my bookmarks! :) "Allen Browne" wrote: If all records are entered through forms (not directly on the tables/queries), you could set the forms' AllowEdits and AllowDeletions to No, leaving AllowAdditions as Yes to permit new records. Another option... 30 Jun 2008 22:00

Increase Record Limit in Auto Number
I want to set an auto number field in a table that will contain hundreds of thousands of records. The default structure is Long Integer and won't work. How can I exceed that limit? -- Ken Hudson ... 1 Jul 2008 11:18

Convention Attendees Design
Hello all, I am needing some suggestions in creating a database to track attendees for two conventions. I need to track the attendees, conact info, lodging arrangements, which convention they are attending, and which branch they are affiliated with. Also, I need to provide the welcoming volunteers with pi... 30 Jun 2008 16:52