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

    strange

    I have an access DB setup that uses linked tables that are linked to a SQL Server. This DB works on all of my PCs in my office except one. The one PC I am having issues with will open only certain tables. But if I open another table first I can open the tables that won't open after. IE I...
  2. manny1234

    access and sql server 2000

    I am using an access db to connect to a sql server. All of my work stations work fine with the same copy of the access db that I am using on this pc. On this PC I get Connection failed: SQLState: '0100' SQL Server Error: 2 [Microsoft][ODBC SQL Server...
  3. manny1234

    access substring

    I need to take a date that is formatted like this yyyymmddhhmmss and turn it into mm/dd/yyyy. I have an aspx page that uses substring to accomplish this and I figured I could do the same in access but noooo here is the code I have substring(shipdate,5,2) + '/' + substring(shipdate,7,2) +...
  4. manny1234

    sa-learn --spam

    I use spam assassin and I am still getting slammed. I take each spam I get and copy the body of the mail into sa-learn --spam. Those emails still come through though. What should I be doing?
  5. manny1234

    brain cramp

    I should be able to figure this out but for some reason I cannot figure out where to start. I have a datagrid that shows a list of available dates. You can click on these dates and they will pull up a report for that date. I have three other reports that I want to do the same thing for. But...
  6. manny1234

    datagrid new line

    Is there a way to have one data grid with a line break instead of doing two seperate datagrids? IE I have a data grid that is too long to display on one line but I do not want to create a seperate datagrid to display it on two lines...
  7. manny1234

    blacklisting a sender

    I noticed a specific person is pounding my mail server with spam using different smtp servers. Can I block that individual? How can I go about blocking them? I am using sendmail, qpopper, amavis, clamav, and spamassassin. Here are the headers I. eturn-Path: <dkinealy@gmx.net> Received...
  8. manny1234

    turning a number into a date

    I have a field in my DB that stores date and time in a number string like so 20060522143600 yyyymmddhhmmss. How could I go about breaking this number up so it is a legible date in a datagrid?
  9. manny1234

    opening all to a specific record

    I have a form set up where I view one record at a time. I have arrows were I can scroll through records, or I can search in any of the fields on the form for a specific record. I have a box that lists all of the records I have viewed and I can click the specific listing to open that record in...
  10. manny1234

    calling default media player

    What would the syntax be to call my default media player ie Winamp, Itunes, or Windows Media player. Like calling %System Root% I have Private Sub Command739_Click() On Error GoTo Err_Command739_Click Dim stAppName As String stAppName = "C:\Program Files\Windows Media...
  11. manny1234

    showing home page

    Using just HTML is there a way to open what ever the end user has set as their home page?
  12. manny1234

    turning off write conflict message

    How do I turn off the write conflict error message. DoCmd.SetWarnings doesn't do it.
  13. manny1234

    recovering a HD

    Good morning, I have a SATA HD that FreeBSD is having issues with. From what I have found in my research it appears that FreeBSD has issues with SATA drives. Anyway I could not find a fix to the problem so what I did was load FreeBSD on a fresh HD now I want to access the old HD from via the...
  14. manny1234

    booting problem

    my installation of freebsd froze. I did not have a monitor or a keyboard hooked up to the server in question so being the lazy putz that I am I just powercycled the box. Now when I boot it goes to the screen where you can pick to boot normally, single user, safe, etc. When you make a...
  15. manny1234

    List Box Double Click

    I have a list box set up in a form. I want to be able to double click an item in the list box and have it open a seperate form with the corresponding record. Here is what I have. Private Sub List0_DblClick(Cancel As Integer) DoCmd.OpenForm "MD_ActView", , , "" & Me![VPSID] & " = [ID]" End Sub...
  16. manny1234

    INSERT QUERY

    I need to be able to insert a date into a table with a VB script in access like so... DoCmd.RunSQL "INSERT INTO History (MID,Date) SELECT " & Me![Merchant ID Number] & ",Date()" Not sure how to set up the syntax
  17. manny1234

    INSERT QUERY

    I need to be able to insert a date into a table with a VB script in access like so... DoCmd.RunSQL "INSERT INTO History (MID,Date) SELECT " & Me![Merchant ID Number] & ",Date()" Not sure how to set up the syntax
  18. manny1234

    HyperLinkColumn

    Good morning, I need a way to set to variables in the querystring. http://www.server.com?id=something&id2=something completely different Here is what I have. <asp:HyperLinkColumn HeaderText="MID" DataTextField="MID" DataNavigateUrlField="MID"...
  19. manny1234

    clamav-amavis-spam assassin

    I am using a combination of Clamav, Amavis, and Spam Assassin. With any of these three products is there a way to block certain files types. IE any WAV files?

Part and Inventory Search

Back
Top