1,597 Topics
 | |
| | Hi everyone, i am someone with a weak database background and i have been given a project to design a database for a convenience store which will be used in a customer relationship Management system can anyone offer me any help, thank you. Am not asking for my work to …  |
| | [code=sql]CREATE TABLE Persons ( FirstName VARCHAR, [Last Name] Text, Gender int, [Date Of Birth] DateTime, MaritalStatus Integer, IsMarried Bit, PersonalIncome Money, HouseholdIncome Currency );[/code] Can u plz tell me where I have to write this Query in MS-Access to craete the Table. |
| | Hi, I have a Filemaker 7 database that has been developed for me for my fine art photographs. I have a table of Galleries (who stock my work)/Table of all my images etc. I want to list all the images the gallery got delivered under a delivery note number eg … |
| | I need to [U]create [/U]a data file called students.dat and [U]insert [/U]a few records into it. I need (3) fields: 1) student id no. 2) last name 3) first name I thought it would be pretty straight forward, but I get a compile error: Invalid Outside Procedure and "students.dat" is … |
| | I am to create a form with 2 text boxes to receive numbers as input and 1 command button that displays a message box containing the larger of the two numbers. To do so, I need to write code in the Click event of the command to call a user-defined … |
| | Hi, guys I don’t know if anyone can help or not? I've made a form for a search list using an SQL query which is linked to my form. Basically the user selects a class of a car and the price is shown and then the user inputs what dates … |
| | This is my first exposure to arrays. I need to create a 1-dimensional string-based array with five elements. I need to assign 5 different names to the array. Use a for loop to iterate through each of the array elements, displaying the names in a message box. I would truly … |
| | I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this: [code]CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2 MEMO, Check3 INTEGER, Check4 DOUBLE, Check5 DATETIME, Check6 BOOLEAN) VALUES (1, 'DefSML', 'DefLRG', 0, 0.0, …  |
| | Hi! I'm a foreigner working in japan and my job has recently put me in a position where I have to use Access for the first time. I've managed to create some tables and establish relationships between them, but I got stuck trying to create a form with subforms. I … |
| | Greetings, I'm using Flash MX connecting to an MS Access database via JET. I've stored dates using Flash/Jet into my database as 'dd/mm/yyyy hh:mm:ss' into a DATE/TIME field. However I can't update because of the WHERE clause as I am not specifying the date correctly. I believe syntax wise I … |
| | I am to develop a web based application for a telephone company. I am a novice so plz be deliberate and detailed in your solution. The company has a set of exchanges at various places and needs a daily status of their circuits and calls made by the customers at … |
| | hi i am trying to do a simple access database, with quantities, and a query with a report I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type … |
| | Hi, I have imported all my tables from Access and trying to get up to speed with filemaker on my mac but I'm having problems. I want to copy two fields in table view and paste them into 50-100 other records but I can't see how to do this. Firstly … |
| | Hi guys, I'm fairly new to MS Access and I am running Ver.2003. I have a problem with comparing a Excel speadsheet with an Access DB. The result I require is as follows.... If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then … |
| | hi everyone. just had a question. iam trying to link ms access to a sybase database which i was able to do through odbc. but everytime i link the odbc driver keeps prompting for the user name and password to connect to sybase. is there a way to save this …  |
| | hi, i hv a residential facility reservation database in which the facility can wither be a hotel or a guest house. Now, i hv created these tables(along with many other) ############# Facility Table Facility ID Facility Type Name Number of rooms Address City Phone ############## Table Hotels Facility ID Tieup … |
| | I'm looking into creating a Access database for marking my students and so they can get there marks online. The online part is much later mind you but that is my goal. I need help in the structure of my tables, quaries and reports. I've been using access for a … |
| | Hi, Does anyone know how to make ms access online & shared by different users? Thx... |
| | Hi i am making a table where i have different currency fields showing the salary of different staff and then a total field where i can calculate each staff's salary on rent, transport etc... now how do i make the total field show the total i.e. addition of rent+transport+education |
| | I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem … |
| | I need to calculate the approximate current age in years of patients at a clinic. We don't have the birthday of all the patients, but we know how old they were when then first registered and we know the date they registered. I am doing a calculation which returns some … |
| | Hi there, I am finished writing a filemaker pro database ready to be used on the field. Everything is fine in the .fp7 file. Everything works great. However, after compiling to a runtime app, it refuses to export PDF files. When I create a database and want to export some … |
| | Hello I need help in microsoft access. I am creating an electronic database so i need 2 events, 2 resources and 2 agents for example event (order) resources (product). and i also want to know how do we link the table with each other i am talking about relationship Thankyou … |
| | I have a list box set to simple multi select option. I want to be able to pass those options to a text box. If I have multi select set to no, the value appears in the textbox fine. Whether I set it to Simple or Extended, it doesnt seem … |
| | First hello to every one in this forum. Well I am using MS Access 2003 for building a database. [B]I am usign 3 tables.[/B] [LIST=1] [*]Students [*]Books [*]Request [/LIST] Both student and books table has one to many relation with request table. I am using MS Access Forum for all … |
| | Does anyone have experience with "Actual Installer" by Softeza Development? I am looking for a product to create installation packages for Access mde runtime distribution. |
| | I have 2 forms; one called frmLogin and another called user_info. On frmLogin I have a text box called USERNAME and a command button. When you click the command button the following code is run: [COLOR="Red"]This Code Works (Or atleast It should)[/COLOR] [ICODE]Private Sub Command29_Click() Dim strUSERNAME As String Dim … |
| | i just wanna ask if it if possible to make columns n ms access and how... because i am making a personal data sheet thanks in advance more powers and God Bless You all |
| | hi i want to do operation on image...i have extracted the pixels of small window of 15 X15.. now i want to save that matrix in ms access 2003. for the further opeartions.... have the data in 2-d array say a[15,15], and since there is no build in data type … |
| | Am Samitha from U A E,but am an Indian completed M C A.Am married and my husband is a textile engineer. I found this site in google and registered as i have to complete a new project in VB 6.0 for my husband's company. i have a doubt in inserting … |
| | I have developed an access database for my company and want this to be available to multiple users remotely from different offices. I have been told that i need to migrate to MS SQL Server. Is this the case?? If so how do i do it? If not what do … |
| | Hi folks This will be my first ask for help here;) I'm working on a database at the moment and have exhausted my resources on this one. I have a report with an underlying muti-table query. The report uses an input box to set the date criteria rather than Parameter … |
| | Howdy All! Here's what I have and what I'm trying to accomplish. I have four reports in access that I run once a month. The reports are designed to hit on a query that pulls the records needed for a specific client based on the previous calendar month. Basically, each … |
| | there a way to get this info about my tables in a text file or anything that can be copy paste . i have many tables so i cant write them one by one? Properties DateCreated: 08/05/2007 11:38:58 PM DefaultView: Datasheet GUID: {guid {A79F9FC7-D630- LastUpdated: 09/05/2007 12:18:31 AM 47FB-A227-EB5202999268}} NameMap: …  |
| | Goodday all, Just tried to install MSDE, no sooner then i click the intall icon, i get this message "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." Now i took a … |
| | i want sample code with Html with Ms Access.....i want urgently,, |
| | Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base. |
| | Okay, this is the situation. We are trying to set up a database where we input individuals for their personnel evaluations. We created a button in the form window and linked it to a macro that updates the "Date Due" block based on the date in the "Date Completed" block … |
| | I would like to append bookings in a database that are older than 2 weeks old, what is the criteria to do this please? thanks |
| | i wanted to restrict the national holidays in validation rule (msaccess),i could restict one holiday ex:-15-aug every year by applying ([hdate])<>15 and month([hdate])<>"aug" but when i tried to enter two holidays ex:-([hdate])<>15 and month([hdate])<>"aug" AND([hdate])<>26 and month([hdate])<>"jan",it did not work.Help please. pramoda |
| | Hello Daniweb Community, I wish to use a microsoft access database for my website. I want it to do the following: 1. work as a login script 2. work as the points script I wish for users to log in using microsoft access - can I get a script for … |
| | |
| | Hello, hope all people around will be fine and enjoying programming. I want to do get data from the database which is available on internet domain while my application is window base application. Is there any complete method i can get data from the database. |
| | Hi Guys, I need your help. I have created an Acccess application using forms to view, update and delete data. Is it possible when I delete a record using a button on a form, that the record is deleted from the table and goes into a temp table where I … |
| | Hi guys, I'm in a real spot of bother and this is really beginning to get me down. Basically, I need to program a class which will connect to a MSAccess database. I'm using Visual Studio 2005 and C#. I'm really at a loss for what to do. I've looked … |
| | how can i make an error message appear for a input mask i have an input mask that allows only 3 digets to be entered, but i want to show a message if someone enters this in wrong, how can i do so?  |
| | I have a control in an access database that holds credit card numbers. I want to format the control so that it only displays the last 4 digits the first 12 digits just displaying an X so that it will appear like this XXXX XXXX XXXX 1245 What is the … |
| | I have a query to find dates based on Between And criteria but I can't pull up anything in 2008. all 2007 dates work properly. What am I missing? Thanks |
| | I was wondering is there anyway to wrap the text in the columns? Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own. :?: |
| | Folks, Many years ago I worked as a dBase III programmer. In my early 30's I left the field of IT to persue another career. Today I am required to develop databases for a variety of stand-alone (PC) applications. I have Access to construct the database but I need advice …  |
The End.