Search results

I have a report with a query that looks like this: mbr# macro result micro microresult 1 -1 Positive 0 Null 1 0 Null -1 Neg My report is grouped by mbr# I want them all on one line, but because there are NULLS in result field. I get a blank if I...

I guess I was looking at the wrong knowledge base question. I should have been looking at Using EVAL function. I used this in my query and now I have cut my code significantly. Thanks for all help.... Kim

Jack, I did try that this is what I came up with, however in the example I was looking at it only used a single line to open the records and using 1 parameter eg. set rs = myQdef.openrecordset() what do I do with the myQdef2???? Here is an example of my code. Thanks kim Dim db As DATABASE...

I have search this knowledge base for this error and have found my error and the solution if the expected is 1, but in my situation I have 2 parameters not two. How can I handle that? My parameter for a [DATEADMIT] field is Between[Forms]![frmReportRange]![DateBegin]AND...

Jack I looked at the knowledge base and this did help, but I have 2 parameters so at the point where I set my rs I don't know how to set the two parameters any suggestions? Thanks kim

I did this same thing. Run an update query to multiply your currency by 100. This will change 402.23 to 40223.00 when you export it will drop the .00 leaving you with 40223 Thanks Kim

I am very new to Graphing. , but I went to properties and found the recordsource for my graph. When I click on the elipse marks I actually see my data instead of the test data. From here I was able to modify the legend. Hope this helps.. Kim

Sorry everyone. I built with query builder and like magic it worked.... kim

I have a report that contains a controlsource to employee the value is either T or F I set up an unbound field whose controlsource is IIF([Employee] = "T","Yes","No"). When I run the report I get Syntax error(comma)in query expression [IIF([Employee] = "T","Yes","No")]. What am I doing...

You could maybe check the primary key field like UserID or something on your form and see if it is null. If it is then close if it isn't then me.undo. kim

Thanks R. Hicks I have the 2000 code but was looking for the 97 code to create a list box listing all the reports available. Here is the 2000 code for anyone who may searching for it.... Private Sub Form_Load() Dim objAO as AccessObject Dim objCP as Object Dim strValues As String Set objCP =...

Wonderful, Kudos to you. kim

That's the thing I only randomly need about 20 out of 60 checkboxes. like 5,11,26,27,28,31,32,33,39,41,42,43,44,46,47,58 etc. So I don't think that will work. Tks Kim

I have a form that has several check boxes. I need to know if cb5, cb7, cb12, cb19, cb24, cb25 cb30 and so on have been checked. I also need to know if the count of these checkboxes that have been checked is greater then say 4. I can write the statements individually such as If [cb5] = -1...

I have a database that is split. currently they both are in G:\projects\ I need to move the backend database to a production drive I:\. The front end will be on a local PC. Here's my question... In a few of the forms I need to write information to a table in the backend database using the...

Thanks it works.... by the way my mbrid was a string value. Much appreciation kim

I have the code" strCount = Forms![frmcallhis]![mbrid] intCount = Dcount("[mbrid]","tblcall","[mbrid] = 'strCount'") intcount = intcount + 1 intcount is always 0 even if there are several calls for mbrid I'm just trying to get the count from tblcall based on a mbrid and up by 1. Thanks

Evedently she has moves BOO HOO. kim

Thanks so much ..I had to tweek the code a little, but it is much better then having to go through each box on the form. I had to tweek the following line to get it to work.... If Ctl.ControlType = acTextBox Then Kim

Thanks that worked perfectly... kim