Recent content by richardn

I am using "DoCmd.OpenReport strMyRepName, acViewPreview, strMyFilter" command to open a report in a preview mode. How can I avoid to open it if there are no records? I tried to use the NoData event, but after this event occures the command DoCmd.OpenReport ... , and I get an error. Please...

How can I print a report from VBA? For example I have a report named rpt1, and I want to print'it from code, not after opening the report in preview mode? Thanks, Richard

I use the Calendar ActiveX to select a date. The calendar have a dropdownlistto post the selectede date? I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list. I think that the control have a dropdownlist to show the selection, but i...

I tought about this solution, I hope there are other ways to do this. Thanks for your help. Richard

I have to run a SQL Statement (make table query)from code that creates a table, and sometimes one of the fields in memo type. in this case I get an error: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" How can I control the...

What's the maximum number of joins (primary keys) from a table in MS Access XP ? Is this possible to change this limit? Thanks, Richard

A lot of thanks.

Hi, Please some help about printing a treeview. I would like to print all branches from a selected node, or the entire tree. Thanks, Richard

Thanks, I will check this link.

Hi to everyone, I need some help about using treeview control. I have a table (A) with 2 columns : ParentID and ChildID. The names of ParentID and ChildID are saved in another table (UsersProperties table). I want to fill the treeview with records from first table(A), so I can see in the first...

How to catch the "F1 key" Press event ? (from a form) Thanks

I would like to know when records or data in a table was changed. I tried to use the DateUpdate field of MSysObjects system table to catch any change in contents of table. When I change records (delete, update, append) and closing the table without SAVE, the DateUpdate field did not...

I would like to know when records or data in a table was changed. I tried to use the DateUpdate field of MSysObjects system table to catch any change in contents of table. When I change records (delete, update, append) and closing the table without SAVE, the DateUpdate field did not...

Somebody can explain what means each column in MSysRelationships system table , especialy this fields : ccolumn, grbit, icolumn Thanks

I have two databases : the first is a MS Access XP DataBase and the second is an Oracle one. In MS Access I have a table (A) containing my customers, and in Oracle I have a table (B) with all customers (including my customers). The key is the same key in both databases (CustomerID). I am...