General discussion

Locked

Access 97 Really Tough One

By MRA2 ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by baronpublications In reply to Access 97 Really Tough On ...

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.

Collapse -

by MRA2 In reply to

Poster rated this answer.

Collapse -

by grtammi In reply to Access 97 Really Tough On ...

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

Collapse -

by MRA2 In reply to

Poster rated this answer.

Collapse -

by MRA2 In reply to Access 97 Really Tough On ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums