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 Wanet Telecoms Ltd 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: mossimo
  • Content: Threads
  • Order by date
  1. mossimo

    Keep adding to db or greate new ones (efficiency?)

    Hello All, I don’t know if I should add to an existing database or create additional ones. This is what I have: content.mdb (holds all site html/txt content) 2,685 KB, heavy use site.mdb (admin and configuration settings) 724 KB, light use users.mdb (user accounts and form data) 1,429 KB...
  2. mossimo

    Basic SQL query syntax?

    I have a simple amateur question. This is my SQL code: SELECT PassWrd, UID FROM tblUsers WHERE UID='"&Session("UID")&"' And this is the same code after MS Access applied its formatting: SELECT PassWrd, UID FROM tblUsers WHERE (((UID)='"&Session("UID")&"')); They both work fine so my question...
  3. mossimo

    Valid SQL? Or is there a better way

    My code below works fine but I’m not sure if it’s valid since I’ve never seen it done this way. I’m checking one field each in three different tables to see if it has data or is null. I only care if all three fields are null (false) or if any one of them has data (true). If someone with more...
  4. mossimo

    Return highest digit from string

    I have a simple access 2003 database that contains links to pictures in a directory. Example: link = http://www.mysite.com/upload/MO_07191_02.jpg link = http://www.mysite.com/upload/MO_07191_08.jpg link = http://www.mysite.com/upload/MO_07191_05.jpg link =...
  5. mossimo

    Select Case syntax?

    Is there any real difference between these two ways of writing select case statements? Select Case(sVariable) Case “1” : Do(this) : Do(that) Case “2” : Do(thistwo) : Do(thattwo) End Select OR THIS: Select Case(sVariable) Case “1” Do(this) Do(that) Case “2” Do(thistwo)...
  6. mossimo

    List all local variables

    I have been stuck with the task of converting a large web sites code so that all local variables are explicitly declared. Currently <% Option Explicit %> is not used at all. I’m looking for a way to list all local variables by page or site wide. This would save a lot of time.
  7. mossimo

    lost the ability to select and copy text with the mouse

    I have lost the ability to select and copy text with the mouse. I can highlight a selection but when I left click to open the copy past context menu my selection is lost. This behavior occurs in any file or application (system wide). I’m running XP Pro with all current service packs and...

Part and Inventory Search

Back
Top