Recent content by mmjr103

Yes, to a certain degree. That would be the record source of my report. I know how to add tables, show/hide field, certain criteria. I can navigate my way there, I guess it would depend on what I need to do. On criteria I always have trouble with the (, [, ] + " and when to use them. I...

OK, I'm not sure exactly what you mean with your response. Where am I putting this DLookup? Is this the Textbox on the top of the report? I apologize, but I am still learning Access.

OK, as a novice it appears that I have sinned. I created tables that have lookup fields referencing another field. Actually I have several tables that all have relationships and object dependencies in my database. Now that I am trying to create some different reports, when I run the report I...

Thanks, but could you be a little more specific? I looked at the URL provided and not sure which to use. I tried one of them for the dates and received #Error in the text box. Any help would be appreciated, as I am still a novice at Access. Thanks

Ok, I’m going to try to again! I created a DB (in A2007) and now using A2010 and I have run into a wall, and have been pulling my hair out. Here is a description on my current problem… The DB is one-to-many table relationships. The main table is EInfo which stores all the contact info for the...

I have created a form called 'Reports Form'. Within the form are several list boxes. There are like 'County', 'Level' and 'Individuals' list boxes. I want to be able to select something from one of the list boxes and click on a command button to open a report and generate report based on...

Good evening everyone, I am going to try this again. I am very new to access, and really green when it comes to using the program so I am learn as I go. I started to create a database for work, and never thought that it would get this involved. The pressure is on at work to complete the...

OK, in the form I have a combo/list box and then a command button. Will the information that you listed above generate the report as soon as the selection is made in the combo/list box, or will the user still have to click the command button. In the same form, I also have 2 combo/list boxes...

OK, I appreciate the response, but where do I go to get to the docmd.openreport? Do I use this on the Command button? Not sure where to go. Can you provide a little better direction? Thanks again

Good Evening Everyone, I am very newbie to this forum, as a matter of fact I am still trying to learn access as well. I have managed to create a database with multiple tables, that are all, in some manner connected to the main table. I have created a form, put a combo/list box on the form...