Recent content by Cgrnc

I thought of using a dialog box to prompt for the beginning and ending dates but wasn't sure I could use the same form for several queries because I thought it would pop-up for each query???? I'll try using a form to run the report. Thank you. I'm still new at this!

My database is used to enter daily work activity. I'm trying to create queries that will be used for a report with subreports. The main query\report will show work sorted by ActivityName for a given date range (I'm using a parameter query with a beginning date and ending date to get the date...

Bless you!! I am not a programmer and nor am I an academic thinker apparently! This was just the ticket and just what I was looking for. A note to anyone else as new at this as I am: I had to bring focus back to the main form using a DoCmd.GoToControl method within the If statement and used...

Thank you for the response! I guess they'll have to input the date!

Let me get specific in hopes that I will receive a response on this one!! I've built a work activity database that tracks the activity of a Traffic division in the city that I work in. It's used primarily for production reporting. My main form for Sign Making has three subforms on it...

Right you are!!! Thanks for the suggestions. I've got difficult users who want what they cannot have . . . I'll just have to learn to says so!!!

Do you have the short date format chosen in the date field for the TABLE where the data is being stored??? If so . . . you need to change this as well.

This didn't work for me but THANKS SO MUCH for the reply!! Any other ideas?????

I posted this problem once and got one reply (that I didn't quite follow) under the subject: Autonumber and saving records. Once again: I used autonumbers as primary keys in my tables. I have a Parent form with three text boxes and three subforms. The textboxes all have defaults in them at...

How would I go about saving a recordset? Could I save a recordset for the Parent form? This is the form with the default problem. Thanks!

I have used autonumbers in most of my tables as primary keys. I have a form that has four text boxes and three subforms on it. The first text box holds the primary key and is not visible to the user. The other three text boxes have defaults in them (the user can change if needed). My...

Thanks for the help! I'm off to try and work this out . . .

I can help you with some of this. 1. Go to the design view of your form. Make sure the Control Wizards button is "on" (this is a button in the tool box . . . has a wand on it). Click on the Combo Box button (toolbox) Click on your form where you would like the combo box and follow the wizard...

Thanks for the info! It definately got me started! Can anyone suggest the best shareware or inexpensive software to help me scale down my bitmaps? Also, the few I have tried to make smaller look terrible!!! (the edges are rough . . . etc) Can anyone tell me what I'm doing wrong? Thanks for...

I have a client who would like specific pictures on the buttons and forms to identify specific transactions. I have NO experience with graphics files and don't know how to use any pictures that are not already available within Access. I have several manuals and have read HELP . . . I can find...