Search results

Good day! I need to change the property "Pop up" for all forms depending on user name. i.e. if username is "abc" then all forms pop up property will be "yes" otherwise, it will be set to "no" Thanks in advance

Thanks all, I'll try the best workable one. Thanks again

Good evening! I need a code to link a table from an external database (protected with password) so that the linked table will be in ReadOnly mode in the destination database. Thanks in advance

@arnelgp It's working perfect. But my VBA can't access the tables. I use the following code to deal with a table: Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = OpenForSeek("client_master") rst.Index = "client_id" rst.Seek "=", client_ID And here's the OpenforSeek...

I don't know how to thank you dear!

I revisited my code. the enclosing bracket ) is there. I appreciate if you send me the sample on which you have tried. Thanks a mile arnelgp

It works with "*" in tablenames but with selective tables it doesn't work neither it gives any error message. I've also tried to refresh the database window manually, but still the same. !!! I also noticed that when I use : 'Call Relink("d:\database\db_be.accdb", "my_password", "table1"...

Thanks a lot. I'll try it and revert to you. Thanks again

I'm talking about new linked tables. This code links only one table as prescribed in the (strSourceTableName = "client_master") line above. I need to link all tables in the back end database with the same code Please!!!

Good day! I have a back-end database which is protected with password. the following code imports one table only, I need a code to: 1) Link all tables in the back-end database; 2) Link particular tables. Code: Dim db As DAO.Database Dim tdf As DAO.TableDef Dim strConnect As String Dim...

Thanks, I'll work in it. Kindly let me revert to you later

I have two databases; one for forms (db1) and the other (db2) where I kept my tables (protected with password) Now, I need to bound data in a form; form or sub-form recordsource, combobox, listbox ...etc. to that external database without linking tables. NB: linking tables will enable the user...

Do you have a code for that?

To open the image for preview. Sample for attached. thanks

Hello again! I have an unbound image on my form. when I double click it, it opens in the default image opening application. When I come back to the form, the focus is not moving to any control on the form. I must close the form and open it again. How to resolve this very please? Thanks

Thanks for all of you

It's very confusing to use "quotes" with the docmd.openreport. Can any one please and please, provide us standard forms for: 1) Docmd.openreport,,, where NUMERIC FIELD= NUMERIC FIELD and NUMERIC FIELD= NUMERIC FIELD 2) Docmd.openreport,,, where NUMERIC FIELD= NUMERIC FIELD and TEXT...

Thanks a mile

Thanks for your kind reply and directives. However, for some reason I need to do that by a vba code like: docmd.runsql ("update cost centers ....... set cost centers.debit=sum of( a field in a table or query). Is it possible?

Thanks for your persistent support. I have a table (transactions) with the columns: date; description, debit, credit and cost center. The second table is: Cost centers summary with the columns: const center and balance I need a vba code to update the sum of credit (for example) into the table...