Thanks Tim,
Its been a month since the last post. I thought it was dead. I've change my approach and used formulas instead (as you suggest now). I ran into another issue with that approach where the reader installed with our application would not compute one of my formula. I ended up having to...
The subreport is still not displaying on the last page of the report. I get the same "5 of 5+ > |>" but can't get on the 6th page. The main report is called from VB with parameters, is that what's causing my problems with the subreport? Can I use variables to pass information along to the...
To create the sub report, I've made a copy of the original and dropped everything but the two fields I needed. Saved it as the same name but with subrpt in front. When I add the subreport to the main report, I link it to some field (is there a particular field I should link it to or no link at...
Thanks for your reply.
I've tried just that but when I execute the report from the application, in the viewer I can't accessed the last page of the report. I get "5 of 5+ > |>" but can't get on the 6th page. If I get rid of the subreport, it works fine.
CR 8.5
I've got a report that lists employee's name and the amount of minutes assigned in regular and overtime. Looks like this:
Div1
Empl1 0
Empl2 580
Empl3 518
Empl4 539
Empl5 0
...
Div2
Empl6 0
Empl7 580
Empl8 518...
As I mentionned in the bottom of my second post, I'm from Montreal, Quebec, Canada. I work for AXA, a world leader in Insurance (not that big on this side of the globe but getting there!).
It's so obvious once you look at the answer! I had something similar in the french db but must've had AND instead of OR between the two phone numbers and the three ContractNo or something (see SQL code below). Thanks a lot for your patience and help. Hope to get a chance to return the favor...
Thanks for your reply.
-->But, the SQL that you posted has no reference to a criteria experession for the Phone Number. Had you overlooked that criteria. It can't be that simple can it?<--
You are right, I've overlooked it in the sample db I've assembled to simplify it for this forum. My...
Thanks scriverb, I didn't want to put too much information in the first post not to scare anyone.
As I said, I've simplyfied it a bit for this post but what I have right now is
Clients in tblClient...
I've got a search form that has ContractNo, Name, Firstname and PhoneNo as four text fields. I need to look up informtation in a table and display matching records. I've looked at a couple of thread in this forum and it seams a lot of people are having issues with query criterias liked to form...
Using A97, I've created a user-defined type that contains the informations from a medical information form. The type has information for about 50 questions and looks a bit like this:
Public Type MedicalQ
intYN1 As Integer
str1 As String
intYN2 As Integer
str2 As String...
I've looked around quite a bit and there seems to be no way of calling a userdefined function at table level to specify a default value for a field. I have a function to create my own autonumber field but since I can't call it from table level and I don't want a form or a query, it appears to be...
I've looked around quite a bit and there seems to be no way of calling a userdefined function at table level to specify a default value for a field. I have a function to create my own autonumber field but since I can't call it from table level and I don't want a form or a query, it appears to be...
Thanks thornmastr,
It makes sense but is there a more "programatical" way? Some of my users only have the run time version of Access 97 and I'm not sure this would apply.
For this particular case that solves it but...
Any other ideas?
I have a small form that allows a user to enter a couple of thousand of documents number, one at a time, and assign it to a user. The numbers aren't sequential but are usually just a couple of numbers apart. On my form, once you clicked on "OK" to validate the entry, you then get the...
Yes but how do I get recordcount = 1 if I have one record?
I want the last record (or the only one in this case) checked to be saved in the table prior to query it in order to have the entry in the table.
By "TREAT" I ment to work on it, to do something with it.
And Yes I have a continuous form view that looks like this:
[] partOne descriptionOne
[] partTwo descriptionTwo
[] partThree descriptionThree
[] and so on,
[Back button] [Done button]
I usualy have more then ten records...
I have a form that presents all the parts ordered like a report would do in a detail section. I have a "delivered" checkbox for every record. I want to be able to check as many checkbox of parts I'm delivering and when I click "Done", the code behind the form treats all the...
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.