Search results for query: *

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...

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...

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) +...

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?

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...

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...

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...

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?

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...

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...

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

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

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...

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...

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...

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

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

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"...

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?