Hi Dw. I have a timer that in every 600 interval access the database and the database I'm using is MS Access database. The problem I have is that with this being said, the MS Access database has a limitation of 64 connections on each thread so this 600 interval does reaches the limitation, but I don't want that to happen. This is what I have and I think its where I should be removing the connection. Code: Public conn As OleDbConnection Public Sub ConnDB() Try conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="c:\test.mdb;Jet OLEDB.Database Password = 1234;") conn.Open() Catch ex As Exception …

Member Avatar
Member Avatar
+0 forum 2

Hi Dw. I have a MS Access database that has 9 columns what I want to do is to retrieve all data from a database only on 5 columns. I think I have to use the `select * from data` but I don't know how to select the columns I want to retrieve because I can't use the `WHERE test = '"` because I want to retrieve all database records but only selected columns. A very good example of what I want to achieve is this` select all usernames, birthdates, last_seen_status` now this is just an example where a database …

Member Avatar
Member Avatar
+1 forum 7

Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? Dim stDocName As String Dim db As Database Dim rs As Recordset Dim rs2 As Recordset Dim sSQL As String Dim fld As DAO.Field ' recordset field Dim txtNew As Access.TextBox ' textbox control Dim rpt As Report ' hold report object Dim lngTop As Long ' holds top value of control position Dim lngLeft As Long ' holds left value of controls position Dim location As …

Member Avatar
+0 forum 0

how to edit ms access right click menu? How can I add more items and modify this menu?

Member Avatar
+0 forum 0

Hi Guys, I'm not sure exactly which forum I should ask this in, nevertheless, here I go: I'm hearing about a project being done here where I work using MS InfoPath with Nintex workflows. I do not know anything about these 2. Could anyone shed some light on their knowledge/experiences regarding these (this method of application building)? Thanking you in advance :) May

Member Avatar
+0 forum 0

I have this gigantic query that returns certain data from my MSSQL Database (working perfectly- Courtesy of djjeavons). I want to sort and arrange this data in order. I want if the user selects a range of dates from the form (ex. November 1, 2014 - November 9, 2014), the result should be grouped in order (November 1, 2014, November 2, 2014, November 3, 2014 ..... November 9, 2014). I would like for each of the results to form its own dataset. # November 1, 2014 # Distributor/Importer OpeningPMS Transfer Sales Closing (ADD DATA) # November 2, 2014 # Distributor/Importer …

Member Avatar
Member Avatar
+0 forum 1

I HAVE A QUERY THIS IS PRODUCING THIS RESULT. EVERYTHING WORKS FINE BUT WHAT I WANT TO ACHIEVE IS SLIGHTLY DIFFERENT. INSTEAD OF HAVING REPEATING IMPORTERS, I WANT TO GROUP THE IMPORTERS/DISTRIBUTOR SO THAT NOTHING CAN REPEAT AND HAVE ALL THE BALANCES IN THREE SEPARATE COLUMNS. BELOW IS MY TABLE STRUCTURE: TABLE 1 (ImporterDistributor) --> ID NAME TABLE 2 (PD_Temp_Balance) DISTRIBUTOR IMPORTER BALANCE BELOW IS MY QUERY. Select concat(ImporterDistributor.name, '/', ID.name) as [Distributor_Importer], PD_Temp_Balance.Balance from ImporterDistributor join PD_Temp_Balance on (PD_Temp_Balance.Distributor=ImporterDistributor.ID ) join ImporterDistributor as ID on (PD_Temp_Balance.Importer=ID.ID ) where PD_Temp_Balance.Transaction_Date = '2014-11-01' group by concat(ImporterDistributor.name, '/', ID.name), PD_Temp_Balance.Balance, PD_Temp_Balance.Product AS …

Member Avatar
Member Avatar
+0 forum 2

I would like code to display ms access database dynamically in a jframe . here is my database.**[img]http://i.imgur.com/PtuGLnX.png?1[/img]**.I tried searching a lot but i think i need personal help in this area as this is a suppose to be dynamically updated Jframe.on the other hand i am open to suggestion to how to better display the database(considering the details IDE:eclipse luna for java ee,ms access 2010,my website is in .jsp file).thanks in advance.

Member Avatar
Member Avatar
+0 forum 6

I have written a program using Visual Basic within Visual Studio 2008 which occasionally needs to load data from two MS Access database files into datatables for selection purposes. This all works perfectly on the built 'release' version but when I publish to Public_HTML via CPanel to my website and then try to run from the website there is no link to MS Access data. The actual program runs perfectly and does all that is required except for loading data from MS Access files into selection table when required. I know my terminology may be a bit amatuerish but I'm …

Member Avatar
Member Avatar
+0 forum 2

** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'companyna' nvarchar(150) begin select Company_Name from companynames where ' at line 2 this is my MS SQL Stored Procedure create proc spgetcompanynames @companyna nvarchar(150) as begin select Company_Name from companynames where Company_Name Like @companyna + '%' end this is my MYSQL …

Member Avatar
Member Avatar
+0 forum 1

hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date date/time INV_date date/time row_upd_date date/time courier_name text inward_type text user_id long(contains 0 as value for all entries) DC_NO text closed_status boolean(true for some agn only) to_dept text agn long table2 name: item_master Column Name DataType user_id long(contains 0 as value for all entries) row_upd_date date/time deleted_status boolean(contains false value for …

Member Avatar
Member Avatar
+0 forum 3

Hello, I want an idea for my Masters in Computer Science and communication thesis. I am confused between to categories, networking or web/android development. Please help me and tell me what is the appropriate idea. Thank you very much.

Member Avatar
Member Avatar
+0 forum 3

I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in cells not word wrapped. In other words the cells formatting as far as word wrap goes does not go with it, or Excel doesn't recognize that it needs to be wrapped. I'm not sure if this is a real problem or a normal function of Excel. I have to highlight …

Member Avatar
+0 forum 0

Hello, My sincere apology, I have been posting almost 4 questions now where I have received 2 answers being solved. These are simple questions which any one familar with VB.Net can solve easily. Please understand, I'm a newbie to VB.Net. Now my next issue is; I have a a form which has text boxes from where the user has to enter the data for the MS Access backend. I am getting the error as INSERT SYNTAX Error when entering the data and clicking the Save button. What is wrong with my insert statemnet below which is at the click even …

Member Avatar
Member Avatar
+0 forum 4

Hi All, M trying to design a web portal which shows all my trackers and allows me to open it . the trackers are in ms Excel format. Please suggest me d best possible way to achieve the goal. Thanks Mukul

Member Avatar
Member Avatar
+0 forum 1

Hi all, Im working on a page that sends information to a mssql database. Its a basic registration page with a UserID, Password, First Name, Middle Name, Last Name, and Email box. When Sign up is clicked, all the information in the textboxes should be sent to the Users table in the MSSQL Database. The Problem I am facing is that the data is not appearing in the tables after the sign up button is clicked. Why is it not working? Thanks in Advance! Sign Up Page Code: using System; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Collections.Generic; using System.Linq; …

Member Avatar
Member Avatar
+0 forum 6

studentrecords table.,.,contains IDNumber,LastName,Course,Firstname i will login through my system using IDNumber and once i go to the mainform iwant to display LASTname and course to the 2 textboxes in the mainform using the IDNumber as their Primary Key.,.My code errors Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim da As New OleDbDataAdapter Dim dt As New DataTable Dim sSQL As String = String.Empty 'try catch block is used to catch the error 'get connection string declared in the Module1.vb and assing it to conn variable con = New OleDbConnection(Get_Constring) con.Open() cmd.Connection = con cmd.CommandType = CommandType.Text sSQL …

Member Avatar
Member Avatar
+0 forum 1

HERE I WANTED TO FILL MY BLANK RECORD WITH ITS VALID DATA private void button5_Click(object sender, EventArgs e)//modify { comm.Connection = conn; comm.CommandText = " UPDATE Table1 SET total='" + textBox6.Text + "',result='" + label7.Text + "' WHERE Fname ='" + textBox1.Text + "'"; conn.Open(); comm.ExecuteNonQuery(); conn.Close(); dataGridView1.Update(); } I WISH FOR A SIMPLE SINGLE LINE CODE..

Member Avatar
Member Avatar
+0 forum 3

good pm.,.,i have a next button Try lblcat.Text = ds.Tables("evaluation").Rows(cat)("QuestionCategory") txt1.Text = ds.Tables("evaluation").Rows(CurrentRow)("Question") txt2.Text = ds.Tables("evaluation").Rows(CurrentRow + 1)("Question") txt3.Text = ds.Tables("evaluation").Rows(CurrentRow + 2)("Question") txt4.Text = ds.Tables("evaluation").Rows(CurrentRow + 3)("Question") txt5.Text = ds.Tables("evaluation").Rows(CurrentRow + 4)("Question") Catch ex As Exception End Try every click to the next button my category and questions change.,., every click i want also to save in my database Private Sub Save_commit() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Try 'get connection string declared in the Module1.vb and assing it to conn variable con = New OleDbConnection(Get_Constring) con.Open() cmd.Connection = …

Member Avatar
Member Avatar
+0 forum 1

Private Sub Load_Faculty() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim dr As OleDbDataReader Dim arrImage() As Byte Dim myMS As New IO.MemoryStream Dim sSQL As String = String.Empty Try sSQL = "SELECT b.FacultyFirstName, b.Image, b.Course, a.Course" sSQL = sSQL & " FROM studentsrecords as a left join facultynew as b " sSQL = sSQL & " on a.ID = b.FacultyFirstName WHERE(a.Course = @Course) order by a.Course" con = New OleDbConnection(Get_Constring) con.Open() cmd.Connection = con cmd.CommandType = CommandType.Text cmd.CommandText = sSQL ' cmd.Parameters.Add("@EvaluationID", OleDbType.DBDate).Value dr = cmd.ExecuteReader If dr.HasRows Then While dr.Read If Not IsDBNull(dr("Image")) Then myMS …

Member Avatar
+0 forum 0

Private Sub Save_Record() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else arrImage = Nothing End If 'get connection string declared in the Module1.vb and assing it to conn variable con = New OleDbConnection(Get_Constring) con.Open() cmd.Connection = con cmd.CommandType = CommandType.Text 'I just use the textbox tag property to idetify if the data is new or existing. If Me.txtFacultyFirstName.Tag = 0 Then …

Member Avatar
Member Avatar
+0 forum 10

Friends I have completed my engineering in India and now working as a software developer. I am now planning to undergo my higher studies abroad. But I am really got confused on the universities there and every one I asked told different universities as the best one. I want a place to learn well, as well as, get placed by the campus drive there itself. Please help me to find a good one. PS:I am a newbie when it comes to abroad...

Member Avatar
Member Avatar
+0 forum 17

I receive an error message when i install an Office Software or open an Office program or document.

Member Avatar
Member Avatar
+0 forum 1

i am working on a project and theres a feature that i seemingly want to include, it is the attachment of a word file in an email and the values that are included in the letter are imported from the database using vb.net is there a way to import values from vb to word or vice-versa? every answer will be of great help! :)

Member Avatar
Member Avatar
+0 forum 3

Hello, How do I return the value of a custom property in Word 2007 using VBA? Depending on the custom property, I also need to automatically check a checkbox using VBA. Thanks!

Member Avatar
Member Avatar
+0 forum 2

Please help me im new in making database i dont know what tables will i create and its content pls.. 1. Develop a database design for a Student Attendance Management System. Create an ER Diagram to illustrate the relationship between the entities in your database. Below are the suggested list of entities to be included in the database: • Students • Subjects • Courses • Rooms • Schedules(includes subject, room assignment , time-frame, days etc) • Class list (refers to the list of students under one schedule) • Attendance Record (list of attendances per class list) 2. Create the database …

Member Avatar
Member Avatar
+0 forum 5

Hello I'm having Trouble here in my ms chart. ![6c6bbe39010ff302ee66367ce9439bba](/attachments/large/4/6c6bbe39010ff302ee66367ce9439bba.jpg "6c6bbe39010ff302ee66367ce9439bba") as you can see the chart in the right side the secondary axis i want it to be fixed in the line of the primary axis in the left side Public Sub Chart_BU_GP_vs_Target() With Chart_EBU_GP_vs_Target .Series.Clear() .Legends.Clear() .ChartAreas("ChartArea1").AxisX.MinorTickMark.Enabled = True .ChartAreas("ChartArea1").AxisX.Interval = 1 .ChartAreas("ChartArea1").AxisX.IsLabelAutoFit = True .ChartAreas("ChartArea1").AxisX.LabelAutoFitStyle = DataVisualization.Charting.LabelAutoFitStyles.LabelsAngleStep30 .Series.Add("Gross Profit") .Series("Gross Profit").ChartType = DataVisualization.Charting.SeriesChartType.Column .Series("Gross Profit").Points.AddXY("January", Me.BU_JanGP.Text) .Series("Gross Profit").Points.AddXY("February", Me.BU_FebGP.Text) .Series("Gross Profit").Points.AddXY("March", Me.BU_MarGP.Text) .Series("Gross Profit").Points.AddXY("April", Me.BU_AprGP.Text) .Series("Gross Profit").Points.AddXY("May", Me.BU_MayGP.Text) .Series("Gross Profit").Points.AddXY("June", Me.BU_JunGP.Text) .Series("Gross Profit").Points.AddXY("July", Me.BU_JulGP.Text) .Series("Gross Profit").Points.AddXY("August", Me.BU_AugGP.Text) .Series("Gross Profit").Points.AddXY("September", Me.BU_SepGP.Text) .Series("Gross Profit").Points.AddXY("October", Me.BU_OctGP.Text) .Series("Gross Profit").Points.AddXY("November", Me.BU_NovGP.Text) .Series("Gross …

Member Avatar
Member Avatar
+0 forum 6

Hi, I have a problem with a code harness given to me by my tutor. Every time i enter values into a form, I get the following message: > Warning: mssql_query(): message: Invalid column name 'N56DSRT'. (severity 16) in /web/users/l1099341/SDD/insertCarController.php on line 27 Warning: mssql_query(): General SQL Server error: Check messages from the SQL Server (severity 16) in /web/users/l1099341/SDD/insertCarController.php on line 27 We have to try and insert a car into our database using a form and I get this error message for every field on the form. The code is: <!-- insertCarForm.php gcapper 2013 form for getting new car …

Member Avatar
Member Avatar
+0 forum 1

I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions. In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which contains the word "Impact" without deleting the cell itself.

Member Avatar
Member Avatar
+0 forum 1

I want to delete the contents from cell if the content of that cell are similar to the content of the previous cell of last column. i.e If the 10th cell of column 'A' & 10th cell of column 'B' have the identical content then I need to clear that content from column 'B',without deleting the cell itself (i.e content of the cell only not the cell itself).

Member Avatar
Member Avatar
+0 forum 5

The End.