Search results

Thanks Jennifer and Pat. Looks like I'll be fit and trim in no time.......after my 3 bags of chips ;) j

Hmm this is wierd. The Magic Wand icon is always clicked and I never have had a wizard come up when I select things or do other tasks. Now Im really lost of why this is. If the wand is selected and I put a frame on the form. What Im trying to do is select all the check boxes. But nothing is...

Frame Wizard? Is this the property box? If you are talking about the property box for the field I tried to assign a value that way and it didnt work for me. Thanks

I want to make a form where I can track my fat food intake. Each check box will represent a food that I consumed that day. I want to know if I can make the value of a check box any number I choose and how to do that? For Example: Bag of Chips - 10grams of fat I check the box that I made for...

Im interested in knowing this too.

I dont know if this will help but I would try moving the page widths. If that doesnt work make sure that the whole part of the subform is contained within the margins. john

This kinda goes hand and hand with Forms and Reports. I have a report built off of a form with a subform. When I print the report, sometimes I may need to have the subform continue onto the next page. I keep trying but I only can either keep the subform from Growing or the subform takes over...

Rename it, I can handle that. Thanks. Ill let you know if it works.

For example: On the report, I want to stretch one of the fields in the subform part of it to fit the report nicer, then in the Form that the report was based off of the subform also has stretched fields. Im boggled.

I made a Report from a Form that had a Subform in it. When I go to make format changes to the Report, it also changes the format in the Original Form. Is there a way to put an end to this? Thanks.

Im sorry, but now im a little lost. Only been working with Access for about 4 months. Could you explain what steps Ill need to do to accomplish this? Much appreciated.

I understand that the form and subform are linked but is there a way to do this?

I have a simple Form with a subform. I inserted a button using the wizard to duplicate the record. It works but when I go and change something in the new record all the information in the subform disappears. Can anyone shed some light on this? Thanks.

Yes, typo error. Got it now. Thanks Much!

Thanks Fellas. Much Abliged

Hi, Im wanting to make a couple of text fields uneditable after data is put into them. Im kinda lost on how to do this. I want to avoid someone changing data in these fields. Thanks.

Good news and Bad news. The Statement is now staying in the Order By Box, but its not sorting. Heres what Ive tried: SELECT ([On Time Shipping Subform].[ID]), ([On Time Shipping Subform].[Purchase Order]), ([On Time Shipping Subform].[Control Numbers]), ([On Time Shipping Subform].[Required...

Thanks for the reply. Heres exactly what I have. One table "On Time Shipping Subform" and a bunch of fields. I entered this into the Order By Property. After I save it, it disappears and nothing is sorted. Am I missing something. Seems like there should be brackets or something. SELECT On...

I did a search and am having a hard time finding out how to sort 2 fields in the same query. I have a subform that is based on a query. I need it to sort by PO# first and then by Ship Date second. Thanks

I have a simple check box form that tells me if a shipment has been delivered On Time or not. Check if it was on time. I want the check box value to be 1 instead of -1. I tried this statement in the control source: =IIf([On Time]=True,1,0) And I tried this too. =IIf([On Time]=True,1) Both...