Recent content by nomax

Must have been something funky in the line, deleting the line, changing the name to just departure and readded - now it works!!!!

Okay, Doc Man - replaced it exactly as you noted and still come up with the runtime error on that line stbody = "Thank you for allowing us the opportunity to assist you with your travel plans. Below please find the details you requested!" & vbCrLf & vbCrLf stbody = stbody & "Destination: "...

Yes, now I have and even a different numeric field is causing the same issue

Nope that didn't work either, I think it has something to do with this is a numeric field - i've removed the field and it works, I've added a different numeric field and the same error

Thanks, but nope that didn't help - same error

Good morning all, I'm stumped, pretty sure I know what the issue is, but I'm not certain on how to fix it and know that someone on this forum will be able to tell me what I'm doing wrong. Here is the code I am using: stbody = ("Thank you for allowing us the opportunity to assist you with your...

boerbende - the issue is being the datasheet view is based on a union query only the CRUISEID is showing, not the BOOKINGID. Minty - "your terminology is a little confusing. A union query joins two queries not two forms. Is your form now based on the union query? If so are you trying to open...

Good morning all, you have been so helpful in the past and I'm stuck again, I don't think this should be this difficult, so it must be me!! I have a union query that works just fine (thanks to the help received here). It joins 2 forms "cruises" and "bookings". Now my issue is from the...

Okay, great that worked, now I just need to figure out how to open that record

Thank you I will give that a try

sorry, not getting it - maybe this will help - here is my union query SELECT Contacts.ID, Contacts.[Full Legal Name], [FIT BOOKING].TRIPID, [FIT BOOKING].Confirmation, [FIT BOOKING].[Departure Date], [FIT BOOKING].Description FROM Contacts INNER JOIN [FIT BOOKING] ON Contacts.ID = [FIT...

I realize that is a terrible subject line, not sure how else to word it. Here is my issue and hope someone can help me with it I have (3) forms - CONTACTS, CRUISEBOOKING and FITBOOKING. I have a union query that provides me with both cruisebooking and fitbooking for that contact. This works...

Okay, stripped down version (removed sub forms from the forms as they don't really have anything to do with the issue I'm having. The way it works Open GROUP MASTER - add all of the information from GROUP MASTER open ADD INDIVIDUAL TO GROUP. By choosing the Master Booking Number - fields on...

Not purchased I developed it. Maybe I could just Copy those forms to a new database and upload that, let me try if that will work. I'm not worried about someone stealing my customer list, it's a little sloppy right now with many revisions, changes, forms that I am not going to use and am deleting.

Thank you, I am a travel agent, the database is a CRM with both cruise, tours, FIT booking information as well. Customer profiles etc. As I am using the database, to post a copy of it would be an incredible amount of work to strip it down to remove all the personal information already...