[microsoft:access] Forum Topics

hello .. im having this thesis project and im new in vb.net i am having a problem in using the combobox and textbox that is connected through a database.. (im using microsoft access) i want that when i choose in the combobox .. the textbox will automatically update itself that …

Hello, I just only want to ask.How to connect MS access database to a C program.See the code below: #include<stdio.h> char firstname[20], middlename, lastname[20]; main() { clrscr(); printf("Enter your First Name: ");scanf("%s",&firstname); printf("Enter your Middle Name: ");scanf("%c",&middlename); printf("Enter your Last Name: ");scanf("%s",&lastname); getch(); } This is what I want to …

Hello, I am working on a seemingly unique file uploading project where files that are dropped onto a server are programmatically uploaded to an ms access db (don’t ask, I’m already pushin for sql) I believe the problem lies in converting the ftp stream to binary and then to the …

This project is to load same form to managers, and the managers will start this same forms to manage a job. 1. How can you load the same blank form to different managers? 2. This form has the datagridview, textbox, combobox, how do you save the values to the tables …

I have created a Cryatal Report and set its Access database(.mdb) during design time. I have imported the crystal report into VB.NET. now i want to know how can we set the database path during runtime. The database to which i've linked will change its path and name every year. …

i am trying to create a massive list of letters and numbers using this program. but for some reason i keep getting an error (sometimes this occurs, sometimes it doesn't) [B]error PRJ0002 : Error result 31 returned from 'C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin\mt.exe'.[/B] i also get(sometimes this occurs, sometimes it doesn't) [B]Unhandled …

Hi i have written my code to to insert data that has been entered into my textboxes n my form into my access database. i am gettin an error message saying: OLEDBEXEPTION OCCURED...Syntax error in INSERT INTO statement. i was wondering if someone could look over my code and tell …

Dear friends, I have a VB6 app using MS Access2003 database ODBC connection in Windows Server 2008 my connection string is simple ODBC-- DSN=hotel -- using Microsoft Access Driver (.mdb) using admin user - i can run all forms on windows server 2003 successfully using other users - i get …

Hi, i am trying to create a report using VB6...the format of the report is attached as pdf file..the format of report is important for me.. i have my data in Access and finally would like to print report on a word document.. Please let me what should i use …

I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x …

Hey, I'm trying to create a website for a friend, which involves a login system, with registering users, and then booking places on weekends away. I have no knowledge of javascript, but would like to use it for client side updates, I only have a week or 2 left to …

Hello everyone I currently have a form w/ two text boxes so that the user may enter the dates they wish to display in the report. The report consists of multiple clients per page and the date that they purchased an order. What I have under the button sub procedure …

Hi, I am creating an application in vb linked with a access database and i am having problems searching records. For the team screen I have the following database query that I wish to call: [CODE] SELECT TeamName, [Section] FROM Team WHERE (TeamName LIKE ''' & TeamNameSearchTextbox.Text & ''') [/CODE] …

I design A wed page in html. and An Access database. please show me how do I link them

i have made a code in which i access my database(MS Access). i m able to print the first record of the database on the page. but i m not able to go to next record which i want to show on click of a button.

Hi All, My knowledge of databases and Access is almost zero but none the less I have to try and solve a problem with a small home-grown Access database and hoping someone can help. I've done many searches and can't locate what I thought would be an easy answer. There …

I have written the following code for VB6 The application uses MS Access and used Microsoft Jet 4.0 OLEDM Provider [CODE] Private Sub cmdSubmit_Click() On Error GoTo Handler Eval_Env.Insert txtEvalCode.Text, txtEvalName.Text, txtEvalPhone.Text, 0 ClearControls Label4.Caption = "Data Submitted Successfully" Label4.Visible = True Handler: MsgBox "An error occurred" Label4.Visible = False …

I used autonumber for my id. i attach the screen shot.. [ATTACH]13899[/ATTACH] and i dont know how to make a code for compute command.. It should compute all the payments on that day, but i really dont have an idea how to make it.. ill attach my vb and access …

Hi all, I have a VS2008 winform application that connects to an Access 2007 database. However, I have been given the task of converting it so that it connects to SQL Server 2005 instead. (I've already migrated the data + database over without too many problems). The question is... is …

I hav created a database using a windows application form in vc++ i can add and delete entries in the database.. but my prob is that the database s nt getting updated.... it says that "[COLOR="Red"]no value given for one or more required parameters[/COLOR]" my update code s as follows …

hi, can anybody send me the code for retrieving drug information and price list using access database and C# code with just two tables. thanks

hi.. I've created a Point of Sales(POS) system which will link to microsoft access and now I'm trying to create a mobile apps tht will be use in PDA to link to my POS system and access which is my database. Any idea of what type of method i should …

Hi GUys Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable: e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my …

hi i have a basic website connected to MS Access Database and i want to display the search results, 100 records returned from a query split over 10 pages. can anyone give me the script to do this, i am using ASP JAVASCRIPT NOT VB. Source Code is listed below. …

Hi, I'm using C#, Access 2007 and VS2008 to write a windows app. I have populated a datagridview from a query (taking data from 2 tables). When the user clicks "Save", I want to be able to save any changes made in the datagridview to the database. Only one column …

Hi friendz, I completed a project in VB6 recently, its a database handling project, Problem is, I have created a SETUP with all its required files via PDW wizard, when I run that setup just before completing the setup there came a message that "System files are outdated" so I …

Can anyone provide a quick solution for INSERT the entire excel sheet into a access database. This is a click button event that just opens a excel sheet in a windows form. What I like to see is some example how to INSERT the same excel data into a access …

hi, I need to create or replace a permanent query in access (like a view in oracle, postgres...), but from vb6 using ADODB. i know that i can create and alter tables using a ADODB connection object with something like this dim obj as new adodb.connection ... ... obj.execute "create …

how to show hidden table for MS-Access2003

Hi, I have a project developed in VB.NET 1.1 (using VS 2003). The project has forms developed using the DataForm wizard (Connecting to Access Database, having a dataset and couple of adapter as automatically generated through the wizard - See attached screenprint "Original Form In VS 2003.PNG"). I converted the …

Hi, I am using CodeGear c++builder. Im trying to make a GUI to read, write and modify an .mdb( ms-acces) file. In my form i use TQuery, TDBGrid, TDataSource. So im able to load the database in the TDBGrid using SELECT. I can also use UPDATE, INSERT so that i …

Can some one give me a sample code or project on how to load a data of a particular table in access databse in to a data grid view

Pls give some example code for Form Authentication using Ms Access Database. pls help me?

pls help me....

hi, i am currently using delphi 2007, i am wanting to be able to add a image(prefrebly jpeg) into a access database. i have tried doing this but i cannot as when it adds i get several errors, or it does not insert correctly, has anyone made any code or …

Hi, I'm new in C#. I want to import data from Microsoft Access into Excel spreadsheet. How can I do this? Do I need to use OLEDBConnection and retrieve the data or is there any straight away way to import the data? Can someone point me to the right tutorial …

Hello I am currently doing a project and I have added a new table to an access database linked to the vb project. I re-linked the access database, but the new table does not appear in the drop down list of the form recordsource. Please can someone tell me what …

I had built a small cRM database in MS Access. The database is outgrowing its life in access so i was thinking of porting the backend to SQL server express. I was curious on what people's favorite/best frontend for forms and reports was. ie keep my access forms/reports on top …

hi every1 i m creating a simple ms access project. i created a report ,when the user opens it,it opens a query which askes user to enter name. the user enters the name and the report by that name generates. is there a possibility that when the name is asked …

Hi, Can anybody tell me how to make a button in an access form that connect me to a website?

hei friends can anyone tell me how to upload excel file to access in vb.....if u give code it will be very much helpfull to me, thankx.

Hi all, Now I've spend hours on google without findeing a solution to this small problem. I have a running program that uses an access database as datasource. When startet it opens the mdb in exclusive mode. [B]Now the problem:[/B] I need to read (and only read) the data from …

Hi, I am PANHA, I am Cambodia, I study Microsoft Visual Basic 6.0 ,I like it Because this Program , It's not Difficult to use , I alway make some program that i can with this program , also I sometime I study Microsoft access , ADOBE Flash ,ADOBE Photoshop, …

Dear Friends, I am new to Visual basic 2005 as I have used VB6 till now. I wish to do a database application using Microsoft Access 2003 and Visual basic 2005. I am very happy, if any one could give the step by step instruction to connect Access, insert, delete, …

please, check and give new source code[code]function getsubmit() { var lastname; var Firstn=t1.value; var cn=new ActiveXobject("ADODB.Connection"); var StrConn="provider Microsoft.Jet.OLEDB.4.0"; Data Source=d;//student_base.mdb; var SQL="select t1 from manisha where FirstName="'"Firstn+"'"); On.open(SQL,cn); surname.value=rs(0); DOB.value=rs(1); alter(rs(0)); rs.close(); cn.close(); } </script> </head>[/code]

hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the …

Hey all, I wondering if you could help me get my head around this problem. [CODE] connetionString = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = KellihersLawnmowers.accdb" cnn = New OleDbConnection(connetionString) cnn.Open() overDue = "SELECT tblCustomer.*, tblMachineHistory.*, tblPayments.* FROM (tblCustomer INNER JOIN tblMachineHistory ON tblCustomer.Customer_ID = tblMachineHistory.Customer_ID) INNER JOIN tblPayments ON tblMachineHistory.Machine_ID = …

Hello everyone I am new to access and have been trying to teach myself a bit lately. In any case, I have a problem with a specific text box(NumofMonths) within a form. I need for the default value to be 12 and that it may be edited. This text box …

Trying to use an oledbdatareader to search through a table in my Access database. When I hit the command button to search it throws an error that says no data exists for row/column, but if I execute the command against the database it returns exactly what I am looking for. …

Dear all, Good Day I need your help, I have the attached files that contain a data for "queue system" and I can get report from them by the q-system application But I search for another way to open this file as (SQL, Access or other) If you can open …