Recent content by Marjano

I have searched a lot on the web and it seems that this is impossible. I just need to You to confirm me this. I use locking for edited record. When user try to edit the record while other user is allready editing that record - it is not possible and he can see the sign in record selector. But...

Can someone give me vba code for changing the table links. I have msaccess application that I want to use with different msaccess databases (by lining the tables) and I need code for choosing the location for msaccess database file so that all links can be refreshed for new target location...

Any other tool ? Is there any other tool? Upsizing wizard can not translate any query that contains form field as a condition - for example.

Is there a tool that converts Access querys (jet syntax) to sql views and procedures (sql server syntx)? Thanks

Is it same thing about speed and other issues to have ADP application that works with SQLserver and to have a MDB (or MDE) application that has no querys but works with sql views instead? Thanks

I have a small MsAccess application as a mdb file and I have a many querys that use some field in a form as a condition. For example: Forms![formx]![fieldx] is a condition for query's field. I have upsized my access application (mdb) to access project and theese querys does not work anymore...

Has anyone had this problem: You make an access mdb database "X" with table "A"- which includes autonumber field and few more fields (text or something else). Than You make another mdb file "Y"- which contains link to table "A" in mdb file "X". When You open mdb file "Y" and You open linked...

How? Can you explain me how to do that?

Is it possible to connect access data project with two or more sql databases? Thank you

I recieve this error message when I run some parts of my access applications on some computers: "A problem occured while Microsoft Access was communicating with the OLE server or ActiveX control. Close the OLE server and restart it outside of Microsoft Access. Then try the original operation...

Is there a function for cumulative row for use in querys (calculated field) or in a code - something like "running sum" in reports?