[microsoft:access] Forum Topics

I have two access database, one was old access from 2000 and the other is 2007. the problem is there are some feature that are in 2000 but not in 2007. so, i want to merge the two database together so that i can use both the old features and …

Hey everyone can I get some help please. I read through a few threads with the same problem as me but i can't seem to get the answer i'm looking for. I'm doing a school project and I need to save a Access DataBase that I have created in C#! …

Hi gyes I need any solution about login form I have 3 from (formLogin, formUsers, FormAdministrator) In formLogin i have 2 textbox for user and password and 2 radiobutton who check if I click radiobuttonuser to open formUser and if i click on radiobutonAdmin to open formAdministrator. how can I …

Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way?

[QUOTE]Hi all I am using Vb2008 Express and an Access DB. I would like to Display a note from a column in the Notes_tbl to a text box this from an Access database. Here is the code that I used but it does not do the job. [/QUOTE] [ICODE] Dim …

I'm not sure if this is the right place for this, but I'm having an issue I'm trying to solve for a customer, and it's not going well. Searching online I'm seeing this has been a common problem for many people, but there aren't really any solutions that I can …

Hey every one i need some help please! I am trying to save a Database through c# but cant seem to crack it. I read a few threads but every one explains how to save an existing DB. In my program I am creating a new DB in c# then …

i can't use vba in access because when i write: Dim db as[space]->error it seem error space . how do i fix it ?i reinstalled it already but it's not working . thank you

hi i have some question to ask everyone . 1.How make open form in full screen ? 2.Example: I created two completed forms,frmLogin and frmStudent and saved it name "Student".what i want is when i open saved file,i want it only show frmLogin auto(full screen) without choose a form from …

I'm confused about how to link my app to an Access database - there seems to be a number of approaches. I can add in my database via the Data Sources tab. Fine if I want to bind controls and view/edit data. But is this the best approach for queries …

How do i find out the number, names and datatype of fields in an Access table.....using code.....

Hi, I have begun using Visual Studio 2010 in an attempt to create a website. The website uses a Microsoft Access Database to store information and then displays this information on a page according to the city. So for Hendersonville it redirects to myDomain.com/Hendersonville.aspx Well, In development i realized the …

Hello, I am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the …

Hi. I am doing a C# windows form application and I am using Ms Access for the database. I have a sql query which retrieves data from 2 tables and I am displaying it in a crystal report. The problem I am having is for example i have 4 records …

i need a design of student profile system. And i am using Access for my backend and visual studio for front end. Plz plz plz help me. Its urgent

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.

Hello again guys, I am little bit stuck in this situation and searched everywhere in google but i did'nt find what actually i want.. a problem with autonumber in access database. i have created a database with 4 columns .. deleted primary key slip, cname, nic... the slip column is …

hello everybody. i need help ASAP. i have access file in windows XP and now i have been install win 7 and the access software say "you need the right user", how can i fix this problem tks in advance...

I am trying to make a quiz form in C# . Questions are stored in Access database and it will be displayed on 2nd form when i click the button in 1st form. But it is giving me path error but my path is correct can any one help me …

hye here is my code but it is not working plz help me. [CODE] FRd = txtBCode.Text On Error Resume Next Set Mydb = OpenDatabase("E:\Projects\TS\database\MyDb.mdb") Set Myrs = Mydb.OpenRecordset("SELECT * FROM ItemEntry Where[Barcode]= "&FRd, dbOpenDynaset) ' other data have to retrive. If Not Myrs.EOF = True Then txtINameS.Text = Myrs("ItemNameSize").Value …

hi guys:) Does anybody know how to change the full path of a database imported in c#? Cause i imported a database (MS Access) in c# with a path of "Server/Server/bin/debug/products.mdb" but what appears on the program properties is "C:/Me/FrontEnd/BackEnd/products.mdb", a different source. How could i change that? i tried …

i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE. the first table contains (username, password, first name, last name). the second table is only one field (manager, admin, agent). there are two forms (administration, login), the administration form adds a new user, the login form makes user …

HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify …

hi, im working on a small project on access 2007, i have a form that contains multiple textboxes ,and a save button. these textboxes are related to tables, so what i need is a code for that button to save the records in the textboxes in the tables and then …

Hey so I'm having some problems with vb.net 2008. I need to create a search form where a combobox populates with names then the user clicks a name and the textboxes in the form are filled with the correct data for example txt_Firstname txt_last txt__nameage would all be filled with …

Hello, I got a problem, I can save my data to access database and in the access database field I set it to date/time. But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00 How to get the …

hi everybody! I want to create a complete database (Tables,Fields name etc) in MS Access via vb6 database object and using SQL queries at run time this database will create when first time project load. may i have to create function in Module and where i will need i will …

Hi I have a access database that contains foreign characters(Hebrew language). How can i search the values in the column by using c#? This is my code: SELECT * FROM "table name" WHERE column_name LIKE '%שגל%' I'm getting this error: Syntax Error in SQl statement Can anyone please afford your …

Good day guys, anyone here who knows how to easily access image pointers stored in a database in JSP?... here's my code =) ... it already works in retrieving data other than the image... my database contains petid, petname,birthdate,image,petprice.... [CODE] <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/store" user="root"/> …

Hello! I am working with an Access Database (Access 2002) that contains a form that is supposed to import a CSV. However, because some of the integers contained in the CSV are too large for Access to handle (regardless of the number format I select for the field), I'm going …

This is my code to save values in MS access...but when i click on save it shows "INSERT INTO STATEMENT error" Plz som1 help!!!! [CODE]Private Sub save_Click() 'Text4.Text = cmbCustID.Text 'Text3.Text = cmbLocation1.Text 'Text5.Text = cboSize1.Text Dim temp As Integer 'On Error GoTo eror blnerror = False myValidation If blnerror …

Hello , all dear. I was not here for long time. I got project for a tuck shop please suggestion me what type of database i hae yo use MS access,Sal, Orelle or other ease tool? regards, Zeb noon

Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open …

Hi, I am working in the program which is written in Access 2003 database with developer extension. It looks really similar with vb6. It is quick and it does the job, but we would like to upgrade it into vb.net considering that the technology might "abandon" it. So, we try …

HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in …

How could you, update the fields on database if its data type is Y/N, and the method of updating is a checkbox??

I feel guilty about posting again but I need help again and I have tried other sources of help e.g google and asking someone who is familiar with vb.net but still can't find the solution to it. It must be another simple fix but I cant find any reference to …

i use ms access as database and i dont know why my code not working.. here some of code [CODE]Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim conAccess As OleDb.OleDbConnection conAccess = New OleDb.OleDbConnection conAccess.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\kptm.mdb" conAccess.Open() If txtNamaP.Text …

Hi, Im creating a website where users can enter details into an access database. I want to add a page where the most common names from the access database are displayed. Would anybody have any ideas how this can be done. The table im trying to get the information from …

Hi, I am trying to come up wit a database design for a small school. it works this way: in AC-Year, there are 3 terms with each term having 2 semesters. New students get registered at the start of each term. A student may take entrance exam. if he fails, …

Hi all, I have this code for the password reset form, It is supposed to generate a new password and the encrypt it to update the database then send an email to the user the new password for the user to log in and change the password. This is because …

[code=php] $conn=odbc_connect('mobshopDB','',''); if(!$conn){ exit("Connection Failed: " . $conn); } $query="INSERT INTO users(uid,pass,fname,lname,pmm) VALUES('$username','$password','$fname','$lname',$pmm)"; $rs=odbc_exec($conn,$query); [/code] this query gives me this error Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\Program Files\EasyPHP-5.3.6.0\www\mobshop\registered.php on line 39 ..please suggest a …

Hello, I need help saving data into an access 2007 database from a program created in vb 2008. I am making a basic "game" that allows you to move a "robot" up,down,left, right and will save the movements/positions into an access 2007 database. I already have the basic movement created …

Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : …

How to insert questions with multiple choice and its answers in .mdb file as a single row for each question .. How to retrive that .mdb file and display only the questions into the listbox. If i select the question in listbox it must display the data of selected question …

hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks

hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to …

Hi, I'm doing the following code to connect to Access Db. The db1.mdb is placed in c:\db1.mdb. It giving me error "couldn't find file" [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System; using System.Data.OleDb; namespace CustomerDB { class OleDbTest{ public static void Main() { //create the database connection …

Hi All!, here's my problem. i'm working with Visual basic 6 and microsoft Access 2003 database. I use ADO objects for connection and manipulation of the database. In my database there are 3 tables .2 tables(Customers and Events) are the parent tables and 1 table(Orders) is a child table.The order …

hello, can somebody please help me. I need to create a clear button to delete all the data from my form. I don't know how to do this. can some body give an idea how to do this, I am using vb.net 2003.