Search results

Shane, Thanks for the reply. With the undo command, it doesn't seem like it is deleting the record if it has been started.

I have a form that has an exit button on it. Is there a code I can write that will delete the current record if one has been started, and if not just close the form? I tried doing this with just a delete record, then close form macro, however if no data has been inputed to start the record...

Thank you both for your help, got it working now.

I have a combo box on a form that pulls data from the first column of a table, however I need to drop whatever is in the 2nd column of that selection in a seperate text box automatically. Is there a way to do this? If so, any guidance would be appreciated. Thanks!

Perfect, got it. Thanks!

Hi, I'm using a module that uses the Microsoft Word and Excel 12.0 Object Library, however I have some users that have Office 10 and 11 and I am not sure how to reference those libraries for them. Is there a way to load those into my database?

Sweet, I fixed it by just using this instead. Function UP2() Dim appWd As Word.Application Dim wdDoc As Word.Document Set appWd = New Word.Application appWd.Visible = True Set wdDoc = appWd.Documents.Open("G:\Bulletin Board\UP Billing Flags\UP 1.2 - Health and Safety Plan.doc")...

Is there something here: ShellExecute 0, "Print", "file:///G:\Bulletin Board\UP Billing Flags\UP 1.2 - Health and Safety Plan.doc", "", "", 0 That is telling it to save and close? I got a "The object invoked has disconnected from its clients" Automation error at wdDoc.Close False

Ok, I'm using this code, so far it works great. I added something to print as well, but I don't want it to save any changes and somewhere it is telling it to do that. Dim appWd As Word.Application Dim wdDoc As Word.Document Set appWd = New Word.Application appWd.Visible = True Set wdDoc =...

Thanks a ton Bob. Only thing I'm getting when I try to run the code is "invalid use of Me keyword". Any idea there?

I hear you. Thanks for the pointers. I'll see what I can do!

Ugh..that seems pretty tricky for me having no real knowledge of VBA, other that what I have borrowed from here. =) Is there a simpler way of doing what I explained?

Just thought I would bump this up and see if anyone could lend a hand. Thanks.

Hi all, I'm finally down to my last hangup on this database that I'm working on. I just wanted to thank everyone here that helps out, the discussions here have helped me more then I could have imagined as I knew absolutley nothing about access or vba. Ok, now on to question at hand. Right...

Got it! You da man Bob. Thank you kindly.

Ok I added an extra / in there, so now it reads... Function OpenWordDoc() FollowHyperlink "file:///G:\Bulletin Board\ExxonMobil\UP Billing Flags\UP 1.2 - Health and Safety Plan.doc" End Function Renamed the module to "modOpenWordDoc" yet I'm still getting... the object doesn't contain...

hmm...I'm not sure I understand. Would that still apply here? I have a macro set on the "On Click" event, which is; Condition: [Forms]![frmGWO1]![UP Billing Flag]="UP-02" Action: RunCode Arguments: OpenWordDoc I have a module named "OpenWordDoc" which has this code: Option Compare Database...

I should add that I tried the following here... http://www.access-programmers.co.uk/forums/showthread.php?t=73934&highlight=followhyperlink with this as the condition: [Forms]![frmGWO1]![UP Billing Flag]="UP-02" However, I was getting a "the object doesn't contain the automation object" error.

I'm sure this is easy for people that are familiar with VBA, but being the noob that I am. I need a little help trying to write this. I have a button on a form I need to do a few things. The first thing I need it to do is simply save the record. Then I would like it to look at one of my...

This would work like that, however, it does create the possibility of gaps if someone decides to cancel out of entering a record. I have an idea in mind that I am going to try and I'll post back here with any progress. Thanks for your help Gary.