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!

  • Congratulations Chriss Miller 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: ecojohnson
  • Content: Threads
  • Order by date
  1. ecojohnson

    Populate random data into a table

    Hi everyone. I am trying to create a table that has two columns, column1 and column2. I want a loop so that column1 starts with 1, and end with 2000 (counting up by 1). I want column2 to have a random number between 1 and 999. I have each of these working separately. For column1, I have...
  2. ecojohnson

    Adding a date range to filter results

    Hi everyone. I am trying to create an excel report where I specify a date range on one of the worksheets. Cell A1 might be something like: 4/1/08, and cell A2 might be something like: 4/30/08. The remaining worksheets are set up so they each have various information on them, and this...
  3. ecojohnson

    Help with a date formula

    Hello. I manage a permit tracking database and use crystal reports. I am creating a report where I want to count the number of permits where the date the permit was issued was in the current year - without including permits from the current month. So, for example, I would run the report today...
  4. ecojohnson

    'Save to file' not working

    Hi everyone. I downloaded and installed a 120 day trial version of SQL Server. This included the entire suite (query analyzer, profiler, etc.) I was trying to run a trace using SQL Profiler, and then save this trace to a file, but ran into a problem. On the Trace Properties dialog, there...
  5. ecojohnson

    Inability to create a global header

    Hi everyone. Is it possible to create a global header? This would be where I could create multiple reports that all have the same header (rather than recreating it every time). I know this question must have come up before, but I don't see anything specific to this. On one of my searches...
  6. ecojohnson

    Query question

    Hello. I have a problem that seems absolutely trivial, but I cannot solve it. I have a MS-Access database table (called REVIEWS) that has the following columns: NAME NUMBER Andrews 12 Green 4 Jones 8 Smith 15 Green 10 Jones 9 My goal is to write a query that returns the person with...
  7. ecojohnson

    Distribution groups pounded by SPAM

    Hi everyone. I am a fairly new user to Exchange 2003 and I apologize upfront for any "beginner ignorances" I may have. I have been using Exchange 2003 for about a year now. We have a small little spam blocker and it seems to work. www.vamisoft.com. Yesterday, around 10:00 AM PST, I started...
  8. ecojohnson

    I will never pass

    I am struggling. Are tests supposed to be this confusing? I took a practice exam last week. There was a question: You are a desktop admin, and you are asked to assign a standard application using a windows installer package. You attempt to do so, but an error occurs. You want to deploy...
  9. ecojohnson

    70-270 question

    Hi everyone. I am studying to pass the 70-270 exam. I have taken a class, and have three separate books which are designed to "help" me pass the test. I took a practice exam last week, and out of the 50 question, 9 of the questions were question I have never heard of before. They...
  10. ecojohnson

    Table border

    I am trying to build a table with two columns, with a border around the second column. Everything I try doesn't seem to work. In this example, I would like to have a border arouond the &quot;Blah Blah&quot; section. However, if I place a <TD width=&quot;460&quot; border=&quot;2&quot;> for...
  11. ecojohnson

    I work for a company that has an es

    I work for a company that has an established well selling product. We are now working on moving our product to the web for the first time. I am looking for any design ideas that anyone may have that could make our web page look a bit more classy. Here’s a little bit of background info: Our...
  12. ecojohnson

    Creating a windows icon

    I have an image of a phone. When I created this image in Paint Shop Pro, the image is of just the phone, and that's it. However, when I try to create a windows icon out of this, I save it as a bitmap, and when I look at it (in paint, not psp), it has a large white background. How do I save...
  13. ecojohnson

    Incorporating two applications

    I have two separate apps that I am trying to combine into one app. The first app is just a standard winsock app. The second application is a simple SMTP app. The goal of combining the two is this: if the first app creates an error, I want to send an e-mail using the SMTP app. So, on the...
  14. ecojohnson

    Error handling

    I am new to Visual Basic (one week experience). I have a program that utilizes winsock. The program is the &quot;sender&quot; which sends data to a remote computer. It's incredibly complicated, but works rather well. However, there is one nagging problem. Our users tend to occasionally...
  15. ecojohnson

    Winsock

    I am very new to programming in VB. I am currently trying to rewrite a piece of code that deals with the winsock control. The current program is extremely complicated, so I am trying to break it down piece by piece. My goal would be to create a simple winsock program on my own pc, so then I...
  16. ecojohnson

    Sorting order in a query

    I use the following logic for one of my queries: SELECT Number FROM DB ORDER BY Number ASC However, if my numbers are 1-10, it comes out in the following order: 1,10,2,3,4,5,6,7,8,9 Is there a simple way to make this order go logically (i.e. 1,2,3,4,5,6,7,8,9,10). I'm sure I can come up...
  17. ecojohnson

    Javascript newbie - function question

    I'm guessing it's probably obvious, but does anyone see what's wrong with my javascript function? I don't see it. function Delete() { if (confirm (&quot;Are you sure you want to delete the selected record?&quot;)) { if (document.forms[0].List.value=(&quot;New&quot;)); { alert(&quot;You...
  18. ecojohnson

    using CFFORM

    I've got a weird problem that if anyone has an idea on how to resolve it, I would love to hear it. I have a form that has a list of text boxes. There is one value for the text boxes that is a default value and therefore, it is not a valid entry (the user must change the default value to...

Part and Inventory Search

Back
Top