Search results

I am not sure if this is a better way or not but it works. Call Shell("xcopy C:\database.mdb D\database.mdb", 1) I tried experimenting with the sendkeys to stop the prompt for file or folder but couldn't get it to work. Someone with WSH knowledge should be able to figure that part out though...

Try using the SendObject in place of Hyperlink Address. I think you will have much better luck with it. This should work for you: DoCmd.SendObject , , , Me.[E-mail address], , , "OptionalSubjectLine", _ "OptionalMessageText", True You can also pull the Subject and message text from the...

I thought that was the problem and had even tried changing it to a empty string but the zeros were still there. Then when you replied to my question I realized I never reset my table to its original state so I was getting the same results. Anyway, a big duh to me and a final thanks to you.

That worked, thanks again. There is a 0 being added to the beginning of each number like this 0K333-A. What is causing that? [This message has been edited by Talismanic (edited 07-02-2001).]

That did, D-Fresh but I have one more question. How should the update look? I have this: objRS![JobNumber] = TempString Access is looking for a Addnew or Edit near that update.

I must be doing something wrong when I open my table because I am getting an error on the bold line below. Dim objDB As Database Dim objRS As Recordset Dim AllowedCharacters As String Dim TempString As String Dim ctr As Integer AllowedCharacters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-" Set...

I am having some problems figuring this out. I want to remove two spaces from a string if they are present. The string is in a table that is imported from another program which won't allow me to make the changes there. The typical string I am dealing with looks like this K345-, but the...

I am not sure I understand the question but if you are using a path like C:\ResPro.opr\ROCNorth\names_be.mdb, C being your local drive, yes you can just replace the C with what ever the network drive is mapped at. Post back if I misunderstood your post.

If this is Access 2000 and you are using DAO, you will want to declare thar in your dim statement like this: Dim RS As DAO.Recordset Did that work for you or did I misunderstand the problem you are having, post back to let me know.

Yes it is basicaly a Send Key routine - T(ools) D(atabase) C(ompact). Not sure why it isn't working for you though. Anybody else have an idea?

jchesser, please don't double post topics. This was answered in the General forum under the same topic name. Topic: Calling a .bat file from a button or macro?

I love the user name! You can do it with a command button like this: Dim intQuestion As Integer intQuestion = MsgBox("Compacting the database requires that" & vbCrLf & _ "no one else be in this database..." & vbCrLf & " " & vbCrLf & _ "Are you sure you want to continue?", vbYesNo...

This should do it for ya: DoCmd.TransferSpreadsheet acExport, 8, "TableName", "C:\FileName", True All you need to do is use your table's name in place of "TableName" and then set your file name and path by modifying C:\FileName.

You can do it using the Query or Table to supply the email addresses. Here is a post that will help you get started. Topic: Emailing System Help Post back here if you have more questions.

This may be more then you are looking for but this code uses two text boxes and a command button. The user puts in a begin date and a end date and clicks the button. The report will open and only show the records that fit the criteria. No need for a parameter query. Dim bProcOk As Boolean...

You may want to check this thread also: Topic: Emailing System Help

Check the first item in the more Win32 API Code link above. I think that may be closer to what you are looking for, yes?

I was able to do a transfer with this module: API: BrowseFolder Dialog For more Win32 API code: Win32 API Code List

Here is a sample of the SendObject: DoCmd.SendObject , , , Me.Email, , , Me.Subject, "TextToSend", True This assumes that the Email and subject are going to be pulled from the database. Just rename the Me.Email and Me.Subject to match your controls name. You could also do the same thing with...

You must be using Access 2000. Here is the same form for Access 2K.