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: scroce
  • Content: Threads
  • Order by date
  1. scroce

    hiding the database window

    I have a problem where the database window keeps popping up, allowing users to see my tables, forms, modules, etc. I disabled all the shortcut keys and unchecked "display database window" in tools>startup. the database window mysteriously re-appears if a user minimizes the adp window and then...
  2. scroce

    windows 2000 paging file size

    what are the ramifications of increasing a paging file size? I have win2k pro running with 256k of mem. Some of my users (including myself) have lately been getting the "system low on virtual memory" error, due mostly, i think, to some background antivirus apps that global IS has rolled...
  3. scroce

    grouping using arrays and loops

    trying to be brief and simple as possible. my insurance company provides 5 policies to its clients: a, b, c, d, & e. my company also works with several different agents. some agents are associated with more than one policy. there is a report that I'm trying to build that shows the client...
  4. scroce

    unauthorized cookies?

    I built and maintain a website hosted on IIS. I have one user who is very particular about security. Yesterday he logged on to the site from home on a brand new PC, and he tells me that (either his browser or firewall, unclear which) alerted him that the site was trying to download cookies to...
  5. scroce

    trouble excluding records

    In simplified form, i'm trying to write a SQL query that says this: show me those records from the Customers table that have records in the BigOrders table EXCLUDING those Customer records that also have records in the SmallOrders table. it's proving confounding. any hints would be helpful...
  6. scroce

    debian install problem <newbie>

    I'm working thru my very first install of Linux, debian distro. I've gotten to "Install Kernal and Driver Modules" I choose CD-rom drive it says "place first Debian CD ROM in Drive I do that > I choose continue it says "select directory containing images-1.44/rescue.bin" with two choices 1...
  7. scroce

    joins in jet/mdb vs. joins in adp/SQL server

    need some clarification: In jet mdb, you can go into relationships, join a pk with a fk, and then you hit a button called "join type", which gives you the choice of assigning type 1, 2 or 3 (i guess corresponding to INNER, RIGHT OUTER and LEFT OUTER) Diagrams in SQL server doesn't seem to have...
  8. scroce

    Delete Dup record (newbie quesyion)

    being used to working with jet, if I saw a duplicate record, i could just hi-lite the row and press delete key and it would go away. However, it seems in EM and/or Query Analyzer, you can't do that. I could write a DELETE WHERE statment, but that would delete both my records. what is the most...
  9. scroce

    where did my relationships go?

    i recently migrated tables from mdb file into SQL Server. I noticed I lost all my relationships settings and primary keys. When I did the migration I remember telling it which fields were PK's, but it's like it didn't take. Now it looks like i'm going to have to re-do all my relationships...
  10. scroce

    new record button no longer works

    I've just moved my tables to SQL Server 2000 I have a new record button on a form that used to work just fine. now when I click it, error 2105 saying "you can't go to that record" end-debug-help pops up. When I click help, all I get is a blank screen. the code is simply DoCmd.GoToRecord , ...
  11. scroce

    SQL server won't let me in to my db

    Running personal edition on XP pro. Set up an adp file that connects just fine to my SQL server tables on the physical machine. I am logged is as MyName on the "server" machine. I go over to another machine, log in as MyName. I put a shortcut icon to the adp file on this machine's...
  12. scroce

    ADO and refresh method

    Someone please explain this to me. I'm familiar with ADO in regards to ASP, but in Jet, I'm new. I have a form where a user can enter a new record. The user hits the "add" button and the code uses ADO to append the record. After this I need to refresh a listbox on the originating form so...
  13. scroce

    run time error 3251 - object or provider not capable of performing...

    i've seen several posts on this issue, but often they are more complex that what I'm trying to achieve. many of them are calls from asp pages, but I am working right within my own access db (2002) environment. The goal is to understand ADO in Jet environment, as I have plans to eventually work...
  14. scroce

    locking a database directory in IIS

    I have a database on my website containing semi-private information. It's not totally mission critical, but still I would like to take some measure of precaution that it doesn't accidentally or otherwise get downloaded or hacked. I've noticed that if I go to...
  15. scroce

    Terminal Services & IIS advice please.

    I've configured Server1 as my terminal services server. I've got Webserver as my webserver which is on the same network. I want to be able to be able to access Webserver's IIS applet from remote locations. From the remote location, I am able to successfully connect using Terminal services to...
  16. scroce

    basic feathering

    this question is so basic it hurts me to ask, but here it goes. I have a jpg - all I want to do is fade the left and right edges of it, (called feathering, right?), so that the image seems to fade in from the left, becomes full, and fades out on the right. In other words, I don't want the hard...
  17. scroce

    Sending SMTP mail via IIS

    I am under the impression that you do not need to have a full blown email server (exchange or otherwise) to send a simple SMTP mail message through the internet from a scripted page such as ASP - as long as your default SMTP virtual server is configured in IIS is this right? The reason I ask...
  18. scroce

    SMTP mail stuck in queue

    well, after browsing millions of similar posts on this item, I'm sorry I have to bore you all with yet another. I'm Running IIS6 on win2k3 server. Using CDOSYS, I'm attempting to pull information off a form filled out by the user, which then gets put into SMTP mail to be sent to several...
  19. scroce

    CDOSYS trouble

    I've seen innumerable postings on this, but I'm still unclear on a couple of things. I have a simple form which allows people to request a video. When the form is submitted, the page sends and alert email to the video librarian. My code for CDONTS worked fine, but we've since upgraded to...
  20. scroce

    moving a div layer based on screen res:

    So far I have this for javascript which works great: <script language="JavaScript" TYPE="text/javascript"> function rightSize() { var screenWidth = window.screen.width; switch (screenWidth) { case 1024: window.document.write ('ITS 1024!'); break; case 800...

Part and Inventory Search

Back
Top