Access XP: I want to use the tab feature so I created a new form in the same DB. When I try to copy things from the first form to the new form the gui moves over but the action does not. I have to manually create the same action's on the new form. Is there some special way to copy these over...
This is weird. I have Access XP. I went to try and create a report today and as soon as I try to open a blank report it comes back and tells me
"Microsoft Access can't save design changes or save to a new database object because another user has the file open. To save design changes or to...
The date range is on the querie and I run it from either the report section or a form so I need it to work directly from the report.
The querie field:
Field (Case_Completed)
Criteria Between [Start Date] and [End Date]
When I run my reports they kick off a date range selection I have in the queries. (between date a and b) I want to take that value I put in when prompted and have written to the header of my report so I dont have to keep manually changing the text on the report.
I have a table that lists Group Names that I use to feed a combo box.
Group AAA
Group AAB
Group CCA
Group CCB
I wan to be able to list combinations of groups as a selection for the combo box like:
Group AAA
Group AAB
Group CCA
Group CCB
Group AAA & CCA
Group CCA & CCB
Also I would like to...
I want to return a blank value to feed a report. This statement works but when I run the querie of course it stops and asks what value I want for the empty [] so I have to press enter. There is no other output to this other then the report so I dont have to worry about further calculations...
All the data I have available from a materialized view, single table.
Better example:
CASE
10 John Smith <dates> <other data>
11 Harry Jonsone <dates> <other data>
11 Suzi Quatro <dates> <other data>
12 Sherlock Holmes <dates> <other data>
13 Harry Jonsone <dates> <other...
Are you using XP?
Top Center of the screen while in the report edit mode allows you to export to Word or Excell. Try it instead of file/save as etc.
So far I have not as of yet had any problems converting using that function.
This is complicated to explain so please bear with me.
I am pulling up data about service call cases using Access XP. A case may be assigned to one or more groups or one or more individuals. I want to pull up the data for one group or individual and see what other groups or individuals are...