Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Automatic Increment numbers
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... -
Todays date
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 -
Automatic Increment numbers
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... -
Automatic Increment numbers
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... -
Todays date
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 -
Todays date
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... -
Automatic Increment numbers
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... -
Automatic Increment numbers
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... -
What to download
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... -
What to download
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 -
What to download
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... -
Error porblems
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- Asbestos2
- Post #2
- Forum: Microsoft: ASP.NET
-
Error porblems
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...- Asbestos2
- Thread
- Replies: 1
- Forum: Microsoft: ASP.NET
-
What to download
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... -
-
Access to SQL server and front end
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...- Asbestos2
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Access to MySql
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 -
Access to SQL server and front end
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...- Asbestos2
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
MS query adding more tables
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- Asbestos2
- Post #18
- Forum: Microsoft: Office
-
MS query adding more tables
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...- Asbestos2
- Post #16
- Forum: Microsoft: Office
