24 Solved Topics
Remove Filter  | Hi everyone! I'm making an application which requires users with different permissions/previleges to login and use the application.For example, if the user is "admin", all menu items in the menu bar are shown and enabled. If the user is say "user_group1", some of the menu items are to be hidden. …  |
| | Greetings everyone! I have some codes in my application which makes a backup of mysql database and save the backup .sql file to a location on the hard disk. I made the code in like 2013/early 2014, I think I was then using a now older version of mysql, it … |
| | Hi all! I have a form with a combobox, a listbox and 2 command buttons.(see photo and neglect the blank listview) I select items from the combobox and add items to my listbox after clicking the button.(no problem with this) Then, I need to save each item of the ListView … |
| | Hi all! I have just developed an application on VB.NET with mysql. I then need to deploy this to clients workstations. The plan is to install mysql server on one computer and have all other clients connect to this. What do I need to install on the server and what …  |
| | Hi! I'm developing an application for hospital patients information. Now, as common for hospitals, I need to add a feature for various reports.Now I would like to know if you think Crystal Reports are a good option still. I would like to present many reports which a user will choose …  |
| | Hifriends! I've just started working on SEO for my sites, but I have problems in my first attempt. I signed int to Google Webmaster tools...added a site and verified it successfully. My site even started appearing on Google Search and within a very short time, it was on the first … |
| | Hi friends! I installed Windows Server 2008 Standard and then activated it successfully. I has been running for over 2 months now with no problem. But, it has now started to ask me for Activation. "My Computer -->Properties" says "You must activate windows now" and I see the "product ID … |
| | Hi all! I have a USB Modem (dongle) made by ZTE. I normally use it for connecting to the interent. It also came with a dashboard/software that I can use to send & receive SMS and even make a call. I want to make an application with VB.NET that will … |
| | Hi! I'm programming with VB.NET + Mysql database. I have one table of which, one of its column can have multiple entries to it. That's, say a table named TableA(item2,item2,item3,item4). Now, I have a scenario where I may have item1,item2 & item4 filled,but item3 is not. (Please have a look … |
| | Hi! I'm seriously stuck here. The issue is with one Windows 7 Home Premium machine. This machine: -- I can not ping it from either Win 7 or XP clients (I have a mix of Win 7 and XP) -- This machine can not be seen in the 'My Network … |
| | Hi friends, thanks all for your contributions here at DaniWeb Community. I want to ask one thing; I have a table where I keep values for students marks (StudentID,Marks). Let's say there are 50 students. I want to be able to display on the form the class rank for each …  |
| | Hi all! IN MY VIRTUALBOX VIRTUAL MACHINE: I had previously installed XP Service Pack 3 and Windows 2003 Server. I configured this server as a DC and other roles such as DNS...I created users who would login to the domain from the XP client machine. I set up group policies … |
| | Hi all! I'm stuck somewhere. I have a table for Inventory (which contains the available amount of each food component) What I want to do: If I select a certain food (say salad) I want to be able to deduct the components (amount) of 'salad' from the inventory table. Consider …  |
| | Hi all! I don't know if that was a good title, but; I have this query (I will call it query1): "SELECT InvID, quantity FROM Recipe WHERE MenuID = 1" In my tables, this will give me something like Water(20), Oil(30) Now, from this result of a SELECT query1 (i.e … |
| | Hi friends! I have some trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command prompt (Windows) This is my code: mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql With this, I get the message that "mysql" is not recognized … |
| | Hi all! I'm trying to perform a mysql database from vb.net. I use this code: Process.Start("C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\mysqldump.exe", "--user=root --password=mypassword " _ & "--host=127.0.0.1 --databases MySQL databasename -r ""C:\GreatestHR Backup\BackUpDataBase.sql""") When this code runs, a command prompt window opens and goes away immediately that i can't even … |
| | Hi all! I have a big problem that I would like some help. I use Mysql Workbenc 5.2CE. I changed the default port to 3301. The mysql server is up and running well (I access it from an app I'm making with VB.NET). The problem is I can't get mysqldump … |
| | Hi all! I use VB.NET + Mysql. I have two tables (tblstudents & tblpayments). I want to view payments details of a selected student. Thus, I'd like to select some values (firstname,middlename,surname) from tblstudents and (all values from tblpayments WHERE class = @class -I know how to deal with @class, … |
| | Hi friends! I got one puzzle. I wonder if there is a way I can create a table but get a table name from a value of the textbox/combo box control. Does anyone have an idea? I mean something like "CREATE TABLE (TextBox1.Text) (".....)" I wonder if that is really … |
| | Hi! I just learnt to use the "Parameters.AddWithValue" to prevent harm of sql injections.However, I have only been able to do this with the INSERT, but I have trouble using that with SELECT and UPDATE. Please Look at my code with UPDATE Try ConnectionSettings() con.Open() Dim SqlUpdate As String SqlUpdate … |
| | Hi all! I have a table with (StudentID,Physics,Chemistry,Total,Average) I want to pull values of Physics,Chemistry and calculate Total and then Average for a specific StudentID. With the following code: "SELECT SUM (IIF(ISNULL([Physics]),0,[Physics])) As Phy, SUM (IIF(ISNULL([Chemistry]),0,[Chemistry])) As Chem, SUM([Physics])+Sum([Chemistry]) as Total FROM tblForm1 WHERE StudentID = '" & Trim(Me.txtSearch.Text) & … |
| | Why do I get an error creating a temporary table with something even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please? Thanks! |
| | Hi friends! I have a piece of code that I think should be working just fine, but I wonder why it doesn't work, and I get an "Syntax Error in INSERT statement" error message. Here is the code to affect a table called "Users" in my Access database. Dim cmd … |
| | Hi friends, I'm developing an application for HR. I have two tables so far.One is tblDetails and the other is Academic. I have created a relationship (ID to AcademicID), I have been able to pull data to a form by this SELECT statement: sqlSearch = "SELECT tblDetails.ID, tblDetails.FirstName, tblDetails.Surname, Academic.AcademicID, … |
The End.