1,597 Topics
 | |
| | 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 … |
The End.