Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 2nd, 2005, 08:27 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default date function stopped working in report

I have several reports that use the date function. They have worked up until yesterday. Now when the report loads, I get a prompt for "date" and "format" as if it were a parameter query.

I have tried deleting the date textboxes and re-adding them, and Access still seems to think it is a parameter query. I have used both "insert" to add the date, and have even created the calculated text box myself, but it still acts like a parameter query and promts the user for the format and date. Interestingly the "now" function works fine. I've compiled, and compact/repaired with no change in results.
1) Does anyone have any other ideas of how to fix this?

Thanks!
Loralee

Reply With Quote
  #2 (permalink)  
Old December 4th, 2005, 05:44 PM
Authorized User
 
Join Date: Nov 2003
Location: Hillsboro, Ohio, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bjackman Send a message via MSN to bjackman
Default

check your record source for the reports and make sure there are no missing references or tables in the query itself. Some food for thought

Reply With Quote
  #3 (permalink)  
Old December 4th, 2005, 07:32 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Unfortunately, that is all intact. And the queries run fine on their own in QBE.

It appears VB may have lost it's reference to the functions Format and Date???? These are the 2 "parameters" it is asking for.

Reply With Quote
  #4 (permalink)  
Old December 6th, 2005, 05:46 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

If you havent solved this yet...

I would test out your date and format functionality by throwing them into a basic select query and see what comes out. Unless you have much bigger problems, cant imagine you would just lose a built-in function.

Assuming you can use them and further to bjackman's suggestion... you may want to check out all the "hidden" (I know they arent actually hidden, but I mean the non-body text bit!) parts of your report, like groupings, all properties etc, have done similar in the past before... from the sound of it, there may be a "[date]", rather than "=date()" knocking about in there somewhere, Access does do that kind of thing if you havent entered it initially correctly... pain in the derriere, get a colleague to help spot it... had to sort this kind of thing out before when removing fields from a source query and then realising they were used in one of the groupings or similar.

Good luck, they can be tricky to spot.
Reply With Quote
  #5 (permalink)  
Old December 7th, 2005, 03:05 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks, Lee (and bjackman),
I tried running each query again, and they run fine. I checked Properties, and Groupings, etc. and found nothing unusual. Still none of format or date functions work. Even on a newly created Report. And some of the calculated text boxes that had working concantenations are not working now. Now() still works. I think I've got a big problem.
Any other suggestions??

Thank you,

Loralee

Reply With Quote
  #6 (permalink)  
Old December 8th, 2005, 05:39 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

k, start a new mdb and try it out with that... failing that, err... reinstall Office?

I have come across similar but not the same in the past when not realising I was sat in a breakpoint of some code... far out suggestion, but make sure you arent sat in a breakpoint of some code!
Reply With Quote
  #7 (permalink)  
Old December 8th, 2005, 07:11 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

The .mdb must have corrupted somehow......
I ended up taking a backed-up copy of the .MDB, removed the older tables, and imported a copy of the tables from the broken .mdb that had the malfunctioning textboxes. So far it's working fine and the textboxes are behaving. I can't wait to just split the thing.

Thanks,
Loralee

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intellisence stopped working beddowsm Visual Studio 2008 3 September 5th, 2008 12:32 PM
Logins stopped working after adding to web.config troyb BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 5 September 2nd, 2008 03:34 PM
Help... Smtp.Mail.Send stopped working funtent General .NET 1 October 27th, 2004 07:26 AM
Intellisense stopped working in InterDev 6 riga1966 Classic ASP Professional 3 June 1st, 2004 05:31 AM
mid-function not working (i did something wrong) Haroldd Classic ASP Basics 3 February 11th, 2004 04:58 AM



All times are GMT -4. The time now is 01:14 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.