[microsoft:access] Forum Topics

Hey :D , take a look [url]http://www.dalilack.com/marketList.php[/url] click edit on the orange button EX : [url]http://www.dalilack.com/marketFormUpdate.php?Id=11[/url] the id of that user is 11, you can use 'hoho33' as a user name & 'shityshit' as a pass now you notice there's info for each member , and in order when that …

I'm want to join 2 table from access database and Microsoft SQL Server 2008 In microsoft visual studio 2008. Display join data in datagridview.

I want compare 2 datagridview table for calculation purpose. This is because this 2 table is come from different database. 1 is access and 1 is sql server. therefore I cannot join table.So I have 3 datagridview table to display data. I'm want datagridview3 ItemPerPack Column * datagridview1 Qty when …

Hello all, I have created the setup/installer for my application using the PDwizard. The installation is working all good (as its expected). For uninstallation, I have used a custom program (created by me) instead of directly calling the st6unst.exe. This program is called from both programs shortcut menu as well …

So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would …

I retrieved data from access in vb10 between two dates and here is the code for dat: [CODE]Imports System.Data.OleDb Public Class Form4 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try con = New …

Hi, My Access database has one column named 'Term' and the Table name is 'ATG'. I require to populate my listbox with data in the 'Term' columns. I'm unable to do that using this code. Can anyone tell me what's wrong with this (it displays numbers from 1 to 10 …

Hi I've written this code (that works) to inserts registration details into an Access 2010 DB from an aspx registration page. How do I check for duplicates Email before inserting a new record into the DB Dim strConn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\InetPub\WWWRoot\BushHouseGibraltar\Bush.accdb;Persist Security Info=False;" Dim MySQL As String = …

Hi, Am getting the below error at the time of running form to save data. Am checking step by step, at that time i found the error occured in the open connection line [Con.Open()]. Am Using MS Access 2007 for Database, format is (Dashboard.accdb). Kindly give any solution to solve …

I have a login form coded as : [CODE] Imports System.Data.OleDb Public Class Form2 Dim ctr As Integer Private Sub Ok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:/Users/Space Era/Documents/User.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = …

Hello, Hi, can you help me please I have problem in my program,I used MsAccess as my database... how can i make my textbox just like in google that when you type a certain word it will have drop down list... ex...the user will type this word "how to make" …

hello everybody, i am using java as front end and ms access as back-end for my mini project, in my database, in couple of the tables there is field which i've declared [COLOR="red"]primary key[/COLOR] for those respective tables and which has type of [COLOR="Red"]autonumber[/COLOR]. so my question is, while inserting …

"Good Day.. Its my very first database project and I am really excited about it, trying to make for myself… I am an insurance manager and also learning access through free resources like training videos on youtube etc.. kindly help me on my problem Two Tables, tblContributionRegister & tblAgentDetails. tblContributionRegister …

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, I will be developing a program using visual studio 2008 with ms access 2007 as my database. What I only use is this type of connection string: [COLOR="Red"]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;" [/COLOR]but i was asked if it is possible to put the database in sharepoint and I haven't even …

Hi! I am having problems with my login form. So I created a database for my login form so that i can create multiple user. That works fine but when I try to log in the user created an error shows: Error: [CODE] java.sql.SQLException: No row count was produced at …

Hello to everyone! I am an engineering student and we have this class wherein we use Microsoft Access. Our instructor gave as a hands on homework using the MS Access. As I do it at home and inputing numbers and etc all that I need to input, suddenly this [COLOR="Red"][B]ERROR[/B][/COLOR] …

Hi, I have a table with 2 date fields startdate and enddate. A program have a start date and an end date like this 01/01/2011-25/03/2011 . Now I want to test any date and get the program it belongs to. Say for the above, 12/01/2011 would return the above program. …

Anyone can help my problem? I ask a favor on how to network vb.net with ado.net in access database. Thanks.

I'm still new to Microsoft Access so I don't have a great understanding of its workings but have spent the past couple of months working on a project to manage the company's telphone bills. I'm essentially compiling the usage from every company phone each month into a final table by …

Hello! I was looking for some help with something I'm trying to accomplish with MS Access. I have data set up in the following manner: [CODE] CUSTNBR|TRANSYTD| RPTDATE --------------------------- 1 | 7 | 5/28/2010 1 | 10 |12/31/2010 1 | 2 | 4/29/2011 2 | 8 |12/31/2010 2 | 6 …

I have a report based on a query that uses parameters (Date datatype). In the report header I have some other data that is also generated using the parameters (Same parameters). This data is generated programatically and I use a dialog box with date in it. Now, I want to …

I have been assigned a project to develop a software on autocad and MS access for the boiler maintenance dept. of my company which is a thermal power plant. A failure in the boiler is to be reported along with the 3-D image of the point of failure and the …

Hi, I've created a MS Access (2007) database storing details of a charities clients. Is there a validation rule/piece of code for the following: FIELDS: Date, Time, Duration, Room CODE FOR: Not being able to select a room if it is on the same date and time/duration? I'd really appreciate …

Hi i am trying to write dataset into excel using oledb connection. I get an error "The microsoft access database engine could not find the object 'testTable' Make sure that name and path is correct". I understand that dataset is not in the excel thats y i get an error …

static void Main(string[] args) { string[,] fp = readFilePaths(); OleDbConnection con = new OleDbConnection(); OleDbDataAdapter da; DataSet ds = new DataSet(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/kyalanur/Desktop/Nav tool/PCGDataManager.mdb;User ID=;Password=;"; string sq = "SELECT * FROM History"; con.Open(); da = new OleDbDataAdapter(sq, con); da.Fill(ds, "History"); for (int i = 0; i …

I am currently using microsoft access 2007 and vb.net 2008. The problem senario is this: I have a database-table that contains two columns, items, and the price of each item. I tried to drag this table to the form as a checkbox tool, but only one checkbox1 was diplayed. The …

I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …

I have two tables, Episodes and Seizures, with their respective Forms. On Episodes, I have a button the user clicks to open the seizure Form and its internal working is below. The problem is when the form is opened and filtered by parent form, the seizure form instead of filtering …

okay so i figured everything out for my project except how to get this simple select statement to work. i have a table named [B]Car[/B] that i LINQ'd from a Microsoft Access File. please help. i want a button to display the Car database according to the SQL statement. thank …

I am creating a database in MS Access 2010, I have 6 tables. My question do all 6 tables need to have either a direct relationship (primary key to primary key) or Primary Key to Foreign Key with each other?

i don't know if it possible or not if i want to like this : Actually, i have one form "Product" In Form, i have two comboboxs , first name cboProduct that have Row Source "CPU;RAM" and second name cboSeries. what i want to do is when i choose a …

Hello can you help me please... can you help me how can i retrieve the data from my database ms access i want to display this in the table...is it possible to use the JTable or not?...please help me thank you in avdvance and i am hoping for your positive …

Hi, I'm supposed to create a little program that will allow you to select a range of dates and graph prices based on those dates. The data would come from an Access table. I know Excel allows you to pull in data from Access, but I'm not sure how to …

Studying for Security+ and can't find a straight answer. Thanks in advance :)

I am gettig "could not find installable isam" while connecting to access 2007 databse the code that i wrote is: Public Sub MyConnection() constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Contact_management\Contact_DB.accdb;Jet oledb:database password=abcd" con = New OleDbConnection(constr) If con.State = ConnectionState.Open Then con.Close() End If con.Open() End Sub i installed office 2007 via network. …

Code for connecting to Microsoft Access databse, opening and closing connection

Hi I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this... [CODE] switch (x) case 0: switch(y) case …

[ATTACH]20944[/ATTACH] pressing save button i want to store/save all input data in one storage. attached file is the sample form i made thanks

hi, I wants to do register function in window form application microsoft visual studio 2008 and insert the data into microsoft Access 2007 table by using C#. Below is my codes: [CODE] SQLStr = "INSERT INTO RegisterEmployee(EmployeeName,Password,Gender,ContactNumber)" + "VALUES ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" …

I have a table for Account Transaction. For each transaction a user must select a transaction category. These are stored in a second table which has a categoryID, description and a text box with only two values {'Income', 'Expense'}. Now in the report, I am grouping by Income/Expense. However, I …

I was hoping someone could offer me some help please I am new to using asp.net .I want to create a web form with two comboboxes ,one text box and a button .I have multiple tables in ms access database with same structure , col1 and col2 . I want …

Hi I was hoping someone could offer me some help please I have a form with two comboboxes ,one text box and a button .I have multiple tables in ms access database with same structure , col1 and col2 . I want to insert text box value into column1 in …

I'm making an application associated with MS access for its database... I set one of the field to text and the other to object for images..but the object suggest to insert pictures through paint.. [COLOR="Red"]Is it possible for animated images(gif) in ms access? I'm getting stuck with bmps... [/COLOR] -------------------------------------------------------------------------------- …

I am trying to read a long integer value from an Access database, do some math to the number, and save the result back to the database. I've never had a problem doing this with VB6, but with C# it is throwing an error when it tries to Update the …

hi, now I wants to insert some records into table in Microsoft Access and C#, below is my codes : [CODE] SQLStr = "Insert Into RegisterEmployee(EmployeeName,Password,Gender,ContactNumber,Position) " + "Values ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" + SQLStrCmd.ReplaceStr(genReg.Text) + "', '" + SQLStrCmd.ReplaceStr(Hptxt.Text) + "', '" …

Hi guys, I'm kinda new in VB.net. Do you guys know anything tutorials on how to database MSACCESS? I'd like it very very simple. but I want it to be [B][U]pure in Code[/U][/B] not like some Setup or something. a sample downloadable project will do! thanks! :D

Hello Sir, i want to deduct some amount(i.e user input) from main loan taken by employee and remaining amount again come as balance loan amount and on nxt month again the some amount should deduct from balance loan amount. my database is in ms-access and i use vb.net.. plz help......

Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things …

Hi, i am currently doing a system for the rental video. I am new to java coding.. Problem is how to add data to access database using java coding in method? Thank you.