[microsoft:access] Forum Topics

Ok so a few weeks ago i started getting messages from my virus scanner saying that there is a suspected virus on my computer, so i scanned and nothing showed up, so i ignored it, and every time i would log on i would get the message again, but i …

Hey frens, I am entirely new to asp .net and when I was asked to create a web form and send the form data to a database created using Microsoft Access, I had no clue as to how I should do this. I have created a form in my web …

Hi, i'm using ms access and i have a table and a form which have the field code_url. I would like to know how can i create a form with a button that i could use to cut string in the field name code_url for example: <a href="yahoo.com?234234234sdef">Episode 1</a><br><embed src="videos/vplayer.swf …

Hi folks, I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price ([Reserve]) and minimum successful bid so far ([Min]). There is then a text box for the user to input their bid ([Bid]). I have set up a …

I am doing a project on asp.net.but problem is that i cannot connect database(ms access)from page.how can i get this connection?can any one send me source code to solve this problem?or give any better solution as soon as possible please..

Hi all, After I open a connection between an Access database and my project I try to drag the database node onto the Windows Form but it always fail I am not able to create an OleDbConnection to the data source. How this problem can be solved? regards Khaled

I'm new to JSP and trying to do a parameterized query. I've been able to do single stream queries to existing tables without any problem. I'm trying to build a search mechanism to do selective reporting. I've tried many hours to get the combination of different items to get by …

preventing existing records in a table from being added in an ACCESS Database

Hello Friends, I am learning VB.Net (Visual Studios 2005) and using MS Access as backend database. pls someone tell me how to connect VB.net to MS Access.

Hi all... great forum! I'm basically on a crash self-learning course in Coldfusion and database-driven sites, so I'm pretty sure I'm missing some basic concept that would make this an easy query. If anyone could point me in the right direction I'd really appreciate it. This is for a site …

I'm a novice to Access and am learning using Access 2007. I've created my tables and established their relationships. I've created the forms using the wizard. I'm attempting to display summary data on a form but am not having any success. I have a SKU table and form. I have …

Hello all! I hope everyone is blessed and wonderful! I am in a quandry :?: , I have a form that I need certain people (3) to have full rights to edit/update/enter the data and then I have everyone else (approx 40) to be able to view only the information …

Hi I have a small program that imports data from a txt file and then splits it into columns in a dataset. What i want to do now is export that dataset to an access table so that i can start running reports form the data. Is there an easy …

I get this error message when trying to open my 2002 access database using MS visial Studio 2005 "System.IO.FileNotFoundException was unhandled" using the code below Imports System.Data.OleDb Imports System.Console Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Source=C:\temp\MIRC\CCC_DATA.mdb;Persist Security Info=False") cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\MIRC\CCC_DATA.mdb;") cn.Open()

I was woundering if it was possible to do validation on a dtat a grid and how to do it. I know how to generate info and delte it, but not how to validate it. I'm taking a access table and generating the dtat grid from that. I want my …

Hi All I am trying to use VB to access a query in a MS Access Database and pass in a variable to run this query storing the query results in a recordset in VB. I am not very sure this is possible. In other words I am using vb …

hello to everyone i have a program that can update the data that you've edited in the gridview design the problem is whenever i have 3 records in my database and i edited one of them in the grid view all of them gets updated.. can anyone help me with …

hi i have textbox and i want to insert this text into access db but the field in db is number so i tried both functions val and cint to convert text to integer while iam inserting at the same time but i got error : Input string was not …

Hi, if I connected access data base to vb form and I want to insert value of dropdown list(Items are yes and no) into the data base (field is type of Yes/No) what will be the insert statement?!

pls help me.. i have a program that have a database in ms access.. i haved already connect itto my ms access database but i cant save my data in my database everytime i click on my save button.. pls help me to know what codew will i write to …

pls help me i am using vs2005 i am creating a program and connected in a ms access database, the problem is i dont know how to save my data in my database whenever i click the save button because i dont know what code will i write.. for example …

Still in a VERY steep learning curve with MS Access 2000 / 2003 Main Table has LastName - HomePhome - MobilePhone plus others of course Some rows will have no entry in the HomePhone field but will have one in the MobilePhone field. I am trying to set Query criteria …

I am working on my senior project and I am using C#.net and Microsoft Access to create a program that lets the user store information into a database. I have many tables but the primary table that mostly everything connects to is the customers table. Well I know how to …

I work here at UPS in the HR department and they use a Microsoft Access mdb database that connects to oracle servers to retrieve tables. It then creates a local copy of the tables and the queries run off that. The tables are updated every morning at 6am by a …

Hi, I am trying to update a MS access table from my combobox selected item. Here is what I wrote: [code] String^sqlQuery= "UPDATE Profiles SET "+"Wallpaper='"+ comboBox1->SelectedItem->ToString()+"',Ringtone='"+comboBox2->SelectedItem->ToString()+"'"+"WHERE Profile_Name=MotoX"; this->oleDbDataAdapter1->SelectCommand->CommandText=sqlQuery; this->oleDbConnection1->Open(); this->oleDbDataAdapter1->UpdateCommand->Connection=oleDbConnection1; this->oleDbDataAdapter1->UpdateCommand->ExecuteNonQuery(); this->oleDbConnection1->Close(); [/code] However, I keep getting error of "Parameter ?_1 has no default value" I searched through many …

My name is Lincoln. Kenyan and in Nairobi. I like watching movies, lengthy ones, with seasons, playing piano and re-installing programs. Have grown passion of developing softwares and have started working on simple programs using VB 6.0 and Ms Access Databases. Am certain of receiving and getting all the assistance …

I want to insert values of check box list into access data base field (I want all values in ONE field!!!! of course seperate raws) the problem is when i run the inserting statement i got just the first value in the field I tried loops but it doesn't work …

i have tried alot alot of way to resolve the problem but none suceeded. this problem occurs after i try using 3 new hardware i bought listed down below. 1)USB CARD READER/WRITER. (no details of company and so on) 2)THUMBDRIVE MINI 2 GB (by TREK) 3)OPTICAL MOUSE model no: MX110A …

Hi all, When connecting to an Access database from a VB front end usig the ADO control is there any problem caused by the connection being permanently open or am I better to open and close the connection for each transaction. Will there be any difference for a mySQL database. …

i am trying to populate a datagridview from an ms access database with this code but it doesnt works. what is going wrong ? Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=unclp.mdb;") Dim cmd As OleDbCommand = New OleDbCommand("Select * FROM books", con) con.Open() Dim myDA As OleDbDataAdapter = New …

HI im new to the forum and new to access. I just recently took a position with alot of acces develpment involved. My first ques tion is how to pass a value from one form to the next. i want to keep track of what user edits certain records i've …

Im MarcusMaximus. I registered to see if i could get help in access development i never did it in college to the extent i need to do it in work and i am stuck on a lot of things as im now the only person in IT here and nobody …

I have a dbase created in MSACCESS, how can i retrieve a (field) record with stored pictures on it to Visual Basic Form

Hi! I am trying to use MS access to develope a database which can store "Multiple choice questions and options " as input. And out put shold be taken randomly from the database and it should prepare a word file. But I am a physics lecturer. I have a less …

Please help in sample database connetivity in MS Access for login application.

Hello guys, I am doing a project.I have used Microsoft access as my database.I have created register table with first name, last name, username and password. I have inserted username and password from register table to new table named as login table.After logging in with username and password i should …

I gotta make an EpoS system. Does this look right, as a first attempt?

Hi all, Please somebody tell me the code. I have : a textbox name txtfname a table named Customer (located in Database.mdb) the customer table has only 1 field fname. How do i create a connection such that whenever i click on add button, whatever is in the txtfname textbox …

HI all, I have on the form an ADO data control and an OLE object. ADO is connected to a MSAccess Database (With a table having an OLE field). The class of OLE field is "Word.Document.8". Now when I try to connect the datasource property of OLE object, it says …

Hi, Can anybody help? It's about summing up the elements of column called Gyujtemeny and then column Duplak of a table of an Access database and presenting the result using ASP code. So each column is sum up by its own not one with the other. [code=html]<%@ Language="VBScript" %> <% …

I am new to vb programming and I am trying to update a single row in a Microsoft access db. There was no error when I step through the codes but it never updates the record in the backend. Here's the codes: Any help is highly appreciated! Using objdata As …

please help that how to add data of one field of database to the combo box. i attached one rar file with this. check that

Hi Everyone -- new here. I develop websites, tinker with Access, and know a little about a lot. You know how that goes!

:confused: I am doing a project and i need to be able to add, record, search and delete customer bookings. I am using VB.Net 2003 and microsoft access 2003 and i need help on how to do this. Can anybody help me?? PLEASE?!?! Basically i need the information that is …

As the spyware itself ironically keeps reminding me, my computer has been infected with the classic "big red circle with a white X on the taskbar" virus/trojan/whatever program. My numerous attempts at killing it with tools such as Spybot and CCleaner have all failed, and I must now rely on …

hey Really strugling with Access today so i could do with some help :) I'm attempting to add items to a list box. The Sources are 2 text boxes which have been fed to from a querey. So first I tried... lstReorder.AddItem (ITEM_NUMBER.Text) lstReorder.AddItem (ITEM_DESCRIPTION_1.Text) Which brought up the error …

1) open the table in desihn view. 2)Select the filed u want to alter. 3)Select LOOKUP tab. 4)In display control box,Select Combobox 0r listbox. 5)Under Row Sorce TYpe,SElect Value list. I want to ask that if I select Combobox,Then in Row Source type we select Value List. I want to …

HI all, Durig my development of a software I require a OLE field in MS Acess table, which is supposed to have MS Word documents stored in it. Can anybody help me in telling how to display, edit, save and retrieve the OLE Field in MS Access from within VB …

frnds i have made an site and used microsoft access for the database of the various pages now i am not able to access the databace on another pc. this showed an error like this. // cannot access the database it might be openned exclusively or u dont have the …

Hi All I'm fetching lot of records from a central DB and i have to insert/ update these records in my local Access DB. Right now, i'm opening and closing 1 connection per record i insert/update in Access. I know this is wrong. In Java(which i'm more used to) i …