Search results

Thank you all for the replies, then, Please help me in setting a sql server database as a source to access form ( which is already designed ) using Access VB code.what is the code and syntaxes used to connect for a multi user access application.

Can we take sql server database as source for a Access Form on other system on the network?

Hi Cheer, I'm John.i'm totally new to access & vba coding. I saw a sample dynamic database model created by you( the database was named as elemac Reporting.), in which you disabled all the access objects and made them hidden , Please help me i also want to hide tables,queries,forms except...

Thanks dave But, If i change security setting to low of one access file, will that change settings of all other files in the PC.??

Thanks for response gemma & fifty, But , It's something like i have to prepare a database and send it to a user through mail , and when the user gets the mail of this database and opens the database he should be prompted for user id , and when he enters id, VBA codes & macros should...

Dear Friends, I Know that enabling the macros without security warnings is not recommended in access 2007, But I want to enable them automatically for few users , Please help me how can be done,coz it appears whenever the database is opened. Help me how i can prompt for a user name , and...

Dear Friends, I have searched for this but I couldn't find , I'm sorry this was already discussed. I Have created form , in which I want to update a textbox, based on the value of list box. I have YES,NO as the rowsource for the list, and 3 textboxes, name...