Recent content by scorpio1769

Hi all. Is there a way to automatically open a Microsoft access database on a windows machine from a linux box automatically? I don't need to read the db, make changes, update, etc. All I need to do is open the file. Something like Windows task manager that will do this? Thanks,

I've tried PHV's suggestion above and I receive error 2450, "...Access cannot find the subform referenced...." Anyone know how to correct this? Thanks,

Ahhhh. I get it now. Thanks for your help and patience Michael. The transaction history works beautifully.

Not sure. How do I know?

I'm attempting to call the function like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Call basLogTrans(Frm, MyKeyName, MyKey) End Sub When I do, I get a type mismatch at Frm in the parameter list. Can someone let me know what I'm doing wrong? Many thanks.

Thanks for the heads. I don't know VB at all and am trying to figure out how to call the functions. Do I create a sub on the before update and then call Michael's functions from within it as below? Any tips on how do this? Sorry to be "that guy"....just have no idea what I'm doing with VB...

I'm attempting to insert Michael Red's transaction code, faq181-291, and forgive my ignorance, but how do I initiate this code? I've created the tables as described, pasted the code into the db, set the DAO reference as describerd and compiled to make sure no errors. What event do I tie...

Thank you much everyone

Perhaps adding error descritpions to your code to see what happens?

I'm confused. You mean displaying a particular form on startup? If so Tools/Startup/Display Form

Haven't seen the error but what about using the MDBsearch add in to find and replace the yes/no entries in your db?

Hi folks. First off, I have not idea what I'm doing so be gentle. I have the following code that takes an excell template, fills in some data, saves the updated spreadsheet using SaveAs. Everything is kosher for that, however it seems that I cannot close the template file ".....RSP Purchase...

did you use the builder to write the syntax? What error message are you getting exactly?

Unfortunately I'm not using 07 so I can't troubleshoot. Have you tried bypassing the GUI and instead ued the follow hyperlink method in VB?

Did you get it fixed?