Search results

I need to add "dots" between columns in a report so that a line in the report might look like: Queen................................................Elizabeth II What I cannot figure out how to do is add the string of periods between the two columns. The fields involved would be POSITION and...

I am trying to find a way to "insert" a record into a table that will not put the new record at the end of the table but insert it into the middle of the table. For example, let's say that I am keeping track of officers of a trade association. The association has a president, a number of...

I have an address table that contains a field showing the number of copies that the addressee should receive. Is there some way to get the report writer to create multiple labels based on the number of copies column? TIA

I have an Access database that is linked to an Oracle database. Until recently the Oracle database was version 8i, however, it is now 9i. When trying to retrieve data from one of my tables I am getting the following error: "The width of a Unicode text column must be an even number of bytes."...

I am using a series of buttons (a-z) to filter records on a form. It helps navigation to a specific record easier. What I am having a problem with is making the condition case insensitive. Code looks like: DoCmd.OpenForm "FRM_APPENDIX_A",,,"TERM Like 'A*'" It will only pull up records where...

Hi, all...here's the deal. I have a report that I can run that creates a very long report organized by country names. What I would like to do is write a script that will export the report into rtf files by country. In other words I would like a module that would write a separate rtf file for...

Hi, all...this is my first post here. I'm trying to figure out how I can highlight the current record on a form in datasheet view. In otherwords, change the backcolor on the fields in the CurrentRecord. I have tried a coulple of things but Access changes the back color of all the records...