Report not giving info as I want it 1

[VirtualWebgistics]

First, I am no Access guru ... and although I've learned the basics, I still have troubles most days.

I have an Access db I created, which has a table called 'Frequency', which has 'weekly', 'monthly', 'as needed', semi-annual', "annual" etc. in it. I have created a report which is sorted based on frequency, and used a combo drop-down box where the selection can be made.

However, now I am thinking I'd rather have the reports all print seperately, and am not sure how to achieve that. I'm not sure if I need to put each frequency (weekly, monthly, as needed, etc.) each in their own individual tables in order to do this, or if I need to know some coding to make this happen?

Basically in my Switchboard, I'd like for there to be buttons for "Print reports for weekly frequency", "Print reports for monthly frequency", "Print reports for semi-annual frequency", etc.

If anyone has a little time and could help me with this, it would be greatly appreciated.

Warmly, Jules

 

[VirtualWebgistics]

Fred, I still cannot figure out why they're not working, but will have to attack it on Monday. I'm heading on a 40th Birthday trip to LA here shortly, and it'll have to wait.

Thanks for your help and have a super weekend! Jules

 

[VirtualWebgistics]

Well, having spent my 40th having lunch on the Santa Monica Pier, wiggling my toes in the sand walking Venice Beach, and then enjoying dinner with friends on Long Beach, I am now back to work and ready to tackle my database and try and figure out what's wrong.

But ... I just opened it and all is working fine. All three reports give me the info I ask for. And now I am still trying to figure out why they would work, then not work, and now they're working. Maybe some sort of Access glitch?? Any ideas?

HUGz! Jules

 

[fredk]

Not sure but they are working ?

Fred

 

[VirtualWebgistics]

Fred, I just opened and tested again, and yes, everything is working, and the reports are coming up as asked for. I don't know what the glitch was, but it seems that it straightened itself out (crossing fingers.)

Two more questions if you don't mind.

1. When I make a selection from the switchboard and the reports open, they open under (or behind) the switchboard. Is there any way to get the reports to open in front of the switchboard?

2. In my form, where the combo box is for Yes/No, is there anyway to set it where it is always No on a new form, and only will go to Yes if changed by the user?

The reason for this is so that all new form entries will automatically be set as No because they are a new work order, and will only be changed to Yes once they are completed.

Thanks bunches! Jules

 

[fredk]

To get the report to maximize put the following in the on open event of the report:

DoCmd.Maximize

Regarding the form question - go into the design view of the form and select the combo box for yes/no - then go into the combo box properties - under the data tabe there is a property called default value - enter the value you want the box to default to here.

HTH

Fred

 

[VirtualWebgistics]

Thanks Fred ... you are a true doll!!

Now I've gotten myself where I thought I needed to be, but now I'm not sure I'm going to be able to actually do what I'd like for the end result ... in that I'm not sure it's do-able in Access.

I started a new post here:

http://www.tek-tips.com/viewthread.cfm?SQID=838747&SPID=703&page=1

My boss has given the go ahead for me to hire someone hourly if it is something that can be done, but only by someone who really knows what they're doing. ;-)

HUGz! Jules

 

[VirtualWebgistics]

Fred ... I added the above OnOpen command, and I get this error:

"... can't find the macro 'DoCmd.'

Do I have to create a macro first?

Thanks bunches! Jules

 

[fredk]

You need to select "event procedure" in the onopen event of the report .... then click on the three dots "..." this will open the code window - enter DoCmd.Maximize there.

Let me know....


Fred

 

[VirtualWebgistics]

Hi Fred! Well, it works ... in that it opens 'full page' ... maximized ... but what I want is for it to open "on top" of the Switchboard, or ... when I open a report, the Switchboard 'minimizes' itself, so the report is the only thing showing. Does that make sense?

Right now, I open the proggie, and the Switchboard pops up (thanks to you) ... and then if I click on one of my buttons to open a report, the Switchboard stays on top, and the report opens behind it. In order to view the reports, I have to manually minimize the Switchboard ... so I was just trying to see if there was some code I could put in there to make it happen without me doing it manually.

If not, no biggee ... I'll deal with it. As you know, I have bigger problems than that right now. lol

HUGz! Jules