Search results

Hi, I have posted about this before, but never got anywhere, and seen as I have a bit of time off again, I am back to try again. I am wanting to find and delete all Appointments with a * or any other character. This is so I can then add them again using VBA code from my database. So I have...

I want to delete all appointments in my calendar with * in the subject. This code (Just a small bit of it) deletes the subjects when strFindAppt = Subject, but I need to find appointments with * in them, not * as the subject without anything else. strFindAppt = strFindAppt ' Use this...

Hi, I have built a form that needs some VBA filters to search for booking, but it won't allow filters now. I have checked the data settings and everwhere I could think of to allow filters, with no luck. It will allow filters at startup, but won't allow them to be changed. Here is link to...

Hi I would like to delete a record currently open in a form (With a filter on the current record if that matters) I have used this code: If InputBox("Type 'Delete' to delete the customer", "Delete Customer") = "Delete" Then DoCmd.RunCommand acCmdDeleteRecord End If But I get...

Hi I know back again, I'm just always getting suck I am wanting to filter a spilt form via some check boxes and options boxes. Here is how I have it set out: I want to be able to filter 'Upcoming Bookings', 'Cancelled' and the option buttons, these want to display bookings at that stage...

Hi I have used calendar VBA code on this forum to add appointments to outlook, the problem is that I need to be able to update them. I know updating them is going to very hard, so instead of doing that, I thought I could delete all the appointments in the calendar and then add them all again...

I am trying to make a memo box full of information to be exported to excel, I need to use new lines to make is easier to read. I have tried vbNewLine and Char(13) both with errors? Can it be done. Here is the code: ApptNotes: "Name: " & [tblCustomer]![title] & " " & [tblCustomer]![first_name]...

Outlook calendar delete all apointments <Please see below as this thread has changed a bit> Hi, I found this VBA code for adding appointments to outlooks calendar. It asks for the start date, but I would like end date (Like in outlook) not duration. Is this possible or do I just convert it to...

Hi, I have made a 'Details' pop up form which I will use to show the details of customers and there holiday bookings in my database. I have a 'Bookings' tab, this contains a unbound text box called 'txtprice' This is the price of the holiday. I then have another tab 'Payments'. This tab...