Search results

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]

You can also highlight each line with alternating yellow or some other color. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Const vbYellow = 65535 If Me.CurrentRecord Mod 2 = 0 Then Me.Section(acDetail).BackColor = vbYellow Else...

Hi Rich, Wish it were that easy. Management wants to print 5 records per page. I've managed to do this. However, now they not only want 5 records per page, but if there are more than 5 records with the SAME contract number, they want those to print as a group; then page-break for the next 5...

I have a report that I have printing 5 line per page. Now, I have a requirement to have the report not only print 5 lines per page, but when a contract number has more then 5 lines, then I need to have THAT contract number print all of its lines. Example: Many of the lines contain one or two...

Friday, Unfortunately, I have no control over the formatting of the data I receive. I've been able to work around the problems, though. Bob in Indy

Pat, I agree this could be done. I was thinking of import errors. I had Excel data that I could not get to import properly. Access would generate import errors on this field, as it contained a mix of text and numbers on some records, and just numbers on others. I needed this field to import...