Search results for query: *

Fred, this isn't for a client ... it's for me at my FT job. I'm the Admin. Asst. for a Facilities Department at a college, and this thing is for me to finally be able to issue and track Preventive Maintenance jobs. Although our budget is strapped, my boss did say that if I needed to pay...

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...

Good morning Fred, >> You will have one table that holds all of your tasks - you will add a field called frequency (which you may already have) You will run your reports (I would use reports instead of forms) each week/month based on the tasks that need to be done (similar to what you have...

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

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...

Thanks to Fred, who has helped me tremendously, my db is almost to where it needs to be, but now I'm wondering if I've gone about it in the wrong way ... for the results I need. This all started out as a way to enter in maintenance work orders that would repeat either monthly, quarterly...

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...

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...

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

Well ... I didn't change anything, and now the Building combo/button/report are doing the same as the Completed one. It pulls the report, but it's just a blank page. Wonder what's going on?? I'm going to step outside into the sun and fresh air and think about it. ;-) Why would the Building...

Okay, I got rid of the extra queries and tied all the reports to the Query called FrequencyQuery. And, the Frequency combo box and button seem to be working right, only pulling the reports for the frequency that I select. Same thing with the Building combo box, buttona nd reporting. However...

Wow, I was off base there. I had created three queries called BuildingQuery, FrequencyQuery and CompletedQuery. Now I think I get what you're saying. So let me make sure I understand. I'll go into say my BuildingQuery which is from the AllData table, and then down under the field Complete...

Fred, I thought I had worked through everything, but I'm unsure about one thing. When we were doing the Building and Frequency queries, I had to add all of the fields to make it work. However, when I am in the CompletedQuery, if I try and build the query from the table called Complete (which...

>>Do you have a field in your table that stores this field as a yes or a no?<< Yes. >>you just need to add that field to the query and follow the same direction<< That's where I don't understand Fred. Do I put the same exact criteria as we used on the others...

Okay Fred, I am now to the point where I'm ready to make the query for the button on the report, but just need help with how to set the criteria so it runs with just a yes or no, based on the drop down chosen. Thanks bunches! Jules

Well, the problem there is that I only need certain information in the Completed Report, such as Id#, Building, Category, Equipment & Completed. I've already completed the form design, now I just have to know how to make the rest happen. HUGz! Jules

I am laughing at myself now. Okay, I think I get what you're saying, so how do I know the code for the yes/no criterea? And I'm guessing the first step is for me to build the report, right? BTW - is the code such as we speak of somewhere in the program ... or do you have to know Access Speak...

Fred, it doesn't make much sense to me, but that's because Access Speak is so foreign to me ... along with the fact that I get confused about where things are and what's driving what to make things work. That said, here's what I'd like to do, in full detail ... which will hopefully help you...

Okay ... never mind ... it appears to be working now, without adding the criteria to all of them. I hope it is at least. Now I have a question about how to create a new report based on if the box for "complete" is yes or no. Do you want me to continue on here (and we'll go for the longest...

Fred, do I have to add that [forms]![yourform]![yourcomboboxname] or [forms]![yourform]![yourcomboboxname] is null criterea to every field? Thanks, Jules