Search results

I have a form that contains a field for inputting a date. I would like to have this date get transferred to Outlook's calendar as an appointment. My kicker is, I need to have this appointment show up on several people's calendars at the same time. Would I use a group concept in outlook, in...

KeithG, Thanks!! That is pretty close to what I want. Does Monarch offer a time-limited or record-limited copy of their software? I couldn't tell when I looked at their site. What about cost for a single copy license? I appreciate your help! Thanks!!

Good morning, JoeCruise..... Thanks for the suggestion! I've made a copy of your code and will be mod'ing it to see if it'll do what I'm interested in trying. I think my hardest part will be when I'm spanning pages in my txt file, but will dink around with it and see what falls out. In any...

KeithG, Thanks! I've heard of Monarch and used it several years ago. If you would be so kind, yes, please run my sample txt file through your copy of Monarch. I'd love to see what the output looks like, and thanks so much!!!

I've got a really wacky text file that can contain a ton of verbiage, followed by several rows and columns (almost looks like Excel data), which in turn is followed by a bunch of verbiage, another several rows and columns of data and so on. Incidentally, the row and data portions of the text...

I figured it out myself.

I have a report that contains several columns of data, and I would like to change the widths of some of the vertical lines on the report, but not all of the vertical lines on the report. For example, If my CtlDetail is "widget" or "wadget," I would like to place bold vertical lines around those...

Oh, well..... I figured how to do what I wanted to do in the first place: Code I wrote will delete the appointment if it exists, and re-add the appointment for a different date. Took a little longer digging for the info myself, but at least it's done.

Hello???? Anybody there ????

KeithG, Thanks for your reply, however I'm not sure what you're telling me. In my code: Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Set outobj = CreateObject("outlook.application") Set outappt = outobj.CreateItem(olAppointmentItem) With outappt .Start =...

I know how to create an appointment in Outlook from a form in MS Access with VBA code. My question is: Suppose the date and time in my Access table and form are changed..... how would I go about changing the date and time of the appointment in Outlook, using VBA? Would I have to somehow...

The Redemption program is not the only way to bypass user prompts. Go to the following site, http://www.ContextMagic.com. There is a program there called "Click Yes" that allows the user prompts to be bypassed. I've used it for months now and it works very well.

Pat, Please disregard my last posting.... I figured out what I had to do. Thanks so much for your help on this issue. You saved me a lot of time and aspirin.:cool:

Hi again, Pat.... Guess what..... I did not explain myself as fully as I thought .... my mistake (apologies!!). The linking worked, however, I also need to add two fields to my talbe in question, and linking does not allow that. How might I go about doing the removal of relationships, run my...

Pat, Thanks for your reply..... I too remember those days of way back when. I was a computer operator on those old big mainframes, with tape drives, octal sorting algorithms, and also the fun of punch card decks (shades of Florida's "hangiong chads" !) I'll try linking to my desired tables...

Hi, Pat.... I would love to run my "stuff" against the tables where they are, but am not sure how I would point my .mdb against the .mdb's in that other folder. I think that's where my headaches lie. I was able to run my transfer database and then run my queries and modules against the table...

Pat....one more time...... Can you do this type of thing to one .mdb from another .mdb? I've got an .mdb with a module that cycles through the .mdb's in another folder, and everything is working with the exception of being able to delete my relationships. What I want to do is to transfer one...

And, once more, thank you, Pat:)

Thank you, Pat..... it's truly appreciated.

After you've created relationships between tables, does anyone know how to find the names of the relationships? Thanks so much in advance!!