1,557 Topics
 | |
| | Hi, I Have data stored with the following structure: Version Month Amount 1 Brand1 Jan 100 1 Brand1 Feb 200 1 Brand1 Mar 150 1 Brand1 Apr 500 .. .. .. Id'like to transform it in the following table: Version Jan Feb Mar Apr May ... Dec 1 Brand1 100 … |
| | I inherited a database using Workgroup security. I was given the Admin priveliges but I find it is a bit too restrictive for my department. Is there anyway of disabling the Workgroup security so I could put in a designer security instead? Thanks for any help, Papa |
| | Hi @ all: I've been looking for an ODBC-Driver for Filemaker. I've searched the web for hours, but i always found Trials of ODBC-Drivers, and that Trials were only for MAC OS. In an other forum, people where talking about a DLL, called "fmfmp50.dll", which should be an ODBC-Driver, but … |
| | I work at a college and we have a file that looks like this: ID DEGREE 0001 BA 0002 BS 0002 BA 0003 BA 0003 BA 0004 BS 0005 BS 0005 BA 0006 BA 0006 BA 0007 BS 0007 AA 0007 BA Each student has a unique ID and could … |
 | My company has been using an Access 2003 database for a couple years now and the person who previously worked on it just left, the problem is he never gave me the password to unlock the Visual Basic editor window, and I can't seem to contact him. Does anybody know … |
| | Hi I have create database by MSaccess in the my computer and I need publish on the Internet to use direct from website. the database contain tables, queries and forms that is as application. I want open the application through the internet. I have background of MSaccess, and what comes … |
| | I have two databases and want to combine them. I tried sharing the tables but could not make that work. I tried importing the fields into the master table and that did not work (could not find a copy button). So I laboriously typed in the fields (copied them to … |
| | heloo. i created checkboxes in my web interface and each time a checbox is ticked the value is stored in database but however the checboxes which is not selected , the value is stored as Undefined in database. where did i do wrong? here is my coding for the checkbox: … |
| | I have a database used for Phone record auditing. I am trying to see whether it is possible to have labels within a section disappear for 1 page but appear for another. I'll explain below. In the page header, I have it display the customers name and phone number as … |
| | Hullo, I'm an Access novice programming a db for data entry and would be very grateful for any help - I'm stuck on this one! When I attempt to save a new record on a form, I'm getting an error that reads "The record cannot be deleted or changed because … |
| | 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] <% … |
The End.