Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-22-2003, 02:04 PM   #1
EPD Hater
Registered User
 
Join Date: Mar 2003
Location: Harrisburg, PA USA
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
EPD Hater
Send a message via AIM to EPD Hater
Modal Pop-up Form Problem

I'm kinda new here, I've been getting into Access primarily for work, and have this database that I'm working to actually use as an export tool to automate some things in my department.

I work with Access 97. Anyway, I have a form popup when my "export" button is clicked (through a macro). It's modal and it contains custom "yes" and "no" buttons; "no" closes the form, and "yes" leads to another macro (to eventually export). I also have some control data on the form (I hope "control data" is the right terminology) which takes =COUNT([SSN]) and =SUM([Amount]) from a table called "Committed Data" and places it on the form. This works fine, but if there are no rows in the Committed Data table, the form popup is totally blank: no text, buttons, or labels. What could be the problem? I hope to have been thorough.

Or I could avoid this problem and check to see if there are actually any rows to begin with and if not, just give another message.


Last edited by EPD Hater; 04-22-2003 at 04:55 PM.
EPD Hater is offline   Reply With Quote
Old 04-22-2003, 11:36 PM   #2
Mile-O
Back once again...
 
Mile-O's Avatar
 
Join Date: Dec 2002
Location: Glasgow, UK
Posts: 11,312
Thanks: 4
Thanked 118 Times in 108 Posts
Mile-O will become famous soon enough
Try these:

=COUNT(Nz([SSN],0))

=SUM(Nz([Amount],0))
Mile-O is offline   Reply With Quote
Old 04-23-2003, 05:20 PM   #3
EPD Hater
Registered User
 
Join Date: Mar 2003
Location: Harrisburg, PA USA
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
EPD Hater
Send a message via AIM to EPD Hater
Still the same problem; the form is totally blank if there are no rows in the table. Thanks anyway, I'll just have to find another way to deal with this.

EPD Hater is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 07:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World