[microsoft:access] Forum Topics

Ok, so here's the problem: I have a database with tables made with Microsoft Access. I know how to connect to this databse, and retrieve information in the tables, and update the information in the tables. I was hoping someone could help me with the code for inserting new tables, …

Hi, Sorry for posting in Web Dev even though this is an App Dev question. We're looking at methods to create a new application. The application will be used heavily by about 20 people concurrently, it needs to be very user friendly and highly interactive. IT have nominated Java/Python/.Net or …

I am trying to create a new table in an Microsoft Access Database. I have already used Access to create a Database called "GRADEBOOK.MDB" I also have used Access to create a couple Tables in the Database. I would like to use VB2005 to create new tables and update columns …

I'm using the free Microsoft Visual Basic 2005 Express Edition My problem: I have a main form with my options (save, open, etc). I have a form to handle my Open (I'm opening multiple data-tables) and use a masterList.txt to keep track of my current data-tables, and display them in …

Hi, I've problem here. I create 3 check boxlist using vb.net 2.0. One of my check boxlist is uncheck when i try to save in database. when i want to save this using Microsoft access database the error come System.NullReferenceException – “Object reference not set to an instance of an …

Hello, Can you please help me I want to know the functions used to save a data in access database, I have the code to save in a file but is it possible to save in a database in C language. Reegards, Noora

[COLOR=#555555][FONT='Verdana','sans-serif']I have a very beginner type question. I use File maker pro to maintain records of member for a local Historical Society. We want be able to move a single record/member from one database to another. We do not want to import the whole database. Is there anyone out here …

Hi all, I got a SELECT QUERY name "Q: Naming Assignments" in MS ACCESS which do the naming assignment for all the products in my company. In this query, i inner join several tables comprises (T:Supplier Code, T: Manufacture Date, T: Country Code, T: Material Code, T: Assignments , T: …

Hi, I forgot my Ms. Access Database password. :eek: Is there a way that I can recover it..? For your information, I split the database into two files, the front end and the back end. Now, I can't open the back end, although the front end still works. Help.... :confused:

I want build a staff information system use visual basic as a interface and microsoft access as a database. Please some one help me.

Hi there... may sum1 help me... i need to know how to open Access data base from VB6??? THANKS

I need to create an environment that allows a data-entry person to change the default date for records on the fly. i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I …

[CODE][/CODE]How to upload the word document to msaccess database. i have created the datatype as OLEObject in msaccess i am using jsp.from jsp page i have to insert the word document to the database Please guide me. Thanks

a picture link has been given. I want to do the same but it should work with database but not with folders and files.. that is i want my database made with MS Access to show like this where each node is the primary key and all the childs will …

Hi All, O/R Mapping and code generation are those topics which are under consideration for last 4-5 years. there are many tools available in market i.e. TierDeveloper @ [url]http://www.alachisoft.com[/url] Deklarit @ [url]http://www.deklarit.com[/url] LLBLGen Pro Raptier Codecharge etc. are some of the tools available in market. What are ur experiences about …

[B][COLOR=darkorange]i try save Vb.Net checkbox into access database but i could not find the source code for it..please help me to solve this problem immediately....pleaseee..urgentttt...!!!![/COLOR][/B]:sad:

Hi im new to this but i am doing a project for my business, i was wondering how in the validation rule you can set it so that it will have an error message if i do not insert a decimal point e.g for car enngine size 1.6 if enetered …

I am tryinf to remove "hpodvd09" file from my Temp folder but it doesn't let me do it, giving me error that program is beeing used and to close it first. This is my hijack log: Logfile of HijackThis v1.99.1 Scan saved at 06:49:54, on 25/04/2005 Platform: Windows XP SP2 …

Hi, thanks for any help provided in advance. I've tinkered with programming for years, but trying to get serious now. I just read a book called "Learning to Program with VB.net". pretty good book. But the writers approach (since it was for beginners) was to use txt files as a …

Hello everybody, I'm a newb of ASP. Yesterday i've practiced add to database, delete, update, search using ASP. Database: MS Access. I have fields of name, age sex, place, address; how can i make appear all fields except name as tooltip, when we drag the mouse pointer over the 'name' …

hi, I am having problem in updating tables in MS Access. The field which I want to update is of DATE type. here is the code.. #! C:\Perl\bin\perl.exe [code] use Win32::ODBC; my $db = new Win32::ODBC('ServerStatistics'); $q="select distinct(build_date) from wdf_history"; $db->Sql($q); while($db->FetchRow) { $s = $db->Data(); print $s; } $q …

Hello, I have developed a small commercial application in VB+ MS-Access. Now, I want to sale it with trial version and registered version. However, I am not getting a [I]perfect [/I]logic to write in VB to design a [B]Product Registration Code![/B] Please guide me in this regard. Thank you very …

I m havin ShiftTime nd actual Time.I want to get the difference between these two fields in the time format itself.But its comin like.234222........Can u help me hygee

Hi Guys I'm new in ASP and Access and I 'm trying to create a login page. Please Help!! :confused: Thanks in Advance

Hi! I have to problems regarding VB6.0 and Access and some other applications... [b]1. I can not open a database from access.[/b] Dim mydb1 as Database Dim myrs1 as Recordset [b]Set mydb1 = OpenDatabase("MyDatabase.mdb")[/b] Set myrs1 = mydb1.OpenRecordset("student") The error appears on the bold text. It says either "Unrecognized database …

Hi, I'm a newb of ASP. Can anybody help me for the following topic? I want to make a questionaire using ASP with four options using radio button. Questions and answer need to store in an ms access database using this format(field): Question, opt1, opt2, opt3, opt4. Must have each …

When user selects an item in a combo box that has already been selected and stored in a data table. (1) I want the item in the combobox ghosted or not visible in the combo box. or (2) Give user a msgbox that says record has already been selected.

Hi everyone, I'm trying to update an access database using vb.net(2005). I have this code, But it doesnt update. [COLOR=#0000ff] Me[/COLOR][COLOR=#000000].STUDBindingSource.EndEdit()[/COLOR] [COLOR=#0000ff]Me[/COLOR].STUDTableAdapter.Update _([COLOR=#0000ff]Me[/COLOR].TrialDataSet.STUD.GetChanges) Please Help

Hello, I am a novice Access 2002 user and I'd like to delete all rows where the "category" fields says "buyer" as I do not need this information in my Real Estate database. For example, I tried setting a query in SQL view with these parameters: [code] DELETE FROM [dbRealEstate] …

I work in a school and my principal asked if I could create a database so that she can keep track of student benchmark scores for K-5th. I have been working on it since late November and pretty much done with it but have been modifying/adding things to it. I …

can someone help me. what is the code to print hard copy in visual basic 6.0 i do have a msaccess database and all the information in this database is already linked in VB 6.0. your help is highly appreciated.

hi can anyone help me how to compare user and password from a database like access... for example i have registered a user and password in access then when i input the user to VB and the password it will compare if the user exist and if the password is …

[B]IM DOING LEAVE MANAGEMENT PROJECT USING VB AND ACCESS[/B] [B]I finished staff registration and other forms .....I NEED HELP IN DESIGNING A TABLE ......THIS SHOULD CONTAIN THE STAFF LEAVE DETAILS WITH DATE.......HOW TO DESIGN TABLE.......[/B] [B]PLZ HELP ME [/B] [B]REGARDS [/B] [B]SCY[/B]

Please help me how will i solve my problem with login. The requirement is to terminate/lock the system, if after 3 attempts, the user failed to entered a right password. I used a some codes (indicated below). When i enter a correct username & password, it shows the next form. …

Greetings! I'm asking your help. It's about printing a record. I used ADODC and the data is in access. what i want to happen is that when i choose to print a particular record. how will i do it? please help me to solve this problem.. i have a deadline …

I have a contact manager in Access but I want to add an alphbetical index based on the field "Last name" - so by clicking on the M button you would go to the Last names beginning with M. Can any help me?:eek:

can anyone help me? How to encryption/decryption algorithm for mdb table? Private Sub cmdSearch_Click() On Error Resume Next HighlightText txtSearch, True If txtSearch.Text = "" Then Else Dim con As Connection Dim rs As Recordset On Error Resume Next Set con = CreateObject("adodb.connection") con.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & App.Path …

Here is a pretty standard Verify script which searches through a database for specific records and sends the user to the next page if the record is found. The problem the script seems to be unable to find certain records (6 our of 28 in this case). I have tried …

Hi I have a "Repair Record Entry" table and form where the form is used to enter the information and it will be saved in the table then. I placed a command button with queries written at the side of the textbox on the form so that i can be …

Hi, I am trying to deploy an Access database application that refers to a dll in VB code using a DECLARE statement. I wrote the dll in using VC++ 2005. I have tested the dll and it really does work fine, on some systems. The application runs on one computer …

Hello all, I wasn't sure what the correct forum would be for this question so here goes... I have kind of a strange problem (well, to me anyway) and I am having trouble figuring it out. I have a Microsoft Access DB that I have created that I have split …

I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx

Hi i'm new to VB6 and i just wanted to ask how to save the columns in a ListView to an Access DB... The format i use to save individual textbox to an Access DB is.... [code=visual basic 6] With adorecordset .Fields!Name = Text1.Text .Fields!Address = Text2.Text .Fields!Phone = Text3.Text …

I'm hoping someone can help me identify what I have done wrong in my code. I've created an "Update" button that will update a database with info from a form. BUT, whenever I run the app it errors out. Here's the 2 variations for the update I am playing with …

<%@ page language = "java" import = "java.sql.*" %> <%@ page import = "java.sql.*" %> <%@ page import = "java.text.*" %> <% String username,passw,passw1,compnam,tinn; username= request.getParameter("username"); passw = request.getParameter("pwd"); passw1 = request.getParameter("pwd1"); compnam = request.getParameter("compname"); tinn=request.getParameter("TIN"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String st = "jdbc:odbc:loginval"; Connection cn = DriverManager.getConnection(st," "," "); Statement stmt = …

I am developing a system that has to connect the website to the database. I have started designing the site and I need to connect it to the database and have options of creating new members, updating new records and deleting some records. If anyone has some solutions to the …

I'm Sean... a Semi Professional Musician and Management Information Technology student (former Computer Science) :confused: hehe!! right now I am on my 3rd year as MIT, and currently working on a SAD project about TPS (on VB/Access) and a Tax processing system on C... i've really searched for a website …

Hello, Does anyone know how to extract data from a record for a query? For example I have a sample number (Example: 1555A-S-070202-105500) and I would like to query todays date against it, the 070202 part of it. I would like to have Access show me all records with todays …

My problem is that i have been asked to try and find out how to, and to make a program in VB which is linked to an access database. I help out at a charity band thing which happens every week. there are three bands play (but that doesnt matter) …

can anyone tell me the code how to connect database in C..The databas3 may be either Oracle ,SQL Server Or MS Acess.. plz help me...