Search results

i have tried encrypting the database and splitting the database as well (front-end and back-end). even by doing these things, users are still able to see the tables and open the tables. they can change/add data thru these tables. i don't mind if they are able to open the table just as long as...

is there another way? because if i do this, i will have to update all the forms, queries, reports that link to the table. or do these objects update automatically when i rename a table? even if the table is visible to the users, i dont want them to CHANGE ANY OF THE DATA in the table. how do...

hi tony. where did you place this specific command? i am also looking for ways to totally disable the navigation pane. changing the extension name to accdR helps but a user can change this extension name. what i want is even if the user can see the tables, they cannot be able to view OR...

hi Atomic Shrimp. i have the same table structure as lok1234 and i want to split the field into multiple rows (just like what you showed). how can i do it without any complicated programming language? i am not knowledgeable with VBA but i can work with queries. thanks.

how can i convert a field into a multivalue field? my field is separated by commas. example: this is the original entry: field1......... field2 204 ............418,419,420 what i want: field1...

i want the form to show the original entry the users made, all accounts that they used regardless whether the account was active or inactive AT THE TIME OF VIEWING. the underlying table of the subform contains all the accounts that they used. its only in the form that the inactive accounts...

thanks, vbainet. the requery still did not work. i'm just wondering why you are suggesting a requery? the query which the combobox is based on is working perfectly. users only see all the ACTIVE accounts when they make accounting entries. here is another example: this morning, i make the...

subform is linked via master-child links. there is no problem with the query. whenever a user clicks on the dropdown arrow, only the ACTIVE accounts are shown, which is definitely correct. it is only when an active account becomes inactive that i have a problem. when an active account is...

to vbinet: i have no problem with the report. i also have no problem with the filtering of the combo box. when i click on the drop-down arrow of the combo box, i see only the ACTIVE accounts because i filtered the query to show only active accounts. my problem is with the form (not the...

this is my problem: i have a combo box that looks up values from a query. i filtered the query to show ACTIVE accounts only. when i click on the drop-down arrow, i only see the ACTIVE accounts, which is correct. my problem is when an account becomes inactive. i go back to the old...

i am an accountant and i try very hard to understand the VBA syntax. it makes me dizzy:D so to be on the safe side, i either use macro builder or expression builder. i dont have the database with me right now but i know what i want to happen. this is the expression in plain english: (i am...

the expression builder's limit is only 255 characters. i am using a macro to set the value of a field of a table (together with an IIF condition). access uses the full syntax name of a field that is on a subform. i already used the "alias" function in the property sheet of the subform to give...

i have a form with a subform. the codes that you gave work on the MAIN form. my SUBFORM is in DATASHEET VIEW. how will i be able to add the 'allow edit' button to my subform and make that 'allow edit' button to work as a whole in the subform (not on a per record basis because this is...