Whenever I use SendKeys, my number luck is disabled. I've tried using SendKeys "{NUMLOCK}" after all the other keystrokes I want have been completed. However, this is not working. Any ideas how to enable the number lock would be greatly appreciated.
Create a command button on your form.
In the On Click property use the following code:
DoCmd.OpenReport "Your report name here",acViewNormal
That should do the trick.
-Chris
I would think this would be easy for those of you with experience out there. This is a would like to have,not a need to have and I must move on to other things due to time. Any help would be appreciated.
I have a subform A with record source of table 1. In the header of my form(the form with...
Thinking about my reply again, this would not work given that the number of fields would always change...unless you knew that at some point there would be a finite number of fields.
Good luck!
Good question Geraldo...I know of no solution other than the painfull truth of the following:
Your crosstab creates a table. That table appends to a new table with genaric field names and your report is based on the genaric field names. You'd have to change the labels in your report...
Hello Starling,
I feel your pain. I have had the same problem (repeatedly) using MS Access 97. Unfortunately, but successuflly the only way I ahve figeured out how to solve the preoblem is to recreate the chart from scratch. It is a pain no doubt but it has worked for me and I know of no...
What is the field type in your table for the ProjectID?
If is text it should work. I have MS Acces 97 and using "file, save as/export as a Microsoft Excel 97" file works fine for me.
Not much help I know but it works for me and I do get what you you want.
-Chris
The only way to send MS Access Reports electronically that I am aware of besides Snapshop is using Adobe PDF Writer. It works great although I have never tried it using a chart. It installs as a printer option I believe and when you choose the printer it gives you the option to choose the...
Hello Cindy,
I've had many similar problems with charts in MS Access. As you probably know there are many advantages using charts in Access and many headaches. The only ting that has worked at times for me unfortunately is to recrete the chart all together. It has worked for MOST but not all...
I have a report with the control source of a query. The two main fields that are causing the problem are store_nbr and project_nbr. The query resluts are as following:
store_nbr project_nbr
1 a
1 b
1 c
1 d
1 x
2 a
2 b
2...
Try creating two text boxes in your report. In the control source of the first text box use =[Enter Start Date]and in the control source of the second use =[Enter End Date] This should work as long as your report's record source is the query with the parameters. Hope that helps.
Try creating two text boxes in your report. In the control source of the first text box use =[Enter Start Date]and in the control source of the second use =[Enter End Date] This should work as long as your report's record source is the query with the parameters. Hope that helps.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.