[ms-access] Forum Topics

Hi Dw. What is the correct way to write an sql query like this? `"select * from MyTable where username ='username' And password ='Password'"` in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. …

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 …

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 …

Hi.. I have a gridview in form 1 and i am inserting records from form 2. How to refresh gridview in form 1. And filter gridview in form 1 based on comboboxPlease help..

How can I insert splitted texts to my ms access database? I can't seem to find the logic in it. :( Please help me. Here are my codes: This is where i split the texts that are inputted in textBox1, textBox2, and textBox3 string items = textBox2.Text; string[] splittedText1 = …

I've got this error: **Additional information: Data type mismatch in criteria expression.** I don't know why.. I want to use split text in a textbox and insert the splitted texts to ms access. Here is my code: string[] splittedText1 = textBox2.Text.Split(' '); string[] splittedText2 = textBox1.Text.Split(' '); string[] splittedText3 = …

hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship …

hi my name is vishal. i have been trying long to figure out to export data from vb6 using join queries in sql to ms word. here is my sample code i have tried: Option Explicit Dim dIsVisible As Boolean Dim inst As String Private Declare Function ShellExecute Lib "shell32.dll" …

I have just a user form in access 2007 with a text box and a Save command. MY code: Private Sub Save_Click() If School.Value = "" Then MsgBox ("Text Box is empty") else Msgbox(" Not Empty") End If End Sub When the Save is clicked, and the text box is …

Private Sub Save_Record() 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 Try If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else arrImage = Nothing End …

Hey guys Im doing some testing on a few database conversions from MDB format to accdb. I packged up my files so when the exe was ran it would install MS runtime as well as the databases needed for the app. I was trying to get it so that I …

hi i m making a c# app which reads data from ms accesss & display it in textbox i have tried the following method but that didn't worked suggest me smthing or correct my code pls myconn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nature bliss\Desktop\Stock\section1.accdb;Persist Security Info=False"); try { OleDbCommand cmd = new …

I'm trying to search on how to store the image in a local folder and save its path and filename in ms access using vb.net but a lot of topic makes it more confusing for me. I'm just a student and working on my baby thesis. I'm currently building an …

I have written a program which allows agents of a call centre the ability to access a database (ms access) containing names of solicitors to allocate to. the database is stored centrally and i need a way to update the local dataset on the agents machine when a change is …

i have a datagridview in my vb.net form displaying data from ms access file A , table A , is it possible for me to export the data in the data gridview to ms access file A table B?? i'm not using sql.

hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and …

Don't know if this is right place for my question, but Does anyone know if it is possible to have multiple forms visible at the same time while developing an application with Access in "Form View" mode? If so, how does one tell Access to do this? This applies to …

Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo …

Can anyone provide a quick solution for INSERT the entire excel sheet into a access database. This is a click button event that just opens a excel sheet in a windows form. What I like to see is some example how to INSERT the same excel data into a access …