Search results for query: *

I do not think that this a version issue. I created the db with A2000 and I tryied to convert it with that same version (no updates or changes of the version in the meantime). How can I check if Access has compilation problems? I compacted and repaired the db without problems. When I save and...

Thanks lupins! I am trying to convert the db with the same installation (without any update up to now) of Access with which I created the db. Do you know if Access creates a log file or something similar during the conversion process that contains a description of the errors? When I try to...

Hi there. I need help about creating an MDE file of my Access db. The db to be converted contains linked tables from an Oracle db. Access is currently not able to create an MDE file. I assume that this problems results from the linked tables. Is it possible to create an MDE file anyway? I...

Unfortunately I don´t have writing access to the Oracle db, but there are primary keys defined.

Thanks to both of you! The last interpretation is correct. The problem is that the primary key column contains values that differ only because of free spaces. As you stated Access doesn´t distinguish these records. I can solve the problem by linking the tables from the Orcale db, but the...

Hi there! I have a problem with a db that has imported tables from an Oracle db. I imported the tables for performance purposes as direct queries to linked tables take very long in this case ... Unfortunately the Oracle db contains recordsets for which the primary keys distinguish only through...

Hi. I have a problem to sort a table by one column (sounds too easy, I know). I created the table by importing it from a text file. After the import I added a column (Memo format). I did not change any properties of the column or table. Now it is impossible to sort the table by the column added...

I appreciate all of your replies. The textbox can´t be placed in the header or footer section as it has to appear besides (on the left side) the contents of the report (design standard of my company...). The height of the textbox (about one third of a page) causes in a lot of cases blank...

The textbox (about one third of a page high) has to be placed in the lower left part of the report. So it can´t be located in a header or footer. The details area for recordsets consists of two components: a 'header area' for each recordset, and a 'text area' depending on the header area...

Thanks Tom! The problem is that the textbox has to be besides the contents on the left side of the report. As the text box has a lot of rows a format problem occurs when the details about a recordset have fewer rows than the text box. Even if invisible the textbox having more rows than the...

Hi there. I´ve a problem during the development of a report. I´m generating reports from a query with a variable number of pages depending on the recordsets selected before. As I would like to send these reports to customers I need to have a textbox containing company information on each first...

Thanks lewds for the hint! As it is important for me to know if an item of the list is marked and not only if the list contains values I added 'listname.value =""' at the end of the if construction. That seems to work without error.

Thanks in advance for any help!!! I use the expression 'listname.value' in an 'if' construction in vba code to remove entries from a list in a form by clicking on a button. 'Listname.value' returns a unique id for each entry of the list that is selected (by the user) in the form. When the last...