Search results

Assistance Needed: I have a query that has 3 fields. Date - Standard Date Nosocomial - Checkbox Number - Integer The Date Field's Expression is a Between/And The Nosocomial Expression is =True The Number Expression is where I have the issue. It's not actually a field. I need the...

Thank you......!!!!!!!!!!!!!!!!!!!!!!!!!! Reading the link now.

If you have VB6 Studio and just A2K, do you need the developers edition of A2K?

Thanks All, it works great!

Does the Access 2000 runtime have to be specific to the DB developed, or is their one "Access 2000 runtime"? If there is one "Access 2000 runtime", is it as simple as copying the .mde/.mdb and the "Access 2000 runtime" onto another PC and the user can run the DB without Access or Office...

thanks, I'll do that now.

Looks good Audrey!

I'm sure this question has been asked before... but here goes. Is there anyway w/ A2K to develop a .mdb or .mde and place it on another PC that does not have any type of Access... and work?

I'm sure this is posted somewhere else and is quite simple, but I haven't ever had to do it. I could use the boards opinions on this. In the Form Footer of my main form I want to place a cmd that deletes not only the main form record but also the associated subform records that are tied to it...

Found answer here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q208835

I searched the report section for has data and it returned 925 pages - any clues on what to narrow that down with? I've searched for likely responses - counting and such but haven't found a response. Please advise. What I've tried: In Main Report Footer Section sits an unbound text box...

Hello all, need a little help here. I have a report that contains a subreport. In the subreport is a field that I need to reference on to my main report. Does anyone know how to call a value from a subreport into the main report? Please help!

Thanks Pat

on a network I find that most "linking" of any file or type is problamatic due to being linked by a "mapped" drive. Instead use the (I forgot the term) format: //Server//Data//File.mdb Or whatever is your link to the server/and back.

Does anyone know how to import raw data from a .mde into a .mdb? Not any forms/queries/reports/or VBA, just data.

Or use switch! Switch([isize]<0,0+[exutiss],[isize]<0.3,1+[exutiss],[isize]<0.7,2+[exutiss],[isize]<=1,3+[exutiss],[isize]<2.1,4+[exutiss],[isize]<=3,5+[exutiss],[isize]<=4,6 +[exutiss],[isize]<=8,7+[exutiss],[isize]<=12,8+[exutiss],[isize]<=24,9+[exutiss],[isize]>24,10+[exutiss]) I don't know...

Forms!Mainformname!Mainformfield That worked now! I forgot to list Forms!

You know I can get the values from the subform onto the mainform, but not vice-versa. But I need it to go the other way. I need a value on the main form to calc a value on the subform. [This message has been edited by legendv (edited 06-04-2002).]

Thanks Rich, But that's what I'd tried, and when form is displayed it shows vaule #Name? =Sum([pushchange])/[push]![days] [pushchange] is query calculated [push] is name of mainform from qryPerson [days] is value on mainform from qryPerson I tried =Sum([pushchange])/[push]![days]...

I had some forms with cmd buttons that that happened to. I don't know why but I turned the autocorrect in the tools/options menu off and it quit occuring. But I don't know why.