Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Zoon
  • Content: Threads
  • Order by date
  1. Zoon

    SQL for subtotals & grand total?

    This query is for an Access 97 database and it works OK. With it I get a total cost for each department. Department is not the key field, there are 40 fields. There are 50 different departments in the Department field & 10,000 records. SELECT [Department], COUNT([Department]) AS [SKU Count]...
  2. Zoon

    HTML table row problem

    Could somebody tell me why this calendar looks wrong with DECEMBER, but looks right without <TH bgcolor=BROWN>DECEMBER</TH> <HTML><HEAD><style>a{text-decoration:none}</style></HEAD> <body> <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 WIDTH=115 BGCOLOR=Yellow> <TH bgcolor=BROWN>DECEMBER</TH> <tr...
  3. Zoon

    Desktop Icons Move

    I have Windows XP Home on a Compaq Presario 6000. Sometimes when I start the computer the desktop icons are rearranged. I then drag them to where they should be. Why is this happening?
  4. Zoon

    WordPad won't Wrap

    Word Pad won't wrap the text even though I click View>Options>Wrap>OK. Up to a week ago it wrapped, then I set it to No Wrap. When I went to set it to wrap it stays on No Wrap. What is wrong?
  5. Zoon

    Sum of a Sum column?

    I have these 3 fields (and others) in an Access 97 database; [Department] a text field, [Quantity] a number field, [Cost] a number field. There are 30 different departments and 9000 records. This query works and gives the total cost for each department. SELECT [Department], SUM([Quanty]*[Cost])...
  6. Zoon

    Calculate a number field?

    I use a 6 year old program that uses Access 97 databases. I also have Access 97 and a beginners knowledge of how to use it. I want to add a number field (I know how) and use the number entered in this new field to calculate the number in another field (I do not know how). The fields are; Code...
  7. Zoon

    Order By 2 ways on 1 field?

    A text field named SKU has in it strings like these; 1005693, 88800245, ABC-5846703, XYZ-23710. How can I sort or Order a Select query using the first character in SKU unless the fourth character is a dash, then I want to use the fifth character to sort? The query should return this; 1005693...
  8. Zoon

    How is CD-R CD-RW recording speed determined?

    How does the computer know what recording speed to use with a CD-R or a CD-RW disc? I was setting the recording speed for a CD-R when I was told that the software knows the correct speed for any disc. Do I set the speed or is speed selection automatic?
  9. Zoon

    tek-tips problem getting e-mail to me

    When I log on to Tek-Tips I see this message &quot;We've recently had a problem getting your e-mail to you&quot;. I click to indicate the e-mail address is OK, because it is OK. What could be causing this problem? Is upper case and lower case important in an e-mail address?
  10. Zoon

    Jet 3.5 SQL and tables

    I am using a commercial database program that was made using Access 97 and runs on Jet 3.5. I do not use Access to run this program. Each table is in a file like HISTORY.MDB or CUSTOMER.MDB. The program updates the required tables when entering data in a form for data entry. There are about 20...
  11. Zoon

    How can I copy a column sum to another database?

    I have 2 databases, customer.mdb has fields ID and NUMBER, sales.mdb has ID, CODE and AMOUNT. Customer has 2000 records and sales has 20000 records. ID and CODE are text fields, NUMBER and AMOUNT are number fields. Customer.mdb has data in ID and there are no duplicates of ID it is a key...
  12. Zoon

    Copy a folder to a CDR by one click?

    I have Windows XP and I want to copy a folder from the C drive to the F drive, a CDR, just by clicking a icon or button. I tried Xcopy in a batch file but it did not work. I do not know VB. This is so that a regular computer user can easily make a backup each day. How would I go about doing this?
  13. Zoon

    close dial-up connection after using IE in WinXP

    I recently changed my ISP, before when I closed IE the dial-up connection would be automatically disconnected. With the new ISP I have to do several steps to disconnect. How can I automatically close the dial-up after closing IE?
  14. Zoon

    How to copy a record from another table in another folder?

    I have a commercial database that uses a jet engine. I make a backup of this database in another folder on the same computer. How can I copy a record from the backup database into the working database using SQL?
  15. Zoon

    ADD COLUMN in a specified position?

    Can I add a column to a jet 3.5 database in a specified column position using SQL? I tried the following and they did not work; ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) BEFORE [Entered Date], ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) AFTER [Description]. This works...
  16. Zoon

    ADD COLUMN in a specified position?

    Can I add a column to a jet 3.5 database in a specified column position using SQL? I tried the following and they did not work; ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) BEFORE [Entered Date], ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) AFTER [Description]. This works...
  17. Zoon

    Word Pad Open all files?

    How can I make Word Pad show all files when I click on open, not Doc as it does now?
  18. Zoon

    Why SQL syntax error in alter table?

    I want to make a text field wider in a database that uses jet 3.5, and SQL is the only way that I know of to query this database. I get '3293 syntax error in alter table statement' when I run this; ALTER TABLE [Product] ALTER COLUMN [Description] TEXT(30). The publisher of the program will not...
  19. Zoon

    SQL to widen a Text field?

    The company has Windows 98 computers and an inventory database using MS Jet 3.5. Using SQL, I need to make a text field wider, from 16 to 20. I am a SQL novice and when I tried ALTER TABLE [Product] ALTER COLUMN [Product Code] TEXT(20) also ALTER TABLE [Product] ALTER COLUMN [Product Code]SET...
  20. Zoon

    AlterTable with Default Date?

    The company has Windows 98 computers and an inventory database using MS Jet 3.5. Using SQL, I need to add a date field called [Date First Received] and have a date like 6/29/02 entered when the record is created. I am a SQL novice and when I tried ALTER TABLE [Product1] ADD COLUMN [Date First...

Part and Inventory Search

Back
Top