[microsoft:access] Forum Topics

I need a vb code as below This is my login page [ATTACH]16718[/ATTACH] This is my login page code Private Sub StudentLoginButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StudentLoginButton.Click Dim connection As New OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0;Data Source = ../Data/Student.accdb;") Dim command As New OleDbCommand("SELECT * FROM Student WHERE …

Hi everyone Could someone please help me, I need to loop through all the records in a column in my access database, Currently my program only views the first record in the column and does not go any further, I tried a While loop but I get a NullException error …

I am doing a Quiz Generator / Viewer project, which requries the use of a database for the numerous questions the teacher has to put in, as well as the user names, passwords, etc. I used Microsoft Access (2000, I think) because I found it easier to use. For the …

Hello everyone.. I desperately need your help to tell me how can i retrieve the data that i've stored in an access db column and display it in a combo box in a vb2008 project? thank u in advance..

Hi! I am having a problem with the project I am working on. The project will have more than one query; however, I cannot get the simple one to work yet. I have a form with two text boxes and a button. I also have an Access database that I …

Hello all, I am currently working on a project that requires an update within an Access Database. There are photo folders, and the user defines the path name via a dialog box. That path name is stored to a string value, and through OleDBReader, the actual name of the photo …

I dont know how to connect the ms access database to the website.can anyone help me out?

I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does …

Hello Everyone, I am trying to find a good way to get information from a website into a access 2007 database. Im thinking I should have the website write a text or xml file with the data on it and then have some program (or access itself if it can) …

Confusing question? The only way I can explain it best is to show it: [CODE] Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 [/CODE] [CODE] Query Getting Max Value --------------------------- Num1 Num2 Num3 322 46 929 …

Hi friends, Anyone know how to take backup of Access database through Coding in vb.net. Means when i click on button ,the folder should be automaticaly created and that folder contains Access database file with current entered records means updated database. Plz if u know plz help me all. Thanks …

hi... can u tell me how to send messages through gateway using C#. I am using ms access for storing the contacts..

I'm trying to create a Web Form Application for my class final. I downloaded the zipped file and extracted it of course. When I go to Data/Add New Data Source and follow the prompts in the Wizard I get to the screen that you choose your Database Objects, I get …

I'm a college professor with noe one to turn to forauthoritative help regarding the stuff I'm teaching .. when my examples for students (or projects for clients) don't behave as expected, it gets pretty lonely out here! I will appreciate having a circle of well informed, highly experienced folks to …

I am Working on Conecting to a database in windos forms C++. I use MVC++. here is a link to my DB file so people can see what i have tried to do in the DB. [URL="http://www.mediafire.com/?yfr52oqcknakk9g"]http://www.mediafire.com/?yfr52oqcknakk9g[/URL] you need access to see this. i have finaly figured out how to …

i am developing website which on asp.net n backend is microsoft access now i have the grid into it with show 3 colums my questions are if i want to add2 more colums which i want to 5 how do i do now i want to add records into grid …

Could you please answer these questions? 1. Name, job title and place of employment -- 2. Do you use Microsoft access, excel, power point or word? & how long have you been using it? -- 3. Did you have any formal training? Or did you teach yourself how to use …

I need some help in setting up a MS Access database and link it with VB.Net. The current situation is creating a form in VB and entering the codes from VB and the data will be stored in MS Access. -anton

Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I …

how do i store a .bmp image or a .jpg image in a table in MS Access database?

Hi, I am trying to read the subject line on all of my emails within: Personal Folders|Inbox\TEST I need to do this on the fly (using late binding) and once read delete the email. I am using VBA within MS Access and to say that I have got stuck is …

Hello everyone, I have a problem with access 2003 that keeps on rounding off the numbers that appears on the field. I have a table with different fields and this two field whis is numbers and double in properties still keeps on roundin to the nearest wqhole numbers. Is there …

Hello Everyone I have been looking on the net and I found a few things but I am a bit think :P. I need more of a walkthrough kind of things. I am currently making a programe for a game and I need to access a database that has information. …

I'm having trouble with adding multiple records to a table in access. The fields are number (data type) and I can't change them due to the relationships needed for a query used to calulate amounts. Here is the cade I have currently maybe someone could help me out with this …

Hi, I have a database linked to my VB.NET project using the data source wizard. I've created a log in form using a table in access that has the details required to log in. The code is: [CODE]Imports System.Data Public Class Form1 Dim conn As OleDb.OleDbConnection Dim strSQL As String …

i m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 …

hi, may i know how to migrate excel file into access db, using macro @ vb? thank you

i am developing website which on asp.net n backend is microsoft access now i have the grid into it with show 3 colums my questions are if i want to add2 more colums which i want to 5 how do i do now i want to add records into grid …

Hi guys, I am able to delete record from specified table when I just run the program from visual studio 2008. I am using ms access as database. My connection string is: Provider=Microsoft.Jet.OLEDB.4.0;data source=" + @Directory.GetCurrentDirectory() + "\\smsmanager.mdb;Jet OLEDB:Database Password=matmat However, after setup and deployed in Program Files folder and …

Hi, I’m trying to return a value from VB 6 to Access 2007 report and the unbound textbox remains empty. It seems that actually the problem is not coming from the coding itself, but due to connectivity between the two ends. In fact, I tried to enter a Beep instruction …

I have a comboBox that I need to fill using data from Access database. For this, I get a DataTable with resultset from database, transform this resultset in a List<T> to sort by number and fill the Rows with this List. The problem is, after selected some value, I can't …

The software developed should extract the details of an audio CD ( like album name, artist, genre, year released) and then transfer them to a database. I am using an access database. so far i hv been able to get the attributes except the year. Also how do I prevent …

I have an MS Access databse which supports a machine health monitoring application. I have the database schema but very little other documentation on how it has been constructed, very little support resource inside our own company to do any new development. An important client has requested we provide a …

Can anyone help me create an .exe using Mirosoft Access. I have an Access application and I want to place an .exe file on the server so that everyone can have access to it. Please Help!!:!: :cheesy:

Hello All, I am not incredibly skilled in visual basic. I have manipulated script to suit my needs but have never written it myself. I am in need of help/direction. I have a database which was designed by someone else. I am looking to update a table in this database …

i need help . what are the codes for importing data from access and creating a text file which you save to a certain name. and this text file gets specific information by search. And can all that be done in one button?? Thanx

I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …

Is there a way to determine what control I clicked using a global click event. I would like to be able to click a form text box table I created for my access app to enable to enable and unlock it without have a million on click event handlers

hi, i am using (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\" + " Book1.xlsx ;Extended Properties=Excel 12.0;HDR=YES;") this provider for inserting values from excel to ms access. when i am trying to execute the code, i got "Could not find installable ISAM" this error.so how can i solve this problem. i …

Hello everyone! I'm new here. I'm currently working on a project. The concept is that I created a shell script that will query information, then I will use VB to get the data retrieved by the shell script and put it in a text file. I do not know how …

Hi, I have an MS Access database which has password. Now I can open the database using the password from MS Access, but when I try to test connection from Visual Studio Connection String Settings Design Time Windows Form, I get message that "Not a valid password". Still, I tried …

hye, i need help about asp.net..i new in this language. so i don't know how to connect database from ms access to asp.net and submit button. the situation : when the user click on submit button, the data that they fill in will insert in database.

Hello everyone I m using java and ms access. I want to retrieve values from database into combo box. When I m trying to do this, only first value is getting displayed in combo box insted of list of all items. can you plz help me with the code? Thanx …

I need someone to help me with VB6 codes to add new columns to already created Access database table at run time. Secondly, i needed to create a duty rota table that keeps track of staff duties for 365 days. I am a bit confuse as i intended placing the …

hello to all, by the way i'am new in visual basic. could any teach me how i should start my project. my project is that. its talk about accounting the proopsheet and the ledger. now this is the problem when a person created a proopsheet in excel, there is three …

Hello everybody, I have developed my software using NetBeans IDE 6.9: very simple, a db on a remote server, a JDBC:ODBC bridge connection in order to access it and everything was working fine, until I was ready to deploy it, and I fell in this problem of 32-64 bits conflict. …

Hi friends, Plz anybody can tell me, How to retrieve only date from DateTime in vb.net in dd/MM/yyyy format and I have a field in table in access 2007 which has date/time datatype. Data is stored in datetime format.(04/08/2010 12:01:07 AM) I want to retrive only dates which are in …

Is it possible to get the max values from the columns in 1 table and copy them into another or would this not be recommended. The more I think about it the more I begin to think it isn't such a good idea. Here's an example what I'm looking for: …

[COLOR=darkred]hi I have some questions in VB.Net[/COLOR] [COLOR=darkred][/COLOR] [COLOR=darkred]1- how can I retrieve data by VB.Net from database using MS Access database? 2- can I retrieve data from a database and list them in a [COLOR=blue]CheckedListBox[/COLOR]? [/COLOR] [COLOR=darkred][/COLOR] [COLOR=darkred]thanx[/COLOR] [COLOR=#8b0000][/COLOR] [COLOR=#8b0000]Please help me :-| [/COLOR]

Hi pipo, I have a MSACCESS db linked with my project. The db has related tables but when i delete fields from one table, related fields in other tables dont go Plz help