Recent content by rmunteanu

You were right, HiTechCoach. Grouping was the problem. Thanks a lot.

Hi, I have a problem with a report. I modified it from the original version, I changed the data source of the report and then data source for each field. One of the fields is no longer available, so I deleted its control (text box) from the report. When I open the report I get the message of...

Hi, This kinda solved the problem but there is only one aspect. In a query this works fine now, but I have a form that uses a query as data source. The form is used in datasheet view and filtering does not work there. what could be the problem? I think these are ODBC fields that I want to...

Hi, I have a problem with manually filtering data in results of a query (Datasheet view).I am using access 2007. In some fields I can filter the data by selecting the column header and clicking toggle buttons on each data value in the filter list (Like in excel 2007). But in some columns...

Hi. I encountered an error in exporting a report in rtf (MSWord). When displaying the report it is ok but when trying to export to rtf there is a problem: In the report I have grouped data by a category, and in the group footer I have a total for the group. When exporting it displays the total...

Hi. I am experiencing approximately the same problem. I have a report that groups data by a category and I need to export to excel respecting the format of the report: the category subtotal row detail is displayed in the same column with data (no indent). I don't have the solution. I would...

Hi, I have 4 identical databases in different server locations (long distance, slow connection). I want to unify data of all 4 databases in another database. I tried a single database with several access points but it doesn't work (very slow) due to the small bandwidth of the connection...

Hello I have a problem with a report when exporting to excel. (in ACCESS 2007). When outputting the report to excel it looses it's formats. For example the grouping becomes heading and does not look like the original report anymore. I attached an image of the report (in ACCESS) and an...

Hi. I am using 2007 but I did not find such option. Can you direct me to it?

Hi. I am interested in exchanging information about ACCESS 2007. Contact me anytime!

Hi. You could try this: Open properties window for "FORM" In DATA tab, set "Recordset Type" property to "Dynaset (Inconsistent updates)" I hope this will help. Have a nice day!

Hello! First, to get rid of the annoying borders just open the subform in design mode; open PROPERTIES sheet for "Form"; in format tab, on "Record selectors" and "Navigation buttons" choose NO. You can also set BORDER STYLE to Dialog. Second, for the report to display only certain data, based on...

Hello, I need your help. I am realy :confused:. I have made a report that is grouping data by a category. I would like the report to show the total rows only for categories that have more than 1 row in the report. If one category has only one row, I want the report to show only the data row...

Hi, I am working in Acces 2007. I added a "refresh form data" command in a form on a Combo Box control on "Got focus". I did this to automatically refresh data in the Combo Box list after adding new data. The problem is i have some fields that are marked "required" and the form does not refresh...