Search results for query: *

Hi CosmoKramer, Your idea worked! Thank You Thank You! I Greatly appreciate the help! jedlag

Hi LonnieJohnson and CosmoKramer, I'm gonna try CosmoKramer's suggestion and just have them put in the month. The workaround I found on my own, I love banging my head against a brick wall, was to build the database in 2000 and then convert it to 97. I'm not real happy with it. You have to put...

Hi All, Am having an interesting problem. In Access 2000 I can put in a criteria of: Between [Enter Beginning Date] and [Enter Ending Date] for a Date field in a query. When I input 08/01/2001 and 08/30/2001, it will return the records between those dates. In Access 97, using that same...

In the Criteria line in the query type: Like [Enter the first letter of last name to search by: ] & "*" Sorry, don't know about an "autocomplete". jedlag

Hi Terry, Thanks for responding. All I thought I wanted to do was give a date parameter for my Report and give a County parameter for the same Report. When I do this the easy way, ie putting in the criteria under date and County [enter beginning date][enter ending date] [enter county]...

I hate to beat a dead horse, but I've gone through this forum from top to bottom and still can't get this figured out. I have a query to populate a Report. I have the criteria in the Date field as Between [Enter Beginning Date:] and [Enter Ending Date:] This works...the way it should! I...

You might also try re-installing Access in a different directory from your original Office. Went through this in trying to install Access 2000 on a machine which already had Ofc. 2000 Small Business version. Installing in a different directory did away with the No License message. Good Luck...

Tempclerk, I apologize for not getting back. I found the problem, I missed putting the height of the More box to 0. That's what I get for printing these things out and not changing the ink cartridge when it's needed. I came back and read from the page and picked up the height to 0. After...

OK!!! Here's what I did, though not as easy for the user as I would have liked. I made my More field about 2 pixels high and ran it right across the bottom of the report, from margin to margin. I changed the properties of the Detail Section and the More field to Yes on the Can Grow, Can...

Tempclerk, Wanted to say THANKS for that Can Grow, Can Shrink. It solved another problem with a different Report. Saved on some paper! Thanks again jedlag

Hi Guys, Sorry about that, got called out of town for the day. I've been playing with this problem for way too long! I'm starting to get confused on what I'm doing. Here's what I have at the moment. My pre-made form is just big/small ;-) enough to fit on one page. I can't get my More...

To be truthful, I don't really need the label, I just thought it was interesting how I got it to display. It never ceases to amaze me what Access will do, whether I want it to or not! ;-) Did my explanation make sense? That I got two pages whether the More field had text or not? Sorry I was...

Hi Tempclerk I set the Can Shrink of both the More field and the Details property to Yes. I still get the extra blank sheets no matter, though for some reason, the label of the More field does not show up, even if the sheet should not be there. I put a page break before the More field and...

Hi Tempclerk The Report is actually a direct copy of a form that was originally filled out by hand. Problem is, the form cannot be changed on a whim by me. With the hand written form, you could add a second sheet of paper when needed if you had more information than you could fit on the form...

I'm using Access 2000. My form is a Hit Form for doing background checks. I'm having problems with a field called More. It's used only when all the charges do not fit in the original Charges field. What I would like to do is design a report from this form that prints as one page. The catch...