3,842 Topics
 | |
 | I am using java and ms access . Now I have two tables 1. issuedBooks - bookID, userName, issueDate, returnDate, fine 2. book - bookID, name, author, edition, cost , publisher now I want to show issued books in a table in java . So I used this SQL query … |
| | I am trying to setup a page on my website with a text input box and a command button. A user will type the serial number of their product and click the button...the result I am looking for is a message telling them if their product is in warranty, out … |
| | Hi, I am trying create a query that counts all records which have the field Hypotension=1 (which is Yes), but I only want to count the same customer once. For example: My table has 3 fields: RecID (primary key), MRN, and Hypotension RecID Cus# Hypotension 1 6 1 2 6 … |
| | I am trying to work on VIEW command of SQL. Whenever I write the SQL as [code=sql]CREATE VIEW PartOrder AS SELECT PartNum, NumOrdered, price FROM part;[/code] I get an error message "Syntax error in CREATE TABLE". I dont have any problems in writing SQL commands but whenever I mention CREATE … |
| | Hi All I am creating a database archiving tool,in which a user can delete all the data before a date he would specify.But the problem is i am not able to create a delete query which can delete a range of data. I had created the following query [CODE] <% … |
| | Greetings! I would request your expert help with suggestions on moving an existing database from FileMaker Pro v.8 to MS Access. How can it be done and what are the pros and cons of doing so? Thank You, Regards, nsb |
| | Hi, I want to create a form with 2 textboxses(starting number and ending number) and 1 button. When i click on button it is going to list all the records between two numbers in a report. How can i do this? Thansk |
| | we are able to query successfullu from a Column called "ParentUUD" (without space) using query "SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'" we have a column whose name is "Parent UUID" (with space) We are trying to query the column from PYTHON. we are getting error.I think the error … |
| | Hi.. i am running a multiple forums with many subdomains based on different country, we are using ASP script using MS Access database. I wish to get someone to make some modification , so that when the MS Access Database in the subdomain forum get updated, it will also automatically … |
| | Hi, does anyone know if there is a backup SQL statement in MS Access to backup the entire Database?  |
| | Hi All, I have put together a service delivery application in Access that needs to send SMS messages to technicians in the field. Any ideas on how I may achieve this? Regards  |
| | Hi All, I am developing a report generation web page in which i have a text box in which a user would enter a value and i have to extract similar data from my MS Access database. I have tried using wild card % but it is giving an error. … |
| | I have a from that displays an employees info when selected from a list. The employee then updates text boxes as well as combo boxes to describe a type of project they are working on. I'm trying to add what the employee selects to the Project table. Here is my … |
| | I am working in an organisation. In this we want to create a database in MSAccess (MSoffice 2003) about the system information about the computers. By using one software we have the following inforamtion in text format. In this, We want to craete the first part as the field name. … |
| | Hi There, I wonder if I could get help with something. I'm working on a DB for employees. Each employee has a position within the company, so, for example, "Staff Manager 1" and "Staff Manager 2" etc. I've made up a table called tblRole that holds the PK and the … |
| | I support a jet 4.0 database application that is deployed out to multiple users. These users have different types of Windows Operating Systems. There is some support from the vendor for this system, but they are not able to answer all problems. The data files live on a central server … |
| | Hey there everyone! I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them??? Thanks ;) |
 | Hello, I accidentally deleted a column in my Access database, and do not know how to "undo". The undo button isn't an option, so do I need to do some system re-store or something? |
| | hi, I would like to delete duplicate rows in MS ACCESS. Note: There are no PKEY in Database also the DB allows duplicate records. Please help Regards, DINIL |
| | Hi, I am fairly new at this so please bear with me. I created a table called vehicles with one field called vehicle. I then created a form to "Add a Vehicle" to add a new record which worked great. However, I had to go into the table and mark …  |
| | Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName [code]strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic[/code] But I am getting a runtime error "-2147217833". I have … |
| | I am trying to format a form in Access 2003 where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. …  |
| | We have a filemaker db collecting email subscriptions. We need to export those on a regular basis and import them into a listserv. We would like to write a script to have this all happen on it's own. Is this possible with FileMaker? There is a script in it that … |
| | I am trying to access a .accdb file from my c# app. when i run the app, it tells me that I don't have Microsoft.Jet.4.0 Provider installed. I know that I need the Jet provider to access MS Access files, I just don't know how to get or install it. … |
| | I have an Access database that I use to keep track of account and inventory information for my job. I am currently writing a C# app to allow me to search through and pull up the information from a couple different tables and display them. How can I access the … |
| | Does anyone know how to convert a .accdb file into a SQLite compatible format? I am looking to migrate an existing DB from Access to an app I am writing to add and retrieve the information for me without having to manually enter the stuff into 4 different tables. |
| | Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 … |
| | Hi, I have developed a complex database in MS Access 2007. The problem is that people from around the country will need to input data into the data base on a regular basis. With the data base being in our head office, I thought the easiest way it to make … |
| | Hey guys, i'm trying to create a database in Access, but i'm having problems, keep getting the same error, i've gone through it so many times but cannot see whats wrong with it, i'm getting a syntax error which highlights at the start of the Enrolment table, any help would … |
| | Hello all, This is my first post in a forum like this, I hope someone is able to help me! :) I found a post from about a year ago that explained how to use combo box parameters in a query, and I was wondering if there is a way … |
The End.