3,459 Topics
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 …
getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) …
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 …
Hi all, I would like to export data from an Access DB, can this be achieved through a command? I plan to automate this export.
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 …
Hello everyone please your help with the correct syntax of this code i´ve just build it but the visual studio has closed the session and i lost all my work the code as you can see search between two dates that part its ok, and then search in another field …
Good time of day all. Today I saw this error "The database has been placed in an unexpected state; Microsoft Access can't open it." I was working with it I mean with this particular file not long ago, then my PC was shut down due to power surge. And now …
[B]Question TWO[/B] I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. …
1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into …
Dear... I'm doing INVENTORY PROJECT... I'm using ACCESS as BACK-END... My tables are PURCHASE and SALES... In PURCHASE table, fields are CODE(primary key), PRICE, DATE, TOTAL, QTY... when I'm entering datas in form and when i click submit, the datas stored... but when i enter same DATA(CODE), it is showing …
i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit
i have 2 combobox 1 is that to check if the status of the room is available or occupied. i want to show my records into my combobox of what is the room type that is available. for example: cmbroom has two item the "delux" and the "ordinary" in my …
Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With …
I am making an application that will automatically fetch information from database and display it on a textbox based on date. So for example i want to fetch a latest article on feb 25,2016. How do i do that? i need help cus im kinda new to c# Any help …
how to edit ms access right click menu? How can I add more items and modify this menu?
OleDbConnection cn = new OleDbConnection(); cn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\`Hp\Desktop\PROGRAM1\notificationSystem\notificationSystem\Database.accdb"; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = cn; //reg(); cn.Open(); cmd.CommandText = "select article from news where npublished = '" + metroDateTime1.Text + "' AND ntime = '" + label4.Text + "'"; //AND ntime = '" + label4.Text + "' //Scalar …
Hello again Please your support with the next statement in vb.net and access database this is part of the code can you help me the error code is missing operator in query expression str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\MXDTBTZ3XC1\Users\MXDTBTZ3XC1\Desktop\refacciones web\surtido.accdb" con = New OleDbConnection(str) sql = "select * from material where IDDOS …
good day is there a way in storing image and retrieving images using ms access and display in picture box randomly or just like a slideshow?which slides form left to right?or vice versa..i have some codes here but i does not display...hope you could help me and correct me..thanks more …
Hello. My VB.Net project is connected with MS Access. Whenever input in VB, it will save in Access. I don't have any problem with textbox but I don't know what to do with checkbox and radiobutton. I want, when checkbox or radiobutton is checked in VB, it will checked also …
Hi all. Can anybody help me? Yesterday I work with my access file with necessary data for my work and today I can’t open it. The version of Microsoft Office is 2003. Windows 7. Thank you!
Hi thanks for the help I am new to this so sorry if I’m slow. I am trying to make an Access Database I have a quarry that pulls data into a combo box and then auto fills the below text boxes. I want the user will then fill out …
Hello Friends I am facing a little problem that I want to sort my records according to date I mean to say I want to show the upcoming records based on dates on the top in ascending order I have a complete working code to fetch from the database but …
Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here …
I am facing a problem that I have to show database results from 3 different tables on a single report these three tables have are used for different purposes and want to show their headings details separately. I am using VB6 and designing this report in **DataReport** a common feature …
Hello! There is another problem which I am facing in JDBC, is Insert statement. I am giving code of my program and explaining my problem . I am using ms access and netbeans 8.1 package database2; import java.sql.*; public class Database2 { public static void main(String[] args) { try { …
I am making a multiple choice quiz in vb with the questions and answers stored in an access database. When trying to display the question and answers on my labels, they don't change. Here is my code: Imports System.Data.OleDb Public Class Football_Questions Dim con As New OleDbConnection Private Sub Football_Questions_Load(sender …
I knew how to use combo box to read the database in Microsoft access, let say I have 7 option and I can make it into conbo box. But now I want the 7 option in the form of button (means got 7 button). Can anyone help ?? While (acsdr.Read()) …
I m new to the MS Access, I m prone to the SQL Server Only. Can u plz explain the difference b/w[B][COLOR="Red"] Datasheet View & Design View[/COLOR][/B]. I have some idea,pls check it whether me right pr wrong. In design view,we have to specify by own datatypes & column names. …
WAMP 2.5 server on my windows 10 machine was working completely fine, until I accidentally installed a software which silently installed Win MySQLAdmin on the same machine. That day since, Wamp server icon remains in orange color (never turns green). **Issues:** 1. localhot/ phpmyadmin displays 'access denied' error. following is …
Hello, I am facing a very little problem but I am totally confused how to resolve it I have two tables in my access database which have similar items in it from the first table i.e **tbl_reci_inds** I have selected **reci_prod_code** which is a product code, also in this table …
Hello every one. i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add …
When I was editing the databse, the power went off and now arror comes as "Unrecognized file format ...............". I tried to compact and repair but no success. how to recover data?
I have 3 table which are  I want to duplicate a record from the master table in the same time it will duplicate all children table. I will assign new primary key to the new duplicate record. For the tbl_System and tbl_MainComp work fine. But when i have …
Hi There, Could you guys please help me out with the below query. I have a table called **WI Inventory** & out of the same table i have created **combo box** from one of the field named as**Associate Corp ID** & a **button** which after selecting the value from combo …
how to search a data in particular fields(ms access database) in vb6.0 using data1 control. I create a project in vb 6.0 using ms access data base and data control. I want to find a particular name from the data base table field. My code is.... If Data1.Recordset.Fields("C_Number") = Text15.Text …
I'm updating my database using this code. only id and attendance date is updated but the time(AM_TIME_IN etc...) is not updating. What could be wrong? I'm using access and time(AM_TIME_IN etc...) datatype is shorttext Dim a As String = Now.ToShortTimeString If a.Contains("AM") Then a = "AM" Else a = "PM" …
Dear all, I have created project database in msaccessdatabase. It contail  form layout as shown in image & i have attached code for reference Imports System Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the …
I dont fully understand this issue at all, it makes no sense to me for several reasons but ill liust the main ones i have code elsewhere that works just fine and is identical in function and setup i dont think the issue is a registry key issue, this i …
Hi, so i have a bit of an issue trying to select all my ms-access data in DGV with only a button, no typing in textboxes. I have been struggling with for a few days since unfortunately this isn't very popular? I can't seem to come up with anything in …
hello there im doing a project and need help.. how to show auto-id from ms access table 2000 into vb 6 textbox?
Hi guys, I am trying to save the items in a listview to Access database. The listview has two columns; "Description and Price". For example, If a user adds three Items (products) in a listview and clicks a command button, I want these items to be saved in a database …
Dear all, I have created database like this. I have 2 manufacture . I would like to create 2 combobox. COmbox 1 -> Manufacture list combox 2 contain -> model no Can some one share example code where it explained. if particular manufacture selected display only his model in combobox …
Hello: this is my first window app in .net and have been assigned to create a form that contains a datagridview. I decided to leave it unbound, because I need it to populate in a slightly unconventional way. I also created each column and set them as drop-downs in the …
No ERRORS query is executed perfectly but no data stored what could be wrong? my database is employee with id, first_name, middle_name, last_name fields id is auto number the rest is short text I'm using ms access. Imports System.Data.OleDb Public Class AccountReg Dim dbProvider As String Dim dbSource As String …
Hi, I am newbie.I have seen projects where there are menus or links below it which are accessible as per the profile set for the logged in users.If there are A,B,C,D menus in project then some group of user will have only A and B Menu when logged in..while other …
Im making a simple login form for my project and I faced this annoying database connection problem. The problem is I can't connect to "MSACCESS2013" it directs me to my errorhandler but I'm pretty sure my datasource is correct. I already created a datasource and I'm using its connection string. …
Hello everyone, I've a little problem with updating my Access DB. I use this code to update my db in vb.net. Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click Try oledbCmdBuilder = New OleDbCommandBuilder(adapter) changes = ds.GetChanges() If changes IsNot Nothing Then adapter.Update(ds.Tables(0)) End If ds.AcceptChanges() …
Hi Friends. I am facing Microsoft ODBC Driver error at run time in my program. I am using window 7, jdk 7 and Ms Access 2007. I am using "jdbc:odbc:JdbcOdbcDriver". I am giving code and error message below. Please tell me solution of this problem import java.sql.*; public class JdbcDMLEx2 …
Good day! I have the following sub-query that generates payroll report by a given date with format **(dd/MM/yyyy)** but I do not know why MSAccess **automatically changed it to (MM/dd/yyyy)** thus I am getting incorrect data. My regional date settings in **control panel is set to (dd/MM/yyyy)** format as well …
I have an Access 2007 file that I was working on at my office. I left for the day and the database was still open. When I came back the next day the system had shut off so I rebooted (no issues). I tried to open the database and am …
The End.