Is there a way that I can force the filename for a workbook?
I want a user to open a template file. Fill in some details and save the file with its filname being based on a cell on the sheet
I could use
projectfilename = sheets("PEROJECT INFO").CELLS(5,5).value
saveas...
Hi,
I would like to be able to show "tick marks" ( I guess check marks i the US) in a message box. any suggestions?
I need to show the box as help for filling in a questionnaire. Something like
"fill in the appropriate number
of ticks as described below"
x = a little
xx...
Ryan,
Populating a combobox with a list of values determined at run-time is not easy.
Unfortunately access is not designed so you can add or delete items from the combobox quickly
It is possible however and most good VBA books will describe the process, It fairly long winded
An alternative...
Larry,
Sorry if I didnt make it clear. I HAVE put the column headers in the report header section of the subreport.
This does make them appear, but only once at the start of the subreport.
The subreport is very long and runs to several pages.
I would like the column headings to appear at...
I have a problem with a long subreport. In order to get the column headings to appear above the first line of detail I have to put them in the Report header rather than the page header. But then they dont appear again at the top of each new page the subreport fills.
Any Ideas?
How About:-
You could add another entry to the combo box by using a UNION query
e.g.
Select department from tbldepartments
UNION
Select "All" from tbldepartments
then do some code to select a different query if the value of the combo box is "All" when you fire the report
How about this
Concatenate them all together using '&' and vbNewline and use the nz funtion to avoid the problem of concatenating NULL values
strFullAddress = Nz([CustID],"") & Nz([AddressLine1] & "," & vbNewLine,"") & Nz([AddressLine2] & "," &...
OK I agree that its linking the customerID that is the problem.
The Answer as I look at is that you dont have to link on any field. Just let the subreport return all its rows.
There should only be one row for the count subreports and thats fine ( you could even move them to the main report if...
What are you trying to show?
Report Header
customer1 cout of calls
customer1 count of meeting set up
customer 1 .....
customer 1 .....
customer 2
custtmer 2
customer 2
customer 2
...
or
Report header
customer1
customer 2
customer 3...
I have the same problem with header fields and labels not appearing in the page header of a subreport
Which header section are you using?
I found moving stuff to the report header from the page header caused it to appear.
However this is only a partial solution as I would like it to appear on...
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.