Search results for query: *

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?

Also I suggest that you have a table with a date/time field for each status you may have: WIP, Shipped, etc. Over the life of the part you need to track when did it change from wip and then ship, etc. ID PartNumber WIPDate PackedDate ShippedDate Reply if you need more help./

madctch, Little confused as to what you're trying to do. Sounds like you need an expression to evaluate based upon a date range. Something that says "if the date range is a specific something then yes else no" and then add those up. I suggest NewEnrollment: iif([date]>= some date,1,0)...

You mean you just want to suppress the record visually? If that's the case, I would think you need to add some more criteria to the query that the subform is based on and requery the subform after a user action. Then the record would no longer appear in the subform. Is this what you're...

Create a new query an put this in the SQL. You can then export the results. It's a start. SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.Attributes, IIf([datatype]=1,"Yes/No",IIf([datatype]=2,"Byte",IIf([datatype]=3,"Integer",IIf([datatype]=4,"Long...

HP Autostore may be a solution.