jimleon
Last Activity: Apr 30 '12, 12:47 AM
Joined: Nov 9 '06
Location:
-
Many thanks, I will try it later and let you know! -
sometimes more than one person enters with the registrant
Table data like this:
number time
3 01/01/12 10:30:05
1 01/01/12 10:32:25
4 01/01/12 10:34:02
2 01/01/12 10:37:35
1 01/01/12 10:44:15
etc....
An i need to plot a chart of people in verus time in 15 minute segmentsLeave a comment:
-
People per hour Chart
Hello Community.
I have a table consisting of a date / time field and a number field, the first being what time the people entered and the latter being the number of people to enter. I wish to display this data as a line graph with 15 minute intervals so every quarter of an hour it will display the count of all people through the door in that period to show busy times. I am using Access 2003. Do any of you people know if there is... -
Format last character in table cell...
I need to set the last character in a word 2007 Table cell string superscript property in VB. I have seen examples where the .Character(star t char, number of chars) method is employed but that feature does not seem to be in VS2010..... Any ideas people...
Jim -
Editing tables on a different Word 2007 page.
I'm using Visual studio to make a document template active. I use a combo box on page 1 to populate a table on the last page. Is there any way of doing this without the view jumping to the last page. I need to keep focus on page 1.
Many Thanks in advance
Jim -
I used iif and hasData to produce psuedo output in the fields... as I said it prints out fine as a stand alone report, it just doesnt when used as a subreport...Leave a comment:
-
Report behaving differently as a sub report
Hello People,
I have a main report containing 3 subreports fed by 3 queries in access 2003. All worked fine until recently when one of the subreports wouldn't print out. I found that for that month there was no data coming from its query (as no records matched). If I output the report on its own I would get the headers, 1 blank data line and the footers. I used the HasData property to set the contents of the data to 0 or null. This... -
Listbox not outputting in subreport
Hi People,
This one is really doing my head in.
I have a form that outputs invoices that is fed fron a query listInv, this works fine as a stand alone form but when I insert it as a subform the listbox is blank.
I havent set the master/child fields as the subform doesnt require any external references as the query picks these up.
What is happening when I insert the form as a subform?
ps... -
Adding Subreports to reports
Hi all....
I have 3 reports - Report1, Report2 and Report3 each one being supplied by quieries query1 - query3 repectively. I need a report that will output all 3 each one starting on a fresh page, with a cost total at the end of the report.
I'm guessing this is somehow achieved using subreports added into the first report but I just cant get it to work....
Any ideas where I'm going wrong people?
... -
Output html file to text file
Hi People,
I have a link in my vba code:
Application.Fol lowHyperlink "http://www.xxxxxx.co.u k/"
but I dont want to open a browser (or show it minimised) but need to dump the resultant html page to a text file to search for a string.
I have tried:
Application.Fol lowHyperlink "http://www.xxxxxx.co.u k/" >c:\temp.txt
but that doesnt work.
... -
Thanks Chip, that worked a dream was a bit confused about the Link Master Fields and Link Child Fields but now i know what each does.Leave a comment:
-
Cool, and how do you do that?Leave a comment:
-
If you go into the desing view of the query, right click on it and select 'sql view' you will see the query in text format.Leave a comment:
-
Subform referencing subform
I know this question has been answered in many ways on this and other forums, but cannot find and anwer that directly refers to my problem.
I have 2 subforms, Clients (which contains client details) and Invoice address. The contents of both form are derived from the table clientDetails. I would like the Invoice address form to reflect the address stored in the clientDetails table referenced by the client in the clients subform. Have... -
Its displayed as a single form...Leave a comment:
-
As a stand alone form it works fine so I know everythings ok there, it is only after it has been put in as a subform it wont workLeave a comment:
-
Yes, I meant nothing shows up in the list box. The Row Source is set in the properties thus:
SELECT listNewJobs.wor kDate, listNewJobs.[Client Ref], listNewJobs.Com pany, listNewJobs.wor kType FROM listNewJobs;
and the Row Source Type is Table/Query using the query called listNewJobsLeave a comment:
-
Listbox in subform
I have a form with a listbox on it that is populated by a query.
On its own this works fine and lists the querys results, however when I use the same form as a subform it stops working.
I have checked the form, listbox and query but cannot find the problem.
What does the mainform do to the subform (apart from turn it into a control) to stop the listbox outputting the results? -
Parsing HTML links
I have a working link that displays two images bup and bdn
[code=html]<a href="xxxxxxxxx " onMouseOver="ca tbtn.src='/images/nos/adn.gif'; return true" onMouseOut="cat btn.src='/images/nos/aup.gif'; return true"><img src="/images/nos/aup.gif" width="20" height="20" alt="A" border="0" Name="catbtn"></a>[/code]
the... -
That would have been the answer but I can't see any background picture properties in either the header or footer properties....Leave a comment:
No activity results to display
Leave a comment: