Search results

I "fixed" it by deleting the old file first and then adding it. The really strange thing is that I use the same code in a different Private sub for another backup of a file and it works perfectly. Fixed is fixed.

sorry should have included this also: Dim FSO As Object Dim fSource As String, fDest As String Set FSO = VBA.CreateObject("Scripting.FileSystemObject")

I am using the following to copy a backend from one folder to another. My code is: Call FSO.CopyFile(fSource, fDest, True) I copied the backend but is asks if I want to replace the existing file. A search of the forum is that possibly I don't have the correct reference ticked off. But I am...

I am just a amateur at all the programming nuances, but I found early on that trying to edit email and web pages was exasperating, especially for the users who didn't understand why when they tried to edit either of these fields that they were ending up sending unwanted messages or going to...

This also worked great. Thank you so much.

Worked fine except That I had to use: DueDate: DateSerial(Year(Fdate),Month(Fdate)+3,15) because when I pasted the above it kept putting in [] and the query didn't seem to like that. Thank you. Can now go back to doing nothing again, stuck at home and the golf course is still closed.

I am trying to set a "Due Date" of the 15th of the month 3 months in advance. For example, if I send out an invoice for May, and select that month as the invoice Month, I use the function: Public Function FDIM(Optional dtmDate As Date = 0) As Date ' Return the first day in the specified...

Demo works fine, except if the next record is missing. That should nto be a problem. Not trying to make this too complicated but I plan just to show if an error message occurs, that the user has to go to another method of opening a record through a report. Unless there is an easy fix to...

This merely brings me back to the first record in the table. Going to try another suggestion. Just thought you wiould like to know my result on this.

Been busy and I do appreciate all the comments and suggestions. Will be working on this tomorrow. Thanks to all.

I did do that, didn't I? First two lines of the code.

If I use the standard VBA to open a specific form, that is: DoCmd.OpenForm "frmNewNames", , , "ID = " & Forms!frmLastN.txtLastN I open the exact record I want. But when I get to frmNewNames and then want to go to the next record it says I cannot. I've looked up a solution but can't seem to...

Same error message. Syntax error missing operator. I did a work around by putting two hidden text boxes on the form from which the report is run. Minus2Weeks with it =DateAdd('ww',-2,Date()) Plus2Weeks with it =DateAdd('ww',2,Date()) and used the code DoCmd.OpenReport...

Did that and the error is Runtime error 307 Between Operator Without And

I have the following code that opens the report correctly: Daily Followup: DoCmd.OpenReport "rptSalesContactsOpen", acViewReport, , WhereCondition:="[FollowUpDate] = Date()" Weekly Followup: DoCmd.OpenReport "rptSalesContactsOpen", acViewReport, , WhereCondition:="DatePart('ww',[FollowUpDate])...

I tried the paste to the hidden text box and got this when Outlook opened. <div><font face="Times New Roman" size=3 color=black>To:you Details </font></div> <div><font face="Times New Roman" size=3 color=black>please add:</font></div> <div><font face="Times New Roman" size=3 color=black>1. a...

Using Access 2010 Late Binding I am attempting to send an email with a word document in the body of the email. I have a form which I can fill out (or is filled out with the data of another form). The code below works fine in previous applications where I had .Body = Cstr(Me.MessageBoy)...

You forgot Marshall Islands, MH.

Sorry no I do not. I am sure that it is just my computer that is slow, but it could also be that I have way too many codings in my Access program. I am just living with it. It doesn't seem to affect the running of Access, just bringing up the module portion to edit or add new coding.

Firefox just warned me that there was a security problem with this site. Of course I ignored it but thought you would like to know.