Search results for query: *

Hello. Does anybody know how to set Trusted Location in Trust Center via VBA? Thank you. sudakov.

Hello, I have a table with a MEMO field. I want to add records into the table by executing a parameterized action (append) query via VBA. Does anybody know how to run a parameterized action (append) query with MEMO parameter via VBA? Thank you. sudakov.

Hello, I have a table with a MEMO field. I want to add records into the table by executing a parameterized action (append) query via VBA. Does anybody know how to run a parameterized action (append) query with MEMO parameter via VBA? Thank you. sudakov.

Hello, Does anybody know how to create a drill-down report in MS Access 2010? Thank you. Sudakov.

Hello everyone, I have a report with approximatelly 100 records in Detail section (4 pages). The requirement is to display 15 bottom controls on the Front page and hide 10 of them on the other pages showing only 5 bottom controls. As my aprroach, I put all 15 controls on the Page Footer...

Hello, I have multiple (hundreds) MS Word files in a folder. I would like to write VBA code to convert them into respective PDF files. Does anybody know if this is possible? Has anyone done it before? Thanks. Sudakov.

Hello, I have multiple (hundreds) MS Word files in a folder. I would like to write VBA code to convert them into respective PDF files. Does anybody know if this is possible? Has anyone done it before? Thanks. Sudakov.

Hello everyone, I have a continuous sub-form within a form. Both forms are bound. The sub-form has a text-box control "TXB_AGGREGATE" that calculates Totals of the sub-form (=SUM([FIELD1]*[FIELD2]) in its Footer section. The Main- and Sub-form are related using LINK MASTER/CHILD FIELDS...

Hello everyone, I have a continuous sub-form within a form. The sub-form has a text-box control "TXB_AGGREGATE" that aggregates values (=SUM([FIELD1]) of a field in the sub-form. If a user has not finished entering a new record in the sub-form (user does not move to a next record) the text-box...

Hello, I have inherited a DB where most of programming is done using MACROS, not code. I receive an error during execution. Does anyone know how to trace macros? Thanks. sudakov

Hello everyone, Does anyone know how to loop through all queries to print SQL-text of each? My task is to find name of queries that use function ROUND. I created the following code: Public Function varSearchStringInQueries() Dim db As Database Dim qdf As QueryDef Dim strSQL As String Dim...

Hello, I have a date-type field in one of my tables. After I ran (and compacted) my database on another machine the date-type field format is changed from "D/M/YYYY" to "M/D/YYYY". Does anyone know how can I restore the format "D/M/YYYY"? It is important to keep this format since values of the...

Does anybody know how to create a link to MS SQL Server’s table in MS Access database programmatically? sudakov

Hi everybody, does anybody know how to set startup option "Allow Default Shortcut Menus" via VBA? I tried the following: Application.SetOption "AllowDefaultShortcutMenus"), False and CurrentDb.Properties("AllowDefaultShortcutMenus") = False No success for now. Does anybody can help...

I am developing a MS ACCESS application for a client that has non-stable network. The application is split into front-end (on Client PC) and back-end (on LAN). I use mostly unbound forms to minimize connection time to the back-end database (MS ACCESS as well). My goal is to decrease chances of...

Hi everyone, I have a MS Access 2003 application as front end with SQL Server 2005 as backend. Previously it was Access 2000 front end and SQL Server 2000 Back end. Now it has been converted to Access 2003 front end and SQL Server 2005 backend. The tables in Access are linked to the tables in...

Hi everyone, Does anybody know what type of file with DBQ extension is? Thanks, sudakov

Hello, I would like to protect my code by setting password to view the code. I heard that some parts of code will not work after password-protecting the code. Did anyone experience problems to run code after protecting it with password? Your help is appreciated. sudakov

Hi everyone, Does anybody know whether it is possible to protect code and to control code version of MS Access 2003 application using Visual SourceSafe? This means it will not allow some users to modify code, on the other hand, it should allow some users (developers) to modify the code with...

Hi everyone, I have a pop-up form (POP UP property set to YES) that displays a WAIT message, while my code performs activity that takes some time (compacting, copying files etc). At the end of the code I close this pop-up form programmatically. Everything works fine until a user decides to...