Search results

Hello Dave, This is going to be a quick one before I go to work... maybe one of the other guys can add to this... :) In your forms 'Design' mode, click on 'View', 'Tab Order' and you should see your tab order highlighted on the form. From there all you have to do is click your forms...

I like clean simple forms. ) White backgrounds. :eek: ) Small forms that are not maximized unless required. That helps for different screen resolutions... unless you want to set their screen resolution in code... cough... cough... ) For me I never stack exactly sized forms directly on top of...

Data Access Application Block for .NET v2 http://www.microsoft.com/downloads/details.aspx?FamilyID=F63D1F0A-9877-4A7B-88EC-0426B48DF275&displaylang=en Overview Are you involved in the design and development of data access code for .NET-based applications? Have you ever felt that you write the...

I have read ‘a little’ on OOP, but honestly never really practiced it. Everything catches up with you sooner or later… <g> it’s not like I don’t have enough to learn already. I have always thought that when I got into OOP, I would use it something similar to how I used modules within forms in...

This is where I definitely need to spend more time in. A while back I asked if Access would ever be a front-end for .net database applications and the reply was why would I want every Access user to have or need the knowledge of .net. That would require a huge learning curve of relational...

You know… I am going with the point of I think Access is actually more functional with IT or IR departments than database developers (except for prototyping).

In fact to stir the pot a little... here are a few links... Another Microsoft's direction... http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx Which kind of makes one ponder exactly what role Access is going to provide in the future besides being a (very small)...

I don't work in IT... or in my workplace it is known as IR... but "their" opinion is VERY similar to FoFa's. In fact I would say... BINGO! The right application for the right job. I think Access was generically used as an introductory tool to get small businesses to up-size to MS Server...:D...

I will go along with Joe... My interpretation on this is your primary key which can be a composite key of more than one column is to help ensure uniqueness and to help in structuring indexes or help in the speed of your queries etc. Indexes…...

Ohhh yes it has been addressed many times... this is just one example... And it is in the same immediate forum: Working on Design Tutorial. http://www.access-programmers.co.uk/forums/showthread.php?t=100211 There is a lot of good information in there of which you can not digest or learn in a...

I have had one issue with the Access2003 runtime where I had used nested DAO recordsets. The app would work fine on my machine but wouldn't sort correctly on the clients. It also didn't throw an error message... just the sort order wasn't correct in the final recordset... interesting... I had to...

No problem...always learning. And sometimes I get to revisit them more than once. <g> I didn't know I could assign the default values in the datasets designer in VS2005... Thanks! With VistaDB and TurboDB I could automatically insert my default table values (inserting a new row in the table...

Ok... after throwing this around a little, I *believe* I understand why Microsoft doesn't pull table level default values into the dataset. It is so a 'Null' value can still be entered into the database instead of the assigned default value for that column at the table level. At least they...

I really dont think the dataset (your form) has ever been designed to pull or store database/table/column default value properties for creating new rows (by design)… so you will have to do it in the run-time. I was thinking you weren't pulling your default values from the database after...

Did you get it to go? Make sure your table has a primary key, or it will not work. In fact make sure all of your tables have primary keys. You should be able to make it work by doing the following... Create new Data Source (go through the wizards - to bind a datasource to your DataGridView...

Ok... briefly. I can get my default values pulled in and show in the dataset. Just by inserting a DataGridView on the form and adding a datasource through the wizard. This will pull all of my default values WHEN I create new rows 'in the raw' using my database tools on my table. So I am not...

Matty... I am going to have to sincerely apologize! This would be easy with VS2003, but I am having the same problem with VS2005 with bit fields... My immediate problem is that VS2005 is not generating the update commands for me on my dataset. In VS2003 you could go back through the...

Ok, (I should have caught this earlier... sorry) this tells me that your default values are being inserted into your new row when you work with your database tools, right? When you create a new row in your dataset do you then update your database, clear and repopulate your dataset? Have you...

How are you creating your new row in your dataset? Have you tried it on a DataGrid and see if the results are the same (just bind the Datagrid to your table and create a new row)? I am not totally up on VS 2005 but for VS 2003 I used the currency manager for creating new rows. (.add new row)...

First instinct is that this is a SQL Server 2000 issue... When you put in false for the default value at the table level it must be 'False' including the hyphens (it works that way in SQL Server 2005 Express - Just started working with it). Truthfully I don't think it matters which way you do...