Search results

I have since worked out how to complete this task, by using a loop to commit all changes, and then a pop up box to say how many changes were made: Private Sub EOMbut_Click() With [Forms]![EndOfMonth]![AffSub].[Form].RecordsetClone Do Until .EOF .Edit !CarryOver =...

I am looking for a way to move monthly data between columns, as I am only required to store information for the past 5 months. CARRY OVER - Month 1 - Month 2 - Month 3 - Month 4 - Month 5 when I press a button I would like for month 5's information to populate the month 4 column, month 4's...

Thanks for the help, I am able to attach 1 file to the email, but I really need to be able to attach 4/5 at a time! I am currently experiencing a bug where I end a "With", but do not start it even though it is started earlier... With oMail .To = Email .Subject = Subject .Body =...

Hello, I have been able to send emails and send attachments if the path is static, but I am looking to create a browse function to attach items to the email. So far my code is... for the selection of files: Dim f As Office.FileDialog Set f =...

Good Morning, I was wondering if anyone could help me out with a small problem I am having. Currently I have a form that holds all information for each "Club". When a button on this form is clicked a pop-up form opens showing the "checklist" for each club, which is stored on a separate table...

Im gonna keep working at it, if I come into anything I will let you know!

Same again, I changed "tony.hine" to a real microsoft address "/gb-en/" so that it would find the address. It still freezes when clicking the button. it seems like it is constantly attempting to finish the request but it is never able to

I have made a blank form with only a text box and a button, the buttons onclick event is the code you posted. when the button is clicked the message box opens as usual, however access then decides to freeze up and I have the same problem. This also happens if I change it to a with https address.

--------------------------- Microsoft Access --------------------------- >>> With HTTP https://www.facebook.com/labotijatapas?rf=112247058835384 --------------------------- OK --------------------------- --------------------------- Microsoft Access --------------------------- >>> NO HTTP...

when http is present: ">>> WITH HTTP (full address line)" when http is not present " >>> NO HTTP (full address line)" It doesnt show the same address twice, and the code is the same for when http is present or not present, but for some reason it opens twice when http is not present :S

The good news is that this stops the program from crashing! it still opens 2 tabs if the URL does not contain https:// And Ideas?

After changing it still gives me the same problem, access attempts to open the hyperlink until I close it from task manager :(

I am attempting to open a website hyperlink, some of the fields contain https:// and some of them dont. Private Sub Facebookbut_Click() Dim Hyper As String If InStr([TEAMFacebook], "https") Then Hyper = Me.TEAMFacebook Else Hyper = ("https://www.facebook.com/" &...

I was able to get this working Dim strEmail As String Dim strMsg As String Dim oLook As Object Dim oMail As Object Dim oNS As Object Dim Email As String Dim CC As String Dim BCC As String Dim Subject As String Dim Attach As String Set oLook = CreateObject("Outlook.Application") Set oMail =...

Ok, so the answer to this was much easier than I first imagined. I used the same row source property for the drop down box that decides the filter, and the combobox inside the subform that is going to be filtered. Because of this I could filter without having to set a variable. If anyone needs...

I tried to do this, but my filter options reside on my main from, and I am trying to filter a subform in datasheet view. I added a "dummy" field that only showed the column I needed [column(n)], but I am unable to sort or filter by this date. The combobox is on one of the fields inside the...

Hello, I am currently in the process of creating a form that will allow you to enter details for an email sent, select a number of documents from a list box and then open the mail message pre-written with attachments. The attachments reside in a list box currently, and I am attempting to use a...

Hello, I am currently having trouble filtering my subform by a different column than the bound column set in properties. the comobobox shows the ID for the last email sent, with the combobox drop down showing the name and date of email when dropped down. I have tried 2 things and neither...

Ah, the "'Make sure we save any changed data and then get recordset" part of your code really helped! I got it working with this code, a lot less intense than yours, but I don't need to send emails with the code! Private Sub SaveNClose_Click() DoCmd.Save With...

Hello, I am currently developing a crude Contact manager database and need a quick way of entering data into a selection of records (around 1000 at a time). At the moment I am manually going through all records and changing the "DateLastEmail" field manually, which can be very tiring. I was...