Search results for query: *

NEVER MIND, I found a workaround. by putting a blank column in a table and referenceing it as the outermost sort, the report works fine. Thanks Anyway. Gerald Grace Wannabe Programmer 8-) Please explain steps so I can learn. Thank You Very Much.

P.S. I can get it to work by putting an overall or outermost sort expression in, but then the "set parimeter value" dialog pops up, would like to get this to stop, HOW? Thanks. Gerald Grace Wannabe Programmer 8-) Please explain steps so I can learn. Thank You Very Much.

I have a report that is set up with two columns sorted vertically, with sub totals in each grouping and a grand "report" total at the end. When the groups end up on the left column the "report" total ends up right below the last record. (This is good) BUT, if the last group...

Thanks Paul, the program works the way it should by grabbing information from the MSysObjects table, but now the table itself is giving the wrong information. Do you know why the MSysObjects table would not update to show the same date as what shows up when the properties for an object are...

I need to change out some tables and want to find all the reports they are used in. It seems time consuming to go through each report and click on the properties to see what tables it utilizes. Is there any program or function that is built into Access or can be built to view or print this...

I am using the MSysObject table as a date created and date modified reference in my reports, but when i compare that information with the info I get from right click properties of reports the information does not match. Why? Is there any way I can "refresh" this information in the...

Thank you Roy, I am able to use the form after decompiling, but the debug command still doesnt allow the database to be re-compiled correctly - comes up with the same errors after closing out and re-opening. would like to do the second option (copy objects to new database) but the form that i...

Thank You Paul, I have one more question. How can i get the date to show up in a long format? Gerald Grace Wannabe Programmer 8-) Please explain steps so I can learn. Thank You Very Much.

The Expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Access can’t find. *The expression may not result in the name of a macro, the name of a user-defined function, or [event procedure]...

I cannot figure out how to put object properties "DateCreated" and "LastUpdate" in a report footer when it is printed. Can anyone help. Thank You in advance. 8-) Gerald Grace Novice Programmer