[microsoft:access] Forum Topics

hello , i have the following accessdatabase access database name = surya table name = collection field 1=id field 2=date field 3=customer field 4= amount i want an asp code were i will input from date to date to search the table collection and to display all records in between …

Hi, I am trying to complete an example from the book SQL for Microsoft Access. I have typed it into Access just as it appears in the book. When I run it, however, I get an error message telling me that there is a "Syntax error in Constraint clause." I …

Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set …

I need vb code to search the access fields using datagrid... I am using one text box and datagrid...but i don know how to write the coding...anyone pls help me.. Thank you

hi friends, i have created a table in ms-access. it contain 7 fields. in it 1st field is customer_id which is set as autonumber type. now i have a doubt of how to provide the value to this table. i dont want to overwrite the autonumber field as well as …

Hi i hve used the syntax provided by ul in order to del multiple rows using checkboxes but for some reason the code shows we an error wen i give the value of the checkbox as one of my feilds so that i cud del the rec on that bases. …

I am working an assignment which is a Sports Day Enrollment system for secondary school. I have simply 3 tables: Student(Sid,class,clsNon,Sname,dob,House) Event(Eid,Ename,Grade) Enrollment(Enid,Sid,Eid) Grade(by calculating the age) A>=16 B=14-15 C<=13 But my assumption is that each student can only apply for 3 events. How can I display the corresponding events …

Hello guys, I have some problems with my project and I want to ask you for some advice. Firstly thank you in advance. 1. How can I create an application with multiple languages ? - My solution was to read from the file, but it was not proved very effective …

HI ME AGAIN=| I'm basically new to connecting to database. MY PROBLEM is that i do not know how to connected to database[ microsoft access] eg. the password entered, is stored at microsoft access database. how do i connect the window application to database so that when i run the …

Hi Anyone know how to correct a currupted database using vb code? Please help me out to solve........

I Have a access data base, and have a field "Card No" if we think starting no is 1 and ending no will be 20. some times some numbers are missing and some are not in this range, ex. 21 How can I make a missing no report?

I am new to databases, this is my first attempt at one. I coach a girls softball team and I am trying to put together some useful stats from the tables that I have made. I have several tables of data, 4 or 5 quries, 3 or 4 reports and …

Hi, I am creating a page that has two dropdowns. One drop down needs to change dynamically depending on the selection made in the other. So Dropdown2 values depend on dropdown1 selection. To do this I am trying to add code to the Dropdown1_SelectedIndexChanged event. The data comes in from …

please guys... help me to connect a textfield on my mobile app to be connected in ms access... thanks alot :)

we r having 10 check boxes in form and we want only caption of selected check boxes in data report through table.we r using back end as ms-access.how to get this?

Hello everyone Im new at this thing of programming and im having trouble in saving a new record to the database, I've searched online for this problem and ive tried all the possible ways that i find in internet but i cant manage to make it work correctly This is …

I have a general question about threads prompted by something strange I'm seeing in an application I developed involving ODBC access to Microsoft Access and SQL Server databases. Let me present the context of the problem first. I have been developing some tutorials on ODBC database access in two different …

hello am tryin to develop a login page for my website.am using c# and microsoft access. can anyone help me out with a secured login page n session.

Hy, I want to create several mdb files. Done that,I've created several tables, populated them, but I want to protect them by a custom password. How can I do that? :icon_confused: Thanks!

This morning EMC, Microsoft and IBM announced they had worked together over a two-year period to create a [URL="http://www.fiercecontentmanagement.com/story/ring-bells-major-ecm-vendors-send-content-sharing-standard-oasis-today/2008-09-10"]content interchange standard[/URL] for enterprise content management systems. It may not sound like much, but it's meaningful on several levels. For content management customers, it means it will greatly simplify moving content …

Overview: This article practically describes how COM objects could be utilized in Java. The user should understand and have general programming skills in Java. This article also gives a small introduction of what COM is all about. What is COM? COM is a popular object model for creating software applications …

Here at DaniWeb I have always been rather proud of the fact that not only is member feedback encouraged, but the powers that be read what is being said, participate in the debate and sometimes their minds, and system policy, are changed by it. For any real community this feedback …

I've been asked to build an access DB application at work to house all IP address information. Why? We have over 500 hundred IP's available for use and seeing as all the clients here at work have access installed I was told it would be good to use. It also …

This is the coding needed to password any button on any switchboard from used in Access Database

Connection To Access Database and Save,Retrieve,Update D:\access\try.mdb=The Address of the Access database table 'Try'. Take a module as ModMain(Copy the code) table fields: idno,name,designation.(idno=auto number) textBoxes=TxtName,TxtDesignation And Combobox=CboRetrieve buttons=new,save,retrieve,exit

This code uses field level validation to check for data in fields in an Access form, and instead of using message boxes (as the "Validation Rule" and "Validation Text" properties of a field (in the table design window) do, it turns the associated label and control (textbox/listbox/combobox) background color to …

Place the file with part one of the code on the server. This part of the code gets placed in a batch file (text file with the extension *.BAT) and placed on each client's machine. Again, you will need to change the paths used to the real paths on your …

Clearing Controls & Forms in Access (VBA)

Access 200,XP and 2003

I am trying to figure out how to set up a form in Access to automatically fill in 2 fields (Region # and Store Name) based on the Store number which is entered in another field. So whenever a user types in a store number, the store name and region …

I have an axxess student database with 2 large forms{IAPp1Form&IAPp1Form}w/calcs figured in the queries. The problem is there are so many fields, including the calc functions in the query that I'm pushing the 255 max field cap. The forms function and track the vital values but when I try to …

[B]I have a combo box to select different types of data in the database, the listview will be filled with data according to its category based on the combo box. The problem is, when i click on that first index of the combo box, it fills the listview with the …

Hi all, i would like to know how to access data in the database using vb6 and the database in ms access 2007. for example i have a table in the database called item, with data fields such as itemname, item-id ,etc, so if i want to access the data …

Hi, I am extremly new to C# and whilst I have a basic understanding some of the more complex answers require ample explaining. What i am trying to do is use data stored in an microsoft access database and also write to it from the c# program, i do not …

Hello, I want to let access fill in a checkbox automatically based on the value of another field in the same table. I have a student course registration system in access, and I have a table of Marks that have a mark field, diploma field and the student_id, that I …

Hello, I have a problem and I hope someone could help me with this. I have a student registration database. The case is that there is courses that student can register in. And when they register there a groups formed for the courses. So there may be 2 groups that …

Hi expert, I'm facing a problem when i try to update the database, below is my code: Dim conn As New OleDb.OleDbConnection Dim strSQL As OleDb.OleDbCommand Dim ra As Integer Dim num conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\employee.mdb" conn.Open() strSQL = New OleDb.OleDbCommand("Update [emp] Set e_name = '" & …

suituation: having employee perrsonel details as a database(msaccess) by selecting empno in combobox and the button(button name:showbutton) was clicked.............. question: how to retreive records in databaseand to display that record in textboxes?

In an ASP.net Application (windows or web) can i write code to store the song into MS Access database . Please Help

I'm trying to do what seems like a simple project, and find out who has an Access Database open. The basic code is below, and it works fine for me, (I'm a domain admin) but when a normal user tries to run it, they don't have the rights required. Is …

Hi expert, i facing a problem when i try to connect to database by using vb.net below is my code: Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim dSet As New DataSet Dim da As OleDb.OleDbDataAdapter Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim User, …

Hi i have to store a song in MS access database . I want the code in c sharp or vb.net

Hi everone, i have a table containing employees in and out dates of a project containing sat and sun.i want to remove sat and sun and display results.how to achieve this.

I need to access the information in an excel file, my only problem is, all the forums i read use the ODBC bridge via the data source tool buillt into windows. Since i am running windows 7, i can only assume, i get an error such as the setup routines …

I have suddenly began getting 'out of memory' messages while editing an Acess2003 module VB code. It deletes the entered text that caused the message. There is no error number - that's the exact text. Restarting Access and rebooting have no effect. XP SP3, Access 2003, VB 6.5, 1.5GB memory, …

pls someone give me a puiz project using visual basic 6 and ms access with adodc connection...plssssssssss... i am under pressure....pls upload file and send me immmediately

I made data report with condition. I want to input a student id number in a text box and press a button to show all data of this student, but a problem when i input a number in the text box (and press the button) for show the report a …

Hey guys need your help here. I will go ahead and describe my problem and what i intend and what i am getting. Platform for SQL Queries : MS Access There are 2 identical table in terms of table structure, they contain information ( RAW Data) about month, money i …

Hi, everyone... I'm using ms access 2003 and i wanna know how to write a code in vba that will take initial days x add y days every end of month and store them as accumulated days. Pleases I don't know wre to start. Thanx in advance

How to get combobox.items from MS Access database? I'm using ADOTable and Datasource to get database into DBGrid.