1,597 Topics
 | |
 | 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.