Web Development

Ask something
Discussion Locked

Access 97 Really Tough One

0 helpful
5 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a DB of Members (Parent Records). Each Member has several Children (Child Records). I have a button which runs a query and outputs the First Name, Last Name and Birth Date of each CHILD into an Excel Spreadsheet.

This worked fine until the guy who uses the Excel Spreadsheet said he needs the birth dates in YYYYMMDD format with NO Seperators.

I wrote my own function (I'll send it to you if you give me your Email Address) and the function seems to work. Each child is on a seperate page and I can see the birth date and the "New Format" birth date. Switching pages changes the birth date and "New Format" birth date without a problem.

HOWEVER, when I output the data using the query, I get whatever birth date was on the page where I hit the Export button. And every child has the SAME BIRTHDATE.

I can send the query for you to examine.

Thanks for your help!
This is a real brain teaser!!!

Alan
Abramowitza@coned.com

5 replies

by baronpublications

I haven't really encountered this using Access but I did encounter this when programming in Visual Basic. Since Access uses VBA maybe more or less this problem is related. What I did was to reset the Recordset whenever the button is pressed and do a Requery on the Recordset.

by grtammi

Alan:

Can you post the query here so others may look at it also? I'm not a SQL guru by any means, but I think either myself or someone else would be able to assist you easier.

Greg

This discussion is closed to new replies.