Search results
-
V
I need help with a Total
I have a report that gives me state and then line information. In the state footer I am doing a total for all lines within the state. How do I do a total for all states by line?? EX: State 1 Line 1 State 1 Line 2 TOtal State 1 State 2 Line 1 State 2 Line 2 Total State 2 Total All States... -
V
Open a subform based on Name or ID
I am trying create a command button that will open a subform based on the criteria in either the name or the ID field. The premise being that the user usually knows 1 or the other but not both. -
V
auto fit to screen forms
Can I please get a copy also? vbourbeau@concordgroupins.com Thanks in Advance, Val -
V
Timing a Macro
That will show me the total time after it is completed, but is there a way to show the elapsed time as the macro is running? -
V
Timing a Macro
How can I create some sort of a timer to show how long a macro has been running? Thanks in Advance -
V
Group Headers above Page Headers
Is there a way to have group Header appear before the Page Header? I have a report and the group header gives the title and date for the report and I want to use the page header for the column names, but now the column names appear above the Title. -
V
Access report with random number
Try using a query that uses the rnd function. EX:Rnd([Numeric_field]+1) Then sort the query by the new field and change the SQL Statement to Select Top 56. -
V
Scheduler Problem
For quite a long time I used a scheduler to Open access, run the autoexec macro and then using the /X run an additional macro. The update was done every morning and I had no problems. Then there were some changes in the office, I got a new PC and had some problems with congigurations Etc... -
V
Sub-Reports with No Data
I have a report that has 4 sub-reports in it. When the report is run there may or may no be data for any of the 4 sub-reports. How do I print a message that says "No data at this time" for any of the sub-reports that have no data, but still print the ones that do? The report has to include a... -
V
Viewable Form
I realize that this question was already asked and answered, however the database I am having a problem with is still Access 7.0. Database Form is not fully viewable on 14" monitors as it is on 17". Is there any way that I can set the size of the image of the form to tell what size...