Search results

Here is a sample of the Kill Statement in code: Dim strFileName As String strFileName = "c:\myfile.txt" Kill strFileName MsgBox (strFileName & " has been deleted") ' Or you could simply use Kill "c:\myfile.txt"

FrontPage used to be my favorite web development tool. That is until I went semi professional with development and needed to work with server side scripting (ASP). Although it can be done in FP it ranks slightly above notepad for usability and usefulness. However if that is what you are stuck...

Rich I agree with Pat on this one except that I would also add that if you are going to do this semi-proffesionaly I would stay away from DAP all together, even in 2002. At this point in the game you are better off downloading Webmatrix for free from MS and start learning ASP.Net.

Oh I see. Well since you are using Outlook why not turn on the Request Delivery Receipt For Message in Outlook. If you do not want it on all the time there may be a way to turn it on in the code. I will check it out here in a minute and let you know if I find something.

If you have not got this figured out yet you can just add a SendMail routine to the form submit code. Let me know if you would like to see an example.

jamie57, If I understand your question correctly this is what you are looking for or at least something similar to this: Dim EmailApp, NameSpace, EmailSend As Object Dim dtDate As Date Dim strEntId As String dtDate = Now() strEntId = Me.EntryID Set EmailApp =...

Here is a working sample for you: Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("YourQuery") Do While Not rsEmail.EOF strEmail = rsEmail.Fields("EmailAddress").Value DoCmd.SendObject , , , strEmail, , , "Subject", "Message Text" rsEmail.MoveNext...

I finaly figured this out. The solution that worked for me can be found here: MDAC Fix But it breaks down to this - Q: "Installation of the Microsoft Data Access Components package failed. (-1)"-- Error occurs during setup ? A:Some workarounds... Sugg1 ----- Check and see if the registry...

It hasn't been easy but I have managed to get the .Net Framework and SQL Server 7 set up on a test domain controller. Both are working correctly independently but when I try and view a page that shows db schema I get this error: The .Net Data SQL Provider (System.Data.SqlClient) requires...

In the past I have went about this a couple of different ways but I have never found a way that I thought was foolproof so I will ask here. What is the best way to fill a form with one record (chosen from previous form) to edit. I basically want to duplicate the entry form but have it open from...

DanR, There is a free program called Pretty Code that can be used for very professional code print outs. You can find it here: PrettyCode.Print v.1.60

Actually the loop is for a mass email that goes along with this code. I just cut that part of the paste to make it easier to understand. However I did add a field to my query like this, Month: Format([LastDate],"mmmm") and then adjusted the form code to look like this, Dim strMonth As...

Got it now, thanks!!! Oh yea and thanks for the spelling correction also. I need a spell checker for my head.

I am opening up a recordset and trying to get all the records that match the current selected date from a combo box. The values in the combo are listed as: January February March ...and so on... The dates in the table are stored like this, 1/1/01 etc. I am trying to pull the matches with this...

Very good point. If they are recent Laptops they may alread have network cards built into them. I recently (last December) looked into buying a laptop and network cards were a pretty standard feature.

Ok if you are only working with two PCs and they are both either Windows 2K or XP all you need to do is get a cross over cable which will cost you about $10.00 at your local computer shop. For around $50 you can buy a Network kit which will come with a 4 or 5 port hub and two network cards...

RT I needed to do the same thing a while back and I was able to do it like this. This code is behind a command button: Dim dtDate2 As String dtDate2 = Format(Date, "mmm") DoCmd.OpenReport "repEmpUpdates", acViewPreview, , _ "[Month] = '" & dtDate2 & "'" See this thread for more...

David R, I have done a search for this exact same subject but never found a solution that worked in my case. Do you have an example of one that does in mind? Doesn't the Mode set to Add still allow the record to advance forward with the mouse wheel? I think Access always assumes a new record...

Thanks I also had to remove the Exit Sub in the function. I am now firing the event and sending the email but just as soon as it completes I get this error: This happens after the email is sent so I think the problem is cuased by the return to the form field. Any ideas? This bold text is...

You mean like this? Private Sub EmpID_Exit(Cancel As Integer) Dim fname As String, lname As String, txtFullName As String On Error GoTo err_Sub lname = DLookup("[LastName]", "EmployeeList", "[EmployeeNumber]=" & Me!EmpID) fname = DLookup("[FirstName]", "EmployeeList", "[EmployeeNumber]=" &...