3,459 Topics
how to create a database in Ms Access and connecting it to forms that is created using swings in java using Netbeans 5.5.... can u please explain me with an example in netbeans 5.5 please
Hi! I am a teacher who has been appointed "tech guy" for our school science fair. I'm trying to build a database to handle the information and number crunching for the event. I've been working with Access, but we have Filemaker too. I'm pretty tech savvy, for a teacher (or …
hi, i need some help in this regard of creating a software, that manages the attendance of students, by taking their thumb prints.
i have a script that query the database for some information which include date field. my problem is i want the query to just show the date and the time not included.. here is the script that i am using.. btw.. i am using an ms access database for this …
I have been working on a database in MS Accesss. I am trying to generate a query in the SQL view but the introduction to SQL class I am taking did not cover how to incorporate multiple WHERE conditions. Here is the query so far... SELECT intFID, COUNT(*) AS TotalAudits, …
hello please help me. i want to search a data using from a textbox and a command button to search ..I have a i have a access database and 1 table with 2 fields ID and Name..im using Visual Basic 2010..please help me on second thought after finding a data …
Hello Below is my entire code of a mobile application. The 4th form with the ID "bookDetails" is supposed to be used to retrieve data from a database called butternut3.mbd. I am currently stuck on writing a code in the script part, for a user to search and view details …
Hi, I am using MS ACCESS. I want to make Do not click a button more than once. I made a calculation button. And want to be just one click. Thanks alot.
hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = …
hi guys, i'm having a problem manipulating the datagridview. i have an access database named "ETB.mdb" and a table inside it named "ETB" it is a read-only database and it has to stay that way, anyway, what i'm trying to do is to retrieve the data on the database put …
Dear DaniWeb Programmers, please help me with my problem. im trying to fetch rows in 3 TABLES using JOined Queries im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. Heres the code below: …
I work in a research lab and I'm building a new filemaker pro advanced 11 database to hold our study data. The variables that this database stores will occasionally be exported into excel documents and merged with exported data sets from another database. Unfortunately, the person who built the first …
How can I retrieve data from a DB in Access to labels, or radiobuttons in VB.NET? I've search and to retrieve data people usually show Datagrids. I just need to know how to navigate in records, by the number of their position (?) and to place that data in labels/textbox …
Hi, This is a from that take comment from the user. Everytime a user open this form, currentDate and Time will be generated although the user does not put comment in it. Today's date = 18/10/2010 earlier, when this user open this form, the date is still "18/10/2010" But, in …
[CODE]Guys I've a problem. I'm using access 2007. The file name has an extension .accdb . I created a table called 'login' in the db file named 'MySite_Database.accdb'. My HTML looks like this : [COLOR="Red"]<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="login.aspx.vb" Inherits="login_to_site._Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html …
Hi to all, sorry for the bad English, I am a beginner programmer but yet task to develop a payroll program for a company with 350 employees. The payroll program that I will going to make is separate from the time in and out program the company have. The Time …
I have a Subjects table with a field Prerequisites, which contains data similar to the Subject IDs in the same table. So for example a subject4 may have the prerequisites subject2 and subject3. The contents of the Prerequisite field are delimited by ORs and ANDs, meaning if there are more …
Hello... I'm a student who's only taken some basic coding classes. My project might be a bit ambitious for my skills, but I'm getting stuck on one small issue. I built an Access database for our personal library. I'm building a small application that will: 1. Display all records of …
I have a query that has two counts in an if statement. I need the query to return all values even if they are null once equated by count. I have tried the NZ function to no effect. Any help would be greatly appreciated. [CODE]SELECT REPRESENTATIVE.Country_id, IIf([CONTESTANT.Team_id] Is Null,COUNT(*),COUNT(*)-1) AS …
Guys, does anyone of you have Windows 7?... Okay, here is my problem can you kindy test this code in windows 7. [CODE=vb] Public Sub createAccessDSN(MDBPath As String, xDescription As String, xDSN As String, xUID As String, Optional xPassword As String) 'Creating the DSN #If Win32 Then Dim intRet As …
All, While not precisely a newb, it has been a long, long time since I've done Access 2003 work and that's all they have in my new job (yay). I used to know how to do this, but first the structure: [B]Table_A[/B] Key Subject Date etc. [B]Table_B[/B] Key Boy y/n …
I am currently creating a form for a shop database and this form is used to enter new record to the product database. in the form, we need to key in the code for the product and I want to have validation rule that checks the code entered is not …
How to use TOP(1) keyword in MS Access query. select * TOP(1) from mytable orderby mycolumn desc; this querry gives me error; Any other alternate to implement this code;
Hey Everyone I looked on this site but didnt find anything good enough to help me. I have a DataTable called dt. it has 230 records in it and 16 colums. I now want to put that table in a table in ms access called weapons. I have never written …
Hello, I have been attempting to export fields from an acesss query to a csv file. In each case the first time I export the file everything is perfect. However when I go to recreate the export (using the same query) the memo field is suddenly truncated. Any idea why …
[B]Hi, I get this error .... I have seen it posted before but no-one seems to have a solution so I am posting it again. I have pinged IIS, set permissions in folders, reset IIS. Any help appreciated [/B] [B][COLOR=#000000]HTTP 500.100 - Internal Server Error - ASP error Internet Information …
I have setup a global variable. I need to store in this variable the value of Max(RequestID) from tblRequests. Then, I want to assign the variable to a label control on a form when the form opens (On Load event). Then, I want to run a query to include this …
Hey everyone.. I have two tables, newTable and newTable2, I am trying to append newTable into newTable2.. They both have the same column names so I thought it would be cake.. If possible I would like it to remove duplicates also.. The code I have is [CODE]CurrentDb.Execute "INSERT INTO newTable2 …
VB6Query20071120.doc Hi VB6 I am trying to have 2 ACCESS databases open at the same time in order to populate the 2nd one with data from the first one. The problem is that it appears that I can only have one connection to a database at a time. Is this …
How to connect vb6 to MS access? I'm only an student and I wanted to have more knowledge about producing new programs and systems to be a better system analyst. We are assigned to make a biometric system using vb6 connected to MS Access..Can you help me? We dont have …
I am using C Sharp for front end and Access as back end. In the sales table I want to enter weight in folating point number. It calculate the total properly but at the time of saving it display error message that Input string was not in correct format. I …
In MS Access you can set the background to a specific colour when the field has the focus. This is done through "conditional formatting", using the "Field has Focus" feature. How is that done in VB.NET?
Need some help understanding Server 2008's infrastructure. Running a program that requires access to the Document and Settings folder. I have full admin rights but it's still giving me an access denied message. Any help?
First, sorry for posting this here, but I couldn't find a VBScript forum on Daniweb (which I find surprising). I'm working with binary data in several different projects. Below is an example of code that works to retrieve a static map image (PNG) from Google: [CODE]strFileURL = "http://maps.google.com/maps/api/staticmap?markers=2200+S+Western+Ave+Lisle+IL&zoom=14&size=400x400&sensor=false" Set objXMLHTTP …
I finally figured out how to auto fill a record in forms. YEAH! Yet I ran into a new problem. Sigh! tblEmployee holds frmEmployee information. qrySiteName pulls information from several other tables giving the details of each location. On frmEmployee, I have it to where when I select the SiteName, …
I've recently done a school management system with MS access Database . How can i embedd my database source in that project .Is there any solution? Help Please
How do you store data in the access database and also to retrieve it? and also a search engine for the database?
Hello, i need help please, i need to create an trigger in ms access 2007, probably by vb code, but don't know how. The issue: i created a database in ms access 2007 and i need to make an time trigger to show every time when opening the database (it …
Please help, Someone there who knows how to create an sql for ms access database and php. The Problem is the fields in the table are written with spaces and I am not gonna change it in any means because it is connected to a very large program and it …
I'm writing a query that will produce the athlete's id, their name (first name and last name combined into one column), the total number of games they have participated in, and the total number of medals they have won. This involves a number of tables. In one query, the number …
Hi I 'm trying to develop a database whereby all information input via vb 2008 will be saved into a microsoft access database. I've tried to populate a few information. The data was saved at that point, but when i reopen my system the next day, all the rows are …
Is there any way to convert microsoft access database to mysql data. Please help me
Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) …
I have a simple form in which i have a contact name combo box. The combo box gets info from a querry (name, contact number 1, contact number 2). I want the name to display in the combobox (which it does) and then contact # 1 and 2 to display …
Hi everyone! I have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri …
Can i create a Ms access database through java code? Can i place Ms access Database inside my project and can i manipulate them?
i need help. i am developing a webpage which is the user is able to log in,log out, register, and change password but my problem is the tutorial that i've seen so far is about mysql. i am using ms access database and i want to do this stuff using …
This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) …
Hello, I m working on windows application using vb.net 2008. My back end database is in MS Access 2003. If I deploy the project, then where does the access database is to be kept when setup is created..? Pls help me....
how do I link ADO data control with a protected access database ???
The End.