student2
Last Activity: Jan 28 '10, 01:54 PM
Joined: Aug 11 '09
Location:
-
How do I create a Data Dictionary using Oracle Designer
Hi,
I'm fairly new to Oracle (I'm using the 10g DB and Developer Suite)
I have an assignment that requests the following:-
DATA DICTIONARY
"Use Oracle Designer to produce a list of attributes for each entity."
I was able to produce the ERD, DFD and PD, however, I do not quite know how to begin to produce the Data Dictionary.
Any help in this area would be appreciated,... -
I redid it again and this time it works thanks anyways :-)Leave a comment:
-
Access Calculations
Hi,
I have an Access database 2003 for product, orders and customer information.
I've joined them to determine the most sold product.
The results of my query looks like this:-
ProductID NumberOrdered
3001........... . 2
7958........... . ... -
It certainly is a frustrating place to be!
Thanks Jared this was in fact the solution.
:-)Leave a comment:
-
HTTP 500.100 Internal Server Error- ASP Error IIS
Hi,
I'm a student looking for any recommendation to finding a solution to the following problem.
(Hope I'm posting in the correct 'section' of the forum, since my error says both IIS and ASP) I'm not quite sure if it is an IIS problem or an ASP or either :S
I'm running IIS on my WIndows XP Pro OS.
I'm connecting an Access database (.mdb file) to Dreamweaver CS4.
I've made the connection with the... -
student2 started a topic HTTP 500.100 Microsoft Jet database Engine could not open the file.. already..in IISHTTP 500.100 Microsoft Jet database Engine could not open the file.. already..
Hi,
I'm a student looking for any recommendation to finding a solution to the following problem.
(Hope I'm posting in the correct 'section' of the forum, since my error says both IIS and ASP)
I'm running IIS on my WIndows XP Pro OS.
I'm connecting an Access database (.mdb file) to Dreamweaver CS4.
I've made the connection with the following string
"Provider=Micro soft.Jet.OLEDB. 4.0;Data... -
Ah! Thanks a lot NeoPa. I did not even realize that, thanks for bringing it to my attention.
:)Leave a comment:
-
Thank you very much, it was very informative, I've tried it before (ADezii's) but somehow I got stuck. I will look at it all over again. Many thanks for the recommendation!
:)Leave a comment:
-
MS Access database online via website
Hi,
I'm trying to help another student in our class to host an Access Database on line for a school project.
1) I tried so with ODBC- DSN (setting this up)
2) Read tutorials and guides on IIS (Inetpup...wwwr oot)
3) Also on Data Access pages, Dreamweaver, Asp/Asp.net (all of which I'm new too)
4) Other methods.
5) From case studies, research and other related articles... -
Ok, thank you very much!
I think this will work NOW.
Thanks again :-)Leave a comment:
-
Thank you both
Then I must be doing something incorrectly
I'm using Access 2003.
I'd re-read your posts and try at it again.
Thanks a lot! :-)Leave a comment:
-
Thanks AJ for your reply.
I am able to create the shortcut from the AutoExec that would automatically start the Database. However, I cannot change the icon to what I want.
That's what I'm trying to say, hope it's now clearer. :-)
Thanks!Leave a comment:
-
Changing the MS Access Icon
Hi!
I want to create a command from my Desktop that would automatically open my Database from that button or Icon.
I've tried going to the Properties of the AutoExecute Form (SwitchBoard) to create a shortcut, however, I'm unable to change the icon from the Macro Sign.
I've also tried my desktop by right-clicking and choosing Shortcut and Changing the Icon and assigning the location. However this Option still... -
Ok ChipR. Thanks a mil, I now got it to work.
Appears that I had line of code in an incorrect order......well all I did was adjust the order and it works thanks again :-)Leave a comment:
-
Hi ChipR.
I tried it, however, it does not seem to be functional on my end.
If my datatype for CategoryName and AuthorName is "text" does that make a difference? (just a wild guess)
Thanks again!
C.R.Leave a comment:
-
Thanks ever so much ChipR, I'm going to look into it.
What I did in the interim was to present a message box on the form's load that would advise the user that a blank form would mean--- no records.
This I thought was unprofessional and not nice design but I did need something to advise the user and not have him/her be at a lost.
Again I thank you ever so much for your responses.
Appreciative!
C.R.Leave a comment:
-
Error Message for Query/Form.
Hi :-)
I've designed a query that gathers its information for two tables:-
1)Author and
2) Category
My selection criteria for this query is Author.AuthorNa me [Enter Author Name] and
Category.Catego ryName [Enter Category].
This query works well. However, if I do the following:
"Joe Public" as the Author and
"Faith" as the Category... -
Ok I'd try that, thanks! :-)Leave a comment:
-
Re-order Level
Hi!
In my database assignment I have a query called "Balance" which is derived from two queries and the main table:-
1) TotalSales
2) TotalReceipts
3) StockDetails (table)
Total Sales represents the SumofAmtSold and
TotalReceipts represents the SumofAmtRcd
StockDetails the OriginalStock is taken
Balance therefore is:-
( SumofAmtRcd + OriginalStock)...
No activity results to display
Leave a comment: