1,597 Topics
 | |
| | Hi there guys can someone explain to me how I can increment a value within a field in my database each time I execute my query?. As I cannot seem to find a way to do this. Below is my structure for reading + writting to my database if you … |
| | Hi!I'm currently trying to make a language translation tool using vb.net 2008 and access 2007. For that I want to do these... 1.There is a textbox,a command button and two labels in my form and I have a database named 'dbwords.mdb' with one table 'word' and two fields named 'word' … |
| | Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of … |
| | Hi, I have a database with lots of fields, some of which are still empty and are to be filled in at a later stage. Is there any way of writing an IF statement (or any other method) that will allow these empty records to be 'shown' in my textboxes … |
| | |
| | Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: … |
 | So, even thou I have searched throughout the forums, I couldn't get a clear answer, maybe perhaps I'm a noob @ Python. As a beginner, I don't know much about Python, and it's frustrating to search the net and not find the actual answer. So, I'm working on this project, … |
| | I'm trying to design Programmable Logical Array using c language. Due to lack of time I downloaded code for tabulation from internet. Now I have modified it to return f and f' in a character array. It works fine for some functions. But it shows memory allocation problem for some … |
| | Hi guys well what I want to do is that when a button is pressed it increases the value in one of my database cells. So my question is how do I do this? As I cannot get this to work. My code so far: Any help would be appreciated …  |
| | Hi guys well I have created a JComboBox that lists all my values from a String. However I want instead of the values for the JComboBox to be in a String the values to be displayed in the JComboBox from my database so if more values are added to the …  |
| | Hi guys well what I'm trying to do is produce a query that only produces the results which will match my director input. I have looked for the correct syntax and cannot seem to find it. Any help would be appreciated Code of my syntax below: [CODE] ResultSet results = …  |
| | Hi guys well I have a problem on my JFrame which is once I click on my List all Videos button it displays my data from my MS database which all works well. However as you can see from the png the query results are not aligned up correctly together …  |
| | Hello! Is there a way to hide the password of your database inside the source code? [CODE=vb.net]"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Database.accdb; Jet OLEDB:Database Password = [B]MyPassword[/B]"[/CODE] As you can see the password is exposed, increasing the risk for the database to be compromise. Is there anything you can suggest …  |
| | Hello, I wrote the following code to create dynamic controls-textboxes and labels. [CODE] ctlRow += 1 ctlRowLocation += 25 Dim new_ForceLabel As New Label new_ForceLabel.Text = "Force" + Convert.ToString(ctlRow - 1) new_ForceLabel.Location = New Point(txtForceLabel.Location.X + 2, ctlRowLocation) new_ForceLabel.Height = 25 new_ForceLabel.Width = 50 Dim new_ForceInput As New TextBox new_ForceInput.Name … |
| | Hi guys I am able to drop my tables that I want but however when I come to trying to drop rows the rows do not delete. I have tried the following which have all produced the same error duplicate key TABLENAME : Any help you can give for a … |
| | Hi guys I have successfully set up my database which through my GUI I am able to create my tables that i wish and insert data into the table. My problem is through that I can only insert one row of data into a table so what would I need …  |
| | Hi there well title says it all really. Is it possible instead of creating tables within my database to create the tables within a form in java? . If it is possible how would I go about doing this?. Before you ask yes my database is fully connected to my … |
| | I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a … |
| | Hi and Greetings, I am new to these forums, so if I submitted this to the wrong forum, my apologies. Before I get to my question, a little backstory. I was running an application on my laptop that was using Microsoft Vista, with Microsoft Office 32 bit and JRE 1.5. … |
| | Hello i am developing a web app in JSP as front end and ms-access as back end..i hv login.jsp which contains username & password which will be validated in access database upon success user.jsp will be shown..i hv been done with jsp page design..but don't know abt database connectivity..can any1 … |
 | Good Morning Lladies and Gentlemen: . I need some help in my app... I am using Access 2007 (from MS Office 2007 Pro). I have an attachment field in my customer table that holds multiple attachments. I need to preserve this data so transferring to from a spreadsheet DOES NOT …  |
| | how to JOIN three tables in MS ACCESS 2007. the tables are: *student (Primary key: StudentNumber) *event (Primary key: Event_num) *Transaction (Primary key: Transaction_num) the MS ACCESS gives me this code, but nothing appears in the Datasheet view. [CODE] SELECT Student.StudentNumber, Student.Lastname, Student.Firstname, Student.Initial, Event.Event, Event.EventDate, Event.EventFee, Transaction.Status FROM Student … |
| | Friends i want to submit project in my college on employee management system.... front end should be c# and back end sql server 2008... i got one project on net but its backend is microsoft access I want to change this to sql server 2008.... what changes i have to …  |
| | i need help in adding image in my current payroll project i need a more simple way or easier to understand codes in adding image in my database tnx in advance |
| | I got the following error in my code today: Syntax error in INSERT INTO statement. [code=c]OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText="Insert into Cursanti([ID],[Nume],[Prenume],[Sex],[Varsta],[Ziua-1],[Ziua-2],[Ora-1],[Ora2],[E-mail],[Telefon],[Referal],[Partic/Grup],[Adult/Copil)] Values ('"+id_b.Text+"','"+name_t.Text+"','"+surname_t.Text+"','"+sex+"',"+age_t.Text+"','"+ziua1.Text+"','"+ziua2.Text+"','"+ora1.Text+"','"+ora2.Text+"','"+email_b.Text+"','"+phone_b.Text+"','"+from_t.Text+"','"+ore+"','"+categorie+"')"; cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close();[/code] The error points at "cmd.ExecuteNonQuery();" Searched the other topics, saw that people had similar problems, but … |
 | I have a storedProcedure in SQL-Server that I am using to delete duplicates from one of the tables. This storedprocedure makes use of a cursor. I tried to create the same storedprocedure in microsoft access by just replacing the 'CREATE PROCEDURE' with 'CREATE PROC' but it didn't seem to work. … |
| | Hi i'm unable to do multiple update (using Ms Acess because of restrictions). I try to do through ADO method (also because of restriction , x ODBC). The operation will break when reaching the script to update on the second page. Can you guys point where did i went wrong? … |
| | Dear all, I want to create a page on which I want to display the Number of kits issued, total women visited monthly wise, How much cases are registered total, how much are close due to delivery/migration/miscarriage/abortion/Fake Data. Can any one help me??? |
| | uhm. im coding a simple log in program in vb 6 and im using access as the database. i already coded the username and password verification part successfully. but our instructor requires us to include a "Privilege" whereas, all registered usernames in the database have corresponding privilege or rights to …  |
| | hi. can you please help me out with this program im writing. its a simple log in system written in vb6 . ms access is my database. i have a problem with connecting vb to access. heres the code: [CODE] /codes for module Public db As ADODB.Connection Public rec As … |
| | Hii Respected Forum members can anyone solve my problem what i want content restriction based on user role and sidebar category based on user Role i have three type of user role Beginner,Intermediate and Advance... Beginner Role: Can Read only seff Blog Intermediate: can Read self and Beginner Blog Advance … |
| | Hey y'all. I'm making a database using MS access 2007. I have a login form from a table which consists of admin and user. I want it admin to enter a different form from the user. Any ideas? |
| | Hello friends, I am new to Jsp Here am facing a problem while trying to retrieve the data from ms access db using student no(number) form.jps ========= [CODE]<html><head> <BODY style="background-color:SteelBlue"> <center> <p> </p> <p> </p> <p> </p> <p> </p> <form method="post" action="search.jsp"><h3> Enter Ur Number: </h3><input type="text" size="3" name="no"><br /> <p><input type="submit" value="Submit"> </form> … |
| | well i am trying to pass this parameter in a function -->[ICODE]char*[I]filename[/I][/ICODE] [CODE] [U][B]//i just wrote this as an example to explain clearer my question[/B][/U] #include<stdio.h> #include<stdlib.h> void try (char *[I]filename[/I]) //[B] the question is how can i use the pointer to refer to a file? [/B] { printf("try"); } … |
| | Hi Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum). After solving many specific problems I … |
| | Hello, Guys i am working on a little project using C# & Ms Access, where i need to print some reports,there are few things i need to ask:- 1) is there any way to print reports other than Crystal Reports 2) i tried using crystal reports all things are kind … |
| | I have all my customer information in a database program called Maximizer CRM 11. I inherited this info from another worker. I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I … |
| | Hey guys, Basically i want to create a database in Access 2002 that will hold names of functions of a mobile phone. When the user enters a search the databse should query the information held within it, display the appropriate search results. It should be able to serach for precise … |
 | can anyone please help me with my update statement, i am trying to update a row within a access 2007 database here is my code. [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & Database & ";Persist Security Info=False" con.Open() cmd.Connection = …  |
| | Hey there. I have a program that uses access, and everytime i go to install it for some one i have to keep my fingures crossed and hope they have office installed on their pc. Is there a way to run my program without buying microsoft office? (using access database) … |
| | I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" … |
| | search button for vb 2010 ultimate in access 2007 database and filtering on a datagrid Hi all! I am trying to make a search button which filters a datagrid. First of all, I have a tab and on this tab a have a datagrid (dgr1). When I load this tab, … |
| | Iam developing a small school software. I want to show fees of every student of whole year. Like John(student) I want show his fees that every month he paid at what date and how much. So how should I start please help..  |
| | Greetings, I have just went from Access 2003 to 2007.... I have a project requiremtn to output some reports to PDF file format... Don't know how to do it.... I tried doing a little research but.... :-( I am open to ideas... I would like to automate the process so … |
| | Hello! Now I am trying to make selection of Customers easier for my user. My user's business involves making deliveries on [B][I]routes[/I][/B]. Every customer is assigned a route number, which references the route in the route table. In my form I want to have [B][I]two list boxes[/I][/B], side by side. … |
| | Hi Guys, I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003. Please let me know how I can do this as when I use …  |
 | Hello guys, I am new to vb programming. Can anyone tell me how to access command button of one form onto another? I have one mdiParent form on which i have command button "PRINT" and "Add New Client", I want to disable Print button, when i clicked on "Add New … |
| | I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the … |
| | I have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error. I've been trying to google the answer but I cannot find solution for this. … |
| | Greetings, I need to have a way to veiw/print reports designed in MS Access in my Delphi application. I have a MS Access 2007 db for the backend of my Delphi2010 application. I have reports I had defined and saved in my Access db. I would like to place a … |
The End.