Search results for query: *

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...

That's what I was looking for. Works like a charm. Here's a star!

Thanks thornmastr, It makes sense but is there a more &quot;programatical&quot; 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 &quot;OK&quot; 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 &quot;TREAT&quot; 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 &quot;delivered&quot; checkbox for every record. I want to be able to check as many checkbox of parts I'm delivering and when I click &quot;Done&quot;, the code behind the form treats all the...

Thanks. I won't have much time to work on this until the first week on January. I'll let you know and post my findings. Happy holidays!