1,597 Topics
 | |
| | Hey guys, quick question. I have a movie table which records information about certain movies. See below for the table structure. id Title Length ------------------------------------------- 1 American Pie 160 2 Van Wilder 115 3 Not Another Teen Movie 115 4, Road Trip 130 5 Shawshank Redemption 130 6 Scarey Movie … |
| | hi, im a student and have my own website. i want to offer my user's a forum but ...well to be honist i have no bloody idea how to create a database. ive never needed to and need a access database for phpbb3 forum. can anyone help me?? p.s will … |
| | help me how to select the record between two date........................................... |
| | I have a really weird thing happening in my database. It used to work fine but all of a sudden now when I preview the report, it shows up too large. Please see the pictures to understand what I mean. I have tried undoing every change that I had made, … |
| | Hi The menu form that starts up when I open access has a bug in it...I wanted to close the form when a certain condition exists but I used the quit command (instead of close) so it quits access completely! I cannot get in to fix my bug. Is there … |
| | Hi, first post, and am a real novice, looking at the problems and solutions posted here. I have a database (Access 2003) where I want to change the name of a field within a query (to be used in forms and reports), depending on a decision the user makes. Can't … |
| | hi i have a window application, wherein i have to choose the database,its table and rowfields present in the table at runtime. Now i want to remove all the duplicates from database. my database is access and whichever row field the user chooses the duplicates should be removed leaving the … |
| | hi everyone, I have my website which i used microsoft access as my database. everything's working fine except when i submitted the site to my boss for approval, they rejected it because they dont want me to use ms access as our database because they said its not a strong …  |
| | Hello Friends, I am a student. I have to complete a project and would like to learn few things from all you experts on ms access. I have to make a personal contact directory with id, date, name, address, phone, email and photo. To feed data, I have to make … |
| | Am supposed to be programming a few forms in Ms Access and the forms seem too crowded that this might not happen on a single access form. Question is there a way i can bypass the 174 max limit num for controls per form because when i get to some … |
| | I have a table with data that i need to plot on a graph using pivot charts and selecting data for a particular patient number that is repeated severally someone with an idea. |
| | I can open most of the FileMaker files on our network. But all of a sudden I've been getting errors when I attempt to open a couple of the files that were working fine all these years. When I try to open these problematic FileMaker Pro 5.5v1 files, I get … |
| | Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section. I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried [ICODE] total = "SELECT COUNT(*) FROM Product" [/ICODE] … |
| | Hi there, Just joined the community! Been having trouble all day with the following select statement and MS Access database: [SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC] The [((date_of_referral >= #9/21/2008#)] section of works, so all dates … |
| | Hi, Im not really sure if this is in the right forum but it is about MS Access so i thought here was as good as anywhere. Basically i am trying to make a front end for an ms database - and to be totally honest i dont know where … |
 | 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 … |
| | I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it? |
| | Hello, I am using TransferText to bring a text file into an Access table. Is there a way to turn off the Import Error file that is produced as a result of improperly formatted text? Thanks! Mark |
| | Hello, Can anyone help me add a column to my Access table? I would like the column to be populated with a number that iterates from 1 to the end of the file. Thanks for your help! Mark |
| | I am trying to import several files to access. I have the code to search the C:\ drive but I need to look thru all the folders also. Below is what I have so far the works. Thanks in advance for any help. Wayne [code] Dim strfile1 As String Dim … |
| | Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others Any recommendations greatly appreciated Thanks |
The End.