Search results

I'm sorry to say your too late the the category one, worked it out after and bit of trying. The reason for putting the ID in the notes is that this is to be viewed on my dad blackberry, and its easier to see with less information in the subject, and my ID are random. I will take a look at the...

Long shopping trip, lol Ok, so looking at the code, I need to change this: Set mobjAPPT = mobjFLDR.Items (strAppSubject) So mobjAPPT is the Appointment title (Or subect), so could i change this to 'APPTNotes' or something for it to search the notes? Then put the booking_ID in the start of the...

Ok, basicly its putting in the subject line as '[name] [start_date]' for the holiday. So if I change was made, I could set the 'addedtooutlook; to false and it would search for the subject line and replace it. But if the name or date is changed it wouldn't. Could I set the booking_ID in the...

Ok, so I don't really need to find a appointment, for me, it would be easier to just delete them all and insert them again. So could you covert your code to delete all the appoints? Also, I asked this before, but do you have the code .Category or something like that for settings the category...

Thanks that's great? You don't know how to set a category do you? So we have 3 cottages and each category could be a cottage name, so they show up in different colours. I will give the code I try tomorrow. Thanks a lot!

Thanks a lot, just what I need, if you could detail some of the area I need to change.

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...

So if you have 1 form, no subforms and 3 tables? It will onlt show information that have keys in all 3 tables? If so, then is there any way around this? I want to be able to view 'Customer Info', but if they don't have a booking, it just say 'booking_ID (New)' So that I can use the same form...

But surly to display information from 2 tables on one form you don't need there to be the foreign key in both tables? No? Or am I wrong? Cos it would be simple to create a empty payment when the booking is made? But I would also have to create a fake booking too.

What will this do?

Thanks a lot, worked great.

Ok, let me try and explain it best I can I have 3 tabs: Customer | Booking | Payments I want all records to show in this form. So if there is a customer without a booking, they still show, so that I can add a booking. If a customer has a booking but no payments or price has been set, it needs...

But If I can a customer without a booking they will show in the details panel before the payments was put in. If there is a customer without a booking there details can still be seen in the details form? I don't understand why a booking need to have a payment for it to show its details? Its...

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]...

Ok, I have 3 tabs, and 3 tables here. Customer: tblcustomer Booking: tblbooking Payments: tblpayment The problem is that if a customer has a booking, say booking_ID = 3, then 3 must be in tblpayments for it to open in the details form. If I have a booking_ID with no payments made, and no...

Ok, If there isn't a record in the payment table, it will not show the booking. So if you want to view a booking where the price is not set, it will not show in the details form. If there is a record in the payments table matching the booking_ID then it will show all the booking info in the...

I'VE DONE IT! WOOOOOT! Dude I'm happy now. I am just going to change the code a little and I will post it back. Now this is all well and good if they don't change in the database, how could I update them. It might be a bit hard, would it be easier to delete the calendar and import them all...

HOLY COW! It works! Well, ish. It will update the price, but if there isn't a price set then it won't bring information from customer and booking, it needs to have a record with the booking_id in the payments table? Why do you think this is? The payments tab has a sub form, with the payment...

I have put your code in now, and getting this error: Here is the full code: Dim bookingid As String txtprice.SetFocus amount = txtprice Dim qDef As DaO.QueryDef Set qDef = CurrentDb.CreateQueryDef("") qDef.SQL = "SELECT * FROM tblpayment WHERE [booking_id] = Forms!frmdetails!booking_ID AND...