Recent content by ddmcn

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...

Maurice, thanks for your reply. I am running this code in an ADO database and it seems to stall on some of the statements. I am having some amount of trouble re-writing it to suit the ADO environment. Any hints? TIA

Thanks, Dennis. Of course, you're right. The table has a column with the org id and another column with a sequence number. The form is organized first by org id then by the sequence number. What I would need to do is change the sequence numbers so that the new record fell into the right order...

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...

You ever hear of Afghanistan? Of course you have, the Brits tried that one too didn't they? :)

The question was..."What gives the state the right to put people to death? My input was that we do...with our laws. I've been back and forth on the death penalty myself...but, the law is there because we put it there. :o

Why is it that when someone does something wrong we try and figure out what society did to cause it? Whatever happened to personal responsibility? We, as humans, know the difference between right and wrong. We make choices every day between doing the right thing and the wrong thing. We are also...

Ancient Law The state, as was aptly put, is you and I. The authority of the state to punish offenders is not a new idea. The idea that the state has no right to punish criminals is pretty scary...I think it is called anarchy.

Help! Pat, I've looked at the code. It appears to require user prompt for the number of duplicates. Any idea how to alter the code to look at a column in the database to determine the number of duplicate labels. For instance, the items I need to mail come in boxes of 10. If a customer needs...

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."...

UPDATE: Problem Solved Thanks for the reply. I looked at the NW database and didn't see a solution. However, I was able to filter based upon another field, an alpha designator field, that allowed me to include all the records regardless of lower or upper case.

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...

Remote Platform? Oliver, What is the platform for your remote database...Oracle, Sybase...

Hmmm...another table might help. First, the table would identify users by a key field (userID) and that userID could be used to identify which records in the reservations table would be related to the user. A form or report could be used to display the user information with a sub form or sub...