Search results

That did it. Thanks for saving me. :)

I am a complete moron so bare with me here.... I went into the Tools\Startup section and turned off all the menus and such. Now I want to go back in and change those settings but I can't see any of the menu choices (ergo Startup is missing). I'm stuck in a catch 22. I need to change that...

Thanks, that works...and after changing the on click expression to close the database it makes it so that the users don't have more than one instace of Access open. Thanks again for your help.

I have about 7 databases in my company all in one shared drive. Each Database has a really nice switchboard form. I want to ease my users' use of these databases by making one main switchboard that has buttons that open the switchboards of each of the other databases. I figured I would make a...

I think you'd prefer this route: Go into the design properties of the form and enter code builder. Enter in this line in the On Activate section Private Sub Form_Activate() DoCmd.Maximize End Sub

I'd agree with your suggestion...there were just so many entries that I wanted to make the other queries and reports that only had to deal with one year faster by keeping them split. I'm just going to combine them all I guess since it would be a heck of a lot easier that way. Thanks

Hi, I have a couple tables with sales data split by year...so for example I have one with all the sales data for 2001 called 2001paid Now I want to run a report or query on these tables so that I can get all the entries for a specific sales code across all the years. How do I make it so that I...

Thanks that led me to the answer. For those looking to solve this problem too enter the design of your form and go to the event procedure for the preview or print button you created. You'll find a line that starts "docmd.openreport" without the quotes. If you want the current record only then...

I want to get a really good Access book to help the programmers in my office. Something that at least lists the functions and their usage/examples. Any ideas??

Hi, Not sure if this falls under Reports or forms but either way here goes.... I have a form with a button that when clicked previews a very plain report of all the record sets in the table. What I want it to do though is jump to the page that has the current record set's info on it.... Does...

I can't solve the problem but I might be able to help with sending the file. You might want to try compacting the database....zip can help but before you do that try this: Tools/Database Utilities/Compact and Repair Database ....if its still too big you may want to delete some of the stuff...

It works great. Thanks for your help!!! For those that need that explained a little more: By going into the properties of the text box and setting my control source back to the date field I wanted to use and changing the Format on the format tab of that property sheet to mmmm my dates have...

I have a report that I'm trying to build that sorts purchases by month... So I end up with something along the lines of this: 1/12/02 John Smith 1 unit $4.00 Jane Doe 2 units $8.00 2/20/02 Joe Johnson 1 unit $4.00 ...now...

Never mind...figured it out.... I just used like "*FL*" or like "*strat*" and it works great.

I'm sure this will be pretty easy for most of you but I'm stuck. I have a crosstab query and I want to filter out entries that do not contain a string of text. I'm used to using "like" in the criteria to find matching fields to the string but that doesn't work when I want anything that at least...