Search results for query: *

Oh I see yes that works. However the next thought is it possible to use a view through access forms (we are using Access as front end tool).... assuming it is, when we enter data into the Quote it should populate the Quote table from the view (input form access form). is my thinking correct...

Hi Guys You lost me now which to be honest isnt hard to do. What we need is the current date (not time) to appear when we open a form (in access) to appear and be part of the record when it is saved.... But form what I can gather this is not possible, is this correct Thanks

I got a little further CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `qview` AS select concat('Q',`quote`.`idQuote`) AS `idquote` from `quote` This applied ok. I added another field into the Quote table called Name and enetere 2 records with names. The...

Hi I ahve tried what you suggest and for some reason when it tries to run it gives a system error message and asks if I want to send an error report and then closes the Workbench. the databse is called Test, The table is called quote and to test I ahve one column called idquote set as PK NN...

Being we are using an Access front end how would the insert work. So each time a user adds a new record how will the database run the Insert. I am fairly new to MySQL so not quite into the programming side as yet. Thanks

Hi I been creating tables in the Workbench 5.2. What I need is a couple of the date fields to automatically out in today's date. I tried commands like Now()in the default and even tried a trigger which looks fine but doesnt put the date in. I would prefer to keep it simple and put the...

Hi Thanks for the reply 1. Yes I mean the auto increment. As I mentioned I am new to MySql so I have bene using the Workbench 5.2 to create and make my tables. I am not up with the programming side as yet. But i understand about truncate and also a tip I saw on the Internet, if you wanted...

Hi I am fairly new to MySql. I have created a table and after a few entries I made the ID into AI. This works OK but a couple of questions; 1. Because I started without AI then did it started the increment at 5. is there away to start it at a number you want it to like 1. 2. Is there a...

Hi Great, I clicked on earlier and did this, I have done this and it looks better , sorry I am new to MySql. So and I hope not to many questions now 1. How do I import and Access database into this or could you point me in the right direction of good training notes for it 2. Do you know of...

I unticked the security and it said it loaded ok. However the only software in my start/all programs/Mysql/mysqlserver5.5/ is the Mysql command line prompt. Shouldn't I have some other Mysql software where I can use the database development etc..... Thanks

Hi I have downloaded the but I am getting as far as the security settings and it then gives me a message Error nr 1364 Field 'authentication_string' doesn't have a default value I dont have a firewall so cannot open port 3306 (dont know any other way to either). Any ideas how I get round...

Hi Please ignore the bit in the code above that shows MVC Music Store Tutorial v2.0 – http://mvcmusicstore.codeplex.com – Tutorial under Creative Commons Attribution 3.0 License Page 14 I copied this in from the training notes by mistake.... Thanks

Hi I am new to .ASP net and have downloaded all i can and I am using MS Visual Web developer expresss 2010. I am following some training notes which is showing me how to add a controller but it doesnt seem to work. This is what the training notes tell me to do This will create a new file...

Hi I would like to download MySQL. The intention is 1. Import Access database and add in new tables, then use Access as a front end (quick solution) 2. I also will be looking at developing the databse os it can be used through .ASP net or PHP So my question(s) are what do I need to download...

Hi Sorry I mean MySQL not MSSql. Any ideas??? Thanks

Hi Thanks all of you for your valuable replies. I cannot see us managing to use MS SQL enterprise due to the cost and the Express would be to small in size. Therefore if we used MySQL (which I am informed is free)and imported and built our DB in this from Access; 1, We could use Access front...

we are looking into using MSsql instead of our current MSAccess database solution. Is it easy to transfer our current master DB into MSSql and also Is there a front end system that we could use to create user screen for creating quotes, data entry etc........ Without heavy programming. Thanks

Hi Our company is looking to use SQL. Either MSsql or MYsql. Presently we have Access database system that creates an MDE file with which we enter surveys into. The database then creates html report files with graphics which we then create a full PDF document and supply the customer with the...

Thanks for your reply I have tried the code as you have given above but it still says Cannot add the table table (((Tablesamples Any ideas Thanks

Hi I added some comments last night and you asked me to try some other things We did a simple select and that worked and also then using 2 tables with a join. this both worked but when I added the next table it did not work. I was using a username ASBESTOS1. The code below is the last copy...