General Forum

I have books and i have enter them into my database using microsoft access. Entities are:Vendor,Book Title,Quantity and price Student entities:Name,Book title,Book price,Quantity issued,Total allowance When the book issued to the student i want the quantity to be reducted from the system for book entered.Students are given P2000.00 for...

Im triiing to run a asp application on a local machine. My iis is installed and i have dreamweaver installed. When i start dreamweaver and then hit f12 to see in iexplorer everything work fine but when i triing to start it from anywhee else it doesnt want to start? anyone have a clue why?

Can any one guide me how to launch the installed application immediatley after the Finished screen button clicked. Once the user clicks the finished screen "Close" button, i need to launch the installed application. I tried with installer class. Sample code is given below.I have created a class library and within that an installer class. I tried...

I am new to writing a stored procedure so any help would be appreciated. I want to fetch a list of a list from 2 tables. I have a folder.id which points to doc.parent_id. I want to get a list of documents where doc.create_date is 30 days or older. It does not need to be a stored procedure but I want to know how using SQL without writing a program....

I have a rather simple system programmed where I have a large table format that was used to create a form for the user to enter new records into the table. Most of the processing is coded in vba for saving data and opening new records-- problem is that when I close the form via a doCmd.close, an extraneous record is written to the table with...

:( HI people, Just wandering any ideas on making my database graphs ect move when showing on a form?? ie so the bars will go up and down?? :(

I am brand new at this access thing and am kinda learning as i go. Lets say i got a database with name, email, and favorite hobby. What i want to be able to do is run a query based on hobby and have it return to me the email addresses(this i can handle), .....this is what i dont get: i then want to export this list of email addresses to the...

hi guys, thankyou Banfa for reply. i have one new problem.when i click submit button in html file. it dispalys File Download-Security Warning Do you want to open or save this file? Name:Confirm.asp type:Active Server Document From:

how can i connect turbo c application to access database please mail me at mcool1230@gmail.com if you know the answer

hi all, can anybody tell me.what is analyze statement in oracle?what is the use of analyze statement and how it helps in explain plan? second is,what is associate statistics?what is it function? :confused:

I have created a software to receive data from an equipment through RS232 communication. It is a simple application of the RS232 class. The software does receive strings from the equipment every time an event is triggered on it. The Expecting reading data is expected like this example: {Rd,d:02123579ABCDEF000098EB18, ......... If so, I...

We have Oracle: Version 7.3.3.4 on Windows 2003 server and HP: HP/UX 11i. We have to copy user profile from main server to a backup server box in automated way to provide access to tables etc. from front end application. Whenever we create a new user account, I don't want to do same manually on the backup server. Is there any automated way of...

Hello, i have created a new database IMD510. i am able to startup and shutdown the db without any problem. i am able also to access the db SQL> connect sys/manager as sysdba Connected to an idle instance. BUT i am not able to connect into it when i access in the way specified below: hostname% sqlplus system/manager@IMD510

Hai , I am new to winHTTP. Can anyone point me out a good website to find few startup samples and details about winHTTP. Please help me out to start winHTTP. :confused: Any help appreciated. Saravana Kumar

Can anybody tell me about how can we recognize Character from any image file?

does anybody play any musical instruments here? im a drummer, have been playing for 11 years now, and loving it...

I need to know the commands in DOS to create a batch file that produces a spinner in DOS. I am in desperate need. I have searched all over the web and have found nothing. I also need to know if I can save it to a CD or not. Can anyone help me please!?

i have e commerce project at my university..and the project is about selling computer hardware.. but i dont know how to make my data base..so could u help me pls?

I have figured out part of my last posting. What i still havent figured out is how i can send email address to outlook. I have a bunch of email addresses in my database and want to run a a query to pull out select ones based on different categories....and then send these email addresses to the "to:" field in outlook. Is this possible??? Please...

Can anyone please help with this? when i run the following query, using SELECT*, SELECT * FROM tbl_artwork, tbl_artworkmedium, tbl_medium WHERE tbl_artwork.artworkID = tbl_artworkmedium.artworkID AND tbl_artworkmedium.mediumID = tbl_medium.mediumID AND `dateCreated` =2002 I get more info than i need, (lots of IDs displaying) and type...

Hi, I'm trying to change the column name - date to Sdate in all the tables in my database. As i have many to change so i tried to search all tables and have it change automatically rather than manually however my query doesn't seem to do the job? requesting assistance from anyone is appreciated thank you! DECLARE @sSQL AS VarChar(500), ...

Quick Question. I gotta a database with fields firstname, lastname, and hobby, etc. I dont want to allow duplicate entries for the name. For instance....no john smith twice....but there can be a repeated john. Well i created a multi-field index and that is fine....the problem is that my form is very long....there is lots of data to enter and the...

Hi all, Please help me out... i want to convert the to_char into number format.... please let em know how to do it... for eg: i have a statement : to_char(p_number, 'S000000') this converts the number into proper format.... now i want to convert tht 'S000000' char back to the original number p_number..... Can anyone tell me...

Hi. im trying to setup a filter for a report. Let me explain what I would like to achieve. I have a form called Invoicing, here all the data is put in about the invoice, I then have a report also called invoicing. I would like to be on the invoicing form and click a button saying view invoice, this then takes the invoice number from the form and...

I need to set a default date on a form that when it comes to a Monday, the form from and to dates will default to the Friday to Sunday of the previous week. For all other day, the form should default to the previous day. Can anyone help? Thanks in advance