Recent content by indyaries

Thanks, Sergeant, for the reply. I tinkered with your reply for a bit, but most of my time has been consumed with dealing with the hail storm we had here in Indiana. Alas, I couldn't get your solution to work for me. However, I found another solution late last night... TRANSFORM...

Sorry for cross-posting. I posted this in the Tables forum, but have had no replies in over 12 hours. I searched on IMPORT (72 threads), but didn't see anything like the problem I have. I have a large Excel file formatted thus; COLUMN A 1 Full Name 2 Full address 3 City State Zip Columns B...

No response in 12 hours ?? Perhaps I should have posted this in the Queries forum. I simply need to get the employee information in tabular format, rather than the columnar that it's in now.

Greetings, I searched on IMPORT, but didn't see anything like the problem I have. I have a large Excel file formatted thus; COLUMN A COLUMN B COLUMN C 1 Full Name 2 Full address 3 City State Zip 4 Phone SSN Sex Alas, as you can see, the first...

Hello Bat17, Absolutely nothing happens. The record is allowed to save even though a duplicate exists. The message box does not appear.

Hello Bat17, Absolutely nothing happens. The record is allowed to save even though a duplicate exists.

Hmmm....no responses yet. Well, below are my attempts to make this work. Here, I wanted the combo box for the Nominator to remain invisible unless the Award Type combo box has the word Peer in it. It works (sort of), but only if I leave the record, and then return. I'd like the combo box...

Greetings, I am using Access 97 at work, Access 2000 at home. This is a work project. I have a database that tracks employee awards. One type of award is the Peer Award. An employee can receive more than one award during the reporting period (01 May 05 through 30 April 06), but an employee...

mresann, Worked like a charm!! Thank you very much!!

mresann, thanks for the rapid reply. I pasted your statement into the query grid, but it returned an error, stating that there were the wrong number of arguments. What you wrote makes sense...I'm guessing that the punctuation may be off ?? Hoping for a reply :)

Greetings, Have an address list with over 600 names, and I need to create mailing labels. Have First Name, Last Name fields, with city, state zip. BUT... There is also a field called SPOUSE. This field is NOT always populated. I need a query that I'll use to create the mailing labels that...

Pat and Kenn, Thanks for your help. Pat, I'll check out that Contributions table you pointed me to. Thanks again !! :)

Hi Kenn, Thanks for the rapid reply. Since some people already have more than one dog, does that mean that; 1. I'd have a table for Contact info 2. One table for each of dog 1 through 5 ?? Is there a way to set it up (perhaps in a query?) to have all 5 dog tables somehow linked, then use...

Greetings, I have a friend who is using Excel to track a Greyhound Protective Association roster. These are folks that foster and adopt Greyhounds -- thus a worthy cause. It has over 600 rows of data. I've attached 50 rows of sample data in Excel format. Along with contact information...

In a TextBox, place this: ="Data Source: " & [RecordSource] I usually put this in the report header portion. Other useful info: Database Name ="Database: " & [CurrentDb].[Name] Report (or Form) Name ="Report: " & [Caption]