[microsoft:access] Forum Topics

Hi, I've been puzzling over how to connect these tables on Filemaker for hours, and hopefully someone can point me in the right direction. I'm trying to connect the tables in such a way that when I select a student, and a specific course, I will get all of the …

Hello, I created a database in Access many years ago before I realized what a mess lookup wizards would make. Does anyone have any good ideas or resources of how I can keep the information but undo the lookup wizard? I have created new tables with the same information and …

how to insert radiobutton value into Access database using c#? rely need help...

I am working on a project based on networking. My problem is that database on server (time to time updated by clients Application) is available in shared folder sometime any client delete that database file from shared folder then project stopped working. So give me process for accomplish this problem …

I have a datagridview which contains 4 records. I want to insert these records into access table.This access table already have records. Datagridview's columns & access table's columns are same (datatype & columnname) How can i insert these 4 records in access table??? Plz anybody help me.............. Thanks in advance...

I have got problem in updating the access database. THIS IS MY CODE // [code] Dim con As New OleDb.OleDbConnection Dim spl As String Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter con.ConnectionString = "PROVIDER= Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Malai\Documents\database31.mdb" con.Open() spl = "select * from REMAINDERDETAILS" da = New OleDb.OleDbDataAdapter(spl, …

Hi All, I am trying to do a record search feature in my datagrid, but I can't find any reference for this. What I want to do is I can search any of the row that contain the text that type in TextBox1 by clink on Button1. Anyone can help …

hey, I have a table say 'Student' and it has the regular fields and a PK called 'stNo'. I ahve made a form to view/enter data for this. This is what I want it to do. When you enter a value into "stNo" if its not present in the table …

I have a web application that links to Microsoft Access and opens one of five databases depending on which button is clicked. The purpose of the web app is to open an instance of the database for an employee to use the forms that we've coded in the database itself. …

Hi, I know this sounds like a repeated question but the tips in other threads didnt quite help me, so thought of asking again. I have 2 tables 'tbl_AWB' abd 'tbl_flight'. Flight has the fields "FlgihtNo" (PK), "DepCityPort","DestCityPort", "DepTime", "ArrTime". tbl_AWB has fields 'FlightNo', 'DepCity' and 'DestCity'. The tbl_AWB is …

I didn't find any place to search to see if my question has been asked already. I am a student taking MS Access 2007. I created a report in layout view. I need to use conditional formatting but it is grayed out.Can some help me so I can use conditional …

Hi all, How to create refresh Button in the form? I have combo box with the data linked to Access database. I create another form for data input for those that appear on the combo box. When I close the input form, I realise that the data is not yet …

I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date …

Hi guys When I ask VB to display a date obtained from a field in Access I get a date that displays the day ok, the year okay but it displays the month as 00. In other words 20100029. Now, I have to evaluate the date difference between todays' date …

Hello All, I am currently in the process of adapting an application that previously worked only with Microsoft Access to work with SQL server or Access. Previously, all database interaction was designed based upon using the XSD file to create queries (etc). I wasn't sure how to handle the new …

I would like to add code to open the form to the on click event of an unbound OLE object. I know I can easily make a button to open the form and place it in the form , I just thought it would be nice to use this shape, …

[COLOR="Green"]Hi, forums I'm not much familiar at access(and English too). And pleases give me the VBA code and needed property settings to my OLE unbounded object control( step by step). 1. my access version is 2007 2. database file name is 'tense db'. 3. i created my OLE unbounded control- …

[code=sql]Select * from Merit where cat='GEN' order by snum[/code] in this querry, i hav a problem as "No value given or required paramenter" due to snum fiels the Datatype of snum is Numeric

Hello Every one! i'm trying to encrypt my ms access database using the encrypt tool in ms access2003. After i encrypt it, i want to decrypt it, using visual basic so that i could run my visual basic forms. Can somebody help me how to do it? Thank you very …

Hi I'm devolping a project in which backend is ms access and front end is vb 6.0. For security reasons i made the ms access as password protected. when i tried to connect the vb and access, the following message is displayed. How to handle it? Please help me.. [IMG]http://i48.tinypic.com/ddyge0.jpg[/IMG]

Hi, I have created a data entry user form in MS Access 2007 which pulls out and puts in data from/in 3 different tables, When I create a new form(a new record should be created in all 3 forms with my primary key), I can enter data in fields from …

I have a VB6 program running fine on the machine I wrote it. When I create and exe of the program that works also. If I export the program to another machine I get a 'Class not registered. Looking for object with CLSID {00000010-0000-0010-8000-00AA006D2EA4}' error. After a bit of research …

How do I make Crystal Reports 4.6 run inside of Access 2003? Upon choosing the Crystal Reports Wizard I was prompted for a database password... for which I have none administered for that database but it works well in access 97. I need to run my crystal report in ms …

Hi i had written the following code to Populate the Calendar Control with Data from an Access Table.[VS2008+MS-Access07] [CODE] Try Dim con As New OleDb.OleDbConnection Dim cmd As OleDbCommand Dim sql As String Dim dr As OleDbDataReader con.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Resources\login.mdb" 'open the connection con.Open() sql = "Select [Scheduled …

I'm trying create a system flowchart which shows ms access as the database. I'm going to create a patient database and a invenroty database and a few others. I believea system flowchart does not show individual programs but rather the computer devices that make up the system and the basic …

I have a web application that links to Microsoft Access and opens one of five databases depending on which button is clicked. I coded it on my machine in Visual Web Developer 2008 and it works exactly as expected when ran on my machine, but when I move the files …

I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these …

I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the …

Hi All I need to create a login screen for a project in ms access. I have the Visual Basic which has been installed by default along with the MS Access package. I have designed a form in MS ACCESS for login and I ahve also created the login table …

i had problem in inserting data into a table in access database.i am using visual studio2005 for the projects.here is my code [CODE] Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" _ & "c:\Users\BELLCONSULT\Documents\LIBRARY2.mdb " Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(strConnection) Dim cmd As New OleDb.OleDbCommand With cmd .CommandText = …

I am trying to figure out the best way to read an OLE Object in MS Access (photo) into coldfusion and then create a new record containing the photo. I have no choice about the field type or of using MS Access. Can anyone offer a suggestion as to what …

Hi I have designed a database for use in an academic arena, but I have come across a problem that I can't find an answer to in the help files or on the web. I think it is something really simple but frustrating to put right! I have designed a …

Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance..

Excuse me if is a silly question... I call a Function to deploy a simple form (data from a table with just one record) DoCmd.OpenForm display form with first record data but CONTINUES excecution!! -Doesn't wait to get typing or clickling- [code] Function PedirDatos() DoCmd.OpenForm ("Asunto y Cuerpo email") Subjectline$ …

I have a form named "switchboard" that contains a number of control buttons. I need the button named "ADMIN" to open a form called "999 Password". On form "999 Password" you enter a password and select a control button named "CheckPassword". If the password entered is correct, I need a …

[CODE] OleDbCommand saveCmd = new OleDbCommand("INSERT INTO rapor (Proje_Adi, Proje_Tanimi, Proje_Sorumlusu, Kim_Verdi, Toplam_Sure, Sure_AsildiMi, Asilma_Sebepleri, Notlar, Baslangic_Tarihi, Bitis_Tarihi) VALUES ('" + adbox.Text + "','" + tanimbox.Text + "','" + comboBox1.Text + "','" + kimbox.Text + "','" + surebox.Text + "','" + checkBox1.Text + "','" + sebepbox.Text + "','" + notbox.Text …

Hi! I'm working on a query that stuck me for some hours. I have 4 tables that I need to query to get a result that I need to populate a flexgrid with. Table Transactions contains (tID, data, clientID, operation) that I need. Table TransactionsContent contains some columns that I …

hi i'm doing code by using picollo i use access database contain text colume iwant to retrive this colume and display the value for example every primary key in data base has name,video, audio, picture i know how ican retrive picture and display it but i can not diaply name …

I'm having problems trying to create a database in MS Access, to do receiving and dispatching of goods. I need to create a database for a cross shipment depot,there are three points of interest. Goods Received. Which do not always have are not standard Products that I can create a …

Hey all. I'm trying to write a query that gets all the multi-field data from a record in another table it has a relationship with. I'm using MS Access 2007 and would prefer to have it written in a SQL query. Here's an example of what I'm trying to do: …

:confused: how to create a payroll processing using VB and MSacccess.i want guidelines for that would anybody plz help me.In VB with all the deatails of an employee,facility to add new member,to edit,hv option to display all the parcticular abt certain employee in detail.plz help me

Hi, I'm trying to build an Access database on Access 2007 and I'm unsure of how to do a few things. I have 2 fields: field1 and field2. Both are dates. I want field2 to change to exactly a month after the date in field1 and I want it to …

Hi All Please assist. I am building a program to manage contractors on site. This program involves a date drawn from access db when the first induction took place and I need to check this against todays date to verify whether the induction is still valid. My problem: the date …

I am currently trying to create a live search box that as I type it will start displaying results that match. Here is an example [url]http://www.w3schools.com/php/php_aja...p?output=print[/url] but it retrieves its data from an XML file, I need mine to retrieve from a column called FirstName within a table of an …

Hi, i'm trying to figure out if there is a way that i can save emails to an access 2007 database when i press send in outlook? I am building a program in c# to store client info and want to be able to view emails to clients based on …

Hi, i have a access database with two tables, one for customer and one for booking. I then have a form application i made in VS 2008 which lets a user enter details such as their name phone number ect into text boxes. All of the information the person enters …

I have a final almost finished database for one of my school courses yet when I went to open it this morning it wouldn't work! Is there a free tool that anyone knows to recover a "corrupt" .mdb access file? Any help would be appreciated! -Bryansworld

i am developing a website in html in which the contactus page i have to connect to ms access database i am not able to get it ,can any one tell me how to get that one.

I have recently made a database in MS Access that has a user-friendly GUI. Can someone please tell me how I can hide the Host Application [MS Access] so that when I run my database, the GUI gives the illusion that the database that I created is a stand alone …

I have a gridview with access and built with "select","edit" & "delete", the outside under gridview with the "add","cancel" buttons. details: select edit delet id name etc. Textbox1 Textbox2 add cancel ALL THE BUILT SELECT,EDIT,DELETE WRER WORKING, ONLY THE "ADD" BUTTON WAS NOT WORKING. So, I rebind the gridview with …